From e5f0d4aaebc10d97b708b5c9ce8db6859791b79c Mon Sep 17 00:00:00 2001 From: YL <YL@LAPTOP-SE03PLUR> Date: 星期二, 03 八月 2021 10:20:46 +0800 Subject: [PATCH] nothing --- WebAPI/DLL/ClsSc_ICMOBillWorkQtyStatus_Tmp.cs | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/WebAPI/DLL/ClsSc_ICMOBillWorkQtyStatus_Tmp.cs b/WebAPI/DLL/ClsSc_ICMOBillWorkQtyStatus_Tmp.cs index 8bcde3e..4f84403 100644 --- a/WebAPI/DLL/ClsSc_ICMOBillWorkQtyStatus_Tmp.cs +++ b/WebAPI/DLL/ClsSc_ICMOBillWorkQtyStatus_Tmp.cs @@ -28,6 +28,7 @@ } #endregion 自定义方法 + //修改单据 public override bool ModifyBill(Int64 lngBillKey, ref string sReturn) { @@ -78,7 +79,7 @@ oCn.BeginTran(); //主表 - oCn.RunProc("Insert Into Sc_ICMOBillWorkQtyStatus_Tmp " + + oCn.RunProc("Insert Into Sc_ICMOBillWorkQtyStatus_Tmp " + "(HInterID,HBillType,HSourceID,HReportType,HPieceQty" + ",HMaterID,HGroupID,HWorkManID,HWorkReportDate,HDate" + ",HBillSubType,HBillNo,HICMOInterID,HICMOEntryID,HICMOBillNo" + @@ -95,8 +96,9 @@ ") "); //根据源单主内码 设置 生产状态表 完工状态(设置本单对应得源单 为完工状态) - oCn.RunProcReturn("exec h_p_JIT_MESICMOReport_Status " + omodel.HSourceID.ToString() + "," + omodel.HSourceInterID.ToString() + "," + omodel.HSourceEntryID.ToString() + ",'" + omodel.HSourceBillNo.ToString() + "','" + omodel.HPlanQty + "','" + omodel.HQty + "','" + omodel.HBadQty + "','" + omodel.HWasterQty + "'", "h_p_JIT_MESICMOReport_Status"); + //更新生产状态临时状态表数量 + oCn.RunProcReturn("exec h_p_Sc_UpDateRelation_ICMOToICMOReport_Qty " + omodel.HICMOInterID.ToString() + "," + omodel.HICMOEntryID.ToString() + "", "h_p_Sc_UpDateRelation_ICMOToICMOReport_Qty"); sReturn = "新增单据成功!"; oCn.Commit(); -- Gitblit v1.9.1