From 820715f221332b8b291a31fb0bd88b9fca59ddbd Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周四, 04 12月 2025 10:19:08 +0800
Subject: [PATCH] 222
---
iWara.SCADA.Code/iWare.Wms.Application/Service/Pda/PdaService.cs | 23 ++++++++++++++++-------
1 files changed, 16 insertions(+), 7 deletions(-)
diff --git a/iWara.SCADA.Code/iWare.Wms.Application/Service/Pda/PdaService.cs b/iWara.SCADA.Code/iWare.Wms.Application/Service/Pda/PdaService.cs
index 8203f06..4c79719 100644
--- a/iWara.SCADA.Code/iWare.Wms.Application/Service/Pda/PdaService.cs
+++ b/iWara.SCADA.Code/iWare.Wms.Application/Service/Pda/PdaService.cs
@@ -1,15 +1,16 @@
锘縰sing Furion.DatabaseAccessor;
-using Furion.FriendlyException;
-using iWare.Wms.Core.Util;
-using iWare.Wms.Core;
-using Mapster;
-using Microsoft.AspNetCore.Mvc;
-using Microsoft.EntityFrameworkCore;
using Furion.DependencyInjection;
using Furion.DynamicApiController;
-using System.Text;
+using Furion.FriendlyException;
+using iWare.Wms.Core;
using iWare.Wms.Core.Enum;
+using iWare.Wms.Core.Util;
+using Mapster;
using Microsoft.AspNetCore.Authorization;
+using Microsoft.AspNetCore.Mvc;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore.Internal;
+using System.Text;
namespace iWare.Wms.Application.Service.Pda
{
@@ -246,6 +247,12 @@
{
var workPieceProcesss = await _workPieceProcessRep.DetachedEntities
.Join(_equipmentBaseInfoRep.DetachedEntities, a => a.EquipmentID, b => b.EquipmentId, (a, b) => new { a, b })
+ // 鏂板 Left Join 鍒� _workPieceInfo 琛�
+ .Join(_workPieceInfoRep.DetachedEntities,
+ temp => temp.a.WorkPieceID, // 浣跨敤涔嬪墠 Join 缁撴灉鐨� a.WorkPieceID
+ c => c.WorkPieceID, // _workPieceInfo 琛ㄧ殑 WorkPieceID
+ (temp, c) => new { temp.a, temp.b, workPieceInfo = c }) // 鍒涘缓鏂扮殑鍖垮悕绫诲瀷鍖呭惈涓変釜瀹炰綋
+
.Where(!string.IsNullOrEmpty(input.WorkPieceID), u => u.a.WorkPieceID.Equals(input.WorkPieceID))
.Where(o => !string.IsNullOrEmpty(o.a.WorkPieceID))
.Select(s => new WorkPieceProcessOutput
@@ -261,6 +268,8 @@
UpdatedUserName = s.a.UpdatedUserName,
WorkPieceID = s.a.WorkPieceID,
+ OP80NewCode = s.workPieceInfo.OP80NewCode,//鎴愬搧鐮�
+
WorkingProcedureCurrent = s.a.WorkingProcedureCurrent,
EquipmentID = s.a.EquipmentID,
EquipmentName = s.b.EquipmentName,
--
Gitblit v1.9.3