| | |
| | | { |
| | | //若MAINDI重复则重新获取 |
| | | oCn.BeginTran(); |
| | | string sql = "Insert into Sc_ICMOBillQualityStatus_Tmp(HBarCode,HInterID,HBillNo,HCheckManID,HBadReasonID,HWasterReasonID,HResult,HAddr," + |
| | | string sql = "Insert into Sc_ICMOBillQualityStatus_Tmp"+ |
| | | "(HBarCode,HInterID,HBillNo,HCheckManID,HBadReasonID,HWasterReasonID,HResult,HAddr," + |
| | | "HRemark,HSaveType,HICMOInterID,HICMOEntryID,HICMOBillNo,HSplitNo,HMaterID,HProcID,HSourceID,HDate,HGroupID,HDeptID,HStationID," + |
| | | "HPRDORGID,HAuxPropID,HBillType,HReportType,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationInterID," + |
| | | "HPRDORGID,HAuxPropID,HBillType,HBillSubType,HReportType,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationInterID," + |
| | | "HRelationEntryID,HRelationBillNo,HMaker,HMakeDate)" + |
| | | "values(" + |
| | | "'" + omodel.HBarCode + |
| | |
| | | "," + omodel.HPRDORGID + |
| | | "," + omodel.HAuxPropID + |
| | | ",'" + BillType + |
| | | "','" + "" + |
| | | "'," + omodel.HReportType + |
| | | "," + omodel.HSourceInterID + |
| | | "," + omodel.HSourceEntryID + |