/// <summary>
/// 获得公司列表
/// 2015-11-25 吉日嘎拉 进行改进
/// </summary>
/// <param name="province">省</param>
/// <param name="city">城市</param>
/// <param name="district">县区</param>
/// <returns>数据表</returns>
public static string[] GetOrganizeByDistrictByCache(string province, string city, string district)
{
string[] result = null;
string organize = string.Empty;
if (string.IsNullOrWhiteSpace(province))
{
province = string.Empty;
}
if (string.IsNullOrWhiteSpace(city))
{
city = string.Empty;
}
if (string.IsNullOrWhiteSpace(district))
{
district = string.Empty;
}
string key = "OrganizeByDistrict_" + province + "_" + city + "_" + district;
using (var redisClient = PooledRedisHelper.GetOrganizeClient())
{
organize = redisClient.Get <string>(key);
}
if (!string.IsNullOrWhiteSpace(organize))
{
result = organize.Split('.');
}
else
{
// 从数据库读取数据
BaseOrganizeManager organizeManager = new BaseOrganizeManager();
result = organizeManager.GetOrganizeByDistrict(province, city, district);
// 设置缓存
if (result != null && result.Length > 0)
{
organize = string.Join(".", result);
using (var redisClient = PooledRedisHelper.GetOrganizeClient())
{
redisClient.Set <string>(key, organize, DateTime.Now.AddHours(4));
}
}
}
return(result);
}
/// <summary>
/// 获取城市
/// 2015-11-25 吉日嘎拉 采用缓存方式，效率应该会更高
/// </summary>
/// <param name="province">省份</param>
/// <returns>城市数组</returns>
public static string[] GetCityByCache(string province = null)
{
string[] result = null;
string city = string.Empty;
if (string.IsNullOrWhiteSpace(province))
{
province = string.Empty;
}
string key = "OrganizeCity_" + province;
using (var redisClient = PooledRedisHelper.GetOrganizeClient())
{
city = redisClient.Get <string>(key);
}
if (!string.IsNullOrWhiteSpace(city))
{
result = city.Split('.');
}
else
{
// 从数据库读取数据
BaseOrganizeManager organizeManager = new BaseOrganizeManager();
result = organizeManager.GetCity(province);
// 设置缓存
if (result != null && result.Length > 0)
{
city = string.Join(".", result);
using (var redisClient = PooledRedisHelper.GetOrganizeClient())
{
redisClient.Set <string>(key, city, DateTime.Now.AddHours(4));
}
}
}
return(result);
}
/// <summary>
/// 获取省份
/// 2015-11-25 吉日嘎拉 采用缓存方式，效率应该会更高
/// </summary>
/// <param name="area">区域</param>
/// <returns>省份数组</returns>
public static string[] GetProvinceByCache(string area = null)
{
string[] result = null;
if (string.IsNullOrWhiteSpace(area))
{
area = string.Empty;
}
string key = "OrganizeProvince_" + area;
string province = string.Empty;
using (var redisClient = PooledRedisHelper.GetOrganizeClient())
{
province = redisClient.Get <string>(key);
}
if (!string.IsNullOrWhiteSpace(province))
{
result = province.Split('.');
}
else
{
// 从数据库读取数据
BaseOrganizeManager organizeManager = new BaseOrganizeManager();
result = organizeManager.GetProvince(area);
// 设置缓存
if (result != null && result.Length > 0)
{
province = string.Join(".", result);
using (var redisClient = PooledRedisHelper.GetOrganizeClient())
{
redisClient.Set <string>(key, province, DateTime.Now.AddHours(4));
}
}
}
return(result);
}