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