/// <inheritdoc/>
protected override async Task <PaginationResultModel <EventModel> > ProtectedHandleAsync(GetPaginatedQuery request, CancellationToken cancellationToken)
{
var principal = PrincipalProvider.GetPrincipal();
if (principal == null)
{
throw new ForbiddenException("Not authenticated");
}
Expression <Func <EventEntity, bool> > expression = PredicateBuilder.True <EventEntity>();
if (!principal.IsInRole(RoleType.Administrator))
{
expression = expression.And(e => e.UserId == principal.Identity.Name);
}
int total = await Context.EventRepository.CountAsync(expression, cancellationToken);
var query = Context.EventRepository
.GetQuery(expression)
.OrderByDescending(e => e.CreatedDate)
.Skip(request.Page * request.Limit)
.Take(request.Limit);
var entities = await Context.ToListAsync(query, cancellationToken);
var models = entities.Select(e => EventModel.Create(e, Serializer));
return(PaginationResultModel <EventModel> .Create(models, request.Page, request.Limit, total));
}
public async Task <PaginationResultModel> GetByFilter(PaginationParamsModel paginationParams)
{
PaginationResultModel response = new PaginationResultModel();
string searchString = paginationParams.SearchString;
IQueryable <SucceededOperation> operations = _userDbContext.SucceededOperations.Where(operation => operation.AccountId == paginationParams.AccountId);
if (!string.IsNullOrEmpty(searchString))
{
operations = operations.Where(operation => operation.AccountId.ToString().Contains(searchString) ||
operation.Id.ToString().Contains(searchString) ||
operation.Balance.ToString().Contains(searchString) ||
operation.OperationTime.ToString().Contains(searchString) ||
operation.TransactionAmount.ToString().Contains(searchString)
);
}
response.OperationsTotal = await operations.CountAsync();
SortField sortField = paginationParams.SortField;
List <SucceededOperation> operationList = await operations
.OrderBy(sortField.ToString(), paginationParams.SortDirection
.ToString() == "Asc"?false : true)
.Skip((paginationParams.PageIndex) * paginationParams.PageSize).Take(paginationParams.PageSize)
.ToListAsync();
response.OperationsList = _mapper.Map <List <SucceededOperationModel> >(operationList);
return(response);
}
public JsonResult GetArticlesList(PaginationModel pageList)
{
PaginationResultModel <Article> alist = new PaginationResultModel <Article>();
alist = RichArticleService.GetArticleList(pageList);
return(Json(alist));
}
public async Task <PaginationResultModel <CategoryModel> > GetWithPaginationAsync(int page = 1, int limit = 5)
{
var result = new PaginationResultModel <CategoryModel>();
string connectionString = _configuration.GetConnectionString("CoreLearningDB");
using (IDbConnection dapper = new SqlConnection(connectionString))
{
string query = "SP_Categories_GetAll_WithPagination";
int skip = (page - 1) * limit;
var parameters = new DynamicParameters();
parameters.Add("skip", skip);
parameters.Add("take", limit);
parameters.Add("total", dbType: DbType.Int32, direction: ParameterDirection.Output);
var queryResult = await dapper.QueryAsync <CategoryModel>(query, parameters, commandType : CommandType.StoredProcedure);
var total = parameters.Get <int>("total");
result.Data = queryResult.ToList();
result.Page = page;
result.Limit = limit;
result.Total = total;
result.Pages = Convert.ToInt32(Math.Ceiling((decimal)total / limit));
return(result);
}
}
//后台根据页面类型获取富文本中的 简短介绍
public JsonResult GetRichArticleList(PaginationModel pageList)
{
PaginationResultModel <SimpleArticle> result = new PaginationResultModel <SimpleArticle>();
result = RichArticleService.GetRichList(pageList);
return(Json(result));
}
public PaginationResultModel <SummaryReportDTO> GetDataCollectionCarInfoSummaryReportPagination(ReportConfigurationDTO reportConfiguration)
{
IQueryable <SummaryReportDTO> collectionCarInfoReport = GetCollectionCarInfoSummaryReport(reportConfiguration);
PaginationResultModel <SummaryReportDTO> result = PaginationHelper
.GetItemsWithPagination(collectionCarInfoReport, reportConfiguration.PageIndex, reportConfiguration.PageSize);
return(result);
}
public async Task <PaginationResultDTO> Get([FromQuery] PaginationParamsDTO paginationParamsDTO)
{
PaginationParamsModel paginationParams = _mapper.Map <PaginationParamsModel>(paginationParamsDTO);
PaginationResultModel operationList = await _operationsHistoryService.GetByFilter(paginationParams);
PaginationResultDTO paginationResultDTO = _mapper.Map <PaginationResultDTO>(operationList);
return(paginationResultDTO);
}
public PaginationResultModel <CollectionSheetSearchItemDTO> GetAllWithFillter(SearchCollectionSheetDTO input)
{
var query = QueryAndApplyFilterSearchCollectionSheet(input);
PaginationResultModel <CollectionSheetSearchItemDTO> resultSearch = new PaginationResultModel <CollectionSheetSearchItemDTO>();
var resultPaging = PaginationHelper.GetItemsWithPagination(query, input.PageIndex, input.PageSize);
return(TakeIndexForPaging(input, resultPaging));
}
public async Task <PaginationResultModel <ArtistModel> > GetPagedArtistsAsync(PaginationModel pagination, ArtistFilterModel filter = null, IEnumerable <ArtistOrderByModel> orderByList = null, string includes = "", bool tracking = true)
{
var p = _mapper.Map <Pagination>(pagination);
var f = ArtistFilterExpressions(_mapper.Map <ArtistFilter>(filter));
var o = ArtistOrderByList(_mapper.Map <IEnumerable <ArtistOrderBy> >(orderByList));
var a = await _unitOfWork.Artists.GetPagedAsync(p, f, o, includes, tracking);
var result = new PaginationResultModel <ArtistModel>(_mapper.Map <PaginationStateModel>(a.PageState), _mapper.Map <IEnumerable <ArtistModel> >(a.Result));
return(result);
}
/// <inheritdoc/>
protected override async Task <PaginationResultModel <AppLogModel> > ProtectedHandleAsync(GetPaginatedQuery request, CancellationToken cancellationToken)
{
int total = await appLogRepository.CountAsync(cancellationToken);
var result = appLogRepository
.GetQuery()
.OrderByDescending(e => e.Timestamp)
.Skip(request.Page * request.Limit)
.Take(request.Limit)
.Select(e => AppLogModel.Create(e));
return(PaginationResultModel <AppLogModel> .Create(result, request.Page, request.Limit, total));
}
public PaginationResultModel <InforCustomerSearchItemDTO> GetAllWithFillter(SearchInfoCustomerDTO input)
{
IQueryable <InfoCustomer> query = _inforCustomerRepository.FindAll();
query = FilterConditionSearchInfoCustomer(query, input);
PaginationResultModel <InforCustomerSearchItemDTO> resultSearch = new PaginationResultModel <InforCustomerSearchItemDTO>();
var queryModelDTO = query.ProjectTo <InforCustomerSearchItemDTO>();
var resultPaging = PaginationHelper.GetItemsWithPagination(queryModelDTO, input.PageIndex, input.PageSize);
return(resultPaging);
}
//后台获取文章类型
public static PaginationResultModel <Article> GetArticleList(PaginationModel pageList)
{
PaginationResultModel <Article> result = new PaginationResultModel <Article>();
try{
using (CDBContext _cDBContext = new CDBContext()){
List <Article> messages = _cDBContext.Ar.Skip((pageList.Index - 1) * pageList.Size).Take(pageList.Size).ToList();
result.Total = _cDBContext.Ar.Count();
result.status = 1;
result.Data = messages;
result.message = "获取数据成功！";
}
}catch (Exception ex) {
result.status = 0;
result.Data = null;
result.message = ex.ToString();
result.Total = 0;
}
return(result);
}
public static PaginationResultModel <ScrollPicture> GetPicList(PaginationModel pageList)
{
PaginationResultModel <ScrollPicture> result = new PaginationResultModel <ScrollPicture>();
try{
using (CDBContext _cDBContext = new CDBContext()){
List <ScrollPicture> sps = new List <ScrollPicture>();
sps = _cDBContext.Sc.Skip((pageList.Index - 1) * pageList.Size).Take(pageList.Size).ToList();
result.Total = _cDBContext.Sc.Count();
result.status = 1;
result.Data = sps;
result.message = "获取轮播图添加成功";
}
}catch (Exception ex) {
result.status = 0;
result.Data = null;
result.message = ex.ToString();
result.Total = 0;
}
return(result);
}
// private static CDBContext _cDBContext;
// public MailService(CDBContext CDBContext){
// _cDBContext=CDBContext;
// }
//展示邮件列表
public static PaginationResultModel <Message> GetMailList(PaginationModel pageList)
{
PaginationResultModel <Message> result = new PaginationResultModel <Message>();
try{
using (CDBContext cb = new CDBContext()){
List <Message> mss = new List <Message>();
mss = cb.Me.Skip((pageList.Index - 1) * pageList.Size).Take(pageList.Size).ToList();
result.Total = cb.Me.Count();
result.status = 1;
result.Data = mss;
result.message = "获取数据成功！";
}
}catch (Exception ex) {
result.status = 0;
result.Data = null;
result.message = ex.ToString();
result.Total = 0;
}
return(result);
}
/// <inheritdoc/>
public async Task <PaginationResultModel <ObjectModel> > Handle(GetObjectsQuery request, CancellationToken cancellationToken)
{
int total = await context.ObjectRepository.CountAsync(cancellationToken);
var query = context.ObjectRepository
.GetQuery()
.Select(e => new
{
Object = e,
Tasks = e.Tasks.OrderByDescending(e1 => e1.CreatedDate).Take(request.Limit),
Results = e.Tasks.OrderByDescending(e1 => e1.CreatedDate).Select(e1 => e1.Result).Take(request.Limit)
})
.OrderByDescending(e => e.Object.CreatedDate)
.Skip((request.Page - 1) * request.Limit)
.Take(request.Limit);
var entities = await context.ToListAsync(query, cancellationToken);
var models = entities.Select(e => ObjectModel.Create(e.Object, e.Tasks, e.Results, serializer));
return(PaginationResultModel <ObjectModel> .Create(models, request.Page, request.Limit, total));
}
public JsonResult ShowMessageList(PaginationModel pageList)
{
PaginationResultModel <Message> result = MailService.GetMailList(pageList);
return(Json(result));
}
public JsonResult GetPics(PaginationModel pageList)
{
PaginationResultModel <ScrollPicture> sps = ScrollPicService.GetPicList(pageList);
return(Json(sps));
}
private PaginationResultModel <CollectionSheetSearchItemDTO> TakeIndexForPaging(SearchCollectionSheetDTO input, PaginationResultModel <CollectionSheetSearchItemDTO> paging)
{
if (paging != null && paging.Items.Any())
{
if (input.PageIndex >= paging.NumberOfPage)
{
input.PageIndex = 0;
}
int no = input.PageSize * (input.PageIndex);
foreach (CollectionSheetSearchItemDTO item in paging.Items)
{
no++;
item.No = no;
}
}
return(paging);
}
