示例#1
0
        public void SetPagination()
        {
            _collection.SetPagination(new QueryDto(1, 20));

            Assert.AreEqual(1, _collection.Page);
            Assert.AreEqual(20, _collection.PerPage);
        }
示例#2
0
        private Pager CalculatePager(int total, int page)
        {
            var q          = new QueryDto(page, 20);
            var collection = new PagedCollection <int>();

            collection.SetPagination(q);
            collection.Total = total;
            var pager = collection.CalculatePager();

            return(pager);
        }
示例#3
0
        /// <inheritdoc />
        public PagedCollection <TEntity> QueryPaged(string baseSql, OrderCritia <TEntity> orderField, QueryDto qdata)
        {
            Expect.IsNotBlank(baseSql, nameof(baseSql));
            Expect.IsNotNull(orderField, nameof(orderField));
            Expect.IsNotNull(qdata, nameof(qdata));

            var result = new PagedCollection <TEntity>();

            result.SetPagination(qdata);
            var queryPair = GetQueryBuilder().CreatePagedQueryTuple(Session, baseSql, orderField, qdata);

            result.Total = queryPair.Item1.ExecInt();
            result.Data  = queryPair.Item2.GetAll();
            return(result);
        }