/// <summary> /// 通过地区取得所在城市 /// </summary> /// <param name="area"></param> /// <returns></returns> public static Hat_cityModel GetFatherCity(Hat_areaModel area) { int id = (int)SqlHelper.ExecuteScalar("select id from hat_city where cityID = @cityID", new SqlParameter("@cityID", area.Father)); return(Hat_cityDAL.GetById(id)); }
/// <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); }