From ce43535d56152482c1f12e6b13ba3377bd268009 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期二, 13 八月 2024 13:42:28 +0800 Subject: [PATCH] 期初入库扫码,接受erp发送的用户数据时,在写入MES用户表时增加部分默认字段 --- MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs | 10 ++++++---- 1 files changed, 6 insertions(+), 4 deletions(-) diff --git a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs index c827092..49ad635 100644 --- a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs +++ b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs @@ -59,17 +59,19 @@ // 鏌ヨ var result = Db .Queryable<MesQaItemsDetect01, MesInvItemArn, MesInvItemArnDetail, - MesItems, MesUnit>( - (a, d, b, c, t) => new object[] + MesItems, MesUnit,MesQaItemsDetectDetail5>( + (a, d, b, c, t,z) => new object[] { JoinType.Inner, d.BillNo == a.LotNo, JoinType.Inner, d.Id == b.Mid && b.ItemNo == a.ItemNo, JoinType.Inner, a.ItemNo == c.ItemNo && a.Company == c.Company && a.Factory == c.Factory, - JoinType.Inner, c.Fpurchaseunitid == t.Id + JoinType.Inner, c.Fpurchaseunitid == t.Id, + JoinType.Inner, z.ReleaseNo == a.ReleaseNo }) - .Where((a, d, b, c, t) => a.FngHandle == "閫�璐�" && + .Where((a, d, b, c, t,z) => a.FngHandle == "閫�璐�" && + z.FcheckResu == "涓嶅悎鏍�" && query.ItemArnDetailIds.Contains(b.Id)) .Select((a, d, b, c, t) => new Material { -- Gitblit v1.9.3