public MonGroupDTO getMonGroupById(int id) { var query = from mg in db.Monitoring_MonGroupInfo join mp in db.Monitoring_MonPointInfo on mg.ID equals mp.MonGroupID into mps where mg.ID == id select new { grp = mg, ptn = mps }; var item = query.FirstOrDefault(); MonGroupDTO res = Mapper.Map <MonGroupDTO>(item.grp); res.MonPoints = Mapper.Map <List <MonPointDTO> >(item.ptn); return(res); }
public MonProjectDTO getMonProjectById(int id) { var query = from mpp in db.Monitoring_MonProjectInfo join mg in db.Monitoring_MonGroupInfo on mpp.ID equals mg.MonProjectID join mp in db.Monitoring_MonPointInfo on mg.ID equals mp.MonGroupID into mps where mpp.ID == id select new { prj = mpp, grp = mg, ptn = mps }; var item = query.ToList(); if (item.Count == 0) { return(null); } MonProjectDTO res = Mapper.Map <MonProjectDTO>(item[0].prj); res.MonGroups = new List <MonGroupDTO>(); foreach (var tmp in item) { MonGroupDTO mg = Mapper.Map <MonGroupDTO>(tmp.grp); mg.MonPoints = Mapper.Map <List <MonPointDTO> >(tmp.ptn); res.MonGroups.Add(mg); } return(res); }