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 | 9 +++++----
1 files changed, 5 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/PublicPageMethodController.cs b/WebAPI/Controllers/PublicPageMethodController.cs
index edfc785..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";
@@ -2069,7 +2070,7 @@
}
else
{
- string sql1 = "Select HItemID,HParentID,HNumber,HName from h_v_IF_Unit ";
+ string sql1 = "Select HItemID,HParentID,HNumber,HName from h_v_IF_Unit ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "h_v_IF_Unit");
}
--
Gitblit v1.9.1