1.ERP订单关闭增加单据id 2.MES工单关闭增加源单id关联

yl

2024-04-15 7ff74f599084561338eef1230db5aa45f74565f8

 VueWebCoreApi/Tools/AppLableBarCode.cs

@@ -24,17 +24,25 @@
        {
            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)
                {
@@ -60,23 +68,23 @@
                                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)
                        {
                            mes.code = "200";
                            mes.Message = "成功!";
                            mes.message = "成功!";
                            mes.data = lab;
                        }
                        else
                        {
                            mes.code = "300";
                            mes.count = 0;
                            mes.Message = "失败!";
                            mes.message = "失败!";
                            mes.data = null;
                        }
                    }
@@ -85,7 +93,7 @@
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "未设置编码规则,生成单号失败,请设置编码为【" + rightcode + "】的编码规则!";
                    mes.message = "未设置编码规则,生成单号失败,请设置编码为【" + rightcode + "】的编码规则!";
                    mes.data = null;
                }
            }
@@ -93,7 +101,7 @@
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;