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