From 6cdde9817310399d7ff829dcb19e580b64f13cf4 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 25 九月 2024 18:10:43 +0800
Subject: [PATCH] 更新SqlSugar的框架。入库检增加回写工序，工单，条码的操作。增加入库单检验结果处理后无法更改检验值的校验
---
MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs | 15 +++++++++------
1 files changed, 9 insertions(+), 6 deletions(-)
diff --git a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
index c827092..73d3732 100644
--- a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
+++ b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
@@ -28,7 +28,8 @@
c.ItemNo == t.ItemNo && c.Company == t.Company &&
c.Factory == t.Factory,
JoinType.Left,
- t.Fpurchaseunitid == u.Id && t.Factory == u.Factory &&
+ t.Fpurchaseunitid == u.Id.ToString() &&
+ t.Factory == u.Factory &&
t.Company == u.Company
})
.Where((c, t, u) => c.Mid == query.id)
@@ -59,18 +60,20 @@
// 鏌ヨ
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.ToString(),
+ JoinType.Inner, z.ReleaseNo == a.ReleaseNo
})
- .Where((a, d, b, c, t) => a.FngHandle == "閫�璐�" &&
- query.ItemArnDetailIds.Contains(b.Id))
+ .Where((a, d, b, c, t, z) => a.FngHandle == "閫�璐�" &&
+ z.FcheckResu == "涓嶅悎鏍�" &&
+ query.ItemArnDetailIds.Contains(b.Id))
.Select((a, d, b, c, t) => new Material
{
FmrMode = a.Fmrmode,
--
Gitblit v1.9.3