From 178ef58efdb6e6fa1f3cc44c2b3b5a66d5200096 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期二, 23 一月 2024 09:36:46 +0800
Subject: [PATCH] 1
---
DAL/销售管理/ClsXs_SeOrderBill.cs | 12 ++++++++++--
1 files changed, 10 insertions(+), 2 deletions(-)
diff --git "a/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_SeOrderBill.cs" "b/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_SeOrderBill.cs"
index 01a2d20..7e1b146 100644
--- "a/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_SeOrderBill.cs"
+++ "b/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_SeOrderBill.cs"
@@ -115,7 +115,8 @@
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,HOrderLevID ) " +
+ ",HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark,HOrderLevID" +
+ ",HCusMaterNumber,HCusModel,HCusMaterName ) " +
"values(" +
"" + omodel.HInterID +
"," + oSub.HEntryID +
@@ -142,6 +143,9 @@
"," + oSub.HInvoiceQty +
",'" + oSub.HRemark +
"','" + oSub.HOrderLevID +
+ "','" + oSub.HCusMaterNumber +
+ "','" + oSub.HCusModel +
+ "','" + oSub.HCusMaterName +
"')";
oCn.RunProc(subSql);
}
@@ -286,7 +290,8 @@
// ") ");
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,HOrderLevID) " +
+ ",HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark,HOrderLevID" +
+ ",HCusMaterNumber,HCusModel,HCusMaterName) " +
"values(" +
"" + omodel.HInterID +
"," + oSub.HEntryID +
@@ -313,6 +318,9 @@
"," + oSub.HInvoiceQty +
",'" + oSub.HRemark +
"','" + oSub.HOrderLevID +
+ "','" + oSub.HCusMaterNumber +
+ "','" + oSub.HCusModel +
+ "','" + oSub.HCusMaterName +
"')";
oCn.RunProc(subSql);
}
--
Gitblit v1.9.1