From 1204150d723e868fe761911f877500b1aad9ab81 Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期二, 13 九月 2022 15:11:07 +0800 Subject: [PATCH] 优化 --- WebAPI/Controllers/BarCodeController.cs | 36 ++---------------------------------- 1 files changed, 2 insertions(+), 34 deletions(-) diff --git a/WebAPI/Controllers/BarCodeController.cs b/WebAPI/Controllers/BarCodeController.cs index 9665667..c560dca 100644 --- a/WebAPI/Controllers/BarCodeController.cs +++ b/WebAPI/Controllers/BarCodeController.cs @@ -899,7 +899,6 @@ List<Model.ClsGy_MaterialList_WMS_Model> ls = new List<Model.ClsGy_MaterialList_WMS_Model>(); List<Model.ClsGy_BarCodeBill_WMS_Model> ls2 = new List<Model.ClsGy_BarCodeBill_WMS_Model>(); - List<Model.ClsGy_BarCodeBill_WMS_Model> ls3 = new List<Model.ClsGy_BarCodeBill_WMS_Model>(); ls = oListModels.getObjectByJson_MaterialList(msg3); foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls) @@ -956,8 +955,8 @@ WeiShu = "灏炬暟"; HMinQty = HSumQty - (HBQty - 1) * HMinQty; } - //TM = $"{oItemSub.HMaterID}#{HMinQty}"; - TM = $"{oItemSub.HMaterID}"; + TM = $"{oItemSub.HMaterID}#{HMinQty}"; + //TM = $"{oItemSub.HMaterID}"; Model.ClsGy_BarCodeBill_WMS_Model bar = new Model.ClsGy_BarCodeBill_WMS_Model(); bar.HBarCode = TM; bar.HMaterID = oItemSub.HMaterID; @@ -1028,37 +1027,6 @@ + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO + "')"; oCn.RunProc(sql); sql = "exec setLSH '" + DateTime.Today + "'"; - oCn.RunProc(sql); - } - } - foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls3) - { - //LogService.Write("寰幆绗笁娆�:" + oItemSub.HSupID); - if (ClsPub.isLong(oItemSub.HMaterID) != 0) - { - HBarCode = oItemSub.HBarCode.ToString(); - HMTONO = ClsPub.isStrNull(oItemSub.HMTONO); - HBarCodeType = "绠卞彿鍐呮潯鐮�"; - HMaterID = ClsPub.isLong(oItemSub.HMaterID); - HUnitID = ClsPub.isLong(oItemSub.HUnitID); - HQty2 = ClsPub.isDoule(oItemSub.HQty); - HBatchNo = ClsPub.isStrNull(oItemSub.HBatchNo); - HSupID = oItemSub.HSupID; - HKFPeriod = ClsPub.isInt(oItemSub.HKFPeriod); - HKFDate = ClsPub.isStrNull(oItemSub.HKFDate); - HKFDQDate = ClsPub.isStrNull(oItemSub.HKFDQDate); - HSourceInterID = ClsPub.isLong(oItemSub.HSourceInterID); - HSourceEntryID = ClsPub.isLong(oItemSub.HSourceEntryID); - HSourceBillNo = ClsPub.isStrNull(oItemSub.HSourceBillNo); - HSourceBillType = ClsPub.isStrNull(oItemSub.HSourceBillType); - HWei = ClsPub.isStrNull(oItemSub.HEndQty); - string sql = "insert into Gy_BarCodeBill (HInterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HKFDate,HKFPeriod,HKFDQDate" + - ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HEndQty,HSupflag" + - ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HMTONO " + - ") values (" - + linterid.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID + "," + HUnitID + "," + HQty2 + ",'" + HKFDate + "'," + HKFPeriod + ",'" + HKFDQDate - + "','" + HBatchNo + "'," + HSupID + "," + HGroupID + ",'" + ClsPub.CurUserName + "','" + DateTime.Today + "'," + HPrintQty + ",'" + HWei + "',1" - + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO + "')"; oCn.RunProc(sql); } } -- Gitblit v1.9.1