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