From 7ee2e58c300374a15c212f9145ba9d762d64e0e6 Mon Sep 17 00:00:00 2001
From: fcx <2246384483@qq.com>
Date: 星期六, 20 十二月 2025 15:58:11 +0800
Subject: [PATCH] 1.新增MES_PROJECT.cs
---
StandardPda/MES.Service/Modes/QsQaItemXj.cs | 4 ++
StandardPda/MES.Service/Modes/MES_PROJECT.cs | 63 +++++++++++++++++++++++++++++++
StandardPda/MES.Service/service/QC/XJService.cs | 25 ++++++++----
3 files changed, 83 insertions(+), 9 deletions(-)
diff --git a/StandardPda/MES.Service/Modes/MES_PROJECT.cs b/StandardPda/MES.Service/Modes/MES_PROJECT.cs
new file mode 100644
index 0000000..f122fb4
--- /dev/null
+++ b/StandardPda/MES.Service/Modes/MES_PROJECT.cs
@@ -0,0 +1,63 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// </summary>
+[SugarTable("MES_PROJECT")]
+public class MES_PROJECT
+{
+
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// 椤圭洰缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "PROJECT_CODE")]
+ public string? PROJECT_CODE { get; set; }
+
+ /// <summary>
+ /// 椤圭洰鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "PROJECT_NAME")]
+ public string? PROJECT_NAME { get; set; }
+
+ /// <summary>
+ /// 椤圭洰鍒嗙被
+ /// </summary>
+ [SugarColumn(ColumnName = "PROJECT_TYPE")]
+ public string? PROJECT_TYPE { get; set; }
+
+ /// <summary>
+ /// 鎻忚堪
+ /// </summary>
+ [SugarColumn(ColumnName = "DESCRIPTION")]
+ public string? DESCRIPTION { get; set; }
+
+ /// <summary>
+ /// 椤圭洰缁忕悊
+ /// </summary>
+ [SugarColumn(ColumnName = "OPERATORS_ID")]
+ public string? OPERATORS_ID { get; set; }
+
+ /// <summary>
+ /// 椤圭洰鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "DOCUMENT_STATUS")]
+ public string? DOCUMENT_STATUS { get; set; }
+
+ /// <summary>
+ /// 鏄惁鐢熸晥
+ /// </summary>
+ [SugarColumn(ColumnName = "FORBID_STATUS")]
+ public string? FORBID_STATUS { get; set; }
+
+
+ /// <summary>
+ /// 涓嬪彂缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "USE_ORG_ID")]
+ public string? USE_ORG_ID { get; set; }
+
+}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/QsQaItemXj.cs b/StandardPda/MES.Service/Modes/QsQaItemXj.cs
index 95f6ba3..a83ccc0 100644
--- a/StandardPda/MES.Service/Modes/QsQaItemXj.cs
+++ b/StandardPda/MES.Service/Modes/QsQaItemXj.cs
@@ -144,4 +144,8 @@
[SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
[SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
+
+ [SugarColumn(IsIgnore = true)] public string? DAA020 { get; set; }
+
+ [SugarColumn(IsIgnore = true)] public string? PROJECT_CODE { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/service/QC/XJService.cs b/StandardPda/MES.Service/service/QC/XJService.cs
index 09fa801..d370a2f 100644
--- a/StandardPda/MES.Service/service/QC/XJService.cs
+++ b/StandardPda/MES.Service/service/QC/XJService.cs
@@ -176,40 +176,45 @@
var totalCount = 0;
var pageList = db
- .Queryable<QsQaItemXj, Womdaa, MesItems>((s, a, b) =>
+ .Queryable<QsQaItemXj, Womdaa, MesItems, Womcaa, MES_PROJECT>((s, a, b,c,d) =>
new JoinQueryInfos(
JoinType.Inner, s.BillNo == a.Daa001,
- JoinType.Left, s.ItemId == b.Id
+ JoinType.Left, s.ItemId == b.Id,
+ JoinType.Left,a.Daa021 == c.Caa001,
+ JoinType.Left ,d.Id == c.Project
)
)
// 猸� 妯＄硦鎼滅储锛圔illNo 鎴� ItemNo 鏂板
.WhereIF(
StringUtil.IsNotNullOrEmpty(queryObj.SearchValue),
- (s, a, b) =>
+ (s, a, b,c,d) =>
s.BillNo.Contains(queryObj.SearchValue) ||
- s.ItemNo.Contains(queryObj.SearchValue)
+ s.ItemNo.Contains(queryObj.SearchValue) ||
+ b.ItemName.Contains(queryObj.SearchValue)||
+ a.Daa020.Contains(queryObj.SearchValue)||
+ d.PROJECT_CODE.Contains(queryObj.SearchValue)
)
// 猸� 鐘舵�佺瓫閫夛細鏈畬鎴�
.WhereIF(
StringUtil.IsNotNullOrEmpty(queryObj.result) &&
"鏈畬鎴�".Equals(queryObj.result),
- (s, a, b) => s.Fsubmit == null || s.Fsubmit == 0
+ (s, a, b,c,d) => s.Fsubmit == null || s.Fsubmit == 0
)
// 猸� 鐘舵�佺瓫閫夛細宸插畬鎴�
.WhereIF(
StringUtil.IsNotNullOrEmpty(queryObj.result) &&
!"鏈畬鎴�".Equals(queryObj.result),
- (s, a, b) => s.Fsubmit == 1
+ (s, a, b,c,d) => s.Fsubmit == 1
)
// 猸� ID 鏌ヨ锛堝崟鏉★級
- .WhereIF(id > 0, (s, a, b) => s.Id == id)
+ .WhereIF(id > 0, (s, a, b,c,d) => s.Id == id)
// 猸� select 瀹炰綋杩斿洖
- .Select((s, a, b) => new QsQaItemXj
+ .Select((s, a, b,c,d) => new QsQaItemXj
{
Id = s.Id,
ReleaseNo = s.ReleaseNo,
@@ -234,7 +239,9 @@
// 猸� 棰濆瀛楁锛堟潵鑷繛琛級
PlanQty = a.Daa008,
ItemName = b.ItemName,
- ItemModel = b.ItemModel
+ ItemModel = b.ItemModel,
+ DAA020 = a.Daa020,
+ PROJECT_CODE = d.PROJECT_CODE
})
.OrderBy(s => s.CreateDate, OrderByType.Desc)
--
Gitblit v1.9.3