From 164c6f37b9c31497079cf4b4183fb14845c33858 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 08 十月 2024 08:43:09 +0800
Subject: [PATCH] 入库检清除检验结果的入库检验调整
---
MES.Service/service/QC/SuspendService.cs | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/MES.Service/service/QC/SuspendService.cs b/MES.Service/service/QC/SuspendService.cs
index b1db17d..ce48de9 100644
--- a/MES.Service/service/QC/SuspendService.cs
+++ b/MES.Service/service/QC/SuspendService.cs
@@ -15,7 +15,8 @@
return db
.Queryable<Womdaa, MesLine, QsQaItemXj, SysDepartment>(
(a, b, c, d) =>
- new JoinQueryInfos(JoinType.Left, a.Daa002 == b.Id.ToString(),
+ new JoinQueryInfos(JoinType.Left,
+ a.Daa002 == b.Id.ToString(),
JoinType.Inner, a.Daa001 == c.BillNo,
JoinType.Left, b.Departmentcode == d.Departmentcode))
.Where((a, b, c, d) => b.LineName != null &&
@@ -36,7 +37,8 @@
var db = SqlSugarHelper.GetInstance();
var mesLines = db.Queryable<Womdaa, MesLine, QsQaItemXj>(
(a, b, c) =>
- new JoinQueryInfos(JoinType.Left, a.Daa002 == b.Id.ToString(),
+ new JoinQueryInfos(JoinType.Left,
+ a.Daa002 == b.Id.ToString(),
JoinType.Inner, a.Daa001 == c.BillNo))
.Where((a, b, c) => b.LineName != null &&
statusArray.Contains(a.Daa018)
--
Gitblit v1.9.3