| | |
| | | BillNew.HSourceBillNo = mainList[0].HICMOBillNo; |
| | | BillNew.HSourceInterID = mainList[0].HICMOInterID; |
| | | BillNew.HSourceBillType = mainList[0].HSourceBillType; |
| | | BillNew.HBadReasonHQty = mainList[0].HBadReasonHQty; |
| | | oCN.BeginTran(); |
| | | //临æ¶è¡¨ |
| | | oCN.RunProc("Insert Into Sc_ICMOBillQualityStatus_Tmp " + |
| | |
| | | ",HProcExchBillNo,HProcExchInterID,HProcExchEntryID,HProcID,HMaterID" + |
| | | ",HSourceID,HGroupID,HCheckManID,HBadReasonID,HBarCode" + |
| | | ",HMaker,HMakeDate,HBillType,HReportType,HSourceBillNo" + |
| | | ",HSourceInterID,HSourceBillType,HICMOEntryID,HSourceEntryID" + |
| | | ",HSourceInterID,HSourceBillType,HICMOEntryID,HSourceEntryID,HBadReasonHQty" + |
| | | ") " + |
| | | " values(" + BillNew.HInterID + ",'" + BillNew.HBillNo + "','" + BillNew.HDate + "','" + BillNew.HICMOBillNo + "'," + BillNew.HICMOInterID + |
| | | ",'" + BillNew.HProcExchBillNo + "'," + BillNew.HProcExchInterID + "," + BillNew.HProcExchEntryID + "," + BillNew.HProcID + "," + BillNew.HMaterID + |
| | | "," + BillNew.HSourceID + "," + BillNew.HGroupID + "," + BillNew.HCheckManID + "," + BillNew.HBadReasonID + ",'" + BillNew.HBarCode + "'" + |
| | | ",'" + BillNew.HMaker + "','" + BillNew.HMakeDate + "','" + BillNew.HBillType + "','" + +BillNew.HReportType + "','" +BillNew.HSourceBillNo + "'" + |
| | | "," + BillNew.HSourceInterID + ",'" + BillNew.HSourceBillType + "'," + BillNew.HICMOEntryID + "," + BillNew.HICMOEntryID + |
| | | "," + BillNew.HSourceInterID + ",'" + BillNew.HSourceBillType + "'," + BillNew.HICMOEntryID + "," + BillNew.HICMOEntryID + "," + BillNew.HBadReasonHQty + |
| | | ") "); |
| | | sReturn = "æ«ç æåï¼"; |
| | | oCN.Commit(); |