/// <summary>
/// 分页获取权限大类别列表
/// </summary>
/// <param name="pageSize">每页显示条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="recordCount">总记录数</param>
/// <param name="PermissionType">权限类别数组（如组团，地接等等）</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.SystemStructure.SysPermissionCategory> GetList(int pageSize, int pageIndex, ref int recordCount, int[] PermissionType)
{
SysPermissionClass permissionClass = new SysPermissionClass();
IList <EyouSoft.Model.SystemStructure.SysPermissionCategory> list = new List <EyouSoft.Model.SystemStructure.SysPermissionCategory>();
string tableName = "tbl_SysPermissionCategory";
string fields = "ID,TypeId,CatagroyName,IsEnable,SortId";
string primaryKey = "ID";
string OrderbyString = "SortId asc,ID desc";
#region 生成查询条件
StringBuilder strWhere = new StringBuilder();
if (PermissionType != null && PermissionType.Length > 0)
{
strWhere.Append("TypeId in(");
for (int i = 0; i < PermissionType.Length; i++)
{
strWhere.AppendFormat("{0}{1}", i > 0 ? "," : "", PermissionType[i].ToString());
}
strWhere.Append(")");
}
#endregion
using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), OrderbyString))
{
while (dr.Read())
{
EyouSoft.Model.SystemStructure.SysPermissionCategory model = new EyouSoft.Model.SystemStructure.SysPermissionCategory();
model.Id = dr.GetInt32(0);
model.TypeId = dr.GetInt32(1);
model.CategoryName = dr.GetString(2);
model.IsEnable = dr.GetString(3) == "1" ? true : false;
model.SortId = dr.GetInt32(4);
model.SysPermissionClass = permissionClass.GetList(string.Empty, model.Id, true);
list.Add(model);
model = null;
}
}
permissionClass = null;
return(list);
}
/// <summary>
/// 获取指定权限类别的权限详细列表
/// </summary>
/// <param name="PermissionType">权限类别数组（如组团，地接等等）</param>
/// <param name="LoadPermission">是否立即读取明细权限</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.SystemStructure.SysPermissionCategory> GetList(int[] PermissionType, bool LoadPermission)
{
IList <EyouSoft.Model.SystemStructure.SysPermissionCategory> list = new List <EyouSoft.Model.SystemStructure.SysPermissionCategory>();
SysPermissionClass permissionClass = new SysPermissionClass();
#region 生成查询语句
StringBuilder strSql = new StringBuilder();
strSql.Append(SQL_SysPermissionCategroy_SELECT);
if (PermissionType != null && PermissionType.Length > 0)
{
strSql.Append(" where typeId in(");
for (int i = 0; i < PermissionType.Length; i++)
{
strSql.AppendFormat("{0}{1}", i > 0 ? "," : "", PermissionType[i].ToString());
}
strSql.Append(")");
}
#endregion
DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
EyouSoft.Model.SystemStructure.SysPermissionCategory model = new EyouSoft.Model.SystemStructure.SysPermissionCategory();
model.Id = dr.GetInt32(0);
model.TypeId = dr.GetInt32(1);
model.CategoryName = dr.GetString(2);
model.IsEnable = dr.GetString(3) == "1" ? true : false;
model.SortId = dr.GetInt32(4);
model.SysPermissionClass = permissionClass.GetList(string.Empty, model.Id, LoadPermission);
list.Add(model);
model = null;
}
}
permissionClass = null;
return(list);
}
