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