From 0dc38a2e38568bdf42f8385dd9355c8f3de4c025 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期三, 05 一月 2022 17:34:00 +0800 Subject: [PATCH] 委外发料单+设备器具点检保养规程完善 --- WebAPI/DLL/ClsSc_PackUnionBill.cs | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/WebAPI/DLL/ClsSc_PackUnionBill.cs b/WebAPI/DLL/ClsSc_PackUnionBill.cs index 2fcf05d..0f94328 100644 --- a/WebAPI/DLL/ClsSc_PackUnionBill.cs +++ b/WebAPI/DLL/ClsSc_PackUnionBill.cs @@ -83,6 +83,7 @@ //鏂板鍗曟嵁 public override bool AddBill(ref string sReturn) { + string ww = ""; try { //寰楀埌mainid @@ -99,7 +100,7 @@ " values(" + omodel.HYear + "," + omodel.HPeriod + ",'" + this.BillType + "'," + omodel.HInterID + "" + ",'" + omodel.HDate + "','" + omodel.HBillNo.ToString() + "'," + omodel.HBillStatus + ",'" + omodel.HRemark + "'," + omodel.HICMOInterID + "" + ",'" + omodel.HICMOBillNo.ToString() + "','" + omodel.HBarCode_Pack.ToString() + "'," + omodel.HMaterID + "," + omodel.HUnitID + "" + - ",'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.GetServerDate(-1) + "'" + + ",'Admin','" + DBUtility.ClsPub.GetServerDate(-1) + "'" + ") "); ////鎻掑叆瀛愯〃 string HSourceInterID = "0"; @@ -135,8 +136,9 @@ //Int64 ZHInterID = DBUtility.ClsPub.CreateBillID_Prod("85", ref DBUtility.ClsPub.sExeReturnInfo); oCn.RunProc("insert into Gy_BarCodeBill(HInterID,HEntryID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HBatchNo,HMakeDate " + ",HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, HUseFlag, HStopflag, HSupID, HGroupID, HPrintQty)" + - "values('" + HSourceInterID + "', 1, '" + omodel.HBarCode_Pack + "', '绠卞彿鏉$爜', '" + HMaterID + "', '" + HUnitID + "','" + HQty + "', '', getdate()" + + "values('" + HSourceInterID + "', 1, '" + omodel.HBarCode_Pack + "', '鎵樼洏鏉$爜', '" + HMaterID + "', '" + HUnitID + "','" + HQty + "', '', getdate()" + ", '" + HSourceInterID + "', '" + HSourceEntryID + "', '" + HSourceBillNo + "', '" + HSourceBillType + "', 1, 0, 0, 0, 0)"); + oCn.RunProcReturn("exec h_p_Sc_PackUnionBill_SumSubBill2 " + omodel.HInterID + ",'"+ omodel.HBillNo.ToString() + "','"+ this.BillType + "','Admin'", "h_p_JIT_MESBeginWorkBill_SaveCtrl"); sReturn = "鏂板鍗曟嵁鎴愬姛锛�"; oCn.Commit(); return true; -- Gitblit v1.9.1