Beispiel #1
0
        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();
        }
Beispiel #2
0
        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);
        }