From 4f8d1da89bc7cf399e6d90d6230ad6c28114443a Mon Sep 17 00:00:00 2001 From: 南骏 池 <chiffly@163.com> Date: 星期一, 23 六月 2025 11:20:13 +0800 Subject: [PATCH] 1.采购入库优化 2.采购退货推荐库位优化 --- service/Warehouse/MesCgthSqManager.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/service/Warehouse/MesCgthSqManager.cs b/service/Warehouse/MesCgthSqManager.cs index 169d43d..9c23a05 100644 --- a/service/Warehouse/MesCgthSqManager.cs +++ b/service/Warehouse/MesCgthSqManager.cs @@ -27,7 +27,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,A.depot_id,'','') as RecoKw fROM MES_CGTH_SQ_DETAIL A LEFT JOIN MES_CGTH_SQ B ON A.MID = B.ID LEFT JOIN MES_ITEMS C ON A.ITEM_ID = C.item_id -- Gitblit v1.9.3