/// <summary> /// 获取省市区列表 /// </summary> /// <returns></returns> public List <Model.ProvinceCity> GetList() { List <Model.ProvinceCity> list = null; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.StoredProcedure, "Pro_GetProvinceCity")) { if (reader.HasRows) { list = new List <Model.ProvinceCity>(); while (reader.Read()) { Model.ProvinceCity model = new Model.ProvinceCity(); model.NumberID = reader.GetString(0); model.RegionName = reader.GetString(1); model.RegionCode = reader.GetString(2); model.ParentID = reader.GetString(3); model.RegionLevel = reader.GetInt32(4); model.RegionOrder = reader.GetInt32(5); model.Ename = reader.GetString(6); model.ShortEname = reader.GetString(7); list.Add(model); } } } return(list); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); //绑定常用 BindHighUse(); List <Model.ProvinceCity> list = WebHelper.ProvinceCityDataProxy.GetListProvinceCity(); if (list == null || list.Count == 0) { return; } //绑定省份 List <Model.ProvinceCity> provinceItems = list.FindAll(delegate(Model.ProvinceCity pc) { return(pc.ParentID == "1"); }); ConsoleProvince(provinceItems); if (!string.IsNullOrEmpty(context.Request.QueryString["pcity"])) { string pcity = context.Request.QueryString["pcity"].Trim(); string[] pcityArr = pcity.Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries); int pcityArrLen = pcityArr.Length; if (pcityArrLen == 1) { Model.ProvinceCity model = list.Find(delegate(Model.ProvinceCity pc) { return(pc.RegionName == pcityArr[0]); }); List <Model.ProvinceCity> cityItems = list.FindAll(delegate(Model.ProvinceCity pc) { return(pc.ParentID == model.NumberID); }); ConsoleCity(cityItems); } else if (pcityArrLen > 1) { Model.ProvinceCity model = list.Find(delegate(Model.ProvinceCity pc) { return(pc.RegionName == pcityArr[1]); }); List <Model.ProvinceCity> cityItems = list.FindAll(delegate(Model.ProvinceCity pc) { return(pc.ParentID == model.ParentID); }); ConsoleCity(cityItems); List <Model.ProvinceCity> countyItems = list.FindAll(delegate(Model.ProvinceCity pc) { return(pc.ParentID == model.NumberID); }); ConsoleCounty(countyItems); } } //if (!string.IsNullOrEmpty(context.Request.QueryString["op"]) || !string.IsNullOrEmpty(context.Request.QueryString["pcity"])) //{ // string pcity = context.Request.QueryString["pcity"].Trim(); // string[] pcityArr = pcity.Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries); // int pcityArrLen = pcityArr.Length; // if (pcityArrLen < 1) return; // //获取当前城市节点 // Model.ProvinceCity model = list.Find(delegate(Model.ProvinceCity pc) { return pc.RegionName == pcityArr[1]; }); // string op = context.Request.QueryString["op"].Trim(); // if (op == "m") // { // if (pcityArrLen == 1) // { // } // List<Model.ProvinceCity> cityItems = list.FindAll(delegate(Model.ProvinceCity pc) { return pc.ParentID == model.ParentID; }); // ConsoleCity(cityItems); // List<Model.ProvinceCity> countyItems = list.FindAll(delegate(Model.ProvinceCity pc) { return pc.ParentID == model.NumberID; }); // ConsoleCounty(countyItems); // } // else if (op == "s") // { // if (pcityArrLen == 1) // { // List<Model.ProvinceCity> cityItems = list.FindAll(delegate(Model.ProvinceCity pc) { return pc.ParentID == model.NumberID; }); // ConsoleCity(cityItems); // } // else // { // List<Model.ProvinceCity> countyItems = list.FindAll(delegate(Model.ProvinceCity pc) { return pc.ParentID == model.NumberID; }); // ConsoleCounty(countyItems); // } // } //} //if (!string.IsNullOrEmpty(context.Request.QueryString["idAppend"])) //{ // string idAppend = string.Empty; // idAppend = context.Request.QueryString["idAppend"]; // //获取当前常用城市的所有区县和所属省份的所有城市 // GetHighUse(idAppend, list); //} //else if (!string.IsNullOrEmpty(context.Request.QueryString["provinceBind"])) //{ // //获取所有省份 // GetProvince(list); // return; //} //else if (!string.IsNullOrEmpty(context.Request.QueryString["parentId"])) //{ // string parentId = string.Empty; // parentId = context.Request.QueryString["parentId"]; // //获取当前省份的所有城市 // GetCityByProvince(parentId, list); //} //else if (!string.IsNullOrEmpty(context.Request.QueryString["provinceId"])) //{ // string provinceId = string.Empty; // provinceId = context.Request.QueryString["provinceId"]; // //获取当前城市的所有区县 // GetCityByProvince(provinceId, list); //} //else if (!string.IsNullOrEmpty(context.Request.QueryString["cityId"])) //{ // string cityId = string.Empty; // cityId = context.Request.QueryString["cityId"]; // //获取当前父级下的所有子级 // GetCountyByCity(cityId, list); //} }