From ed05efdc17aab076146b134ebe105b6382f221d7 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期四, 10 七月 2025 10:09:29 +0800 Subject: [PATCH] 格式化代码 --- MES.Service/service/Warehouse/MesInvItemOutsManager.cs | 70 +++++++++++++++++----------------- 1 files changed, 35 insertions(+), 35 deletions(-) diff --git a/MES.Service/service/Warehouse/MesInvItemOutsManager.cs b/MES.Service/service/Warehouse/MesInvItemOutsManager.cs index 95cc7b2..86cc440 100644 --- a/MES.Service/service/Warehouse/MesInvItemOutsManager.cs +++ b/MES.Service/service/Warehouse/MesInvItemOutsManager.cs @@ -68,11 +68,12 @@ private List<MesInvItemOutItems> getProductionItemsList( WarehouseQuery query) { - return Db.Queryable<MesInvItemOutItems, MesItems, MesDepTaskInfo>( - (c, s, f) => new JoinQueryInfos( - JoinType.Inner, c.ItemNo == s.ItemNo, - JoinType.Left, f.TaskNo == c.TaskNo && f.ItemNo == c.ItemNo - )) + return Db + .Queryable<MesInvItemOutItems, MesItems, + MesDepTaskInfo>((c, s, f) => new JoinQueryInfos( + JoinType.Inner, c.ItemNo == s.ItemNo, + JoinType.Left, f.TaskNo == c.TaskNo && f.ItemNo == c.ItemNo + )) .Where((c, s, f) => c.ItemOutId == query.id) .OrderBy(c => c.Id) .Select((c, s, f) => new MesInvItemOutItems @@ -97,8 +98,8 @@ WarehouseQuery query) { return Db - .Queryable<MesInvItemOutCDetails, MesItems, MesDepots>( - (b, c, d) => new JoinQueryInfos( + .Queryable<MesInvItemOutCDetails, MesItems, MesDepots>((b, c, d) => + new JoinQueryInfos( JoinType.Left, b.ItemNo == c.ItemNo && b.Company == c.Company && b.Factory == c.Factory, @@ -403,8 +404,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() )) @@ -534,17 +535,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 { @@ -880,11 +880,11 @@ if (womcaa == null) throw new Exception("浠诲姟鍗曞彿涓嶅瓨鍦�"); - var Departmentcode = Db.Queryable<SysDepartment, MesInvItemOuts>( - (a, b) => - new JoinQueryInfos(JoinType.Left, - a.Departmentname == b.OutPart - )).Where((a, b) => + var Departmentcode = Db + .Queryable<SysDepartment, MesInvItemOuts>((a, b) => + new JoinQueryInfos(JoinType.Left, + a.Departmentname == b.OutPart + )).Where((a, b) => b.OutPart == mesInvItemOuts.OutPart && b.ItemOutNo == queryBillNo).Select(a => a.Departmentcode) .First(); @@ -896,14 +896,14 @@ if (mesInvItemOuts.Status == 1) throw new Exception("棰嗘枡鍗曞凡瀹℃牳锛屼笉鑳介噸澶嶆帹閫�"); var C_OUT_ITEMS = Db - .Queryable<MesInvItemOutItems, Womdab, Womdaa, Womcaa, Womcab>( - (c, b, d, e, f) => - new JoinQueryInfos( - JoinType.Left, b.Id == c.ItemDabid, - JoinType.Left, d.Id == b.Pid, - JoinType.Left, e.Caa001 == d.Daa021, - JoinType.Left, f.Eid == e.Erpid - )) + .Queryable<MesInvItemOutItems, Womdab, Womdaa, Womcaa, Womcab>((c, + b, d, e, f) => + new JoinQueryInfos( + JoinType.Left, b.Id == c.ItemDabid, + JoinType.Left, d.Id == b.Pid, + JoinType.Left, e.Caa001 == d.Daa021, + JoinType.Left, f.Eid == e.Erpid + )) .Where((c, b, d, e, f) => c.ItemOutId == mesInvItemOuts.Id) .Select((c, b, d, e, f) => new { @@ -936,8 +936,8 @@ { FMaterialId = item.ItemNo, FUnitID = C_ITEM_UNIT, - FAppQty = qty, - FActualQty = qty, + FAppQty = qty, + FActualQty = qty, FStockId = item.DepotCode, FPPBomEntryId = erpid, F_UNW_Text_xsddh = xsddh, -- Gitblit v1.9.3