1.添加质检方案基础资料 2.采购到货接口调整 3.入厂检验扫描标签添加标签判断 4.ERP订单下达生成工单接口修改 5.编码规则接口修改 6.采购退...

yl

2023-04-07 a667d4159bb3f1ba909b94d5b5dd7c6eb28e7197

 VueWebApi/DLL/DAL/SystemSettingDAL.cs

@@ -71,15 +71,25 @@
            var dynamicParams = new DynamicParameters();
            try
            {
                sql = @"select rightcode from  T_CodeRules  where rightcode=@rightcode";
                sql = @"select rightcode,value from  T_CodeRules  where rightcode=@rightcode";
                dynamicParams.Add("@rightcode", rightcode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    sql = @"update T_CodeRules set prefix=@prefix,filingdate=@filingdate,incbit=@incbit,lm_user=@lm_user,lm_date=@CreateDate where rightcode=@rightcode";
                    string value = data.Rows[0]["value"].ToString();
                    if (decimal.Parse(incbit) > value.Length) 
                    {
                       decimal cnum = decimal.Parse(incbit) - value.Length;
                        for (int i = 0; i < cnum; i++)
                        {
                            value = "0" + value;
                        }
                    }
                    sql = @"update T_CodeRules set prefix=@prefix,filingdate=@filingdate,incbit=@incbit,value=@value,lm_user=@lm_user,lm_date=@CreateDate where rightcode=@rightcode";
                    dynamicParams.Add("@prefix", prefix);
                    dynamicParams.Add("@filingdate", filingdate);
                    dynamicParams.Add("@incbit", incbit);
                    dynamicParams.Add("@value", value);
                    dynamicParams.Add("@lm_user", lm_user);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    dynamicParams.Add("@rightcode", rightcode);