public List <MonPointDTO> getMonPointByObjs(string filter) { string sql = DGObjectsFilter.GetDGObjectsSQL("Monitoring_MonPointInfo", filter); var result = ((IObjectContextAdapter)db).ObjectContext.ExecuteStoreQuery <Monitoring_MonPointInfo>(sql).ToList(); return(Mapper.Map <List <MonPointDTO> >(result.ToList())); }
public List <BoreholeDTO> getAllBoreholeByObjs(string filter) { string sql = DGObjectsFilter.GetDGObjectsSQL("Geology_Boreholes", filter); var result = ((IObjectContextAdapter)db).ObjectContext.ExecuteStoreQuery <Geology_Boreholes>(sql).ToList(); var query = from b in result join g in db.Geology_BoreholeStrataInfo on new { c1 = (int?)b.StratumSection, c2 = (int?)b.SectionSequence } equals new { c1 = (int?)g.StratumSectionID, c2 = (int?)g.SectionSequenceBorhole } into bg select new { Borehole = b, Geologies = bg }; var tmps = query.ToList(); List <BoreholeDTO> res = new List <BoreholeDTO>(); foreach (var tmp in tmps) { BoreholeDTO b = Mapper.Map <BoreholeDTO>(tmp.Borehole); b.Geologies = Mapper.Map <List <BoreholeGeologyDTO> >(tmp.Geologies); setBoreholeGeologyTop(b); res.Add(b); } return(res); }