private void SearchReturnedHistory() { ReturnedHistoryService service = new ReturnedHistoryService(_context); SearchParam p = new SearchParam(); p.CurrentPage = _returnCurrentPage - 1; p.PageSize = _pageSize; p.DRNumber = txtReturnedDr.Text; p.OrderBy = rbReturnedAscending.Checked ? OrdeBy.Ascending : OrdeBy.Descending; ReturnItemResult r = service.SearchReturnedHistories(p); _returnedHistories = r.Results; LoadToReturnHistoryListView(); _returnPageCount = r.PageCount; SetNavigationText(); }
public ReturnItemResult SearchReturnedHistories(SearchParam param) { IQueryable <ReturnedHistory> query = _context.ReturnedHistories .Include("DR"); ReturnItemResult r = new ReturnItemResult(); query = ApplyCondition(param, query); r.TotalItems = query.Count(); r.PageCount = (int)Math.Ceiling((double)r.TotalItems / param.PageSize); int skipRows = param.CurrentPage * param.PageSize; query = ApplyOrderBy(param, query); query = query.Skip(skipRows) .Take(param.PageSize); r.Results = query.ToList(); return(r); }