StandardPda/MES.Service/service/BasicData/SalesDeliveryNoticeManager.cs
@@ -268,7 +268,20 @@ var single = _SalesDeliveryDetailManager.GetSingle(it => it.ErpLineId == salesOrderSub.ErpLineId); if (single != null) 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); } StandardPda/MES.Service/service/BasicData/SalesOrderManager.cs
@@ -1,9 +1,10 @@ using MES.Service.DB; using System.Data; using System.Globalization; using 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); } StandardPda/MES.Service/service/BasicData/SalesReturnNoticeManager.cs
@@ -201,6 +201,20 @@ var single = _SalesReturnDetailManager.GetSingle(it => it.ErpLineId == salesOrderSub.ErpLineId); if (single != null) salesOrderSub.Id = single.Id; var mesLinkU9 = Db.Queryable<MesLinkU9>() .Where(x => x.U9Id == erpDto.FMaterialId && x.OrgId == erpDto.FReceivingOrg && 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.FReceivingOrg && x.TableType == "MES_PROJECT").First(); if (mesLinkU92 != null) salesOrderSub.FProject = mesLinkU92.MesId; salesOrderSubList.Add(salesOrderSub); }