From 0b2465fa3e82ac16f2057302a533ff7c8a3a4bf8 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期四, 23 二月 2023 17:28:05 +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