From 911220a0e60d4192cf6b23f95301edb0fbd75764 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期五, 28 三月 2025 16:24:14 +0800
Subject: [PATCH] 采购调价单添加字段，采购入库单审核报错返回语句修改
---
DAL/采购管理/ClsCg_POStockInChangeBill.cs | 10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)
diff --git "a/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/ClsCg_POStockInChangeBill.cs" "b/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/ClsCg_POStockInChangeBill.cs"
index b6d83f8..968ef65 100644
--- "a/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/ClsCg_POStockInChangeBill.cs"
+++ "b/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/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);
}
--
Gitblit v1.9.1