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