| | |
|---|
| | | ", " + oMain.HEmpID.ToString() + "," + oMain.HGroupID.ToString() + "," + oMain.HDeptID.ToString() + "," + oMain.HPRDORGID.ToString() + |
|---|
| | | ") "); |
|---|
| | | |
|---|
| | | //更新生产状态临时表(当日完工数量)HDateFinishQty |
|---|
| | | //更新生产状态临时表(当日完工数量)HDateFinishQty h_p_JIT_Sc_ICMOBillStatus_Tmp_Qty |
|---|
| | | oCn.RunProc("exec h_p_JIT_Sc_ICMOBillStatus_Tmp_Qty '"+ workcode + "','" + HSourceID + "','" + oMain.HMainSourceInterID + "','"+oMain.HMainSourceEntryID + "'"); |
|---|
| | | //string sql1 = string.Format(@"update Sc_ICMOBillWorkQtyStatus_Tmp set |
|---|
| | | // HICMOReportInterID ='" + oMain.HInterID + "', HICMOReportBillNo='" + oMain.HBillNo + "' from Sc_ICMOBillWorkQtyStatus_Tmp a where a.HICMOBillNo='" + workcode + "' and a.HSourceID='" + HSourceID + "' and HICMOInterID='" + oMain.HMainSourceInterID + "' and a.HICMOEntryID='" + oMain.HMainSourceEntryID + "' and a.HMaker='" + oMain.HMaker + "' and HRelationInterID='0'"); |
|---|
| | | //oCn.RunProc(sql1); |
|---|
| | | //string sql1 = string.Format(@"update Sc_ICMOBillStatus_Tmp "); |
|---|
| | | |
|---|
| | | //更新关联数量 |
|---|
| | | oCn.RunProc("exec h_p_Sc_UpDateRelation_ICMOToICMOReport_Add " + oMain.HInterID.ToString()); |
|---|
