From 8fc53d9ba92f32a78146d56a7cd481d65a056556 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期一, 01 十二月 2025 13:33:41 +0800
Subject: [PATCH] 档案状态变更单优化
---
DAL/销售管理/ClsXs_SeOrderChangeBill.cs | 8 ++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
diff --git "a/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_SeOrderChangeBill.cs" "b/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_SeOrderChangeBill.cs"
index 4ac722a..ab80bc3 100644
--- "a/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_SeOrderChangeBill.cs"
+++ "b/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/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 + "'" +
--
Gitblit v1.9.1