From a45e481e2a24319e20751fc3cff0bf5f31d6015e Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期四, 14 十月 2021 18:12:44 +0800
Subject: [PATCH] 列表+编辑的改进
---
WebAPI/Controllers/Pay_OtherBalBillController.cs | 28 +++++++++++++---------------
1 files changed, 13 insertions(+), 15 deletions(-)
diff --git a/WebAPI/Controllers/Pay_OtherBalBillController.cs b/WebAPI/Controllers/Pay_OtherBalBillController.cs
index a1a8568..9389403 100644
--- a/WebAPI/Controllers/Pay_OtherBalBillController.cs
+++ b/WebAPI/Controllers/Pay_OtherBalBillController.cs
@@ -93,8 +93,8 @@
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
string sql1 = "SELECT 鐗╂枡ID,鐗╂枡浠ｇ爜,鐗╂枡鍚嶇О,HDeptID,閮ㄩ棬浠ｇ爜,閮ㄩ棬" +
- ", HGroupID, 鐝粍浠ｇ爜, 鐝粍, 宸ヨ祫绫诲瀷, 鎽樿, 鍐呴儴鍗曟嵁鍙�, 琛ㄥご澶囨敞, 鍒跺崟浜�, 鍒跺崟鏃ユ湡" +
- ", 瀹℃牳浜�, 瀹℃牳鏃ユ湡, 淇敼浜�, 淇敼鏃ユ湡, 鍏抽棴浜�, 鍏抽棴鏃ユ湡, 宸ュ簭ID, 宸ュ簭浠ｇ爜, 宸ュ簭鍚嶇О" +
+ ", HGroupID, 鐝粍浠ｇ爜, 鐝粍, 宸ヨ祫绫诲瀷, 鎽樿, 鍐呴儴鍗曟嵁鍙�, 琛ㄥご澶囨敞" +
+ ", 宸ュ簭ID, 宸ュ簭浠ｇ爜, 宸ュ簭鍚嶇О" +
", 鑱屽憳ID, 鑱屽憳浠ｇ爜, 鑱屽憳, 宸ユ椂, 鏁伴噺, 宸ヤ环, 閲戦 FROM h_v_Pay_OtherBalBillList where 1 = 1 ";
string sql = sql1 + sqlWhere;
ds = oCN.RunProcReturn(sql, "h_v_Pay_OtherBalBillList");
@@ -160,10 +160,10 @@
int HYear = 2021;
double HPeriod = 1;
string HRemark = mainList[0].HRemark;//澶囨敞
- string HBillSubType = mainList[0].HBillSubType;
+ string HBillSubType = "2206";
string HMaker = mainList[0].HMaker;
- string HExplanation = mainList[0].HExplanation;
- string HInnerBillNo = mainList[0].HInnerBillNo;
+ string HExplanation = "0";
+ string HInnerBillNo = "0";
long HMaterID = mainList[0].HMaterID;//浜у搧ID
long HGroupID = mainList[0].HGroupID;
long HDeptID = mainList[0].HDeptID;
@@ -174,16 +174,14 @@
int HPRDORGID = mainList[0].HPRDORGID; //缁勭粐
//涓昏〃
- oCN.RunProc("Insert Into Pay_OtherBalBillMain " +
- "(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
- ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
- ",HGroupID,HDeptID,HEmpID,HPayType,HExplanation,HInnerBillNo" +
- ") " +
- " values('" + HBillType + "'," + HBillSubType + ",'" + HInterID + "','" + HBillNo + "','" + HDate + "'" +
- "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()," + HGroupID + "," + HDeptID + "," + HEmpID + ","+
- "," + HPayType + "," + HExplanation + ",'" + HInnerBillNo + "'," +
- ") ");
-
+ oCN.RunProc(" Insert Into Pay_OtherBalBillMain " +
+ "(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
+ ",HYear,HPeriod,HRemark,HMaker" +
+ ",HGroupID,HDeptID,HEmpID,HPayType,HInnerBillNo,HExplanation" + ")" +
+ "values('" + HBillType + "','" + HBillSubType + "'," + HInterID + ",'" + HBillNo + "','" + HDate +
+ "','" + HYear + "'," + HPeriod + ",'" + HRemark + "','" + HMaker + "'," + HGroupID + ", " + HDeptID +
+ "," + HEmpID + ",'" + HPayType + "','" + HInnerBillNo + "'," + HExplanation +
+ ") ");
//淇濆瓨瀛愯〃
objJsonResult = AddBillSub(msg3, HInterID);
if (objJsonResult.code == "0")
--
Gitblit v1.9.1