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
