From 0aa54059b26e6641196e9953490dd18616e916e3 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期三, 10 九月 2025 17:26:47 +0800 Subject: [PATCH] 精简修正代码 --- service/Warehouse/MesInvItemOutsManager.cs | 53 ++++++++++++++++++++++++++--------------------------- 1 files changed, 26 insertions(+), 27 deletions(-) diff --git a/service/Warehouse/MesInvItemOutsManager.cs b/service/Warehouse/MesInvItemOutsManager.cs index 413e251..5fd556a 100644 --- a/service/Warehouse/MesInvItemOutsManager.cs +++ b/service/Warehouse/MesInvItemOutsManager.cs @@ -68,11 +68,11 @@ if (!isValid) throw new ApplicationException("GUID杞崲閿欒"); - var mesInvItemOutItemsList = Db.Queryable<MesInvItemOutItems, MesItems>( - (c, s) => new object[] - { - JoinType.Inner, c.ItemId == s.Id - }).Where((c, s) => c.ItemOutId == parsedGuid) + var mesInvItemOutItemsList = Db + .Queryable<MesInvItemOutItems, MesItems>((c, s) => new object[] + { + JoinType.Inner, c.ItemId == s.Id + }).Where((c, s) => c.ItemOutId == parsedGuid) .Select<MesInvItemOutItems>((c, s) => new MesInvItemOutItems { Guid = c.Guid, @@ -272,8 +272,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() )) @@ -392,8 +392,7 @@ it.Status == 1) .ToPageList(1, 20); - var ItemOutNos = data5.FindAll(a => a.Nflag == null || a.Nflag == 0) - .ToList(); + var ItemOutNos = data5.FindAll(a => a.Nflag == null || a.Nflag == 0); return ItemOutNos; } @@ -433,13 +432,12 @@ var mesInvItemOutCDetailsList = Db .Queryable<MesInvItemOutCDetails, MesInvItemBarcodes, MesItems, - MesDepots>( - (b, bar, c, d) => new - JoinQueryInfos( - JoinType.Left, b.ItemBarcode == bar.ItemBarcode, - JoinType.Left, b.ItemId == c.Id, - JoinType.Left, b.DepotId == d.DepotId - )) + MesDepots>((b, bar, c, d) => new + JoinQueryInfos( + JoinType.Left, b.ItemBarcode == bar.ItemBarcode, + JoinType.Left, b.ItemId == c.Id, + JoinType.Left, b.DepotId == d.DepotId + )) .Where((b, bar, c, d) => b.ItemOutId == parsedGuid) .Select((b, bar, c, d) => new MesInvItemOutCDetails { @@ -506,15 +504,15 @@ var materials = Db .Queryable<MesInvItemOuts, MesInvItemOutItems, - MesItems, MesUnit, MesInvItemArnDetail, MesDepots>( - (a, b, c, d, e, f) => new JoinQueryInfos( - JoinType.Left, a.Guid == b.ItemOutId, - JoinType.Left, b.ItemId == c.Id, - JoinType.Left, d.Id.ToString() == c.ItemUnit, - JoinType.Left, - e.CbillNo == b.WorkNo && e.ItemId == b.ItemId, - JoinType.Left, f.DepotId == a.DepotId - )).Where((a, b, c, d, e, f) => b.Guid == guid) + MesItems, MesUnit, MesInvItemArnDetail, MesDepots>((a, b, c, d, + e, f) => new JoinQueryInfos( + JoinType.Left, a.Guid == b.ItemOutId, + JoinType.Left, b.ItemId == c.Id, + JoinType.Left, d.Id.ToString() == c.ItemUnit, + JoinType.Left, + e.CbillNo == b.WorkNo && e.ItemId == b.ItemId, + JoinType.Left, f.DepotId == a.DepotId + )).Where((a, b, c, d, e, f) => b.Guid == guid) .Select<Material>((a, b, c, d, e, f) => new Material { FMaterialId = c.ItemNo, @@ -721,8 +719,9 @@ C_STOCKNUM = c_mes_inv_item_stocks.Quantity.Value; // Calculate the total and completed quantities for the item - var quantities = db.Queryable<MesInvItemOutItems, MesInvItemOuts>( - (s, d) => new object[] + var quantities = db + .Queryable<MesInvItemOutItems, MesInvItemOuts>((s, d) => + new object[] { JoinType.Left, s.ItemOutId == d.Guid }) -- Gitblit v1.9.3