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);
}
