From 0010dd10c41c5c990bf6cc1b40ad857a6c956cbe Mon Sep 17 00:00:00 2001 From: 南骏 池 <chiffly@163.com> Date: 星期四, 05 六月 2025 09:45:43 +0800 Subject: [PATCH] 1.其他入库优化 2.推荐库位函数优化 --- 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