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