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