| | |
| | | string subSql = "Insert into Sc_QualityReportBillSub " + |
| | | " (HInterID,HEntryID,HBillNo_bak,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" + |
| | | ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID,HBadPhenomenaID" + |
| | | ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" + |
| | | ",HBarCode,HReportType,HBadProcID" + |
| | | ",HAddr,HMaker,HMakeDate,HProcID,HNowProcID" + |
| | |
| | | "," + oSub.HEmpID.ToString() + "" + |
| | | "," + oSub.HSourceID.ToString() + "" + |
| | | "," + oSub.HBadReasonID.ToString() + "" + |
| | | "," + oSub.HBadPhenomenaID.ToString() + "" + |
| | | |
| | | "," + oSub.HICMOInterID.ToString() + "" + |
| | | "," + oSub.HICMOEntryID.ToString() + "" + |
| | |
| | | string subSql = "Insert into Sc_QualityReportBillSub " + |
| | | " (HInterID,HEntryID,HBillNo_bak,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" + |
| | | ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID,HBadPhenomenaID" + |
| | | ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" + |
| | | ",HBarCode,HReportType,HBadProcID" + |
| | | ",HAddr,HMaker,HMakeDate,HProcID,HNowProcID" + |
| | |
| | | "," + oSub.HEmpID.ToString() + "" + |
| | | "," + oSub.HSourceID.ToString() + "" + |
| | | "," + oSub.HBadReasonID.ToString() + "" + |
| | | |
| | | "," + oSub.HBadPhenomenaID.ToString() + "" + |
| | | |
| | | "," + oSub.HICMOInterID.ToString() + "" + |
| | | "," + oSub.HICMOEntryID.ToString() + "" + |
| | | ",'" + oSub.HICMOBillNo + "'" + |