YL
2021-08-03 e5f0d4aaebc10d97b708b5c9ce8db6859791b79c
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();