YL
2021-08-11 0cd4472f86ab06a46050876fdd29cc86e5206308
WebAPI/DLL/ClsSc_ICMOBillWorkQtyStatus_Tmp.cs
@@ -53,6 +53,10 @@
                ",HRelationEntryID=" + omodel.HRelationEntryID.ToString() +
                ",HRelationBillNo='" + omodel.HRelationBillNo + "'" +
                ",HReportEntryID=" + omodel.HReportEntryID.ToString() +
                ",HGroupID=" + omodel.HGroupID.ToString() +
                ",HWorkManID=" + omodel.HWorkManID.ToString() +
                ",HBadQty=" + omodel.HBadQty.ToString() +
                ",HWasterQty=" + omodel.HWasterQty.ToString() +
                " where HInterID=" + lngBillKey.ToString());
                //删除关联
                DeleteRelation(ref sReturn, lngBillKey);
@@ -96,7 +100,7 @@
                ") ");
                //根据源单主内码 设置 生产状态表 完工状态(设置本单对应得源单 为完工状态)
                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_JIT_MESICMOReport_Status " + omodel.HSourceID.ToString() + "," + omodel.HSourceInterID.ToString() + "," + omodel.HSourceEntryID.ToString() + ",'" + omodel.HSourceBillNo.ToString() + "','" + omodel.HPlanQty + "'", "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 = "新增单据成功!";