Пример #1
0
        /// <summary>
        /// get paged data
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public List <UserLogEntity> GetPaged(UserLogQuery query, out int count)
        {
            IDbSession session = SessionFactory.CreateSession();

            try
            {
                var sortList = new List <DapperExtensions.ISort>();
                sortList.Add(new DapperExtensions.Sort {
                    PropertyName = "ID", Ascending = false
                });

                IPredicate predicate = null;
                count = QuickRepository.Count <UserLogEntity>(session.Connection, predicate);
                var list = QuickRepository.GetPaged <UserLogEntity>(session.Connection,
                                                                    query.PageIndex, query.PageSize, predicate, sortList, false).ToList();

                return(list);
            }
            catch (System.Exception)
            {
                throw;
            }
            finally
            {
                session.Dispose();
            }
        }
Пример #2
0
        public ResponseResult <List <UserLogEntity> > GetUserLogPaged(UserLogQuery query)
        {
            var result = ResponseResult <List <UserLogEntity> > .Default();

            try
            {
                var count = 0;
                var list  = LogService.GetPaged(query, out count);

                result = ResponseResult <List <UserLogEntity> > .Success(list);

                result.TotalRowsCount = count;
                result.TotalPages     = (count + query.PageSize - 1) / query.PageSize;
            }
            catch (System.Exception)
            {
                result = ResponseResult <List <UserLogEntity> > .Error("获取用户登录日志数据失败!");
            }
            return(result);
        }