From b8fa3c75a36784fb61d1ebc988710293826da521 Mon Sep 17 00:00:00 2001 From: 南骏 池 <chiffly@163.com> Date: 星期五, 06 六月 2025 17:41:04 +0800 Subject: [PATCH] 1.其他出库优化 --- service/Warehouse/MesItemBlManager.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/service/Warehouse/MesItemBlManager.cs b/service/Warehouse/MesItemBlManager.cs index ca78cba..762d934 100644 --- a/service/Warehouse/MesItemBlManager.cs +++ b/service/Warehouse/MesItemBlManager.cs @@ -69,7 +69,7 @@ //return (mesItemBl.Bl001, blDetails); var sql = string.Format(@"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,A.BLD007 FQty,A.BLD008 SQty,A.BLD007 - A.BLD008 DSQty, - dbo.F_QX_GETRECODEPOTSE(A.bld012) as RecoKw,D.daa001 + dbo.F_QX_GETRECODEPOTSE(A.bld012,'','','') as RecoKw,D.daa001 fROM MES_ITEM_BL_DETAIL A LEFT JOIN MES_ITEM_BL B ON A.MID = B.ID LEFT JOIN MES_ITEMS C ON A.bld012 = CAST(C.item_id AS VARCHAR(50)) -- Gitblit v1.9.3