From 44d8a4fbe4abfbf82376a49ae7d07eda5c9cd374 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期四, 20 一月 2022 11:05:13 +0800 Subject: [PATCH] 条码拆码 --- DAL/仓库管理/条码管理/ClsGy_BarCodeBill_ChaiMa.cs | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) diff --git "a/DAL/\344\273\223\345\272\223\347\256\241\347\220\206/\346\235\241\347\240\201\347\256\241\347\220\206/ClsGy_BarCodeBill_ChaiMa.cs" "b/DAL/\344\273\223\345\272\223\347\256\241\347\220\206/\346\235\241\347\240\201\347\256\241\347\220\206/ClsGy_BarCodeBill_ChaiMa.cs" index 78f0f0e..8e8333f 100644 --- "a/DAL/\344\273\223\345\272\223\347\256\241\347\220\206/\346\235\241\347\240\201\347\256\241\347\220\206/ClsGy_BarCodeBill_ChaiMa.cs" +++ "b/DAL/\344\273\223\345\272\223\347\256\241\347\220\206/\346\235\241\347\240\201\347\256\241\347\220\206/ClsGy_BarCodeBill_ChaiMa.cs" @@ -12,13 +12,13 @@ public List<Model.ClsGy_BarCodeEdit_Model> DetailColl_Pay = new List<Model.ClsGy_BarCodeEdit_Model>(); - public bool AddBill(ref string sReturn) + public bool AddBill(ref string sReturn,string HBillNo) { try { //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� oCn.BeginTran(); - string sql = "delete Gy_BarCodeBill where HBarCode='" + omodel.HBarCode + "'"; + string sql = "delete Gy_BarCodeBill where HBarCode='" + HBillNo + "'"; oCn.RunProc(sql); ////鎻掑叆瀛愯〃 foreach (Model.ClsGy_BarCodeEdit_Model oSub in DetailColl_Mater) @@ -37,10 +37,10 @@ ",HSendGoodsBillNo,HServerItemID,HBadReasonList,HProdLev,HInnerBillNo,HCusBarCode,HStatus,HInitSourceEntryID" + ",HOldSourceBillType,HMZ,HGiveAwayFlag" + ") " + - " values("+ oSub.HInterID + ",1,'3710',0," + oSub.HBarCode + ",'" + oSub.HBarCodeType + "','" + oSub.HItemSubID+ - "'," + oSub.HMaterID + ","+ oSub.HUnitID + ",0,"+ oSub.HQty + ","+ oSub.HBatchNo + ","+ oSub.HSupID + "," + oSub.HGroupID + "," + oSub.HDeptID + "," + oSub.HEmpID + - "," + oSub.HMaker + ",'" + oSub.HMakeDate + "',0," + oSub.HSourceInterID + ","+ oSub.HSourceEntryID + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + - "'','" + oSub.HUseFlag + "','',''," + oSub.HStopflag + ",'',0,"+ oSub.HInitQty+",0"+ + " values("+ oSub.HInterID + ",1,'3710',0,'" + oSub.HBarCode + "','" + oSub.HBarCodeType + "','" + oSub.HItemSubID+ + "'," + oSub.HMaterID + ","+ oSub.HUnitID + ",0,"+ oSub.HQty + ",'"+oSub.HBatchNo + "',"+ oSub.HSupID + "," + oSub.HGroupID + "," + oSub.HDeptID + "," + oSub.HEmpID + + ",'" + oSub.HMaker + "','" + oSub.HMakeDate + "',0," + oSub.HSourceInterID + ","+ oSub.HSourceEntryID + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + + "'','" + oSub.HUseFlag + "','','',0,'',0,"+ oSub.HInitQty+",0"+ ",'',0,'',"+ oSub.HSourceID+",'','',"+ oSub.HCusID+","+ oSub.HSTOCKORGID+","+ oSub.HOWNERID + ",'','','','','','','',0,"+ "0,'','"+oSub.HBarCodeDate+"','',0,0"+ -- Gitblit v1.9.1