/// <summary>
/// 根据城市ID获取县区数据列表
/// </summary>
/// <param name="cityId">
/// The city id.
/// </param>
/// <returns>
/// 返回查询结果
/// </returns>
public static IList<County> GetCountiesByCityID(int cityId)
{
if (cityId < 1)
{
return new List<County>();
}
var mongoDbStore = new MongoDbStore<County>("Counties");
var queries = mongoDbStore.List(c => c.CityID == cityId);
if (queries == null)
{
return new List<County>();
}
return queries.ToList();
}
/// <summary>
/// The generate limited buy area.
/// </summary>
/// <returns>
/// The <see cref="string"/>.
/// </returns>
private string GenerateLimitedBuyArea()
{
int pageCount;
var mongoDbHelperForProvince = new MongoDbStore<Province>("Provinces");
var mongoDbHelperForCity = new MongoDbStore<City>("Cities");
var mongoDbHelperForCounty = new MongoDbStore<County>("Counties");
var provinces = mongoDbHelperForProvince.List(1, 34, province => province.ID != 0, out pageCount);
var cities = mongoDbHelperForCity.List(1, 346, city => city.ID != 0, out pageCount);
var counties = mongoDbHelperForCounty.List(1, 2976, county => county.ID != 0, out pageCount);
var province1 = new List<string> { "北京", "上海", "天津", "重庆", "河北" };
var province2 = new List<string> { "山西", "河南", "辽宁", "吉林", "黑龙江" };
var province3 = new List<string> { "内蒙古", "江苏", "山东", "安徽", "浙江" };
var province4 = new List<string> { "福建", "湖北", "湖南", "广东", "广西" };
var province5 = new List<string> { "江西", "四川", "海南", "贵州", "云南" };
var province6 = new List<string> { "西藏", "陕西", "甘肃", "青海", "宁夏" };
var province7 = new List<string> { "新疆", "台湾", "香港", "澳门" };
var stringBuilder = new StringBuilder();
stringBuilder.Append("<div class='smc'>");
#region Generate Province One Html
stringBuilder.Append("<div class='item'>");
for (var i = 0; i < 5; i++)
{
var provinceName = province1[i];
if (string.IsNullOrEmpty(provinceName))
{
continue;
}
stringBuilder.Append(
i < 2
? "<div class='i-item' data-widget='area'>"
: "<div class='i-item right' data-widget='area'>");
var province = provinces.Find(item => item.Name == provinceName);
if (province != null)
{
stringBuilder.Append(string.Format("<div class='province' title='{0}'>", provinceName));
stringBuilder.Append(string.Format("<div data-widget='area-check' data-id='{0}' class='input selected'>", province.ID));
stringBuilder.Append("<span>√</span>");
stringBuilder.Append("</div>");
stringBuilder.Append(string.Format("{0} (<span class='red' data-widget='area-num'>0</span>)<em></em>", provinceName));
stringBuilder.Append("</div>");
var cityList = cities.Where(item => item.ProvinceID == province.ID).ToList();
if (cityList.Count > 0)
{
if (cityList.Count == 1)
{
var countyList = counties.Where(item => item.CityID == cityList[0].ID);
stringBuilder.Append("<div class='city'><ul>");
foreach (var county in countyList)
{
stringBuilder.Append(string.Format("<li title='{0}'>", county.Name));
stringBuilder.Append(
string.Format(
"<input checked='checked' data-widget='area-list' autocomplete='off' data-id='{0}' type='checkbox'>{1}",
county.ID,
county.Name));
stringBuilder.Append(string.Format("</li>"));
}
stringBuilder.Append("</ul></div>");
}
else
{
stringBuilder.Append("<div class='city'><ul>");
foreach (var city in cityList)
{
stringBuilder.Append(string.Format("<li title='{0}'>", city.Name));
stringBuilder.Append(string.Format("<input checked='checked' data-widget='area-list' autocomplete='off' data-id='{0}' type='checkbox'>{1}", city.ID, city.Name));
stringBuilder.Append(string.Format("</li>"));
}
stringBuilder.Append("</ul></div>");
}
}
}
stringBuilder.Append("</div>");
}
stringBuilder.Append("</div>");
#endregion
stringBuilder.AppendLine();
#region Generate Province Two Html
stringBuilder.Append("<div class='item'>");
for (var i = 0; i < 5; i++)
{
var provinceName = province2[i];
if (string.IsNullOrEmpty(provinceName))
{
continue;
}
stringBuilder.Append(
i < 2
? "<div class='i-item' data-widget='area'>"
: "<div class='i-item right' data-widget='area'>");
var province = provinces.Find(item => item.Name == provinceName);
if (province != null)
{
stringBuilder.Append(string.Format("<div class='province' title='{0}'>", provinceName));
stringBuilder.Append(string.Format("<div data-widget='area-check' data-id='{0}' class='input selected'>", province.ID));
stringBuilder.Append("<span>√</span>");
stringBuilder.Append("</div>");
stringBuilder.Append(string.Format("{0} (<span class='red' data-widget='area-num'>0</span>)<em></em>", provinceName));
stringBuilder.Append("</div>");
var cityList = cities.Where(item => item.ProvinceID == province.ID).ToList();
if (cityList.Count > 0)
{
stringBuilder.Append("<div class='city'><ul>");
foreach (var city in cityList)
{
stringBuilder.Append(string.Format("<li title='{0}'>", city.Name));
stringBuilder.Append(string.Format("<input checked='checked' data-widget='area-list' autocomplete='off' data-id='{0}' type='checkbox'>{1}", city.ID, city.Name));
stringBuilder.Append(string.Format("</li>"));
}
stringBuilder.Append("</ul></div>");
}
}
stringBuilder.Append("</div>");
}
stringBuilder.Append("</div>");
#endregion
stringBuilder.AppendLine();
#region Generate Province Three Html
stringBuilder.Append("<div class='item'>");
for (var i = 0; i < 5; i++)
{
var provinceName = province3[i];
if (string.IsNullOrEmpty(provinceName))
{
continue;
}
stringBuilder.Append(
i < 2
? "<div class='i-item' data-widget='area'>"
: "<div class='i-item right' data-widget='area'>");
var province = provinces.Find(item => item.Name == provinceName);
if (province != null)
{
stringBuilder.Append(string.Format("<div class='province' title='{0}'>", provinceName));
stringBuilder.Append(string.Format("<div data-widget='area-check' data-id='{0}' class='input selected'>", province.ID));
stringBuilder.Append("<span>√</span>");
stringBuilder.Append("</div>");
stringBuilder.Append(string.Format("{0} (<span class='red' data-widget='area-num'>0</span>)<em></em>", provinceName));
stringBuilder.Append("</div>");
var cityList = cities.Where(item => item.ProvinceID == province.ID).ToList();
if (cityList.Count > 0)
{
stringBuilder.Append("<div class='city'><ul>");
foreach (var city in cityList)
{
stringBuilder.Append(string.Format("<li title='{0}'>", city.Name));
stringBuilder.Append(string.Format("<input checked='checked' data-widget='area-list' autocomplete='off' data-id='{0}' type='checkbox'>{1}", city.ID, city.Name));
stringBuilder.Append(string.Format("</li>"));
}
stringBuilder.Append("</ul></div>");
}
}
stringBuilder.Append("</div>");
}
stringBuilder.Append("</div>");
#endregion
stringBuilder.AppendLine();
#region Generate Province Four Html
stringBuilder.Append("<div class='item'>");
for (var i = 0; i < 5; i++)
{
var provinceName = province4[i];
if (string.IsNullOrEmpty(provinceName))
{
continue;
}
stringBuilder.Append(
i < 2
? "<div class='i-item' data-widget='area'>"
: "<div class='i-item right' data-widget='area'>");
var province = provinces.Find(item => item.Name == provinceName);
if (province != null)
{
stringBuilder.Append(string.Format("<div class='province' title='{0}'>", provinceName));
stringBuilder.Append(string.Format("<div data-widget='area-check' data-id='{0}' class='input selected'>", province.ID));
stringBuilder.Append("<span>√</span>");
stringBuilder.Append("</div>");
stringBuilder.Append(string.Format("{0} (<span class='red' data-widget='area-num'>0</span>)<em></em>", provinceName));
stringBuilder.Append("</div>");
var cityList = cities.Where(item => item.ProvinceID == province.ID).ToList();
if (cityList.Count > 0)
{
stringBuilder.Append("<div class='city'><ul>");
foreach (var city in cityList)
{
stringBuilder.Append(string.Format("<li title='{0}'>", city.Name));
stringBuilder.Append(string.Format("<input checked='checked' data-widget='area-list' autocomplete='off' data-id='{0}' type='checkbox'>{1}", city.ID, city.Name));
stringBuilder.Append(string.Format("</li>"));
}
stringBuilder.Append("</ul></div>");
}
}
stringBuilder.Append("</div>");
}
stringBuilder.Append("</div>");
#endregion
stringBuilder.AppendLine();
#region Generate Province Five Html
stringBuilder.Append("<div class='item'>");
for (var i = 0; i < 5; i++)
{
var provinceName = province5[i];
if (string.IsNullOrEmpty(provinceName))
{
continue;
}
stringBuilder.Append(
i < 2
? "<div class='i-item' data-widget='area'>"
: "<div class='i-item right' data-widget='area'>");
var province = provinces.Find(item => item.Name == provinceName);
if (province != null)
{
stringBuilder.Append(string.Format("<div class='province' title='{0}'>", provinceName));
stringBuilder.Append(string.Format("<div data-widget='area-check' data-id='{0}' class='input selected'>", province.ID));
stringBuilder.Append("<span>√</span>");
stringBuilder.Append("</div>");
stringBuilder.Append(string.Format("{0} (<span class='red' data-widget='area-num'>0</span>)<em></em>", provinceName));
stringBuilder.Append("</div>");
var cityList = cities.Where(item => item.ProvinceID == province.ID).ToList();
if (cityList.Count > 0)
{
stringBuilder.Append("<div class='city'><ul>");
foreach (var city in cityList)
{
stringBuilder.Append(string.Format("<li title='{0}'>", city.Name));
stringBuilder.Append(string.Format("<input checked='checked' data-widget='area-list' autocomplete='off' data-id='{0}' type='checkbox'>{1}", city.ID, city.Name));
stringBuilder.Append(string.Format("</li>"));
}
stringBuilder.Append("</ul></div>");
}
}
stringBuilder.Append("</div>");
}
stringBuilder.Append("</div>");
#endregion
stringBuilder.AppendLine();
#region Generate Province Six Html
stringBuilder.Append("<div class='item'>");
for (var i = 0; i < 5; i++)
{
var provinceName = province6[i];
if (string.IsNullOrEmpty(provinceName))
{
continue;
}
stringBuilder.Append(
i < 2
? "<div class='i-item' data-widget='area'>"
: "<div class='i-item right' data-widget='area'>");
var province = provinces.Find(item => item.Name == provinceName);
if (province != null)
{
stringBuilder.Append(string.Format("<div class='province' title='{0}'>", provinceName));
stringBuilder.Append(string.Format("<div data-widget='area-check' data-id='{0}' class='input selected'>", province.ID));
stringBuilder.Append("<span>√</span>");
stringBuilder.Append("</div>");
stringBuilder.Append(string.Format("{0} (<span class='red' data-widget='area-num'>0</span>)<em></em>", provinceName));
stringBuilder.Append("</div>");
var cityList = cities.Where(item => item.ProvinceID == province.ID).ToList();
if (cityList.Count > 0)
{
stringBuilder.Append("<div class='city'><ul>");
foreach (var city in cityList)
{
stringBuilder.Append(string.Format("<li title='{0}'>", city.Name));
stringBuilder.Append(string.Format("<input checked='checked' data-widget='area-list' autocomplete='off' data-id='{0}' type='checkbox'>{1}", city.ID, city.Name));
stringBuilder.Append(string.Format("</li>"));
}
stringBuilder.Append("</ul></div>");
}
}
stringBuilder.Append("</div>");
}
stringBuilder.Append("</div>");
#endregion
stringBuilder.AppendLine();
#region Generate Province Seven Html
stringBuilder.Append("<div class='item'>");
for (var i = 0; i < 4; i++)
{
var provinceName = province7[i];
if (string.IsNullOrEmpty(provinceName))
{
continue;
}
stringBuilder.Append(
i < 2
? "<div class='i-item' data-widget='area'>"
: "<div class='i-item right' data-widget='area'>");
var province = provinces.Find(item => item.Name == provinceName);
if (province != null)
{
stringBuilder.Append(string.Format("<div class='province' title='{0}'>", provinceName));
stringBuilder.Append(string.Format("<div data-widget='area-check' data-id='{0}' class='input selected'>", province.ID));
stringBuilder.Append("<span>√</span>");
stringBuilder.Append("</div>");
stringBuilder.Append(string.Format("{0} (<span class='red' data-widget='area-num'>0</span>)<em></em>", provinceName));
stringBuilder.Append("</div>");
var cityList = cities.Where(item => item.ProvinceID == province.ID).ToList();
if (cityList.Count > 0)
{
stringBuilder.Append("<div class='city'><ul>");
foreach (var city in cityList)
{
stringBuilder.Append(string.Format("<li title='{0}'>", city.Name));
stringBuilder.Append(string.Format("<input checked='checked' data-widget='area-list' autocomplete='off' data-id='{0}' type='checkbox'>{1}", city.ID, city.Name));
stringBuilder.Append(string.Format("</li>"));
}
stringBuilder.Append("</ul></div>");
}
}
stringBuilder.Append("</div>");
}
stringBuilder.Append("</div>");
#endregion
stringBuilder.Append("</div>");
return stringBuilder.ToString();
}
/// <summary>
/// The query cities.
/// </summary>
/// <param name="provinceID">
/// The Province ID.
/// </param>
/// <returns>
/// The <see cref="JsonResult"/>.
/// </returns>
public static IList<City> QueryCities(int provinceID)
{
var mongoDbHelper = new MongoDbStore<City>("Cities");
var list = mongoDbHelper.List(c => c.ProvinceID == provinceID);
if (list == null)
{
return new List<City>();
}
return list.ToList();
}
/// <summary>
/// The get resource.
/// </summary>
public static IList<System_Resources> GetResource()
{
var mongoDbStore = new MongoDbStore<System_Resources>("Resources");
var list = mongoDbStore.List(i => i.Key.Contains("picture"));
return list;
}
/// <summary>
/// The query provinces.
/// </summary>
/// <returns>
/// The <see cref="JsonResult"/>.
/// </returns>
public static IList<Province> QueryProvinces()
{
var mongoDbHelper = new MongoDbStore<Province>("Provinces");
var list = mongoDbHelper.List(p => p.ID != 0);
return list == null ? new List<Province>() : list.ToList();
}
/// <summary>
/// The query counties.
/// </summary>
/// <param name="cityID">
/// The city id.
/// </param>
/// <returns>
/// The <see cref="JsonResult"/>.
/// </returns>
public JsonResult QueryCounties(string cityID)
{
var mongoDbHelper = new MongoDbStore<County>("Counties");
int pageCount;
var list = mongoDbHelper.List(1, 2976, county => county.ID != 0, out pageCount);
if (list == null)
{
return this.Json(null);
}
var result = list.Where(item => item.CityID == Convert.ToInt32(cityID));
return this.Json(result, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// The validate right.
/// </summary>
/// <param name="resourceKey">
/// The resource key.
/// </param>
/// <param name="permissions">
/// The permissions.
/// </param>
/// <returns>
/// The <see cref="bool"/>.
/// </returns>
public bool ValidateRight(string resourceKey, string permissions)
{
if (string.IsNullOrWhiteSpace(permissions) || string.IsNullOrWhiteSpace(resourceKey))
{
return false;
}
try
{
var resources = new MongoDbStore<System_Resources>("Resources");
var list = resources.List(i => i.ID > 0);
var resource = list.FirstOrDefault(item => item.Key == resourceKey);
if (resource == null || resource.Code == null)
{
return true;
}
return resource.Position <= permissions.Length && permissions.Substring(resource.Position, 1).Equals("1");
}
catch (Exception exception)
{
LogUtils.SystemTrace(
string.Format("判断权限出错了，ResourceKey = {0}，错误信息:{1}", resourceKey, exception.Message),
"ValidateRight",
Category.Fatal,
"",
10,
"判断权限");
throw;
}
}
