From 47ebb7042bb5b26640e7136404046edd635841c1 Mon Sep 17 00:00:00 2001
From: ch <37327@LLOOCCY>
Date: 星期二, 07 二月 2023 17:36:24 +0800
Subject: [PATCH] 提交

---
 WebAPI/Controllers/PublicPageMethodController.cs |    7 ++++---
 1 files changed, 4 insertions(+), 3 deletions(-)

diff --git a/WebAPI/Controllers/PublicPageMethodController.cs b/WebAPI/Controllers/PublicPageMethodController.cs
index 80c23d0..cfcda44 100644
--- a/WebAPI/Controllers/PublicPageMethodController.cs
+++ b/WebAPI/Controllers/PublicPageMethodController.cs
@@ -1491,9 +1491,10 @@
             try
             {
                 
-                    string sql1 = "Select * from Kf_StockOutRequestBillMain where 1 = 1 ";
-                    string sql = sql1 + sWhere;
-                    ds = oCN.RunProcReturn(sql, "Kf_StockOutRequestBillMain");
+                    string sql1 = "Select * from AIS20220914133941..T_STK_OUTSTOCKAPPLY where fdocumentstatus = 'C' and FCloseStatus = 'A'";
+                   string sql2 = "order by Fdate asc";
+                 string sql = sql1 + sWhere + sql2;
+                    ds = oCN.RunProcReturn(sql, "T_STK_OUTSTOCKAPPLY");
                 if (ds == null || ds.Tables[0].Rows.Count == 0)
                 {
                     objJsonResult.code = "0";

--
Gitblit v1.9.1