llj
2025-10-20 2b5aa0f7d432d8dcd1aac3cd9d45d5a04a17d2c7
DAL/采购管理/ClsCg_POStockInChangeBill.cs
@@ -78,7 +78,7 @@
                {
                    string subSql = "insert into Cg_POStockInChangeBillSub " +
                        "(HInterID,HEntryID,HBillNo_bak,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                        ",HMaterID,HUnitID,HQty,HTaxPrice_Old,HTaxPrice_New,HMoney_New) " +
                        ",HMaterID,HUnitID,HQty,HTaxPrice_Old,HTaxPrice_New,HMoney_New,HTaxRate_Old,HTaxRate_New) " +
                        " values(" +
                        "" + omodel.HInterID.ToString() +
                        "," + oSub.HEntryID.ToString() +
@@ -96,6 +96,8 @@
                        "," + oSub.HTaxPrice_Old + "" +
                        "," + oSub.HTaxPrice_New + "" +
                        "," + oSub.HMoney_New + "" +
                        "," + oSub.HTaxRate_Old + "" +
                        "," + oSub.HTaxRate_New + "" +
                        ")";
                    oCn.RunProc(subSql);
                }
@@ -185,7 +187,7 @@
                {
                    string subSql = "insert into Cg_POStockInChangeBillSub " +
                        "(HInterID,HEntryID,HBillNo_bak,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                        ",HMaterID,HUnitID,HQty,HTaxPrice_Old,HTaxPrice_New,HMoney_New) " +
                        ",HMaterID,HUnitID,HQty,HTaxPrice_Old,HTaxPrice_New,HMoney_New,HTaxRate_Old,HTaxRate_New) " +
                        " values(" +
                        "" + omodel.HInterID.ToString() +
                        "," + oSub.HEntryID.ToString() +
@@ -203,6 +205,8 @@
                        "," + oSub.HTaxPrice_Old + "" +
                        "," + oSub.HTaxPrice_New + "" +
                        "," + oSub.HMoney_New + "" +
                        "," + oSub.HTaxRate_Old + "" +
                        "," + oSub.HTaxRate_New + "" +
                        ")";
                    oCn.RunProc(subSql);
                }
@@ -316,6 +320,8 @@
                    oSub.HTaxPrice_Old = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HTaxPrice_Old"]);
                    oSub.HTaxPrice_New = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HTaxPrice_New"]);
                    oSub.HMoney_New = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HMoney_New"]);
                    oSub.HTaxRate_Old = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HTaxRate_Old"]);
                    oSub.HTaxRate_New = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HTaxRate_New"]);
                    DetailColl.Add(oSub);
                }