From 90e42f99c2b3a4b8226e9a6951c2b7b9a968df10 Mon Sep 17 00:00:00 2001
From: zyf <1071160500@qq.com>
Date: 星期五, 22 八月 2025 14:38:46 +0800
Subject: [PATCH] 入库检新增销售订单号
---
MES.Service/Modes/QsItemOqcReq.cs | 6 ++++++
MES.Service/service/QC/RKJService.cs | 10 ++++++----
2 files changed, 12 insertions(+), 4 deletions(-)
diff --git a/MES.Service/Modes/QsItemOqcReq.cs b/MES.Service/Modes/QsItemOqcReq.cs
index c97a1af..6f3b100 100644
--- a/MES.Service/Modes/QsItemOqcReq.cs
+++ b/MES.Service/Modes/QsItemOqcReq.cs
@@ -119,6 +119,12 @@
[SugarColumn(ColumnName = "ITEM_ID")]
public decimal? ItemId { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CAA015")]
+ public string? SaleOederNo { get; set; }
+
// 娣诲姞浠ヤ笅瀛楁浠ラ�傚簲鏌ヨ杩斿洖鐨勬暟鎹�
[SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
diff --git a/MES.Service/service/QC/RKJService.cs b/MES.Service/service/QC/RKJService.cs
index a5aa607..886d05b 100644
--- a/MES.Service/service/QC/RKJService.cs
+++ b/MES.Service/service/QC/RKJService.cs
@@ -522,11 +522,12 @@
var query = db
- .Queryable<QsItemOqcReq, MesItems, Womdaa, MesLine, SysUser>((a, b,
- da, c, us) =>
+ .Queryable<QsItemOqcReq, MesItems, Womdaa, MesLine, SysUser,Womcaa>((a, b,
+ da, c, us, ca) =>
new JoinQueryInfos(
JoinType.Left, a.ItemNo == b.ItemNo, // 鍏宠仈鐗╂枡淇℃伅
JoinType.Left, a.BillNo == da.Daa001, // 鍏宠仈宸ュ崟淇℃伅
+ JoinType.Left, da.Daa021 == ca.Caa020,//浠诲姟鍗曪紝鐢ㄤ簬鏌ヨ閿�鍞鍗曞彿
JoinType.Left, da.Daa015 == c.LineNo, // 鍏宠仈宸ュ崟淇℃伅
JoinType.Left, us.Fcode == a.CreateBy // 鍏宠仈宸ュ崟淇℃伅
))
@@ -548,7 +549,7 @@
.Contains(queryObj.SearchValue.ToLower()) ||
a.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower()))
// 鏌ヨ瀛楁
- .Select((a, b, da, c, us) => new QsItemOqcReq
+ .Select((a, b, da, c, us, ca) => new QsItemOqcReq
{
Id = a.Id,
BillNo = a.BillNo,
@@ -566,7 +567,8 @@
Daa015 = da.Daa015, // 宸ュ崟绾夸綋
Fsubmit = a.Fsubmit,
Quantity = da.Daa008,
- LineNo = c.LineName
+ LineNo = c.LineName,
+ SaleOederNo = ca.Caa015
})
// 鎺掑簭
.OrderBy(a => a.CreateDate, OrderByType.Desc);
--
Gitblit v1.9.3