/// <summary>
/// 获取省市区列表
/// </summary>
/// <returns></returns>
public List <Model.ProvinceCityInfo> GetList()
{
List <Model.ProvinceCityInfo> list = null;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.StoredProcedure, "Pro_GetProvinceCity"))
{
if (reader.HasRows)
{
list = new List <Model.ProvinceCityInfo>();
while (reader.Read())
{
Model.ProvinceCityInfo model = new Model.ProvinceCityInfo();
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.ProvinceCityInfo> list = WebHelper.ProvinceCityDataProxy.GetListProvinceCity();
if (list == null || list.Count == 0)
{
return;
}
//绑定省份
List <Model.ProvinceCityInfo> provinceItems = list.FindAll(delegate(Model.ProvinceCityInfo 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.ProvinceCityInfo model = list.Find(delegate(Model.ProvinceCityInfo pc) { return(pc.RegionName == pcityArr[0]); });
List <Model.ProvinceCityInfo> cityItems = list.FindAll(delegate(Model.ProvinceCityInfo pc) { return(pc.ParentID == model.NumberID); });
ConsoleCity(cityItems);
}
else if (pcityArrLen > 1)
{
Model.ProvinceCityInfo model = list.Find(delegate(Model.ProvinceCityInfo pc) { return(pc.RegionName == pcityArr[1]); });
List <Model.ProvinceCityInfo> cityItems = list.FindAll(delegate(Model.ProvinceCityInfo pc) { return(pc.ParentID == model.ParentID); });
ConsoleCity(cityItems);
List <Model.ProvinceCityInfo> countyItems = list.FindAll(delegate(Model.ProvinceCityInfo 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);
//}
}
