From c819dddabba9767bd6f732ce09833b37ce7ffd5f Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期四, 22 八月 2024 09:49:05 +0800
Subject: [PATCH] 1
---
DAL/应收管理/ClsYS_ReceiveOtherBill.cs | 44 +++++++++++++++++++++++++-------------------
1 files changed, 25 insertions(+), 19 deletions(-)
diff --git "a/DAL/\345\272\224\346\224\266\347\256\241\347\220\206/ClsYS_ReceiveOtherBill.cs" "b/DAL/\345\272\224\346\224\266\347\256\241\347\220\206/ClsYS_ReceiveOtherBill.cs"
index ca286d9..7ff0121 100644
--- "a/DAL/\345\272\224\346\224\266\347\256\241\347\220\206/ClsYS_ReceiveOtherBill.cs"
+++ "b/DAL/\345\272\224\346\224\266\347\256\241\347\220\206/ClsYS_ReceiveOtherBill.cs"
@@ -71,24 +71,27 @@
foreach (Model.ClsYS_ReceiveOtherBillSub oSub in DetailColl)
{
string subSql = "insert into YS_ReceiveOtherBillSub" +
- "" +
- "" +
- "" +
- "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
- ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney) " +
- " values(" +
- "" + omodel.HInterID.ToString() +
- "," + oSub.HEntryID.ToString() +
- "," + oSub.HSourceInterID +
- "," + oSub.HSourceEntryID +
- ",'" + oSub.HSourceBillNo +
- "','" + oSub.HSourceBillType +
- "','" + oSub.HProjectMoneyID +
- "','" + oSub.HTypeSub +
- "','" + oSub.HMoney +
- "','" + oSub.HTaxRate +
- "','" + oSub.HSumMoney +
- "')";
+ "" +
+ "" +
+ "" +
+ "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
+ ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney,HQty,HPrice,HRemark) " +
+ " values(" +
+ "" + omodel.HInterID.ToString() +
+ "," + oSub.HEntryID.ToString() +
+ "," + oSub.HSourceInterID +
+ "," + oSub.HSourceEntryID +
+ ",'" + oSub.HSourceBillNo +
+ "','" + oSub.HSourceBillType +
+ "','" + oSub.HProjectMoneyID +
+ "','" + oSub.HTypeSub +
+ "','" + oSub.HMoney +
+ "','" + oSub.HTaxRate +
+ "','" + oSub.HSumMoney +
+ "','" + oSub.HQty +
+ "','" + oSub.HPrice +
+ "','" + oSub.HRemark +
+ "')";
oCn.RunProc(subSql);
}
sReturn = "淇敼鍗曟嵁鎴愬姛锛�";
@@ -131,7 +134,7 @@
"" +
"" +
"(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
- ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney) " +
+ ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney,HQty,HPrice,HRemark) " +
" values(" +
"" + omodel.HInterID.ToString() +
"," + oSub.HEntryID.ToString() +
@@ -144,6 +147,9 @@
"','" + oSub.HMoney +
"','" + oSub.HTaxRate +
"','" + oSub.HSumMoney +
+ "','" + oSub.HQty +
+ "','" + oSub.HPrice +
+ "','" + oSub.HRemark +
"')";
oCn.RunProc(subSql);
}
--
Gitblit v1.9.1