| | |
| | | foreach (Model.ClsKf_ProductReceiveMaterialBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Kf_ProductReceiveMaterialBillSub " + |
| | | " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + |
| | | " (HInterID,HEntryID,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HMaterID,HUnitID,HQtyMust,HQty,HWHID,HSCWHID,HSPID,HSCSPID" + |
| | | ",HSPGroupID,HBatchNo,HPropertyID,HSecUnitID" + |
| | |
| | | " values(" + |
| | | "" + omodel.HInterID.ToString() + "" + |
| | | "," + oSub.HEntryID.ToString() + "" + |
| | | ",'" + oSub.HCloseMan + "'" + |
| | | ",'" + oSub.HEntryCloseDate.ToShortDateString() + "'" + |
| | | "," + Convert.ToString(oSub.HCloseType ? 1 : 0) + "" + |
| | | ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "" + |
| | | "," + oSub.HSourceEntryID.ToString() + "" + |