From 5a01014dc116813fd4ea05b61e1eb6eec669f95d Mon Sep 17 00:00:00 2001
From: wangbin <lan@DESKTOP-MG88OFJ>
Date: 星期一, 08 七月 2024 09:25:48 +0800
Subject: [PATCH] 1

---
 WebAPI/Controllers/CGGL/YF_PayMentBillController.cs |    5 +++--
 1 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/WebAPI/Controllers/CGGL/YF_PayMentBillController.cs b/WebAPI/Controllers/CGGL/YF_PayMentBillController.cs
index 4f973d0..9089659 100644
--- a/WebAPI/Controllers/CGGL/YF_PayMentBillController.cs
+++ b/WebAPI/Controllers/CGGL/YF_PayMentBillController.cs
@@ -1018,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)
@@ -1078,6 +1078,7 @@
                 else
                 {
                     string sql = "exec h_p_Cg_POInStockBillSumReport  '" + sWhere + "'";
+                    ds = oCN.RunProcReturn(sql, "h_p_Cg_POInStockBillSumReport");
                 }
 
                 //娣诲姞鍒楀悕
@@ -1238,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