/// <summary>
/// 分页查询
/// </summary>
/// <param name="keyword">关键字</param>
/// <param name="pageIndex">页数</param>
/// <param name="pageSize">页码</param>
/// <param name="sortColumn">排序字段</param>
/// <param name="sortBy">ASC,DESC</param>
/// <returns></returns>
public Page <SysUser> GetPage(SysUsersSearchModel model)
{
var sql = new StringBuilder(@" select a.* from sys_user a
where a.state!=-1");
if (!string.IsNullOrWhiteSpace(model.keyword))
{
sql.Append(string.Format(" and (a.name like '{0}')", "%" + model.keyword.Trim() + "%"));
}
if (model.state != -1)
{
sql.Append($" and (a.state = '{model.state}')");
}
sql.Append(" order by a.create_on desc ");
var result = fsql.Select <SysUser>().WithSql(sql.ToString()).ToPage(model.page, model.limit);
return(result);
}
public Page <SysUser> GetPage(SysUsersSearchModel model)
{
Page <SysUser> pages = _ISysUserServices.GetPage(model);
return(pages);
}
