| | |
| | | { |
| | | string sql, year = "", month = "", day = "", fdate = "", q = "", cunm2 = "", Encode = "", cunm = ""; |
| | | int digit2 = 0, value2 = 0, digit3 = 0, digitdiff = 0; |
| | | decimal labcum = 0; |
| | | bool stf; |
| | | List<object> list = new List<object>(); |
| | | List<string> listdt = new List<string>(); |
| | | List<AppLabCode> lab = new List<AppLabCode>(); |
| | | var dynamicParams = new DynamicParameters(); |
| | | //获取标签个数:进一法 |
| | | decimal labcum = Math.Ceiling(decimal.Parse(qty) / decimal.Parse(onelabqty)); |
| | | if (qty == "0" && onelabqty == "0") |
| | | { |
| | | labcum = 1; |
| | | } |
| | | else |
| | | { |
| | | labcum = Math.Ceiling(decimal.Parse(qty) / decimal.Parse(onelabqty)); |
| | | } |
| | | try |
| | | { |
| | | sql = @"select prefix,filingdate,incbit,value from TCodeRules where rightcode=@rightcode"; |
| | | dynamicParams.Add("@rightcode", rightcode); |
| | | sql = @"select prefix,filingdate,incbit,value from TCodeRules where menucode=@menucode"; |
| | | dynamicParams.Add("@menucode", rightcode); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | if (data.Rows.Count > 0) |
| | | { |
| | |
| | | break; |
| | | } |
| | | //更新规则表位数及流水号 |
| | | sql = @"update TCodeRules set incbit=@incbit,value=@cunm2 where rightcode=@rightcode"; |
| | | sql = @"update TCodeRules set incbit=@incbit,value=@cunm2 where menucode=@menucode"; |
| | | dynamicParams.Add("@incbit", cunm.Length); |
| | | dynamicParams.Add("@cunm2", cunm); |
| | | dynamicParams.Add("@rightcode", rightcode); |
| | | dynamicParams.Add("@menucode", rightcode); |
| | | list.Add(new { str = sql, parm = dynamicParams }); |
| | | stf = DapperHelper.DoTransaction(list); |
| | | if (stf) |