StandardPda/MES.Service/service/WomcaaManager.cs

@@ -276,12 +276,18 @@
                            && x.OrgId == "1002011210000095"
                            && x.TableType == "MES_ITEMS").First();

            var mesLinkU9_TDL = Db.Queryable<MesLinkU9>()
               .Where(x => x.U9Id == Convert.ToString(dto.FSubstitutedItem)
                           && x.OrgId == "1002011210000095"
                           && x.TableType == "MES_ITEMS").First();

            var mesLinkU9_xm = Db.Queryable<MesLinkU9>()
         .Where(x => x.U9Id == Convert.ToString(dto.FProject)
                     && x.OrgId == "1002011210000095"
                     && 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);