From 2436c46d344236852b1a5e7bfabc36f97a6f143a Mon Sep 17 00:00:00 2001
From: 沈泽 <211959439@qq.com>
Date: 星期四, 14 十月 2021 08:30:32 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/Pay_SingleBalBillController.cs | 124 ++++++++++++++++++-----------------------
1 files changed, 55 insertions(+), 69 deletions(-)
diff --git a/WebAPI/Controllers/Pay_SingleBalBillController.cs b/WebAPI/Controllers/Pay_SingleBalBillController.cs
index 56d9a37..292f5fb 100644
--- a/WebAPI/Controllers/Pay_SingleBalBillController.cs
+++ b/WebAPI/Controllers/Pay_SingleBalBillController.cs
@@ -92,10 +92,10 @@
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
- string sql1 = "SELECT HMaterID,鐗╂枡浠ｇ爜,鐗╂枡鍚嶇О, HDeptID,閮ㄩ棬浠ｇ爜,閮ㄩ棬" +
+ string sql1 = "SELECT HMaterID,HMaterCode,HMaterName, HDeptID,閮ㄩ棬浠ｇ爜,閮ㄩ棬" +
",HGroupID,鐝粍浠ｇ爜,鐝粍,宸ヨ祫绫诲瀷,鎽樿,鍐呴儴鍗曟嵁鍙�,琛ㄥご澶囨敞,鍒跺崟浜�,鍒跺崟鏃ユ湡" +
- ",瀹℃牳浜�,瀹℃牳鏃ユ湡,淇敼浜�,淇敼鏃ユ湡,鍏抽棴浜�, 鍏抽棴鏃ユ湡,HProcID,宸ュ簭浠ｇ爜,宸ュ簭鍚嶇О" +
- ",HEmpID,鑱屽憳浠ｇ爜,鑱屽憳,宸ユ椂,鏁伴噺,宸ヤ环,閲戦 FROM h_v_Pay_SingleBalBillList where 1 = 1 ";
+ ",瀹℃牳浜�,瀹℃牳鏃ユ湡,淇敼浜�,淇敼鏃ユ湡,鍏抽棴浜�, 鍏抽棴鏃ユ湡,HProcID,HProcNumber,HProcName" +
+ ",HEmpID,HEmpNumber,HEmpName,宸ユ椂,鏁伴噺,宸ヤ环,閲戦 FROM h_v_Pay_SingleBalBillList where 1 = 1 ";
string sql = sql1 + sqlWhere;
ds = oCN.RunProcReturn(sql, "h_v_Pay_SingleBalBillList");
objJsonResult.code = "0";
@@ -140,7 +140,7 @@
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "鏂板鍗曟嵁鎴愬姛锛�";
- objJsonResult.data = ds.Tables[0];
+ objJsonResult.data = null;
return objJsonResult;
}
@@ -193,17 +193,6 @@
objJsonResult.data = null;
return objJsonResult;
}
- else
- {
- if (ClsPub.isStrNull(ds.Tables[0].Rows[0][0]) == "2")
- {
- objJsonResult.code = "0";
- objJsonResult.count = 0;
- objJsonResult.Message = ClsPub.isStrNull(ds.Tables[0].Rows[0][1]);
- objJsonResult.data = null;
- return objJsonResult;
- }
- }
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = null;
@@ -225,67 +214,64 @@
List<Pay_SingleBalBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Pay_SingleBalBillSub>>(msg3);
for (int i = 0; i < subList.ToArray().Length; i++)
{
- //if (subList[i].HWorkQty <= 0)
- //{
- // objJsonResult.code = "0";
- // objJsonResult.count = 0;
- // objJsonResult.Message = "绗�" + i + "琛岋紝鍔犲伐鏁伴噺涓嶈兘涓�0鎴栬�呭皬浜�0";
- // objJsonResult.data = null;
- // return objJsonResult;
- //}
-
- string HCloseMan = "";//鍏抽棴浜�
- bool HCloseType = false;//
- string HEntryCloseDate = "";//鏃堕棿鍗曚綅
- long HSourceInterID = 0;//婧愬崟涓诲唴鐮�
- long HSourceEntryID = 0;//婧愬崟瀛愬唴鐮�
- string HSourceBillNo = "";//婧愬崟鍗曞彿
- string HSourceBillType = "";//婧愬崟绫诲瀷
- double HRelationQty = 0;//鍏宠仈鏁伴噺
- double HRelationMoney = 0;//鍏宠仈閲戦
- decimal HTimes = 0;
- decimal HQty = 0;
- decimal HPrice = 0;
- decimal HMoney = 0;
- long HICMOInterID = 0;
- string HICMOBillNo = "";
- long HProcID_S = 0;//宸ユID
- long HMaterID_S = 0;
- long HEmpID_S = 0;
- long HSourceID_S = 0;
- long HProcReportInterID = 0;
- long HProcReportEntryID = 0;
- long HProcPlanInterID = 0;
- long HProcPlanEntryID = 0;
- string HProcReportBillNo = "";
- string HProcPlanBillNo = "";
- decimal HPriceRate = 0;
- decimal HSubsidyTotal = 0;
- decimal HDeuctTotal = 0;
- decimal HPackQty = 0;
- decimal HPackPrice = 0;
- decimal HPackMoney = 0;
- long HPackMaterID = 0;
- decimal HSubsidyQty = 0;
- decimal HSubsidyMoney = 0;
+ long HEntryID = subList[0].HEntryID;//宸ユID
+ string HCloseMan = subList[0].HCloseMan;
+ long HCloseType = subList[0].HCloseType;
+ string HRemark = subList[0].HRemark;
+ long HSourceInterID = subList[0].HSourceInterID;
+ long HSourceEntryID = subList[0].HSourceEntryID;
+ string HSourceBillNo = subList[0].HSourceBillNo;
+ string HSourceBillType = subList[0].HSourceBillType;
+ decimal HRelationQty = subList[0].HRelationQty;
+ decimal HRelationMoney = subList[0].HRelationMoney;
+ long HSourceID = subList[0].HSourceID;
+ long HSqty = subList[0].HSqty;
+ long HSubsidyID = subList[0].HSubsidyID;
+ long HDeuctID = subList[0].HDeuctID;
+ long HMaterID = subList[0].HMaterID;
+ long HProcID = subList[0].HProcID;
+ long HEmpID = subList[0].HEmpID;
+ decimal HTimes = subList[0].HTimes;
+ decimal HQty = subList[0].HQty;
+ decimal HPrice = subList[0].HPrice;
+ decimal HPackQty = subList[0].HPackQty;
+ decimal HPackPrice = subList[0].HPackPrice;
+ decimal HPackMoney = subList[0].HPackMoney;
+ long HPackMaterID = subList[0].HPackMaterID;
+ decimal HPriceRate = subList[0].HPriceRate;
+ decimal HSubsidyTotal = subList[0].HSubsidyTotal;
+ decimal HDeuctTotal = subList[0].HDeuctTotal;
+ decimal HSubsidyQty = subList[0].HSubsidyQty;
+ decimal HSubsidyMoney = subList[0].HSubsidyMoney;
+ decimal HMoney = subList[0].HMoney;
+ long HICMOInterID = subList[0].HICMOInterID;
+ string HICMOBillNo = subList[0].HICMOBillNo;
+ long HProcReportInterID = subList[0].HProcReportInterID;
+ long HProcReportEntryID = subList[0].HProcReportEntryID;
+ long HProcPlanInterID = subList[0].HProcPlanInterID;
+ long HProcPlanEntryID = subList[0].HProcPlanEntryID;
+ string HProcReportBillNo = subList[0].HProcReportBillNo;
+ string HProcPlanBillNo = subList[0].HProcPlanBillNo;
- oCN.RunProc("Insert into Pay_SingleBalBillSub " +
+ string sql = "Insert into Pay_SingleBalBillSub " +
" (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
- ",HMaterID_S,HProcID_S,HEmpID_S,HSourceID_S,HTimes,HQty,HPrice," +
+ ",HMaterID,HProcID,HEmpID,HSourceID,HTimes,HQty,HPrice,HSqty" +
",HMoney,HICMOInterID,HICMOBillNo,HProcReportInterID,HProcReportEntryID,HProcReportBillNo" +
",HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo" +
- ",HPriceRate,HSubsidyTotal,HDeuctTotal" +
+ ",HPriceRate,HSubsidyTotal,HDeuctTotal,HSubsidyID,HDeuctID" +
",HPackQty,HPackPrice,HPackMoney,HPackMaterID,HSubsidyQty,HSubsidyMoney" +
") values("
- + HInterID + "," + i + "," + subList[i].HEntryID + ",'" + HCloseMan + "'" +
- "," + HEntryCloseDate + "," + Convert.ToString(HCloseType ? 1 : 0) +
- ",'" + subList[i].HRemark + "'," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "'," + HRelationQty + "," + HRelationMoney + "," +
- "," + HProcID_S + "," + HMaterID_S + "," + HEmpID_S + ", " + HSourceID_S + ",'" + HTimes + "','" + HQty + "'" +
- ",'" + HPrice + "','" + HMoney + "','" + HICMOInterID + "'," + HICMOBillNo + "," + HProcReportInterID + "," + HProcReportEntryID + "," +
- "," + HProcReportBillNo + "," + HProcPlanInterID + ",'" + HProcPlanEntryID + "','" + HProcPlanBillNo + "'," + HPriceRate + "," + HSubsidyTotal + "," +
- "," + HDeuctTotal + ",'" + HPackQty + "'," + HPackPrice + "," + HPackMoney + "," + HPackMaterID + "," + HSubsidyQty + "," + HSubsidyMoney + "," +
- ") ");
+ + HInterID.ToString() + "," + HEntryID.ToString() + ",'" + HCloseMan + "',''," + HCloseType + ",'" + HRemark + "'" +
+ "," + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "'," + HRelationQty.ToString() + "," + HRelationMoney.ToString() +
+ "," + HMaterID.ToString() + "," + HProcID.ToString() + "," + HEmpID.ToString() + "," + HSourceID.ToString()
+ + "," + HTimes.ToString() + "," + HQty.ToString() + "," + HPrice.ToString() + "," + HSqty.ToString() +
+ "," +HMoney.ToString() + "," + HICMOInterID.ToString() + ",'" + HICMOBillNo + "'," + HProcReportInterID.ToString() + "," + HProcReportEntryID.ToString() + ",'" + HProcReportBillNo + "'" +
+ "," +HProcPlanInterID.ToString() + "," + HProcPlanEntryID.ToString() + ",'" + HProcPlanBillNo + "'" +
+ "," + HPriceRate.ToString() + "," + HSubsidyTotal.ToString() + "," + HDeuctTotal.ToString() + "," + HSubsidyID.ToString() + "," + HDeuctID.ToString() +
+ "," + HPackQty.ToString() + "," + HPackPrice.ToString() + "," + HPackMoney.ToString() + "," + HPackMaterID.ToString() + "," + HSubsidyQty.ToString() + "," + HSubsidyMoney.ToString() +
+ ") ";
+ oCN.RunProc(sql);
}
objJsonResult.code = "1";
--
Gitblit v1.9.1