From 873f69e7f1e681cbd1dacd7a39f9140885756fcc Mon Sep 17 00:00:00 2001 From: payne <bzrlw2012@163.com> Date: 周四, 25 4月 2024 16:37:45 +0800 Subject: [PATCH] 修改 --- iWare_RawMaterialWarehouse_Wms/Admin.NET.Application/Service/WmsBase/WmsMaterial/WmsMaterialService.cs | 16 +++++++++++++--- 1 files changed, 13 insertions(+), 3 deletions(-) diff --git a/iWare_RawMaterialWarehouse_Wms/Admin.NET.Application/Service/WmsBase/WmsMaterial/WmsMaterialService.cs b/iWare_RawMaterialWarehouse_Wms/Admin.NET.Application/Service/WmsBase/WmsMaterial/WmsMaterialService.cs index 2f34e10..4d6c0c2 100644 --- a/iWare_RawMaterialWarehouse_Wms/Admin.NET.Application/Service/WmsBase/WmsMaterial/WmsMaterialService.cs +++ b/iWare_RawMaterialWarehouse_Wms/Admin.NET.Application/Service/WmsBase/WmsMaterial/WmsMaterialService.cs @@ -191,16 +191,26 @@ .ProjectToType<WmsControlRuleDetailOutput>() .ToListAsync(); + //鐗╂枡瀹㈡埛鍏宠仈 + var wmsMaterialCustomerList = await _wmsMaterialCustomerRep.DetachedEntities + .Where(u => u.MaterialId == wmsMaterialInfo.Id) + .Where(u => u.IsDeleted == false) + .OrderBy(o => o.CreatedTime) + .ProjectToType<WmsMaterialCustomerOutput>() + .ToListAsync(); + List<long> custIds = wmsMaterialCustomerList.Select(s => s.CustId).ToList(); //鏍规嵁鐗╂枡瀹㈡埛鍏宠仈琛ㄨ幏鍙栧線鏉ヤ俊鎭� - var baseCustomers = await _baseCustomerRep.DetachedEntities.Join(_wmsMaterialCustomerRep.DetachedEntities, bc => bc.Id, mc => mc.CustId, (bc, mc) => new { bc, mc }) - .Where(p =>p.mc.MaterialId== wmsMaterialInfo.Id) - .OrderBy(o => o.mc.CreatedTime) + var baseCustomers = await _baseCustomerRep.DetachedEntities + .Where(p => custIds.Contains(p.Id)) + .OrderBy(o => o.CreatedTime) .ProjectToType<BaseCustomerOutput>() .ToListAsync(); + resultInfo.MaterialInfo = wmsMaterialInfo; resultInfo.SubstituteGoodList = wmsSubstituteGoods; resultInfo.ControlRuleDetailList = wmsControlRuleDetails; + resultInfo.BaseCustomerList = baseCustomers; return resultInfo; } -- Gitblit v1.9.3