Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API

yusijie

2024-01-05 75f450e31ac4c2cba2bde49daf1c019a2a15c409

 DAL/销售管理/ClsXs_SeOrderBill.cs

@@ -115,7 +115,7 @@

                    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 +
@@ -139,8 +139,9 @@
                        "," + oSub.HlineTotalBB +
                        ",'" + oSub.HDate +
                        "'," + oSub.HOutStockQty +
                        "," + oSub.HInvoiceQty +
                        "," + oSub.HInvoiceQty + 
                        ",'" + oSub.HRemark +
                        ",'" + oSub.HOrderLevID +
                        "')";
                    oCn.RunProc(subSql);
                }
@@ -285,7 +286,7 @@
                    //  ") ");
                    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 +
@@ -311,6 +312,7 @@
                        "'," + oSub.HOutStockQty +
                        "," + oSub.HInvoiceQty +
                        ",'" + oSub.HRemark +
                        "','" + oSub.HOrderLevID +
                        "')";
                    oCn.RunProc(subSql);
                }