/// <summary>
/// 选择省
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cb_province_SelectedIndexChanged(object sender, EventArgs e)
{
Hat_provinceModel province = (Hat_provinceModel)cb_province.SelectedItem;
cb_city.DataSource = GeneralHelper.GetCitiesByProvince(province);
cb_city.DisplayMember = "city";
}
private static Hat_provinceModel ToModel(DataRow row)
{
Hat_provinceModel hat_province = new Hat_provinceModel();
hat_province.Id = (System.Int32)row["id"];
hat_province.ProvinceID = (System.String)row["provinceID"];
hat_province.Province = (System.String)row["province"];
return(hat_province);
}
/// <summary>
/// 通过地区Area获取包括上级市，省的字符串
/// e.g: 双流县的Hat_areaModel -> "四川省_成都市_双流县"
/// </summary>
/// <param name="area"></param>
/// <returns></returns>
public static string GetFullLocationString(Hat_areaModel area)
{
Hat_cityModel fatherCity = Hat_areaDAL.GetFatherCity(area);
Hat_provinceModel fatherProvince = Hat_cityDAL.GetFatherProvince(fatherCity);
string result = fatherProvince.Province + "_" + fatherCity.City + "_" + area.Area;
return(result);
}
public static Hat_provinceModel[] GetAll()
{
DataTable table = SqlHelper.ExecuteDataTable("select * from hat_province");
Hat_provinceModel[] hat_province = new Hat_provinceModel[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
hat_province[i] = ToModel(table.Rows[i]);
}
return(hat_province);
}
/// <summary>
/// 通过省找到底下的城市
/// </summary>
/// <param name="province"></param>
/// <returns></returns>
public static Hat_cityModel[] GetCitiesByProvince(Hat_provinceModel province)
{
LoadLocationData();
List <Hat_cityModel> cityList = new List <Hat_cityModel>();
string provinceID = province.ProvinceID;
foreach (var city in cities)
{
if (city.Father.Equals(provinceID))
{
cityList.Add(city);
}
}
return(cityList.ToArray());
}
