From 148e3eea1fea2d45ab135c6e66e69d163a4dd811 Mon Sep 17 00:00:00 2001 From: zjh <2207896513@qq.com> Date: 星期五, 28 二月 2025 16:19:53 +0800 Subject: [PATCH] 代码提交 --- StandardPda/MES.Service/service/BasicData/MesRohInManager.cs | 44 ++++++++++++++++++++++++++------------------ 1 files changed, 26 insertions(+), 18 deletions(-) diff --git a/StandardPda/MES.Service/service/BasicData/MesRohInManager.cs b/StandardPda/MES.Service/service/BasicData/MesRohInManager.cs index af6f4d7..3444d92 100644 --- a/StandardPda/MES.Service/service/BasicData/MesRohInManager.cs +++ b/StandardPda/MES.Service/service/BasicData/MesRohInManager.cs @@ -91,22 +91,22 @@ // 灏� ErpRohIn 瀵硅薄杞崲涓� MesRohIn 瀵硅薄鐨勬柟娉� private MesRohIn GetMesRohIn(ErpRohIn rohIn) { - var eid = Convert.ToDecimal(rohIn.id); + var eid = rohIn.id; var mesRohIn = new MesRohIn(); var single = base.GetSingle(it => it.EbelnK3id == eid); if (single != null) mesRohIn.Id = single.Id; var mesLinkU9 = Db.Queryable<MesLinkU9>() - .Where(s=>s.U9Id == rohIn.FSupplierId - && s.OrgId == rohIn.FReceiveOrgId - && s.TableType == "MES_SUPPLIER").First(); + .Where(s => s.U9Id == rohIn.FSupplierId + && s.OrgId == rohIn.FReceiveOrgId + && s.TableType == "MES_SUPPLIER").First(); if (mesLinkU9 != null) { mesRohIn.Supplier = mesLinkU9.MesId; } - + mesRohIn.EbelnK3id = eid; mesRohIn.BillNo = rohIn.FBillNo; mesRohIn.DocumentStatus = rohIn.FDocumentStatus; @@ -115,7 +115,7 @@ if (rohIn.FDate != null) mesRohIn.PurchaseDate = DateTime.ParseExact(rohIn.FDate, "yyyy-MM-dd HH:mm:ss", null); - + mesRohIn.CloseStatus = rohIn.FCloseStatus; mesRohIn.PurchaseOrg = rohIn.FPurchaseOrgId; mesRohIn.PurchaseDept = rohIn.FPurchaseDeptId; @@ -136,10 +136,8 @@ mesRohIn.ErpCheckBy = rohIn.FApproverId; mesRohIn.ErpCheckDate = rohIn.FApproveDate; mesRohIn.Changereason = rohIn.PubDescSeg2; - mesRohIn.ReceiveOrg = Convert.ToDecimal(rohIn.FReceiveOrgId); + mesRohIn.ReceiveOrg = rohIn.FReceiveOrgId; mesRohIn.Remarks = rohIn.Remarks; - mesRohIn.CancellationStatus = rohIn.FCancelStatus; - mesRohIn.SrcDocType = rohIn.FSrcDocType; mesRohIn.SrcDoc = rohIn.FSrcDoc; mesRohIn.TradePathName = rohIn.FTradePathName; @@ -149,7 +147,7 @@ mesRohIn.Version = rohIn.FVersion; //浣滃簾鐨勭浉鍏冲瓧娈� - // mesRohIn.CancellationStatus = rohIn.FCancelStatus; + mesRohIn.CancellationStatus = rohIn.FCancelStatus; // mesRohIn.CancellationPerson = rohIn.FCancellerId; // // if (rohIn.FCancelDate != null) @@ -168,14 +166,14 @@ { var entity = new MesRohInData { - EbelnK3id = Convert.ToDecimal(s.id), - ErpId = Convert.ToDecimal(s.Eid), + EbelnK3id = s.id, + ErpId = s.Eid, BillNo = s.FBillNo, OrderLineId = s.FSeq, BusinessFreeze = s.FStatus, PurchaseOrderLineNumber = s.FSeq, SalesOrderId = s.FDemandBillEntrySeq, - + PurchaseUnit = s.FUnitId, PurchaseQty = Convert.ToDecimal(s.FQty), PricingUnit = s.FPriceUnitId, @@ -203,25 +201,35 @@ DemandDocumentId = s.FDemandBillNo, DemandDocumentLineId = s.FDemandBillEntrySeq, RdProject = s.RdProject, - Project = s.Project, ProjectPurchaser = s.ProjectPurchaser }; var single = rohInDataManager.GetSingle(it => it.EbelnK3id == entity.EbelnK3id); if (single != null) entity.Id = single.Id; - + //ItemId = s.FMaterialId, var mesLinkU9 = Db.Queryable<MesLinkU9>() - .Where(x=>x.U9Id == s.FMaterialId - && x.OrgId == s.FReceiveOrgId - && x.TableType == "MES_ITEMS").First(); + .Where(x => x.U9Id == s.FMaterialId + && x.OrgId == s.FReceiveOrgId + && x.TableType == "MES_ITEMS").First(); if (mesLinkU9 != null) { entity.ItemId = mesLinkU9.MesId; } + + var mesLinkU92 = Db.Queryable<MesLinkU9>() + .Where(x => x.U9Id == s.Project + && x.OrgId == s.FReceiveOrgId + && x.TableType == "MES_PROJECT").First(); + + if (mesLinkU92 != null) + { + entity.Project = mesLinkU92.MesId; + } + return entity; }).ToList(); } -- Gitblit v1.9.3