1

cwjbxqmz

2024-01-15 88523bf8d694dee603d3ad3fbddd217c37c3a21a

 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);
                }
@@ -248,9 +249,9 @@
                    ",'" + omodel.HRemark +
                    "'," + omodel.HOrgID +
                    ",'" + omodel.HMaker +
                    "','" + omodel.HMakeDate +
                    "',getdate()" +

                    "','" + omodel.HLinkMan +
                    ",'" + omodel.HLinkMan +
                    "','" + omodel.HLinkPhone +

                    "'," + omodel.HERPInterID +
@@ -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);
                }