/// <summary> /// 获取角色列表 /// </summary> /// <param name="condition"></param> /// <param name="pagination"></param> /// <param name="sortFieldName"></param> /// <param name="sortEnum"></param> /// <returns></returns> public virtual List <SysRole> GetRoleList(SearchSysRole condition, Pagination pagination, string sortFieldName, ScriptQuery.SortEnum sortEnum) { try { Script.TableName = SysRole.SysRole_TableName; Script.Select().ALL().From().Where(); if (!string.IsNullOrEmpty(condition.RoleName)) { Script.Like(SysRole.RoleName_FieldName, condition.RoleName); } if (condition.RoleState > 0) { Script.Where(SysRole.RoleState_FieldName, condition.RoleState); } if (condition.IsInnerRole != 2) { Script.Where(SysRole.IsInnerRole_FieldName, condition.IsInnerRole); } Script.Where(SysRole.Owner_FieldName, condition.Owner); if (!string.IsNullOrEmpty(condition.OwnerCode)) { Script.Where(SysRole.OwnerCode_FieldName, condition.OwnerCode); } Script.AddOrderBy().OrderBy(sortFieldName, sortEnum); Script.PageIndex = pagination.PageIndex; Script.PageSize = pagination.PageSize; Script.PrimaryKey = SysRole.RoleID_FieldName; //sql2000分页查询时请指定主键字段名称 List <SysRole> lists = Script.GetList <SysRole>(); pagination.RecordCount = Script.RecordCount; return(lists); } catch (Exception ex) { Log.Error(ex.Message, ex); return(new List <SysRole>()); } }
/// <summary> /// 获取角色列表 /// </summary> /// <param name="condition"></param> /// <param name="pagination"></param> /// <returns></returns> public virtual List <SysRole> GetRoleList(SearchSysRole condition, DevNet.Common.Pagination pagination) { return(GetRoleList(condition, pagination, SysRole.RoleID_FieldName, ScriptQuery.SortEnum.ASC)); }