From 9e28913626d14082f2b6a9589c4585935c297667 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期三, 27 八月 2025 08:53:45 +0800 Subject: [PATCH] 11 --- StandardPda/MES.Service/service/WomcaaManager.cs | 22 +++++++++++++++++++++- 1 files changed, 21 insertions(+), 1 deletions(-) diff --git a/StandardPda/MES.Service/service/WomcaaManager.cs b/StandardPda/MES.Service/service/WomcaaManager.cs index 1e62567..c003010 100644 --- a/StandardPda/MES.Service/service/WomcaaManager.cs +++ b/StandardPda/MES.Service/service/WomcaaManager.cs @@ -158,6 +158,7 @@ Reasonforrework = dto.FReasonForRework, Isforcewholeset = dto.FIsForceWholeSet, PREVMO = dto.FPrevMO, + TsDate = DateTime.Now, Typea = dto.TypeA }; @@ -171,7 +172,14 @@ && x.OrgId == dto.FPrdOrgId && x.TableType == "MES_ITEMS").First(); + + var mesLinkU9_xm = Db.Queryable<MesLinkU9>() + .Where(x => x.U9Id == Convert.ToString(dto.FProject) + && x.OrgId == dto.FPrdOrgId + && x.TableType == "MES_PROJECT").First(); + if (mesLinkU9 != null) entity.Caa006 = mesLinkU9.MesId; + if (mesLinkU9_xm != null) entity.Project = Convert.ToInt64(mesLinkU9_xm.MesId); return entity; } @@ -267,10 +275,22 @@ //Cab003 = dto.FMaterialID var mesLinkU9 = Db.Queryable<MesLinkU9>() .Where(x => x.U9Id == dto.FMaterialID - && x.OrgId == "1002011210000095" + && x.OrgId == "1002503270000079" && x.TableType == "MES_ITEMS").First(); + var mesLinkU9_TDL = Db.Queryable<MesLinkU9>() + .Where(x => x.U9Id == Convert.ToString(dto.FSubstitutedItem) + && x.OrgId == "1002503270000079" + && x.TableType == "MES_ITEMS").First(); + + var mesLinkU9_xm = Db.Queryable<MesLinkU9>() + .Where(x => x.U9Id == Convert.ToString(dto.FProject) + && x.OrgId == "1002503270000079" + && x.TableType == "MES_PROJECT").First(); + if (mesLinkU9 != null) womcab.Cab003 = mesLinkU9.MesId; + if (mesLinkU9_TDL != null) womcab.Substituteditem = Convert.ToInt64(mesLinkU9_TDL.MesId); + if (mesLinkU9_xm != null) womcab.Project = mesLinkU9_xm.MesId; womcabList.Add(womcab); } -- Gitblit v1.9.3