| | |
|---|
| | | ",HLastResult=" + DBUtility.ClsPub.BoolToString(omodel.HLastResult) + |
|---|
| | | ",HShiftsID=" + omodel.HShiftsID.ToString() + |
|---|
| | | ",HErrTreatment='" + omodel.HErrTreatment + "'" + |
|---|
| | | ",HBatchNo='" + omodel.HBatchNo + "'" + |
|---|
| | | " where HInterID=" + lngBillKey.ToString()); |
|---|
| | | //鍒犻櫎鍏宠仈 |
|---|
| | | |
|---|
| | |
|---|
| | | ",HYear,HPeriod,HRemark" + |
|---|
| | | ",HSourceID,HICMOInterID,HICMOBillNo,HICMOQty,HProcExchInterID,HProcExchEntryID" + |
|---|
| | | ",HProcExchBillNo,HProcExchQty,HMaterID,HFirstCheckEmp,HLastResult" + |
|---|
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HICMOEntryID,HQCSchemeID,HShiftsID,HErrTreatment" + |
|---|
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HICMOEntryID,HQCSchemeID,HShiftsID,HErrTreatment,HBatchNo" + |
|---|
| | | ") " + |
|---|
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",'" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + |
|---|
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'" + |
|---|
| | | "," + omodel.HSourceID.ToString() + "," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "'," + omodel.HICMOQty.ToString() + "," + omodel.HProcExchInterID.ToString() + "," + omodel.HProcExchEntryID.ToString() + |
|---|
| | | ",'" + omodel.HProcExchBillNo + "'," + omodel.HProcExchQty.ToString() + "," + omodel.HMaterID.ToString() + "," + omodel.HFirstCheckEmp.ToString() + ", " + DBUtility.ClsPub.BoolToString(omodel.HLastResult) + |
|---|
| | | "," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'," + omodel.HICMOEntryID + "," + omodel.HQCSchemeID + "," + omodel.HShiftsID + ",'" + omodel.HErrTreatment + "'" + |
|---|
| | | "," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'," + omodel.HICMOEntryID + "," + omodel.HQCSchemeID + "," + omodel.HShiftsID + ",'" + omodel.HErrTreatment + "','" + omodel.HBatchNo + "'" + |
|---|
| | | ") "); |
|---|
| | | //鎻掑叆瀛愯〃 |
|---|
| | | foreach (Model.ClsQC_PatrolProcCheckOtherBillSub oSub in DetailColl) |
|---|
