From e47895acbaa55346e02d536ab2da4134058bd3a5 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期二, 12 三月 2024 11:32:32 +0800
Subject: [PATCH] 1
---
DAL/应收管理/ClsYS_ReceiveOtherBill.cs | 42 +++++++++++++++++++++++-------------------
Model/应收管理/ClsYS_ReceiveOtherBillSub.cs | 2 ++
2 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..5e70a4f 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,26 @@
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) " +
+ " 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 +
+ "')";
oCn.RunProc(subSql);
}
sReturn = "淇敼鍗曟嵁鎴愬姛锛�";
@@ -131,7 +133,7 @@
"" +
"" +
"(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
- ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney) " +
+ ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney,HQty,HPrice) " +
" values(" +
"" + omodel.HInterID.ToString() +
"," + oSub.HEntryID.ToString() +
@@ -144,6 +146,8 @@
"','" + oSub.HMoney +
"','" + oSub.HTaxRate +
"','" + oSub.HSumMoney +
+ "','" + oSub.HQty +
+ "','" + oSub.HPrice +
"')";
oCn.RunProc(subSql);
}
diff --git "a/Model/\345\272\224\346\224\266\347\256\241\347\220\206/ClsYS_ReceiveOtherBillSub.cs" "b/Model/\345\272\224\346\224\266\347\256\241\347\220\206/ClsYS_ReceiveOtherBillSub.cs"
index f3cb8c6..640e3aa 100644
--- "a/Model/\345\272\224\346\224\266\347\256\241\347\220\206/ClsYS_ReceiveOtherBillSub.cs"
+++ "b/Model/\345\272\224\346\224\266\347\256\241\347\220\206/ClsYS_ReceiveOtherBillSub.cs"
@@ -13,5 +13,7 @@
public double HMoney;// dec(18,8) //单据金额
public double HTaxRate;// dec(18,8) //税率
public double HSumMoney;// dec(18,8) //总金额
+ public double HQty;// dec(18,8) //税率
+ public double HPrice;// dec(18,8) //总金额
}
}
--
Gitblit v1.9.1