public BasePageList<BaseRoleViewModel> GetRoleList(BaseRoleQueryModel query) { return _baseservice.GetRoleList(query); }
/// <summary> /// 获取角色列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public BasePageList<BaseRoleViewModel> GetRoleList(BaseRoleQueryModel query) { const string spName = "sp_common_pager"; const string tableName = @"sys_role "; const string fields = "innerid, name, remark, isenabled"; //var oldField = string.IsNullOrWhiteSpace(query.Order) ? " modifiedtime desc " : query.Order; var oldField = ""; var sqlWhere = new StringBuilder("1=1"); if (query.isenabled != null) { sqlWhere.Append($" and isenabled = %{query.isenabled}%"); } var model = new PagingModel(spName, tableName, fields, oldField, sqlWhere.ToString(), query.PageSize, query.PageIndex); var list = Helper.ExecutePaging<BaseRoleViewModel>(model, query.Echo); return list; }