| | |
| | | { |
| | | string subSql = "insert into Sc_WorkBeginDotCheckBillSub " + |
| | | "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRemark" + |
| | | ",HCheckNoteItemID,HCheckPostID,HCheckResult,HDotCheckType,HRelationID) " + |
| | | ",HCheckNoteItemID,HCheckPostID,HCheckResult,HDotCheckType,HRelationID,HDotCheckVal) " + |
| | | " values(" + |
| | | "" + omodel.HInterID.ToString() + |
| | | "," + oSub.HEntryID.ToString() + |
| | |
| | | "','" + oSub.HCheckResult + |
| | | "','" + oSub.HDotCheckType + |
| | | "','" + oSub.HRelationID + |
| | | "','" + oSub.HDotCheckVal + |
| | | "')"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | |
| | | { |
| | | string subSql = "insert into Sc_WorkBeginDotCheckBillSub " + |
| | | "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRemark" + |
| | | ",HCheckNoteItemID,HCheckPostID,HCheckResult,HDotCheckType,HRelationID) " + |
| | | ",HCheckNoteItemID,HCheckPostID,HCheckResult,HDotCheckType,HRelationID,HDotCheckVal) " + |
| | | " values(" + |
| | | "" + omodel.HInterID.ToString() + |
| | | "," + oSub.HEntryID.ToString() + |
| | |
| | | "','" + oSub.HCheckResult + |
| | | "','" + oSub.HDotCheckType + |
| | | "','" + oSub.HRelationID + |
| | | "','" + oSub.HDotCheckVal + |
| | | "')"; |
| | | oCn.RunProc(subSql); |
| | | } |