/// <summary>
/// 得到查询条件的分页列表数据
/// </summary>
/// <param name="req">带分页属性的DTO查询对象</param>
/// <returns></returns>
public async Task <IResponseEntity> GetListAsync(RequestEntity <DictionaryHeaderFilterRequest> req)
{
// 得到权限模板配置的数据条件
var condition = await _permissionDomain.GetPermissionDynamicFilterAsync(_authUser.PermissionId, "DICTIONARY_HEADER");
var key = req.Filter?.Key;
var withDisable = req.Filter != null ? req.Filter.WithDisable : false;
var list = await _dictionaryRepository.Select
.WhereDynamicFilter(condition)
.WhereIf(key.IsNotNull(), a => (a.Title.Contains(key) || a.Code.Contains(key) || a.Description.Contains(key)))
.WhereIf(!withDisable, a => a.IsDisabled == false)
.Count(out var total)
.OrderBy(true, a => a.OrderIndex)
.Page(req.CurrentPage, req.PageSize)
.ToListAsync();
var data = new ResponsePageEntity <DictionaryHeaderForListResponse>()
{
List = _mapper.Map <List <DictionaryHeaderForListResponse> >(list),
Total = total
};
return(ResponseEntity.Ok(data));
}
public async Task <IResponseEntity> GetListAsync(RequestEntity <LoginLogFilterRequest> req)
{
var key = req.Filter?.Key;
var list = await _loginLogRepository.Select
.WhereIf(key.IsNotNull(), a => a.CreatedByName.Contains(key) || a.RealName.Contains(key) || a.Ip.Contains(key))
.Count(out var total)
.OrderByDescending(true, c => c.Id)
.Page(req.CurrentPage, req.PageSize)
.ToListAsync <LoginLogForListResponse>();
var data = new ResponsePageEntity <LoginLogForListResponse>()
{
List = list,
Total = total
};
return(ResponseEntity.Ok(data));
}
public async Task <IResponseEntity> GetListAsync(RequestEntity <ConfigFilterRequest> req)
{
var key = req.Filter?.Key;
var withDisable = req.Filter != null ? req.Filter.WithDisable : false;
var list = await _sysConfigRepository.Select
.WhereIf(key.IsNotNull(), a => (a.Title.Contains(key) || a.Code.Contains(key) || a.Description.Contains(key)))
.WhereIf(!withDisable, a => a.IsDisabled == false)
.Count(out var total)
.OrderBy(true, a => a.OrderIndex)
.Page(req.CurrentPage, req.PageSize)
.ToListAsync();
var data = new ResponsePageEntity <ConfigForListResponse>()
{
List = _mapper.Map <List <ConfigForListResponse> >(list),
Total = total
};
return(ResponseEntity.Ok(data));
}
public async Task <IResponseEntity> GetListAsync(RequestEntity <UserFilterRequest> req)
{
var key = req.Filter?.Key;
var withDisable = req.Filter != null ? req.Filter.WithDisable : false;
var list = await _sysUserRepository.Select
.WhereIf(key.IsNotNull(), a => (a.UserName.Contains(key) || a.DisplayName.Contains(key)))
.WhereIf(!withDisable, a => a.IsDisabled == false)
.Include(a => a.Permission)
.Count(out var total)
.OrderBy(true, a => a.CreatedTime)
.Page(req.CurrentPage, req.PageSize)
.ToListAsync();
var data = new ResponsePageEntity <UserForListResponse>()
{
List = _mapper.Map <List <UserForListResponse> >(list),
Total = total
};
return(ResponseEntity.Ok(data));
}
public async Task <IResponseEntity> GetListAsync(RequestEntity <TaskQzFilterRequest> req)
{
var key = req.Filter?.Key;
var withDisable = req.Filter != null ? req.Filter.WithDisable : false;
var list = await _SysTaskQzRepository.Select
.WhereIf(key.IsNotNull(), a => (a.Name.Contains(key) || a.Remark.Contains(key) || a.JobGroup.Contains(key)))
.WhereIf(!withDisable, a => a.IsDisabled == false)
.Count(out var total)
.OrderBy(true, a => a.CreatedTime)
.Page(req.CurrentPage, req.PageSize)
.ToListAsync();
var data = new ResponsePageEntity <TaskQzForListResponse>()
{
List = _mapper.Map <List <TaskQzForListResponse> >(list),
Total = total
};
data.List.ToList().ForEach(x => {
x.TriggerState = _schedulerCenter.GetJobRunTriggerState(x.Id.ToString(), x.JobGroup);
x.NextFireTime = _schedulerCenter.GetJobNextFireTime(x.Id.ToString(), x.JobGroup);
});
return(ResponseEntity.Ok(data));
}
