/// <summary>
/// 分页方法
/// </summary>
/// <typeparam name="TEntity">实体</typeparam>
/// <typeparam name="TEntityDto">返回的Dto</typeparam>
/// <param name="query"></param>
/// <param name="input"></param>
/// <returns></returns>
public static async Task <PagedResultDto <TEntityDto> > GetPageSortListAsync <TEntity, TEntityDto>(this IQueryable <TEntity> query, PagedSortedRequestInput input, Expression <Func <TEntity, TEntityDto> > selector = null)
{
//总行数
var totalCount = await query.CountAsync();
//排序
if (!string.IsNullOrWhiteSpace(input.Sorting))
{
query = query.OrderBy(input.Sorting);
}
//分页
int startIndex = (input.StartPage - 1) * input.PageCount;
query = query.Skip(startIndex).Take(input.PageCount);
List <TEntityDto> rlst = null;
if (selector != null)
{
var query2 = query.Select(selector);
rlst = await query2.ToListAsync();
}
else
{
//获取对象
var entities = await query.ToListAsync();
rlst = Mapper.Map <List <TEntityDto> >(entities);
}
//组装分页返回对象
var PagedResult = new PagedResultDto <TEntityDto>(totalCount, rlst);
return(PagedResult);
}
public Task <PagedResultDto <DireccionFamiliarEstudianteDto> > GetAllFiltered(PagedAndSortedResultRequestDto input, string filter)
{
var provinciaList = new List <DireccionFamiliarEstudiante>();
var query = Repository.GetAll();
query = ApplySorting(query, input);
if (filter != null && filter != string.Empty)
{
provinciaList = query
.Where(x => x.Descripcion.StartsWith(filter))
.Skip(input.SkipCount)
.Take(input.MaxResultCount).ToList();
var result = new PagedResultDto <DireccionFamiliarEstudianteDto>(query.Count(), ObjectMapper.Map <List <DireccionFamiliarEstudianteDto> >(provinciaList));
return(Task.FromResult(result));
}
else
{
provinciaList = query
.Skip(input.SkipCount)
.Take(input.MaxResultCount).ToList()
.ToList();
var result = new PagedResultDto <DireccionFamiliarEstudianteDto>(query.Count(), ObjectMapper.Map <List <DireccionFamiliarEstudianteDto> >(provinciaList));
return(Task.FromResult(result));
}
}
public Task <PagedResultDto <PaisDto> > GetAllFiltered(PagedAndSortedResultRequestDto input, string filter)
{
var paisList = new List <Pais>();
var query = Repository.GetAll();
query = ApplySorting(query, input);
if (filter != null && filter != string.Empty)
{
paisList = query
.Where(x => x.Identificador.StartsWith(filter) || x.Nombre.StartsWith(filter))
.Skip(input.SkipCount)
.Take(input.MaxResultCount).ToList();
var result = new PagedResultDto <PaisDto>(query.Count(), ObjectMapper.Map <List <PaisDto> >(paisList));
return(Task.FromResult(result));
}
else
{
paisList = query
.Skip(input.SkipCount)
.Take(input.MaxResultCount).ToList()
.ToList();
var result = new PagedResultDto <PaisDto>(query.Count(), ObjectMapper.Map <List <PaisDto> >(paisList));
return(Task.FromResult(result));
}
}
public async Task <PagedResultDto <Department> > GetPagedDepartmentsList(GetDepartmentInput input)
{
var query = _departmentRepository.GetAll();
if (!string.IsNullOrEmpty(input.FilterText))
{
query = query.Where(s => s.Name.Contains(input.FilterText));
}
var count = query.Count();
query = query.OrderBy(input.Sorting).Skip((input.CurrentPage - 1) * input.MaxResultCount).Take(input.MaxResultCount);
List <Department> models = await query.Include(i => i.Administrator).AsNoTracking().ToListAsync();
var dtos = new PagedResultDto <Department>
{
TotalCount = count,
CurrentPage = input.CurrentPage,
MaxResultCount = input.MaxResultCount,
Data = models,
FilterText = input.FilterText,
Sorting = input.Sorting
};
return(dtos);
}
private async Task SetAnswerLabel(PagedResultDto <AnswerLogDto> result)
{
foreach (var item in result.Items)
{
item.Title = await questionAppService.GetItemLabel(item.DataSetItemId);
}
}
public async Task TestGetComments()
{
TestingContext testingContext = new TestingContext();
SetUpTestingContext(testingContext);
ApplicationDbContext appDbContext = testingContext.GetSimple <ApplicationDbContext>();
ICommentsService commentsService = testingContext.GetService <CommentsService>();
Question question = appDbContext.Questions.First();
for (int i = 0; i < 20; i++)
{
CommentDto commentDto = new CommentDto()
{
IdQuestion = question.Id,
CommentText = "Hello Comment",
};
await commentsService.AddCommentAsync(commentDto);
}
GetCommentsDto getCommentsDto = new GetCommentsDto
{
IdQuestion = question.Id,
Page = 0,
};
//Act
PagedResultDto <CommentDto> comments = await commentsService.GetCommentssAsync(getCommentsDto);
//Assert
Assert.Equal(5, comments.Data.Count);
Assert.Equal(4, comments.Numpages);
Assert.Equal(20, comments.Count);
}
public PagedResultDto <OrganizationUnitUserDto> GetOrganizationUnitJoinableUserList(GetOrganizationUnitJoinableUserListInput input)
{
var userQuery =
from u in _userRepository.GetAll()
join ouu1 in _userOrganizationUnitRepository.GetAll().Where(q => q.OrganizationUnitId == input.Id)
on u.Id equals ouu1.UserId
into ouu2
from ouu in ouu2.DefaultIfEmpty()
where ouu == null
select u;
if (!string.IsNullOrEmpty(input.Filter))
{
userQuery = userQuery.Where(u =>
u.UserName.Contains(input.Filter) ||
u.Name.Contains(input.Filter) ||
u.PhoneNumber.Contains(input.Filter) ||
u.EmailAddress.Contains(input.Filter));
}
var finalQuery = userQuery.OrderBy(u => u.Id).Skip(input.SkipCount).Take(input.MaxResultCount);
var result = new PagedResultDto <OrganizationUnitUserDto>
{
TotalCount = userQuery.Count(),
Items = finalQuery.ToList().MapTo <List <OrganizationUnitUserDto> >(),
};
return(result);
}
public async Task <IActionResult> GetQuestionsAsync(
[FromQuery] Guid?gcId,
[FromQuery] int?p = 1,
[FromQuery] string filter = "")
{
if (p == null || p <= 0)
{
p = 1;
}
ViewBag.p = p.Value;
var serchInp = new GetGrammarDTO
{
Filter = filter ?? "",
MaxResultCount = AppTheme.Limit,
SkipCount = (p.Value - 1) * AppTheme.Limit,
GrammarCategoryId = gcId ?? null
};
var res = await _Grammarervice.GetBaseListAsync(serchInp);
if (gcId == null || gcId == Guid.Empty)
{
ViewBag.GroupName = L["All"];
}
else
{
var qg = await _GrammarCategoryService.GetAsync(gcId.Value);
if (!qg.Success || qg.Data == null)
{
ViewBag.GroupName = L["Unknow"];
}
else
{
ViewBag.GroupName = qg.Data.Name;
}
}
if (res.Success)
{
PagedResultDto <GrammarBaseDTO> Containers = res.Data;
string listRes = string.Format("Showing {0} to {1} of {2} entries",
res.Data.TotalCount > 0 ? serchInp.SkipCount + 1 : 0, serchInp.SkipCount + res.Data.Items.Count, res.Data.TotalCount);
if (!filter.IsNullOrEmpty())
{
listRes += string.Format(" for \"{0}\"", serchInp.Filter);
}
ViewBag.ListState = listRes;
ViewBag.Filter = filter;
ViewBag.Pagination = PaginateHelper.Generate(
"javascript:syncGrammar('" + gcId + "','{0}', '" + filter + "');",
p.Value, Containers.TotalCount, AppTheme.Limit);
return(PartialView("~/Pages/Manager/Grammars/Partials/Grammars.cshtml", Containers));
}
else
{
return(PartialView(AppTheme.ContentNothing));
}
}
public async Task <PagedResultDto <User> > GetAllByAsync(QueryUserFilter filter)
{
var result = new PagedResultDto <User>();
try
{
var query = await _repository.GetAllByAsync();
query = query.Where(x => x.IsDel == 0);
if (!string.IsNullOrWhiteSpace(filter.Name))
{
query = query.Where(x => x.Name == filter.Name);
}
if (!string.IsNullOrWhiteSpace(filter.Phone))
{
query = query.Where(x => x.Phone == filter.Phone);
}
result.TotalCount = query.Count();
result.Items = query.OrderByDescending(x => x.CreateDate).Skip(filter.limit * (filter.page - 1)).Take(filter.limit).ToList();
}
catch (Exception ex)
{
_logger.LogError("获取异常" + ex.ToString());
}
return(result);
}
public ActionResult GetAllLocalizedStrings()
{
var items = _applicationLanguageTextAppService.GetAllLocalizedStringDtos();
var page = new PagedResultDto <LocalizedStringDto>(items.Count, items);
return(Json(page));
}
public async Task TestGetVersions()
{
//Prepare
TestingContext testingContext = new TestingContext();
SetUpTestingContext(testingContext);
ApplicationDbContext dbContext = testingContext.GetSimple <ApplicationDbContext>();
Question question = dbContext.Questions.First();
testingContext.AddPrincipalMock(question.User.UserId, Roles.User);
testingContext.AddBusinessSecurityService();
IQuestionService questionService = testingContext.GetService <QuestionService>();
testingContext.DependencyMap[typeof(IQuestionService)] = questionService;
IVersionService versionService = testingContext.GetService <VersionService>();
int newId = await versionService.VersionQuestionAsync(question.Id);
await versionService.AcceptQuestionAsync(newId);
VersionInfoParametersDto versionInfoParametersDto = new VersionInfoParametersDto()
{
Page = 0,
IdQuestion = newId,
};
//Act
PagedResultDto <VersionInfoDto> result = await versionService.GetVersionsAsync(versionInfoParametersDto);
//Assert
Assert.Equal(2, result.Count);
}
public async Task <PagedResultDto <Teacher> > GetPagedTeacherList(GetTeacherInput input)
{
var query = _teacherRepository.GetAll();
if (!string.IsNullOrEmpty(input.FilterText))
{
query = query.Where(s => s.Name.Contains(input.FilterText));
}
var count = query.Count();
query = query.OrderBy(input.Sorting).Skip((input.CurrentPage - 1) * input.MaxResultCount).Take(input.MaxResultCount);
var models = await query.Include(a => a.OfficeLocation).Include(a => a.CourseAssignments).ThenInclude(a => a.Course).ThenInclude(a => a.StudentCourses).ThenInclude(a => a.Student)
.Include(i => i.CourseAssignments).ThenInclude(i => i.Course).ThenInclude(i => i.Department).AsNoTracking().ToListAsync();
var dtos = new PagedResultDto <Teacher>
{
TotalCount = count,
CurrentPage = input.CurrentPage,
MaxResultCount = input.MaxResultCount,
Data = models,
FilterText = input.FilterText,
Sorting = input.Sorting
};
return(dtos);
}
private async Task FillRoleNames(PagedResultDto <UserListDto> pagedResultDto)
{
/* This method is optimized to fill role names to given list. */
var distinctRoleIds = (
from userDto in pagedResultDto.Items
from userRoleDto in userDto.Roles
select userRoleDto.RoleId
).Distinct();
var roleNames = new Dictionary <int, string>();
foreach (var roleId in distinctRoleIds)
{
roleNames[roleId] = (await RoleManager.GetRoleByIdAsync(roleId)).DisplayName;
}
foreach (var userDto in pagedResultDto.Items)
{
foreach (var userRoleDto in userDto.Roles)
{
userRoleDto.RoleName = roleNames[userRoleDto.RoleId];
}
userDto.Roles = userDto.Roles.OrderBy(r => r.RoleName).ToList();
}
}
public override Task <PagedResultDto <FacultyDto> > GetListAsync(FacultyFilterDto input)
{
var query = Repository.AsQueryable();
if (input.Id.HasValue)
{
query = query.Where(s => s.Id == input.Id);
}
if (!string.IsNullOrEmpty(input.Name))
{
query = query.Where(s => s.Name.Contains(input.Name));
}
var count = query.Count();
if (!string.IsNullOrEmpty(input.Sorting))
{
query = ApplySorting(query, input);
}
if (input.MaxResultCount > 0)
{
query = ApplyPaging(query, input);
}
var items = query.ToList();
var result = new PagedResultDto <FacultyDto>(count, ObjectMapper.Map <List <Faculty>, List <FacultyDto> >(items));
return(Task.FromResult(result));
}
public async Task <PagedResultDto <Student> > GetPaginatedResult(GetStudentInput input)
{
var query = _studentRepository.GetAll();
//判断输入的搜索名称是否为空
if (!string.IsNullOrEmpty(input.FilterText))
{
query = query.Where(s => s.Name.Contains(input.FilterText) ||
s.Email.Contains(input.FilterText));
}
//统计查询数据的总条数，用于分页计算总页数
var count = query.Count();
//根据需求进行排序，然后进行分页逻辑的计算
query = query.OrderBy(input.Sorting).Skip((input.CurrentPage - 1) * input.MaxResultCount).Take(input.MaxResultCount);
//将查询结果转换为List集合，加载到内存中
var models = await query.AsNoTracking().ToListAsync();
var dtos = new PagedResultDto <Student>
{
TotalCount = count,
CurrentPage = input.CurrentPage,
MaxResultCount = input.MaxResultCount,
Data = models,
FilterText = input.FilterText,
Sorting = input.Sorting
};
return(dtos);
}
public PagedResultDto <InvoiceDto> GetAll(PagedUserResultRequestDto input)
{
var query = (from inv in _repository.GetAll()
join o in _orderRepository.GetAll() on inv.OrderId equals o.Id
join c in _customerRepository.GetAll() on o.CustomerId equals c.Id
select new InvoiceDto
{
Id = inv.Id,
OrderId = o.Id,
InvoiceNumber = inv.InvoiceNumber,
PaidAmount = inv.PaidAmount,
InvoiceDate = inv.InvoiceDate,
CustomerName = c.CustomerName,
})
.Skip(input.SkipCount)
.Take(input.MaxResultCount)
.ToList();
var result = new PagedResultDto <InvoiceDto>
{
Items = query,
TotalCount = query.Count
};
return(result);
}
public Task <PagedResultDto <TipoIdentificacionDto> > GetAllFiltered(PagedAndSortedResultRequestDto input, string filter)
{
var tipoTelefonoList = new List <TipoIdentificacion>();
var query = Repository.GetAll();
query = ApplySorting(query, input);
if (filter != null && filter != string.Empty)
{
tipoTelefonoList = query
.Where(x => x.Descripcion.StartsWith(filter))
.Skip(input.SkipCount)
.Take(input.MaxResultCount).ToList();
var result = new PagedResultDto <TipoIdentificacionDto>(query.Count(), ObjectMapper.Map <List <TipoIdentificacionDto> >(tipoTelefonoList));
return(Task.FromResult(result));
}
else
{
tipoTelefonoList = query
.Skip(input.SkipCount)
.Take(input.MaxResultCount).ToList()
.ToList();
var result = new PagedResultDto <TipoIdentificacionDto>(query.Count(), ObjectMapper.Map <List <TipoIdentificacionDto> >(tipoTelefonoList));
return(Task.FromResult(result));
}
}
public async Task <PagedResultDto <ReviewDto> > Handle(GetReviewsQuery request, CancellationToken cancellationToken)
{
var page = request.InputPage.Page - 1;
IQueryable <Review> reviews;
if (request.ReviewType == ReviewType.Company)
{
reviews = _companyRepository.Read()
.Include(x => x.User).OrderByDescending(x => x.Date)
.Skip(page * request.InputPage.PageSize)
.Take(request.InputPage.PageSize);
}
else if (request.ReviewType == ReviewType.Shop)
{
reviews = _shopRepository.Read()
.Include(x => x.User).OrderByDescending(x => x.Date)
.Skip(page * request.InputPage.PageSize)
.Take(request.InputPage.PageSize);
}
else
{
reviews = null;
}
var reviewsDto = _mapper.Map <IList <ReviewDto> >(reviews.ToList());
var reviewTotalCount = reviews.Count();
var response = new PagedResultDto <ReviewDto>()
{
PageSize = request.InputPage.PageSize,
CurrentPage = request.InputPage.Page,
TotalPages = (int)Math.Ceiling((decimal)reviewTotalCount / (decimal)request.InputPage.PageSize),
Results = reviewsDto
};
return(response);
}
//获取监控数据列表,table显示用
public ActionResult GetLogMonitorData(MonitorSearchVM searchePara)
{
GetLogMonitorInput monitorIn = ConvertSearchVMToGetLogMonitorInput(searchePara);
PagedResultDto <Log_SystemMonitorDto> monitors = _logMonitorService.GetLogMonitors(monitorIn);
var result = Abp.AutoMapper.AutoMapExtensions.MapTo <PagedResultDto <Log_OperateMonitorView> >(monitors);// monitors.MapTo<PagedResultDto<Log_OperateMonitorView>>();
result.Items = result.Items.Select(a =>
{
a.RunHours = Convert.ToDouble(a.RunHours.ToString("f2"));
a.CpuUsage = Convert.ToDouble(a.CpuUsage.ToString("f2"));
a.MemoryUsage = Convert.ToDouble(a.MemoryUsage.ToString("f2"));
a.CurProcMem = Convert.ToDouble(a.CurProcMem.ToString("f2"));
a.CurProcMemUse = Convert.ToDouble(a.CurProcMemUse.ToString("f2"));
a.CurProcCpuUse = Convert.ToDouble(a.CurProcCpuUse.ToString("f2"));
a.CurSubProcMem = Convert.ToDouble(a.CurSubProcMem.ToString("f2"));
if (string.IsNullOrEmpty(a.DiskSpace))
{
a.DiskSpace = null; return(a);
}
a.DiskSpace = string.Join(";", SerializeHelper.XMLDESerializer <List <DiskSpaceEdm> >(a.DiskSpace).Select(p => p.DiscName.Trim(':') + ":" + p.Free + "G(" + p.Rate + "%)"));
return(a);
}).ToList();
var json = AbpJson(new { total = result.TotalCount, rows = result.Items }, null, null, JsonRequestBehavior.AllowGet, true, false);
return(json);
}
public PagedResultDto <BillInfoBusinessDto> GetPagedBusiness(SearchBillInfoInput input) //业务清单
{
var Has = PermissionChecker.IsGranted(PermissionNames.Pages_Staff_Merchandiser); //判断是否业务员
var HasI = PermissionChecker.IsGranted(PermissionNames.Pages_Inspection); //判断是有权限
var task = _BillInfoRepository.GetAll().OrderByDescending(t => t.Id)
.Where(t => t.IsCandidate == false)
.WhereIf(input.BillNo.HasValue, t => t.BillNo == input.BillNo)
.WhereIf(!input.CompanyAbbreviation.IsNullOrEmpty(), t => t.CompanyAbbreviation.Contains(input.CompanyAbbreviation))
.WhereIf(!input.ReceivingCity.IsNullOrEmpty(), t => t.ReceivingCity == input.ReceivingCity)
.WhereIf(input.CreationTimeS.HasValue, t => t.CreationTime >= input.CreationTimeS)
.WhereIf(input.CreationTimeE.HasValue, t => t.CreationTime <= input.CreationTimeE)
.WhereIf(!input.ExpressNo.IsNullOrEmpty(), t => t.ExpressNo == input.ExpressNo)
.WhereIf(!HasI, t => t.BillStateID < 2)
.OrderByDescending(t => t.CreationTime)
.ToList();
var taskcount = task.Count; //数据总量
var tasklist = task.Skip((input.PageIndex - 1) * input.PageSize).Take(input.PageSize).ToList(); //获取目标页数据
var result = new PagedResultDto <BillInfoBusinessDto>(taskcount, tasklist.MapTo <List <BillInfoBusinessDto> >());
return(result);
}
/// <summary>
/// 获取所有role
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <PagedResultDto <RoleListDto> > GetRoles(GetRolesInput input)
{
var query = _roleManager
.Roles
.WhereIf(
!input.Filter.IsNullOrWhiteSpace(),
r => r.DisplayName.Contains(input.Filter)
)
.WhereIf(
!input.Permission.IsNullOrWhiteSpace(),
r => r.Permissions.Any(rp => rp.Name == input.Permission && rp.IsGranted)
);
var count = await query.CountAsync();
var roles = await query
.OrderBy(input.Sorting)
.PageBy(input)
.ToListAsync();
var rolesListDtos = roles.MapTo <List <RoleListDto> >();
var x = new PagedResultDto <RoleListDto>(
count,
rolesListDtos
);
return(new PagedResultDto <RoleListDto>(
count,
rolesListDtos
));
}
public async Task OnGetAsync()
{
PageQuery.OnlyPublish = true;
//HACK 是否要写死每页最大显示?
PageQuery.MaxResultCount = 10;
Articels = await articleService.GetArticleByPageAsync(PageQuery);
}
public async Task <PagedResultDto <CourseDto> > GetCoursesByCategory(long categoryId)
{
var courses = await _courseRepository.GetAll().Include(x => x.Category)
.Include(x => x.Location)
.Where(x => x.Category.Id == categoryId && x.IsActive).Select(x => new CourseDto
{
Id = x.Id,
Title = x.Title,
Description = x.Description,
Quota = x.Quota,
Price = x.Price,
StartDate = x.StartDate,
ImagePath = BlobService.BlobService.GetImageUrl(x.ImagePath),
DiscountPrice = x.DiscountPrice,
EndDate = x.EndDate,
Score = x.Score,
LocationName = x.Location.Name,
}).ToListAsync();
var result = new PagedResultDto <CourseDto>
{
Results = courses,
Count = courses.Count
};
return(result);
}
public async Task <PagedResultDto <AlarmLog> > GetPaginatedResult(GetLogInput input)
{
var logs = await Repository.Alarmlog.GetAllListAsync(X => X.Cid == input.Id);
if (!string.IsNullOrEmpty(input.FilterText))
{
logs = logs.Where(X => X.Sid.Contains(input.FilterText) || X.Sname.Contains(input.FilterText) || X.Textlog.Contains(input.FilterText) || X.Alarmtime.Contains(input.FilterText)).ToList();
}
var count = logs.Count();
switch (input.FilterText)
{
case "sid":
logs = logs.OrderBy(S => S.Sid).ToList();
break;
case "sid_desc":
logs = logs.OrderByDescending(S => S.Sid).ToList();
break;
case "sname":
logs = logs.OrderBy(S => S.Sname).ToList();
break;
case "sname_desc":
logs = logs.OrderByDescending(S => S.Sname).ToList();
break;
case "text":
logs = logs.OrderBy(S => S.Textlog).ToList();
break;
case "text_desc":
logs = logs.OrderBy(S => S.Textlog).ToList();
break;
case "time":
logs = logs.OrderBy(S => S.Alarmtime).ToList();
break;
case "time_desc":
logs = logs.OrderByDescending(S => S.Alarmtime).ToList();
break;
default:
logs = logs.OrderByDescending(X => X.Id).ToList();
break;
}
var dtos = new PagedResultDto <AlarmLog>
{
TotalCount = count,
CurrentPage = input.CurrentPage,
MaxResultCount = input.MaxResultCount,
Data = logs,
FilterText = input.FilterText,
Sorting = input.Sorting
};
return(dtos);
}
/// <summary>
/// 获取用户分页列表
/// </summary>
public async Task <PagedResultDto <UserOutput> > GetUsers(GetUsersInput input)
{
var query = UserManager.Users
.Include(u => u.Roles)
.WhereIf(
!input.Filter.IsNullOrWhiteSpace(),
u =>
u.Name.Contains(input.Filter) ||
u.Surname.Contains(input.Filter) ||
u.UserName.Contains(input.Filter) ||
u.EmailAddress.Contains(input.Filter)
)
.WhereIf(
input.IsActive.HasValue,
t => t.IsActive == input.IsActive.Value
);
var userCount = await query.CountAsync();
var users = await query.OrderBy(input.Sorting).PageBy(input).ToListAsync();
var l = new PagedResultDto <UserOutput>(
userCount,
users.MapTo <List <UserOutput> >()
);
return(l);
}
public async Task <PagedResultDto <Student> > GetPaginatedResult(GetStudentInput input)
{
var query = _studentRepository.GetAll();
if (!string.IsNullOrEmpty(input.FilterText))
{
query = query.Where(s => s.Name.Contains(input.FilterText) || s.Email.Contains(input.FilterText));
}
var count = query.Count();
query = query.OrderBy(input.Sorting).Skip((input.CurrentPage - 1) * input.MaxResultCount).Take(input.MaxResultCount);
var models = await query.AsNoTracking().ToListAsync();
var dtos = new PagedResultDto <Student>
{
TotalCount = count,
CurrentPage = input.CurrentPage,
MaxResultCount = input.MaxResultCount,
Data = models,
FilterText = input.FilterText,
Sorting = input.Sorting
};
return(dtos);
}
public async Task <PagedResultDto <SubscriptionShortDto> > GetAllSubscriptionsAsync(int page)
{
IQueryable <NotificationSubscription> query = _context.Notifications.Where(x => x.Active);
PagedResultDto <SubscriptionShortDto> result = await ToPagedResult(query, page, MaterializeSubscriptionList);
return(result);
}
private void AddShowPanel(PagedResultDto <ParkDto> result)
{
parkDtos = result.Items;
UserControls.ParkInfo parkInfo;
var width = (this.ActualWidth - 5 * 80) / 4;
foreach (var park in parkDtos)
{
parkInfo = new UserControls.ParkInfo();
parkInfo.Margin = new Thickness(80, 100, 0, 0);
parkInfo.Width = width; //每行展示4个
parkInfo.Height = 250;
parkInfo.DataContext = park;
parkInfo.MouseLeftButtonDown += ParkInfo_MouseLeftButtonDown;
ShowPanel.Children.Add(parkInfo);
}
var parkAdd = new UserControl();
parkAdd.Width = width;
parkAdd.Height = 250;
parkAdd.Margin = new Thickness(80, 100, 0, 0);
parkAdd.Template = (ControlTemplate)FindResource("AddParkControlTemplate");
parkAdd.MouseLeftButtonDown += ParkAdd_MouseLeftButtonDown;
ShowPanel.Children.Add(parkAdd);
}
/// <summary>
/// 查询所属角色所有用户
/// </summary>
/// <param name="input">查询条件</param>
public async void GetUserRole(UserRoleInput input)
{
// 全部
var result = from a in ABP_User.GetAll()
join r in ABP_UserRole.GetAll().Where(w => w.RoleId == input.RoleId) on a.Id equals r.UserId into g1
from g in g1.DefaultIfEmpty()
select new UserRole {
UserId = a.Id, RoleId = g.RoleId, UserName = a.UserName
};
// 全部
if (input.type == 1)
{
}
// 是角色
else if (input.type == 2)
{
result = result.Where(w => w.RoleId == input.RoleId);
}
// 不是角色
else if (input.type == 3)
{
result = result.Where(w => w.RoleId == null);
}
input.UserName = input.UserName ?? "";
// 开始查询
result = result.Where(w => w.UserName.StartsWith(input.UserName));
//
var count = result.Count();
var data = await result.OrderBy(o => o.RoleId).PageBy(input)
.ToListAsync();
var resultList = new PagedResultDto <UserRole>(count, data);
}
public virtual IPagedResult <WebhookSendAttempt> GetAllSendAttemptsBySubscriptionAsPagedList(int?tenantId,
Guid subscriptionId, int maxResultCount, int skipCount)
{
PagedResultDto <WebhookSendAttempt> sendAttempts;
using (var uow = _unitOfWorkManager.Begin())
{
using (_unitOfWorkManager.Current.SetTenantId(tenantId))
{
var query = _webhookSendAttemptRepository.GetAllIncluding(attempt => attempt.WebhookEvent)
.Where(attempt =>
attempt.WebhookSubscriptionId == subscriptionId
);
var totalCount = query.Count();
var list = query
.OrderByDescending(attempt => attempt.CreationTime)
.Skip(skipCount)
.Take(maxResultCount)
.ToList();
sendAttempts = new PagedResultDto <WebhookSendAttempt>()
{
TotalCount = totalCount,
Items = list
};
}
uow.Complete();
}
return(sendAttempts);
}
