From e0586c9193b7ac3113980899efadb4ab6f4851b8 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期五, 17 二月 2023 17:23:38 +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 02a85d8..b6f02c4 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