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