public DataTable FindTable(string strSql, DbParameter[] dbParameter, PagingBase pagination) { int records = 0; DataTable result = this.db.FindTable(strSql, dbParameter, pagination.SortField, pagination.SortType.ToLower() == "asc", pagination.PageSize, pagination.PageIndex, out records); pagination.RecordCount = records; return(result); }
public IEnumerable <T> FindList <T>(Expression <Func <T, bool> > condition, PagingBase pagination) where T : class, new() { int records = pagination.RecordCount; IEnumerable <T> result = this.db.FindList <T>(condition, pagination.SortField, pagination.SortType.ToLower() == "asc", pagination.PageSize, pagination.PageIndex, out records); pagination.RecordCount = records; return(result); }
public IEnumerable <T> FindList <T>(string strSql, PagingBase pagination) where T : class { int records = pagination.RecordCount; IEnumerable <T> result = this.db.FindList <T>(strSql, pagination.SortField, pagination.SortType.ToLower() == "asc", pagination.PageSize, pagination.PageIndex, out records); pagination.RecordCount = records; return(result); }
public IEnumerable <T> FindList(string strSql, DbParameter[] dbParameter, PagingBase pagination) { int records = 0;; IEnumerable <T> result = this.db.FindList <T>(strSql, dbParameter, pagination.SortField, pagination.SortType.ToLower() == "asc", pagination.PageSize, pagination.PageIndex, out records); pagination.RecordCount = records; return(result); }
public IEnumerable <T> FindList(PagingBase pagination) { int records = 0; IEnumerable <T> result = this.db.FindList <T>(pagination.PageIndex, pagination.PageSize, pagination.SortField, pagination.SortType.ToLower() == "asc", out records); pagination.RecordCount = records; return(result); }
private static IPagedList <T> DoPaging <T>(IQueryable <T> source, int page, int recordsPerPage) { if (source == null) { throw new ArgumentNullException(nameof(source)); } page = page < 1 ? 1 : page; recordsPerPage = recordsPerPage < 1 ? 1 : recordsPerPage; var result = source.Skip((page - 1) * recordsPerPage).Take(recordsPerPage); var paging = new PagingBase(page, recordsPerPage, source.Count()); return(new PagedList <T>(result.ToList(), paging)); }
public IEnumerable <T> GetPageList(string sql, PagingBase pagination) { return(this.BaseRepository().FindList(sql, pagination)); }
public IEnumerable <T> GetPageList(PagingBase pagination, Expression <Func <T, bool> > expression) { return(this.BaseRepository().FindList(expression, pagination)); }