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))
