/// <summary>
/// 获取多级钻孔数据，
/// </summary>
/// <returns></returns>
public List <MultilevelZKData> GetAll()
{
List <MultilevelZKData> lstmultilev = new List <MultilevelZKData>();
Dictionary <string, string> dic = new Dictionary <string, string>();
DataTable dtzk = this.GetAllRecordsToDT();
if (dtzk == null)
{
return(lstmultilev);
}
List <GeoZkPointsData> lstzk = new List <GeoZkPointsData>();
lstzk = MappingUtil.GetEntityFromDataTable <GeoZkPointsData>(dtzk);
var query = from t in dtzk.AsEnumerable()
group t by new { prjno = t.Field <string>(GeoZkPointsData.FIELD_F_PROJECTNO), prjname = t.Field <string>(GeoZkPointsData.FIELD_F_PROJECTNAME) } into m
select new
{
prjno = m.Key.prjno,
prjname = m.Key.prjname
};
if (query.ToList().Count > 0)
{
query.ToList().ForEach(q => dic.Add(q.prjno, q.prjname));
}
foreach (var item in dic)
{
IEnumerable <GeoZkPointsData> lst = lstzk.Where((zkpoint) => { return(zkpoint.ProjectNo.Equals(item.Key)); });
lstmultilev.Add(new MultilevelZKData(item.Key, item.Value, lst.ToList()));
}
return(lstmultilev);
}
public List <GeoZkPointsData> GetZKDataTest()
{
DataTable dtzk = this.GetZKDataTableTest();
List <GeoZkPointsData> lstzk = new List <GeoZkPointsData>();
lstzk = MappingUtil.GetEntityFromDataTable <GeoZkPointsData>(dtzk);
return(lstzk);
}
public List <GeoZkPointsData> GetAllRecords()
{
DataTable dtzk = this.GetAllRecordsToDT();
List <GeoZkPointsData> lstzk = new List <GeoZkPointsData>();
lstzk = MappingUtil.GetEntityFromDataTable <GeoZkPointsData>(dtzk);
return(lstzk);
}
