| | |
| | | DeleteBillSub(lngBillKey); |
| | | //鎻掑叆瀛愯〃 |
| | | omodel.HInterID = lngBillKey; |
| | | //鎻掑叆瀛愯〃 |
| | | foreach (Model.ClsSc_MouldDotCheckBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Sc_MouldDotCheckBillSub " + |
| | | " (HInterID,HEntryID" + |
| | | ",HManagerID"+ |
| | | ",HDotCheckItem,HDotCheckPart,HClaim"+ |
| | | ",HDotCheckItemID,HDotCheckItem,HDotCheckPart,HClaim" + |
| | | ",HCloseMan,HCloseType,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | "," + oSub.HManagerID.ToString() + |
| | | "," + oSub.HManagerID.ToString() + "," + oSub.HDotCheckItemID.ToString() + |
| | | ",'" + oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + "'" + |
| | | ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'"+ |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | |
| | | oCn.RunProc("Insert into Sc_MouldDotCheckBillSub " + |
| | | " (HInterID,HEntryID" + |
| | | ",HManagerID" + |
| | | ",HDotCheckItem,HDotCheckPart,HClaim" + |
| | | ",HDotCheckItemID,HDotCheckItem,HDotCheckPart,HClaim" + |
| | | ",HCloseMan,HCloseType,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | "," + oSub.HManagerID.ToString() + |
| | | "," + oSub.HManagerID.ToString() +","+ oSub.HDotCheckItemID.ToString()+ |
| | | ",'" + oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + "'" + |
| | | ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |