From 359c272c0b09cc02a43bf6d6f55a8215f71fa94b Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期五, 12 十二月 2025 14:03:17 +0800
Subject: [PATCH] MES前端字段补全
---
WebApi/Gs.BaseInfo/Services/MesItemsManager.cs | 10 ++++++----
1 files changed, 6 insertions(+), 4 deletions(-)
diff --git a/WebApi/Gs.BaseInfo/Services/MesItemsManager.cs b/WebApi/Gs.BaseInfo/Services/MesItemsManager.cs
index 28c32ad..d12734f 100644
--- a/WebApi/Gs.BaseInfo/Services/MesItemsManager.cs
+++ b/WebApi/Gs.BaseInfo/Services/MesItemsManager.cs
@@ -46,8 +46,8 @@
var totalCount = 0;
var itemsList = Db
.Queryable<MesItems, SysOrganization, MesUnit, MesUnit, MesUnit,
- MesUnit, MesUnit, MesUnit, MesDepots, MesItemType>(
- (a, org, c, d, e, f, g, h, m, n) => new object[]
+ MesUnit, MesUnit, MesUnit, MesDepots, MesItemType,MesStaff>(
+ (a, org, c, d, e, f, g, h, m, n,o) => new object[]
{
JoinType.Left, a.FSubsidiary == org.Fid,
JoinType.Left, a.ItemUnit == c.Id.ToString(),
@@ -57,9 +57,10 @@
JoinType.Left, a.SubconUnit == g.Id.ToString(),
JoinType.Left, a.ProduceUnit == h.Id.ToString(),
JoinType.Left, a.DepotCode == m.DepotId.ToString(),
- JoinType.Left, a.Fmaterialgroup == n.Id.ToString()
+ JoinType.Left, a.Fmaterialgroup == n.Id.ToString(),
+ JoinType.Left, a.Fpurchaserid == o.Id.ToString()
})
- .Select((a, org, c, d, e, f, g, h, m, n) => new MesItems
+ .Select((a, org, c, d, e, f, g, h, m, n,o) => new MesItems
{
chkInt = false,
FSubsidiary = "(" + org.FNumber + ")" + org.Name,
@@ -71,6 +72,7 @@
ProduceUnit = h.Fname,
DepotCode = m.DepotName,
Fmaterialgroup = n.Tname,
+ Fpurchaserid = o.StaffName,
Fforbidstatus = a.Fforbidstatus + ":" + (a.Fforbidstatus == "A" ? "姝ｅ父" : "绂佺敤"),
DataType = a.DataType + ":"
+ SqlFunc.IF(a.DataType == "Z").Return("鏆傚瓨")
--
Gitblit v1.9.3