From ac2f359d397c0ec5eb87c9cbc415584d1d88439f Mon Sep 17 00:00:00 2001 From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU> Date: 星期二, 16 九月 2025 08:56:53 +0800 Subject: [PATCH] 采购退料:列表选择、列表明细更改为存储过程,添加组织隔离,添加库位列表,添加隐藏完结单号功能 --- service/Warehouse/MesSctkManager.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/service/Warehouse/MesSctkManager.cs b/service/Warehouse/MesSctkManager.cs index c5798ef..7a1d9bf 100644 --- a/service/Warehouse/MesSctkManager.cs +++ b/service/Warehouse/MesSctkManager.cs @@ -28,7 +28,7 @@ if (mesInvItemOuts == null) throw new Exception("閲囪喘閫�璐х敵璇峰崟涓嶅瓨鍦�"); var sql = string.Format(@"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,A.SQ_NUM FQty,A.YS_NUM SQty,A.SQ_NUM - A.YS_NUM DSQty, - dbo.F_QX_GETRECODEPOTSE(A.ITEM_ID) as RecoKw + dbo.F_QX_GETRECODEPOTSE(A.ITEM_ID,'','','') as RecoKw fROM MES_SCTH_SQ_DETAIL A LEFT JOIN MES_SCTH_SQ B ON A.MID = B.ID LEFT JOIN MES_ITEMS C ON A.ITEM_ID = C.item_id -- Gitblit v1.9.3