11

pzy

2024-08-26 dbbcd506929afda0a85ae23bcb5f88c1dccef387

 DAL/销售管理/ClsXs_SeOrderChangeBill.cs

@@ -87,7 +87,7 @@
                {
                    string subSql = "insert into Xs_SeOrderChangeBillSub" +
                        "(HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                        ",HMaterID,HUnitID,HQty_Old,HQty_New,HTaxPrice_Old,HTaxPrice_New,HDate_Old,HDate_New) " +
                        ",HMaterID,HUnitID,HQty_Old,HQty_New,HTaxRate_Old,HTaxRate_New,HTaxPrice_Old,HTaxPrice_New,HDate_Old,HDate_New) " +
                        " values(" +
                        "" + omodel.HInterID.ToString() +
                        "," + oSub.HEntryID.ToString() +
@@ -106,6 +106,8 @@
                        "," + oSub.HUnitID +
                        "," + oSub.HQty_Old +
                        "," + oSub.HQty_New +
                        "," + oSub.HTaxRate_Old +
                        "," + oSub.HTaxRate_New +
                        "," + oSub.HTaxPrice_Old +
                        "," + oSub.HTaxPrice_New +
                        ",'" + oSub.HDate_Old + "'" +
@@ -211,7 +213,7 @@
                {
                    string subSql = "insert into Xs_SeOrderChangeBillSub" +
                        "(HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                        ",HMaterID,HUnitID,HQty_Old,HQty_New,HTaxPrice_Old,HTaxPrice_New,HDate_Old,HDate_New) " +
                        ",HMaterID,HUnitID,HQty_Old,HQty_New,HTaxRate_Old,HTaxRate_New,HTaxPrice_Old,HTaxPrice_New,HDate_Old,HDate_New) " +
                        " values(" +
                        "" + omodel.HInterID.ToString() +
                        "," + oSub.HEntryID.ToString() +
@@ -230,6 +232,8 @@
                        "," + oSub.HUnitID +
                        "," + oSub.HQty_Old +
                        "," + oSub.HQty_New +
                        "," + oSub.HTaxRate_Old +
                        "," + oSub.HTaxRate_New +
                        "," + oSub.HTaxPrice_Old +
                        "," + oSub.HTaxPrice_New +
                        ",'" + oSub.HDate_Old + "'" +