// // get // AJAX: /City/CitiesWithinPercentJSON?percent=3 public ActionResult CitiesWithinPercentJSON(int excludeCityID, int stateID, int homePop, double percent) { //get year for this data var dataSetYear = publicDB.DataSetCurrentYears.Where(x => x.StateID == stateID && x.EntityType == (byte)EntityType.City && x.DataSet == (byte)DataSet.USCensus && x.DataSetSubtype == (byte)DataSetSubtype.Primary).Single(); byte year = dataSetYear.Year; var cities1 = from c in publicDB.Cities join p in publicDB.CensusCityPops on c.CityID equals p.CityID into cp from p in cp where p.Year == year && p.Population >= homePop * (1 - percent / 100) && p.Population <= homePop * (1 + percent / 100) && c.StateID == stateID && c.CityID != excludeCityID select new { p.CityID, c.CityUniqueName, p.Population, c.StateID }; List <CityNameList> cities = new List <CityNameList>(); foreach (var x in cities1) { CityNameList cityItem = new CityNameList(); cityItem.CityID = x.CityID; string showPop = ""; if (x.Population == null) { showPop = "none"; } else { showPop = x.Population.ToString(); } string showText = x.CityUniqueName + " (pop " + showPop + ")"; cityItem.CityText = showText; cityItem.CityPopulation = x.Population; cityItem.CityUniqueName = x.CityUniqueName; cityItem.CityStateID = x.StateID; cities.Add(cityItem); } return(Json(cities.Select(x => new { value = x.CityID, text = x.CityText, name = x.CityUniqueName, population = x.CityPopulation, stateID = x.CityStateID }), JsonRequestBehavior.AllowGet)); }
// // get // AJAX: /City/SingleCityPopJSON?city=3900142 public ActionResult SingleCityPopJSON(int cityID) { City singleCity = publicDB.Cities.Where(c => c.CityID == cityID).Single(); int cityValue = singleCity.CityID; //get year for this data var dataSetYear = publicDB.DataSetCurrentYears.Where(x => x.StateID == singleCity.StateID && x.EntityType == (byte)EntityType.City && x.DataSet == (byte)DataSet.USCensus && x.DataSetSubtype == (byte)DataSetSubtype.Primary).Single(); byte year = dataSetYear.Year; int? cityPop = publicDB.CensusCityPops.Where(p => p.CityID == cityID && p.Year == year).Select(p => p.Population).SingleOrDefault(); string showPop = ""; if (cityPop == null) { showPop = "none"; } else { showPop = cityPop.ToString(); } string showText = singleCity.CityUniqueName + " (pop " + showPop + ")"; CityNameList cityItem = new CityNameList(); cityItem.CityID = cityValue; cityItem.CityText = showText; cityItem.CityPopulation = cityPop; cityItem.CityUniqueName = singleCity.CityUniqueName; cityItem.CityStateID = singleCity.StateID; List <CityNameList> cities = new List <CityNameList>(); cities.Add(cityItem); return(Json(cities.Select(x => new { value = x.CityID, text = x.CityText, name = x.CityUniqueName, population = x.CityPopulation, stateID = x.CityStateID }), JsonRequestBehavior.AllowGet)); }
/// <summary> /// 初始化城市列表 /// </summary> private static void InitCityNameList() { CityNameList.Add("北京市"); CityNameList.Add("上海市"); CityNameList.Add("天津市"); CityNameList.Add("重庆市"); CityNameList.Add("石家庄市"); CityNameList.Add("唐山市"); CityNameList.Add("秦皇岛市"); CityNameList.Add("邯郸市"); CityNameList.Add("邢台市"); CityNameList.Add("保定市"); CityNameList.Add("张家口市"); CityNameList.Add("承德市"); CityNameList.Add("沧州市"); CityNameList.Add("廊坊市"); CityNameList.Add("衡水市"); CityNameList.Add("太原市"); CityNameList.Add("大同市"); CityNameList.Add("阳泉市"); CityNameList.Add("长治市"); CityNameList.Add("晋城市"); CityNameList.Add("朔州市"); CityNameList.Add("晋中市"); CityNameList.Add("运城市"); CityNameList.Add("忻州市"); CityNameList.Add("临汾市"); CityNameList.Add("吕梁市"); CityNameList.Add("呼和浩特市"); CityNameList.Add("包头市"); CityNameList.Add("乌海市"); CityNameList.Add("赤峰市"); CityNameList.Add("通辽市"); CityNameList.Add("鄂尔多斯市"); CityNameList.Add("呼伦贝尔市"); CityNameList.Add("巴彦淖尔市"); CityNameList.Add("乌兰察布市"); CityNameList.Add("兴安盟"); CityNameList.Add("锡林郭勒盟"); CityNameList.Add("阿拉善盟"); CityNameList.Add("沈阳市"); CityNameList.Add("大连市"); CityNameList.Add("鞍山市"); CityNameList.Add("抚顺市"); CityNameList.Add("本溪市"); CityNameList.Add("丹东市"); CityNameList.Add("锦州市"); CityNameList.Add("营口市"); CityNameList.Add("阜新市"); CityNameList.Add("辽阳市"); CityNameList.Add("盘锦市"); CityNameList.Add("铁岭市"); CityNameList.Add("朝阳市"); CityNameList.Add("葫芦岛市"); CityNameList.Add("长春市"); CityNameList.Add("吉林市"); CityNameList.Add("四平市"); CityNameList.Add("辽源市"); CityNameList.Add("通化市"); CityNameList.Add("白山市"); CityNameList.Add("松原市"); CityNameList.Add("白城市"); CityNameList.Add("延边朝鲜族自治州"); CityNameList.Add("哈尔滨市"); CityNameList.Add("齐齐哈尔市"); CityNameList.Add("鸡西市"); CityNameList.Add("鹤岗市"); CityNameList.Add("双鸭山市"); CityNameList.Add("大庆市"); CityNameList.Add("伊春市"); CityNameList.Add("佳木斯市"); CityNameList.Add("七台河市"); CityNameList.Add("牡丹江市"); CityNameList.Add("黑河市"); CityNameList.Add("绥化市"); CityNameList.Add("大兴安岭地区"); CityNameList.Add("南京市"); CityNameList.Add("无锡市"); CityNameList.Add("徐州市"); CityNameList.Add("常州市"); CityNameList.Add("苏州市"); CityNameList.Add("南通市"); CityNameList.Add("连云港市"); CityNameList.Add("淮安市"); CityNameList.Add("盐城市"); CityNameList.Add("扬州市"); CityNameList.Add("镇江市"); CityNameList.Add("泰州市"); CityNameList.Add("宿迁市"); CityNameList.Add("杭州市"); CityNameList.Add("宁波市"); CityNameList.Add("温州市"); CityNameList.Add("嘉兴市"); CityNameList.Add("湖州市"); CityNameList.Add("绍兴市"); CityNameList.Add("金华市"); CityNameList.Add("衢州市"); CityNameList.Add("舟山市"); CityNameList.Add("台州市"); CityNameList.Add("丽水市"); CityNameList.Add("合肥市"); CityNameList.Add("芜湖市"); CityNameList.Add("蚌埠市"); CityNameList.Add("淮南市"); CityNameList.Add("马鞍山市"); CityNameList.Add("淮北市"); CityNameList.Add("铜陵市"); CityNameList.Add("安庆市"); CityNameList.Add("黄山市"); CityNameList.Add("滁州市"); CityNameList.Add("阜阳市"); CityNameList.Add("宿州市"); CityNameList.Add("六安市"); CityNameList.Add("亳州市"); CityNameList.Add("池州市"); CityNameList.Add("宣城市"); CityNameList.Add("福州市"); CityNameList.Add("厦门市"); CityNameList.Add("莆田市"); CityNameList.Add("三明市"); CityNameList.Add("泉州市"); CityNameList.Add("漳州市"); CityNameList.Add("南平市"); CityNameList.Add("龙岩市"); CityNameList.Add("宁德市"); CityNameList.Add("南昌市"); CityNameList.Add("景德镇市"); CityNameList.Add("萍乡市"); CityNameList.Add("九江市"); CityNameList.Add("新余市"); CityNameList.Add("鹰潭市"); CityNameList.Add("赣州市"); CityNameList.Add("吉安市"); CityNameList.Add("宜春市"); CityNameList.Add("抚州市"); CityNameList.Add("上饶市"); CityNameList.Add("济南市"); CityNameList.Add("青岛市"); CityNameList.Add("淄博市"); CityNameList.Add("枣庄市"); CityNameList.Add("东营市"); CityNameList.Add("烟台市"); CityNameList.Add("潍坊市"); CityNameList.Add("济宁市"); CityNameList.Add("泰安市"); CityNameList.Add("威海市"); CityNameList.Add("日照市"); CityNameList.Add("莱芜市"); CityNameList.Add("临沂市"); CityNameList.Add("德州市"); CityNameList.Add("聊城市"); CityNameList.Add("滨州市"); CityNameList.Add("菏泽市"); CityNameList.Add("郑州市"); CityNameList.Add("开封市"); CityNameList.Add("洛阳市"); CityNameList.Add("平顶山市"); CityNameList.Add("安阳市"); CityNameList.Add("鹤壁市"); CityNameList.Add("新乡市"); CityNameList.Add("焦作市"); CityNameList.Add("濮阳市"); CityNameList.Add("许昌市"); CityNameList.Add("漯河市"); CityNameList.Add("三门峡市"); CityNameList.Add("南阳市"); CityNameList.Add("商丘市"); CityNameList.Add("信阳市"); CityNameList.Add("周口市"); CityNameList.Add("驻马店市"); CityNameList.Add("省直辖县级行政区划"); CityNameList.Add("武汉市"); CityNameList.Add("黄石市"); CityNameList.Add("十堰市"); CityNameList.Add("宜昌市"); CityNameList.Add("襄阳市"); CityNameList.Add("鄂州市"); CityNameList.Add("荆门市"); CityNameList.Add("孝感市"); CityNameList.Add("荆州市"); CityNameList.Add("黄冈市"); CityNameList.Add("咸宁市"); CityNameList.Add("随州市"); CityNameList.Add("恩施土家族苗族自治州"); CityNameList.Add("省直辖县级行政区划"); CityNameList.Add("长沙市"); CityNameList.Add("株洲市"); CityNameList.Add("湘潭市"); CityNameList.Add("衡阳市"); CityNameList.Add("邵阳市"); CityNameList.Add("岳阳市"); CityNameList.Add("常德市"); CityNameList.Add("张家界市"); CityNameList.Add("益阳市"); CityNameList.Add("郴州市"); CityNameList.Add("永州市"); CityNameList.Add("怀化市"); CityNameList.Add("娄底市"); CityNameList.Add("湘西土家族苗族自治州"); CityNameList.Add("广州市"); CityNameList.Add("韶关市"); CityNameList.Add("深圳市"); CityNameList.Add("珠海市"); CityNameList.Add("汕头市"); CityNameList.Add("佛山市"); CityNameList.Add("江门市"); CityNameList.Add("湛江市"); CityNameList.Add("茂名市"); CityNameList.Add("肇庆市"); CityNameList.Add("惠州市"); CityNameList.Add("梅州市"); CityNameList.Add("汕尾市"); CityNameList.Add("河源市"); CityNameList.Add("阳江市"); CityNameList.Add("清远市"); CityNameList.Add("东莞市"); CityNameList.Add("中山市"); CityNameList.Add("潮州市"); CityNameList.Add("揭阳市"); CityNameList.Add("云浮市"); CityNameList.Add("南宁市"); CityNameList.Add("柳州市"); CityNameList.Add("桂林市"); CityNameList.Add("梧州市"); CityNameList.Add("北海市"); CityNameList.Add("防城港市"); CityNameList.Add("钦州市"); CityNameList.Add("贵港市"); CityNameList.Add("玉林市"); CityNameList.Add("百色市"); CityNameList.Add("贺州市"); CityNameList.Add("河池市"); CityNameList.Add("来宾市"); CityNameList.Add("崇左市"); CityNameList.Add("海口市"); CityNameList.Add("三亚市"); CityNameList.Add("三沙市"); CityNameList.Add("成都市"); CityNameList.Add("自贡市"); CityNameList.Add("攀枝花市"); CityNameList.Add("泸州市"); CityNameList.Add("德阳市"); CityNameList.Add("绵阳市"); CityNameList.Add("广元市"); CityNameList.Add("遂宁市"); CityNameList.Add("内江市"); CityNameList.Add("乐山市"); CityNameList.Add("南充市"); CityNameList.Add("眉山市"); CityNameList.Add("宜宾市"); CityNameList.Add("广安市"); CityNameList.Add("达州市"); CityNameList.Add("雅安市"); CityNameList.Add("巴中市"); CityNameList.Add("资阳市"); CityNameList.Add("阿坝藏族羌族自治州"); CityNameList.Add("甘孜藏族自治州"); CityNameList.Add("凉山彝族自治州"); CityNameList.Add("贵阳市"); CityNameList.Add("六盘水市"); CityNameList.Add("遵义市"); CityNameList.Add("安顺市"); CityNameList.Add("毕节市"); CityNameList.Add("铜仁市"); CityNameList.Add("黔西南布依族苗族自治州"); CityNameList.Add("黔东南苗族侗族自治州"); CityNameList.Add("黔南布依族苗族自治州"); CityNameList.Add("昆明市"); CityNameList.Add("曲靖市"); CityNameList.Add("玉溪市"); CityNameList.Add("保山市"); CityNameList.Add("昭通市"); CityNameList.Add("丽江市"); CityNameList.Add("普洱市"); CityNameList.Add("临沧市"); CityNameList.Add("楚雄彝族自治州"); CityNameList.Add("红河哈尼族彝族自治州"); CityNameList.Add("文山壮族苗族自治州"); CityNameList.Add("西双版纳傣族自治州"); CityNameList.Add("大理白族自治州"); CityNameList.Add("德宏傣族景颇族自治州"); CityNameList.Add("怒江傈僳族自治州"); CityNameList.Add("迪庆藏族自治州"); CityNameList.Add("拉萨市"); CityNameList.Add("日喀则市"); CityNameList.Add("昌都地区"); CityNameList.Add("山南地区"); CityNameList.Add("那曲地区"); CityNameList.Add("阿里地区"); CityNameList.Add("林芝地区"); CityNameList.Add("西安市"); CityNameList.Add("铜川市"); CityNameList.Add("宝鸡市"); CityNameList.Add("咸阳市"); CityNameList.Add("渭南市"); CityNameList.Add("延安市"); CityNameList.Add("汉中市"); CityNameList.Add("榆林市"); CityNameList.Add("安康市"); CityNameList.Add("商洛市"); CityNameList.Add("兰州市"); CityNameList.Add("嘉峪关市"); CityNameList.Add("金昌市"); CityNameList.Add("白银市"); CityNameList.Add("天水市"); CityNameList.Add("武威市"); CityNameList.Add("张掖市"); CityNameList.Add("平凉市"); CityNameList.Add("酒泉市"); CityNameList.Add("庆阳市"); CityNameList.Add("定西市"); CityNameList.Add("陇南市"); CityNameList.Add("临夏回族自治州"); CityNameList.Add("甘南藏族自治州"); CityNameList.Add("西宁市"); CityNameList.Add("海东市"); CityNameList.Add("海北藏族自治州"); CityNameList.Add("黄南藏族自治州"); CityNameList.Add("海南藏族自治州"); CityNameList.Add("果洛藏族自治州"); CityNameList.Add("玉树藏族自治州"); CityNameList.Add("海西蒙古族藏族自治州"); CityNameList.Add("银川市"); CityNameList.Add("石嘴山市"); CityNameList.Add("吴忠市"); CityNameList.Add("固原市"); CityNameList.Add("中卫市"); CityNameList.Add("乌鲁木齐市"); CityNameList.Add("克拉玛依市"); CityNameList.Add("吐鲁番地区"); CityNameList.Add("哈密地区"); CityNameList.Add("昌吉回族自治州"); CityNameList.Add("博尔塔拉蒙古自治州"); CityNameList.Add("巴音郭楞蒙古自治州"); CityNameList.Add("阿克苏地区"); CityNameList.Add("克孜勒苏柯尔克孜自治州"); CityNameList.Add("喀什地区"); CityNameList.Add("和田地区"); CityNameList.Add("伊犁哈萨克自治州"); CityNameList.Add("塔城地区"); CityNameList.Add("阿勒泰地区"); }