From 464f5a591e5d02fe0873505a119e17a576945ca6 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期五, 19 七月 2024 17:21:44 +0800
Subject: [PATCH] 报工台跳转异常反馈单 弹窗获取 设备编码
---
WebAPI/Controllers/CGGL/YF_PayMentBillController.cs | 45 +++++++++++----------------------------------
1 files changed, 11 insertions(+), 34 deletions(-)
diff --git a/WebAPI/Controllers/CGGL/YF_PayMentBillController.cs b/WebAPI/Controllers/CGGL/YF_PayMentBillController.cs
index e8e77b5..9089659 100644
--- a/WebAPI/Controllers/CGGL/YF_PayMentBillController.cs
+++ b/WebAPI/Controllers/CGGL/YF_PayMentBillController.cs
@@ -1004,10 +1004,6 @@
#endregion
-
-
-
-
#region 閲囪喘璁㈠崟鍒拌揣鍙婃椂鐜囨姤琛� 鏌ヨ
/// <summary>s
/// 杩斿洖椤圭洰闃舵鍒楄〃
@@ -1022,7 +1018,7 @@
{
List<object> columnNameList = new List<object>();
- ds = oCN.RunProcReturn("exec h_p_Cg_POOrderReceiveSumReport '" + sWhere + "','',''", "h_p_Cg_POMaterialPriceReport");// h_p_Cg_POMaterialPriceReport 閲囪喘鍒嗘瀽鎶ヨ〃
+ ds = oCN.RunProcReturn("exec h_p_Cg_POOrderReceiveSumReport '" + sWhere + "'", "h_p_Cg_POOrderReceiveSumReport");// h_p_Cg_POMaterialPriceReport 閲囪喘鍒嗘瀽鎶ヨ〃
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
@@ -1057,7 +1053,7 @@
/// </summary>
[Route("YF_PayMentBill/GetCg_POInStockBillSumReport")]
[HttpGet]
- public object GetCg_POInStockBillSumReport(string sWhere, string user, string userid)
+ public object GetCg_POInStockBillSumReport(string sWhere, string user)
{
try
{
@@ -1076,12 +1072,13 @@
//鏌ヨ
if (sWhere == null || sWhere.Equals(""))
{
- string sql = "exec h_p_Cg_POInStockBillSumReport '','" + userid + "'";
+ string sql = "exec h_p_Cg_POInStockBillSumReport ''";
ds = oCN.RunProcReturn(sql, "h_p_Cg_POInStockBillSumReport");
}
else
{
- string sql = "exec h_p_Cg_POInStockBillSumReport '" + sWhere + "','" + userid + "'";
+ string sql = "exec h_p_Cg_POInStockBillSumReport '" + sWhere + "'";
+ ds = oCN.RunProcReturn(sql, "h_p_Cg_POInStockBillSumReport");
}
//娣诲姞鍒楀悕
@@ -1113,24 +1110,14 @@
#region 閲囪喘涓氬姟/璁㈠崟鎶ョ粺璁¤〃 鏌ヨ
[Route("YF_PayMentBill/Cg_POOrderBillSumReport")]
[HttpGet]
- public object Cg_POOrderBillSumReport(string DateYear, string HType, string user)
+ public object Cg_POOrderBillSumReport(string sWhere, string user)
{
try
{
DataSet ds;
List<object> columnNameList = new List<object>();
- if (DateYear == null || DateYear.Equals(""))
- {
- objJsonResult.code = "0";
- objJsonResult.count = 0;
- objJsonResult.Message = "璇烽�夋嫨鏈夋晥骞翠唤";
- return objJsonResult;
- }
- else
- {
- ds = oCN.RunProcReturn("exec [h_p_Cg_POOrderBillSumReport] '" + DateYear + "','" + HType + "'", "[h_p_Cg_POMaterialPriceReport]");
- }
+ ds = oCN.RunProcReturn("exec [h_p_Cg_POOrderBillSumReport] '" + sWhere + "'", "[h_p_Cg_POMaterialPriceReport]");
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
@@ -1161,24 +1148,14 @@
#region 閲囪喘浠锋牸鍒嗘瀽琛� 鏌ヨ
[Route("YF_PayMentBill/POMaterialPriceReport")]
[HttpGet]
- public object POMaterialPriceReport(string DateYear, string HType, string user)
+ public object POMaterialPriceReport(string sWhere, string user)
{
try
{
DataSet ds;
List<object> columnNameList = new List<object>();
- if (DateYear == null || DateYear.Equals(""))
- {
- objJsonResult.code = "0";
- objJsonResult.count = 0;
- objJsonResult.Message = "璇烽�夋嫨鏈夋晥骞翠唤";
- return objJsonResult;
- }
- else
- {
- ds = oCN.RunProcReturn("exec [h_p_Cg_POMaterialPriceReport] '" + DateYear + "','" + HType + "'", "[h_p_Cg_POMaterialPriceReport]");
- }
+ ds = oCN.RunProcReturn("exec [h_p_Cg_POMaterialPriceReport] '" + sWhere + "'", "[h_p_Cg_POMaterialPriceReport]");
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
@@ -1220,7 +1197,7 @@
{
List<object> columnNameList = new List<object>();
- ds = oCN.RunProcReturn("exec h_p_Cg_POOrderBillProcessSumReport '" + sWhere + "','',''", "h_p_Cg_POOrderBillProcessSumReport");
+ ds = oCN.RunProcReturn("exec h_p_Cg_POOrderBillProcessSumReport '" + sWhere + "'", "h_p_Cg_POOrderBillProcessSumReport");
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
@@ -1262,7 +1239,7 @@
{
List<object> columnNameList = new List<object>();
- ds = oCN.RunProcReturn("exec h_p_Cg_POOrderReceiveDaySumReport '" + sWhere + "','',''", "h_p_Cg_POOrderReceiveDaySumReport");
+ ds = oCN.RunProcReturn("exec h_p_Cg_POOrderReceiveDaySumReport '" + sWhere + "'", "h_p_Cg_POOrderReceiveDaySumReport");
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
--
Gitblit v1.9.1