From 655dcd6abee52e038e59cd557c3237073c90f979 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期四, 03 四月 2025 15:01:15 +0800 Subject: [PATCH] 登录方法查询修改;各列表查询修改供应商过滤方式 --- WebAPI/Controllers/POInStockBackController.cs | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/POInStockBackController.cs b/WebAPI/Controllers/POInStockBackController.cs index f419a50..6a483c6 100644 --- a/WebAPI/Controllers/POInStockBackController.cs +++ b/WebAPI/Controllers/POInStockBackController.cs @@ -31,7 +31,7 @@ [HttpPost] public object GetPOInStockBackBillList([FromBody] JObject msg) { - string HSupNo = msg["HSupNo"].ToString(); string sqlWhere = msg["sqlWhere"].ToString(); + string HSupIDs = msg["HSupIDs"].ToString(); string sqlWhere = msg["sqlWhere"].ToString(); try { string VsWhere = ""; @@ -39,7 +39,7 @@ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet ds; //鍏朵粬杩囨护 - string sql = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 鐢ㄦ埛=''" + HSupNo.Trim() + "'') " + sqlWhere; + string sql = " Where hsupid in (" + HSupIDs.Trim() + ")" + sqlWhere; //杞崲鐗规畩瀛楃 if (Common.SQLtoChange(sql, ref VsWhere, ref PcWhere) == false) { -- Gitblit v1.9.1