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