/// <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()); }