| | |
| | | |
| | | string subSql = "Insert into Xs_SeOrderBillSub" + |
| | | "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HMoney" + |
| | | ",HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark) " + |
| | | ",HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark,HOrderLevID ) " + |
| | | "values(" + |
| | | "" + omodel.HInterID + |
| | | "," + oSub.HEntryID + |
| | |
| | | "'," + oSub.HOutStockQty + |
| | | "," + oSub.HInvoiceQty + |
| | | ",'" + oSub.HRemark + |
| | | ",'" + oSub.HOrderLevID + |
| | | "')"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | |
| | | // ") "); |
| | | string subSql = "Insert into Xs_SeOrderBillSub" + |
| | | "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HMoney" + |
| | | ",HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark) " + |
| | | ",HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark,HOrderLevID) " + |
| | | "values(" + |
| | | "" + omodel.HInterID + |
| | | "," + oSub.HEntryID + |
| | |
| | | "'," + oSub.HOutStockQty + |
| | | "," + oSub.HInvoiceQty + |
| | | ",'" + oSub.HRemark + |
| | | "','" + oSub.HOrderLevID + |
| | | "')"; |
| | | oCn.RunProc(subSql); |
| | | } |