From 6581234907def80093c3e9b4cdbc864714ed3f59 Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期二, 05 八月 2025 08:49:52 +0800
Subject: [PATCH] 1、首检生成检验项目时报请重试优化（字段长度限制所导致）
---
MES.Service/service/QC/SuspendService.cs | 18 +++++++++---------
1 files changed, 9 insertions(+), 9 deletions(-)
diff --git a/MES.Service/service/QC/SuspendService.cs b/MES.Service/service/QC/SuspendService.cs
index bc6fbef..17ed102 100644
--- a/MES.Service/service/QC/SuspendService.cs
+++ b/MES.Service/service/QC/SuspendService.cs
@@ -13,11 +13,11 @@
var db = SqlSugarHelper.GetInstance();
//return db.Queryable<SysDepartment>().ToList();
return db
- .Queryable<MesSchemeResult, MesLine, QsQaItemXj, SysDepartment>(
- (a, b, c, d) =>
- new JoinQueryInfos(JoinType.Left, a.LineNo == b.LineNo,
- JoinType.Inner, a.BillNo == c.BillNo,
- JoinType.Left, b.Departmentcode == d.Departmentcode))
+ .Queryable<MesSchemeResult, MesLine, QsQaItemXj, SysDepartment>((a,
+ b, c, d) =>
+ new JoinQueryInfos(JoinType.Left, a.LineNo == b.LineNo,
+ JoinType.Inner, a.BillNo == c.BillNo,
+ JoinType.Left, b.Departmentcode == d.Departmentcode))
.Where((a, b, c, d) => a.PmoveMk == 0 && b.LineName != null &&
statusArray.Contains(a.ProcStatus))
.GroupBy((a, b, c, d) => new
@@ -34,10 +34,10 @@
public List<MesLine> GetLines(string deptCode)
{
var db = SqlSugarHelper.GetInstance();
- var mesLines = db.Queryable<MesSchemeResult, MesLine, QsQaItemXj>(
- (a, b, c) =>
- new JoinQueryInfos(JoinType.Left, a.LineNo == b.LineNo,
- JoinType.Inner, a.BillNo == c.BillNo))
+ var mesLines = db
+ .Queryable<MesSchemeResult, MesLine, QsQaItemXj>((a, b, c) =>
+ new JoinQueryInfos(JoinType.Left, a.LineNo == b.LineNo,
+ JoinType.Inner, a.BillNo == c.BillNo))
.Where((a, b, c) => b.LineName != null &&
statusArray.Contains(a.ProcStatus)
&& b.Departmentcode == deptCode)
--
Gitblit v1.9.3