From 799a463b41e84aa265f109035c08892614ea9fd8 Mon Sep 17 00:00:00 2001 From: kyy <3283105747@qq.com> Date: 星期四, 24 七月 2025 21:12:32 +0800 Subject: [PATCH] 首检排序 --- MES.Service/service/Warehouse/MesInvItemOutsManager.cs | 25 ++++++++++++------------- 1 files changed, 12 insertions(+), 13 deletions(-) diff --git a/MES.Service/service/Warehouse/MesInvItemOutsManager.cs b/MES.Service/service/Warehouse/MesInvItemOutsManager.cs index 08b04e2..ee63563 100644 --- a/MES.Service/service/Warehouse/MesInvItemOutsManager.cs +++ b/MES.Service/service/Warehouse/MesInvItemOutsManager.cs @@ -294,8 +294,8 @@ foreach (var j in itemOutItems) { // 鏍¢獙瀛愯〃瀵瑰簲閲囪喘璁㈠崟鐨勪緵搴斿晢缂栫爜 - var c_SuppNo = Db.Queryable<MesRohIn, MesSupplier>( - (roh, supp) => new JoinQueryInfos( + var c_SuppNo = Db.Queryable<MesRohIn, MesSupplier>((roh, supp) => + new JoinQueryInfos( JoinType.Left, roh.Supplier == supp.Id.ToString() )) @@ -425,17 +425,16 @@ public List<MesInvItemOutCDetails> GetScanBarcode(WarehouseQuery query) { return Db.Queryable<MesInvItemOutCDetails, MesInvItemBarcodes, MesItems, - MesDepots>( - (b, bar, c, d) => new - JoinQueryInfos( - JoinType.Left, b.ItemBarcode == bar.ItemBarcode, - JoinType.Left, b.ItemNo == c.ItemNo && - b.Company == c.Company && - b.Factory == c.Factory, - JoinType.Left, b.DepotCode == d.DepotCode && - b.Company == d.Company && - b.Factory == d.Factory - )) + MesDepots>((b, bar, c, d) => new + JoinQueryInfos( + JoinType.Left, b.ItemBarcode == bar.ItemBarcode, + JoinType.Left, b.ItemNo == c.ItemNo && + b.Company == c.Company && + b.Factory == c.Factory, + JoinType.Left, b.DepotCode == d.DepotCode && + b.Company == d.Company && + b.Factory == d.Factory + )) .Where((b, bar, c, d) => b.ItemOutId == query.id) .Select((b, bar, c, d) => new MesInvItemOutCDetails { -- Gitblit v1.9.3