//
// 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("阿勒泰地区");
}
