/// <summary> /// Get Township List /// </summary> /// <param name="year"></param> /// <returns></returns> /// <author>Shen Yongyuan</author> /// <date>20091111</date> public static List<string> GetTownshipList(string city) { try { Dictionary<int, string> result = new Dictionary<int, string>(); TownDBDataContext db = new TownDBDataContext(); if (city == "金华市") { List<string> townshipList = (from z in db.I_ZONE where z.Layer == "Township" && z.City == city select z.Township).Distinct().ToList(); return townshipList; } else if (city == "南充市") { List<string> townshipList = (from z in db.I_ZONE where z.Layer == "District" && z.City == city select z.District).Distinct().ToList(); return townshipList; } else { return null; } } catch (Exception ex) { return null; } }
/// <summary> /// /// </summary> /// <param name="indexName"></param> /// <returns></returns> public static IQueryable<DataLib.I_INDEX_HIGH_LEVEL> QueryIndex(string indexName) { try { TownDBDataContext db = new TownDBDataContext(); return db.I_INDEX_HIGH_LEVELs.Where(c => c.Name == indexName); } catch (Exception ex) { return null; } }
/// <summary> /// Query Index By Year /// </summary> /// <param name="year"></param> /// <returns></returns> /// <author>Shen Yongyuan</author> /// <date>20091208</date> public static IQueryable<DataLib.I_INDEX_HIGH_LEVEL> QueryIndex(int year, string cityName) { try { TownDBDataContext db = new TownDBDataContext(); return db.I_INDEX_HIGH_LEVELs.Where(c => c.FromDate.Year == year && c.I_ZONE.City == cityName); } catch (Exception ex) { return null; } }
/// <summary> /// Query Remark Text /// </summary> /// <param name="name"></param> /// <param name="rankvalue"></param> /// <returns></returns> /// <author>Shen Yongyuan</author> /// <date>20100324</date> public static string QueryRemark(string name, int rankvalue) { try { TownDBDataContext db = new TownDBDataContext(); return db.I_REMARK.Where(c => c.Name == name && c.Rank == rankvalue).First().Reamrk; } catch (Exception ex) { return ""; } }
/// <summary> /// Get Available Years of the specific index name /// </summary> /// <param name="name"></param> /// <returns></returns> /// <author>Shen Yongyuan</author> /// <date>20091222</date> public static List<int> GetAvailableYear(string name, string cityName) { try { TownDBDataContext db = new TownDBDataContext(); var yearCollect = (from y in db.I_INDEX where y.Name.Contains(name) && y.I_ZONE.City == cityName select y.FromDate.Year).Distinct(); return yearCollect.ToList(); } catch (Exception ex) { return null; } }
/// <summary> /// Query 12 Index By Name /// </summary> /// <param name="year"></param> /// <returns></returns> /// <author>Shen Yongyuan</author> /// <date>20091208</date> public static IQueryable<DataLib.I_INDEX_HIGH_LEVEL> Query12Index(string cityName) { try { TownDBDataContext db = new TownDBDataContext(); return db.I_INDEX_HIGH_LEVELs.Where(c => c.Group == 11 && c.I_ZONE.City == cityName).OrderBy(c => c.Name).OrderBy(c => c.Class); } catch (Exception ex) { return null; } }
public static IQueryable<DataLib.I_INDEX_EX> QueryIndex(string name, string cityName) { try { TownDBDataContext db = new TownDBDataContext(); if (cityName == "金华市") return db.I_INDEX_EX.Where(c => c.Name.Equals(name) && c.I_ZONE.ID == 824); else return db.I_INDEX_EX.Where(c => c.Name.Equals(name) && c.I_ZONE.ID == 825); } catch (Exception ex) { return null; } }
public static IQueryable<DataLib.I_INDEX_EX> Query12CityIndex(bool isYiWu) { try { TownDBDataContext db = new TownDBDataContext(); if(isYiWu) return db.I_INDEX_EX.Where(c => c.Group == 11 && c.I_ZONE.ID == 824).OrderBy(c => c.Name).OrderBy(c => c.Class); else return db.I_INDEX_EX.Where(c => c.Group == 11 && c.I_ZONE.ID == 825).OrderBy(c => c.Name).OrderBy(c => c.Class); } catch (Exception ex) { return null; } }
public static void InitiaDb() { TownDBDataContext db = new TownDBDataContext(); if(db.I_INDEX.Where(c=>c.Name=="中等教育人数比重").First().Group==8) { var q = from p in db.I_INDEX where (p.Name == "中等教育人数比重" || p.Name == "水环境综合污染指数" || p.Name == "非建成用地比重变化率" || p.Name == "GDP三产比重增长率" || p.Name == "人均GDP增长率" || p.Name == "地均GDP" || p.Name == "城乡收入差距" || p.Name == "城镇居民人均住房使用面积" || p.Name == "千人拥有病床数" || p.Name == "万元GDP综合能耗变化率" || p.Name == "人均建成用地面积" || p.Name == "净迁移率") select p; foreach (var p in q) { p.Group = 11; } db.SubmitChanges(); } }
/// <summary> /// Get Devide Result /// </summary> /// <param name="year"></param> /// <returns></returns> /// <author>Shen Yongyuan</author> /// <date>20091111</date> public static Dictionary<int, string> GetDevideResult(int year, string city) { try { Dictionary<int, string> result = new Dictionary<int, string>(); TownDBDataContext db = new TownDBDataContext(); IQueryable<I_DEVIDE> devide = db.I_DEVIDE.Where(c => c.FromDate.Year == year && db.I_ZONE.Single(e=>e.ID==c.Zone).City == city); foreach (I_DEVIDE d in devide) { result.Add((int)d.Zone,d.Attribute); } return result; } catch (Exception ex) { return null; } }
/// <summary> /// Query 12 Index By Name /// </summary> /// <param name="year"></param> /// <returns></returns> /// <author>Shen Yongyuan</author> /// <date>20091208</date> public static IQueryable<DataLib.I_INDEX> Query12Index(string cityName, bool isYiwu) { try { TownDBDataContext db = new TownDBDataContext(); if (isYiwu) { return db.I_INDEX.Where(c => c.Group == 11 && c.I_ZONE.Township == cityName).OrderBy(c => c.Name).OrderBy(c => c.Class); } else { return db.I_INDEX.Where(c => c.Group == 11 && c.I_ZONE.District == cityName).OrderBy(c => c.Name).OrderBy(c => c.Class); } } catch (Exception ex) { return null; } }
/// <summary> /// Query Index By Zone /// </summary> /// <param name="year"></param> /// <returns></returns> /// <author>Shen Yongyuan</author> /// <date>20091208</date> public static IQueryable<DataLib.I_INDEX> QueryIndexByZone(string zoneName) { try { TownDBDataContext db = new TownDBDataContext(); if (db.I_INDEX.Where(c => c.I_ZONE.Township.Contains(zoneName)).Count() > 0) { return db.I_INDEX.Where(c => c.I_ZONE.Township.Contains(zoneName)).OrderBy(c => c.FromDate.Year).OrderBy(c => c.Group); } else { return db.I_INDEX.Where(c => c.I_ZONE.District.Contains(zoneName)).OrderBy(c => c.FromDate.Year).OrderBy(c => c.Group); } } catch (Exception ex) { return null; } }
/// <summary> /// Query Index By Name /// </summary> /// <param name="year"></param> /// <returns></returns> /// <author>Shen Yongyuan</author> /// <date>20091208</date> public static IQueryable<DataLib.I_INDEX> QueryIndex(string name, string cityName) { try { TownDBDataContext db = new TownDBDataContext(); return db.I_INDEX.Where(c => c.Name.Equals(name) && c.I_ZONE.City == cityName); } catch (Exception ex) { return null; } }
/// <summary> /// Query Index By Zone /// </summary> /// <param name="year"></param> /// <returns></returns> /// <author>Shen Yongyuan</author> /// <date>20091208</date> public static IQueryable<DataLib.I_INDEX_HIGH_LEVEL> QueryIndexByZone(string zoneName) { try { TownDBDataContext db = new TownDBDataContext(); return db.I_INDEX_HIGH_LEVELs.Where(c => c.I_ZONE.City.Contains(zoneName)).OrderBy(c => c.FromDate.Year).OrderBy(c => c.Group); } catch (Exception ex) { return null; } }
public static IQueryable<DataLib.I_INDEX_HIGH_LEVEL> QueryIndexBySZone(string zoneName) { try { TownDBDataContext db = new TownDBDataContext(); if(zoneName=="义乌市") return db.I_INDEX_HIGH_LEVELs.Where(c => c.Zone==824).OrderBy(c => c.FromDate.Year).OrderBy(c => c.Group); else { return db.I_INDEX_HIGH_LEVELs.Where(c => c.Zone == 825).OrderBy(c => c.FromDate.Year).OrderBy(c => c.Group); } } catch (Exception ex) { return null; } }