| | |
| | | DemandSource = s.FDemandType, |
| | | DemandDocumentId = s.FDemandBillNo, |
| | | DemandDocumentLineId = s.FDemandBillEntrySeq, |
| | | RdProject = s.RdProject, |
| | | Project = s.Project, |
| | | ProjectPurchaser = s.ProjectPurchaser |
| | | }; |
| | | |
| | |
| | | entity.ItemId = mesLinkU9.MesId; |
| | | } |
| | | |
| | | var mesLinkU91 = Db.Queryable<MesLinkU9>() |
| | | .Where(x => x.U9Id == s.RdProject |
| | | && x.OrgId == s.FReceiveOrgId |
| | | && x.TableType == "MES_ITEMS").First(); |
| | | |
| | | if (mesLinkU91 != null) |
| | | { |
| | | entity.RdProject = mesLinkU91.MesId; |
| | | } |
| | | |
| | | var mesLinkU92 = Db.Queryable<MesLinkU9>() |
| | | .Where(x => x.U9Id == s.Project |
| | | && x.OrgId == s.FReceiveOrgId |
| | | && x.TableType == "MES_ITEMS").First(); |
| | | |
| | | if (mesLinkU92 != null) |
| | | { |
| | | entity.Project = mesLinkU92.MesId; |
| | | } |
| | | |
| | | return entity; |
| | | }).ToList(); |
| | | } |