public static IEnumerable <RasterInfo> QueryRasterInfos(string town, string type) { IEnumerable <RasterInfo> result; using (DtContextDataContext dc = new DtContextDataContext()) { switch (type) { case "2G": result = dc.sp_get2GRasterInfos(town).Select(x => new RasterInfo { Area = x.area, Coordinate0 = x.coordinate0, Coordinate1 = x.coordinate1, Coordinate2 = x.coordinate2, Coordinate3 = x.coordinate3, CsvFilesName2G = x.csvFilesName2G, CsvFilesName3G = x.csvFilesName3G, CsvFilesName4G = x.csvFilesName4G, RasterNum = x.rasterNum }).ToList(); break; case "3G": result = dc.sp_get3GRasterInfos(town).Select(x => new RasterInfo { Area = x.area, Coordinate0 = x.coordinate0, Coordinate1 = x.coordinate1, Coordinate2 = x.coordinate2, Coordinate3 = x.coordinate3, CsvFilesName2G = x.csvFilesName2G, CsvFilesName3G = x.csvFilesName3G, CsvFilesName4G = x.csvFilesName4G, RasterNum = x.rasterNum }).ToList(); break; default: result = dc.sp_get4GRasterInfos(town).Select(x => new RasterInfo { Area = x.area, Coordinate0 = x.coordinate0, Coordinate1 = x.coordinate1, Coordinate2 = x.coordinate2, Coordinate3 = x.coordinate3, CsvFilesName2G = x.csvFilesName2G, CsvFilesName3G = x.csvFilesName3G, CsvFilesName4G = x.csvFilesName4G, RasterNum = x.rasterNum }).ToList(); break; } } return(result); }
public static IEnumerable <AreaTestDate> QueryTestDateInfos() { IEnumerable <AreaTestDate> result; using (DtContextDataContext dc = new DtContextDataContext()) { result = dc.AreaTestDate.ToList(); } return(result); }
public static IEnumerable <CsvFilesInfo> QueryDtFileInfos(string district) { IEnumerable <CsvFilesInfo> result; using (DtContextDataContext dc = new DtContextDataContext()) { result = dc.CsvFilesInfo.Where(x => x.CsvFileName.IndexOf(district, StringComparison.Ordinal) >= 0).ToList(); } return(result); }
public static IEnumerable <CsvFilesInfo> QueryDtFileInfos(string district, string keyword, string type) { IEnumerable <CsvFilesInfo> result; using (DtContextDataContext dc = new DtContextDataContext()) { result = dc.sp_getDtFileInfos(keyword, district, type).Select(x => new CsvFilesInfo { CsvFileName = x.csvFileName, DataType = x.dataType, Direct = x.direct, TestDate = x.testDate }).ToList(); } return(result); }
private static IEnumerable <TRecord> QueryFileRecordsFromPoints <TRecord>( IEnumerable <IGeoPointReadonly <double> > points, double range, Func <IEnumerable <RasterInfo>, IEnumerable <Tuple <string, int> > > rasterInfosGetter, Func <string, int, IEnumerable <TRecord> > recordsGetter) { List <TRecord> result = new List <TRecord>(); using (DtContextDataContext dc = new DtContextDataContext()) { IEnumerable <Tuple <string, int> > rasterInfos = rasterInfosGetter(dc.RasterInfo.ToList().Query(points, range)); foreach (Tuple <string, int> info in rasterInfos) { result.AddRange(recordsGetter(info.Item1, info.Item2)); } } return(result); }
private static List <TRecords> QueryFileRecords <TRecords>(string fileName, string spName, int rasterNum = -1) where TRecords : class, IDataReaderImportable, new() { List <TRecords> result = new List <TRecords>(); using (DtContextDataContext dc = new DtContextDataContext()) { SqlConnection conn = new SqlConnection(dc.Connection.ConnectionString); conn.Open(); using (SqlCommand cmd = new SqlCommand(spName, conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter { ParameterName = "@tableName", SqlDbType = SqlDbType.VarChar, Value = fileName }); if (rasterNum >= 0) { cmd.Parameters.Add(new SqlParameter { ParameterName = "@rasterNum", SqlDbType = SqlDbType.Int, Value = rasterNum }); } using (DbDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { TRecords item = new TRecords(); item.Import(dr); result.Add(item); } } } conn.Close(); } return(result); }