From 0b3c06f4d1bca7b91c2f5892a449bbbd3add4d27 Mon Sep 17 00:00:00 2001 From: zjh <2207896513@qq.com> Date: 星期二, 19 八月 2025 10:29:19 +0800 Subject: [PATCH] 产测获取工单接口修改 --- StandardPda/MES.Service/service/BasicData/SalesOrderManager.cs | 21 ++++++++++++++++++--- 1 files changed, 18 insertions(+), 3 deletions(-) diff --git a/StandardPda/MES.Service/service/BasicData/SalesOrderManager.cs b/StandardPda/MES.Service/service/BasicData/SalesOrderManager.cs index bede90f..dfe1746 100644 --- a/StandardPda/MES.Service/service/BasicData/SalesOrderManager.cs +++ b/StandardPda/MES.Service/service/BasicData/SalesOrderManager.cs @@ -1,9 +1,10 @@ -锘縰sing MES.Service.DB; -using System.Data; -using System.Globalization; +锘縰sing AngleSharp.Dom; +using MES.Service.DB; using MES.Service.Dto.webApi; using MES.Service.Modes; using SqlSugar; +using System.Data; +using System.Globalization; namespace MES.Service.service.BasicData; @@ -153,6 +154,20 @@ { salesOrderSub.Id = single.Id; } + var mesLinkU9 = Db.Queryable<MesLinkU9>() + .Where(x => x.U9Id == erpDto.FMaterialId + && x.OrgId == erpDto.FSupplyOrg + && x.TableType == "MES_ITEMS").First(); + + if (mesLinkU9 != null) salesOrderSub.MaterialId = mesLinkU9.MesId; + + + var mesLinkU92 = Db.Queryable<MesLinkU9>() + .Where(x => x.U9Id == erpDto.FProject + && x.OrgId == erpDto.FSupplyOrg + && x.TableType == "MES_PROJECT").First(); + + if (mesLinkU92 != null) salesOrderSub.FProject = mesLinkU92.MesId; salesOrderSubList.Add(salesOrderSub); } -- Gitblit v1.9.3