/// <summary>
/// 获取省份列表
/// </summary>
/// <param name="IsEnabled">是否开通</param>
/// <returns>返回省份实体集合</returns>
public virtual IList <EyouSoft.Model.SystemStructure.SysProvince> GetProvinceList(bool IsEnabled)
{
IList <Model.SystemStructure.SysProvince> List = new List <Model.SystemStructure.SysProvince>();
string strSql = Sql_SysProvince_Select;
if (IsEnabled)
{
strSql += " where ID IN(SELECT ProvinceId FROM tbl_SysCity WHERE IsEnabled='1')";
}
strSql += " order by SortId,HeaderLetter asc";
DbCommand dc = base.SystemStore.GetSqlStringCommand(Sql_SysProvince_Select);
using (IDataReader dr = DbHelper.ExecuteReader(dc, base.SystemStore))
{
Model.SystemStructure.SysProvince model = null;
while (dr.Read())
{
model = new EyouSoft.Model.SystemStructure.SysProvince();
if (!dr.IsDBNull(0))
{
model.ProvinceId = dr.GetInt32(0);
}
if (!dr.IsDBNull(1))
{
model.CountryId = dr.GetInt32(1);
}
model.HeaderLetter = dr[2].ToString();
model.ProvinceName = dr[3].ToString();
if (!dr.IsDBNull(4))
{
model.AreaId = (Model.SystemStructure.ProvinceAreaType)dr.GetInt32(4);
}
if (!dr.IsDBNull(5))
{
model.SortId = dr.GetInt32(5);
}
List.Add(model);
}
model = null;
}
return(List);
}
/// <summary>
/// 获取存在资讯信息的所有省份列表
/// </summary>
/// <returns></returns>
public virtual IList <EyouSoft.Model.SystemStructure.SysProvince> GetExistsNewsProvinceList()
{
IList <Model.SystemStructure.SysProvince> List = new List <Model.SystemStructure.SysProvince>();
string strSql = Sql_SysProvince_Select + " where Id in(select distinct provinceId from tbl_Affiche) order by SortId,HeaderLetter asc";
DbCommand dc = base.SystemStore.GetSqlStringCommand(strSql);
using (IDataReader dr = DbHelper.ExecuteReader(dc, base.SystemStore))
{
Model.SystemStructure.SysProvince model = null;
while (dr.Read())
{
model = new EyouSoft.Model.SystemStructure.SysProvince();
if (!dr.IsDBNull(0))
{
model.ProvinceId = dr.GetInt32(0);
}
if (!dr.IsDBNull(1))
{
model.CountryId = dr.GetInt32(1);
}
model.HeaderLetter = dr[2].ToString();
model.ProvinceName = dr[3].ToString();
if (!dr.IsDBNull(4))
{
model.AreaId = (Model.SystemStructure.ProvinceAreaType)dr.GetInt32(4);
}
if (!dr.IsDBNull(5))
{
model.SortId = dr.GetInt32(5);
}
List.Add(model);
}
model = null;
}
return(List);
}
