public PagedResultDto <PBIReportOutputDto> GetPBIReportList(PagedAndSortedInputDto input)
{
string pbiApi = ConfigurationManager.AppSettings["PBIReportsApi"];
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(pbiApi);
request.ContentType = "application/json";
string adminUserName = ConfigurationManager.AppSettings["AdminUserName"];
string adminPassWord = ConfigurationManager.AppSettings["AdminPassWord"];
request.Credentials = new NetworkCredential(adminUserName, adminPassWord);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream receiveStream = response.GetResponseStream();
StreamReader readStream = new StreamReader(receiveStream, Encoding.UTF8);
var result = readStream.ReadToEnd();
response.Close();
readStream.Close();
var entities = JsonConvert.DeserializeObject <PBIReportResultDto>(result);
return(new PagedResultDto <PBIReportOutputDto>(
entities.Value.Count(),
entities.Value
));
}
public async Task <PagedResultDto <ProjcetAuditResultCheckRoleDto> > GetList(PagedAndSortedInputDto input)
{
var list = _projcetAuditResultCheckRoleRepository.GetAll().WhereIf(!input.SearchKey.IsNullOrWhiteSpace(), r => r.Content.Contains(input.SearchKey));
var count = await list.CountAsync();
var result = list.PageBy(input).ToList();
return(new PagedResultDto <ProjcetAuditResultCheckRoleDto>(count, result.MapTo <List <ProjcetAuditResultCheckRoleDto> >()));
}
public PagedResultDto <WorkFlowModelListDto> GetModels(PagedAndSortedInputDto input)
{
var query = _workFlowModelRepository.GetAll();
if (!input.SearchKey.IsNullOrWhiteSpace())
{
query = query.Where(r => r.Name.Contains(input.SearchKey));
}
var total = query.Count();
var model = query.OrderByDescending(ite => ite.Name).PageBy(input).ToList().MapTo <List <WorkFlowModelListDto> >();
return(new PagedResultDto <WorkFlowModelListDto>(total, model));
}
public List <BlogPostGetAllOutputModel> GetAll(PagedAndSortedInputDto input)
{
var model = _blogPostRepository.GetAll()
.Include(p => p.Tags)
.Include(p => p.PostCategory).ThenInclude(p => p.Category)
.Include(p => p.CreatorUser)
.WhereIsDeleted(false)
.WhereIsActive(true)
.Select(p => new BlogPostGetAllOutputModel
{
Id = p.Id,
CreationDate = p.CreationDate,
Title = p.Title,
SafeTitle = p.SafeTitle,
Detail = p.Detail,
PictureUrl = p.PictureUrl,
Categories = p.PostCategory
.Where(c => c.Category.IsActive & !c.Category.IsDeleted)
.Select(c => new Category
{
Id = c.Category.Id,
SafeName = c.Category.SafeName,
Name = c.Category.Name,
PictureUrl = c.Category.PictureUrl
}).ToList(),
CreatorUser = new CreatorUser
{
Id = p.CreatorUser.Id,
UserName = p.CreatorUser.UserName,
Name = p.CreatorUser.Name,
Surname = p.CreatorUser.Surname,
PictureUrl = p.CreatorUser.PictureUrl
},
Tags = p.Tags
.Where(t => !t.IsDeleted)
.Select(t => new Tag
{
Text = t.Text
}).ToList(),
})
.ApplyCategoryFilter(input.Categories)
.ApplyTagFilter(input.Tags)
.OrderByFilter(input.Sorting)
.Skip((input.PageNumber - 1) * input.PageSize)
.Take(input.PageSize)
.ToList();
//var outputModel = _mapper.Map<List<BlogPostGetAllOutputModel>>(model);
_logger.Information("GetAllBlogPost{0}", model); //TODO:Refactored
return(model);
}
/// <summary>
/// 获取好友列表
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <PagedResultDto <FriendDto> > GetUserFriends(PagedAndSortedInputDto input)
{
var user = AbpSession.GetUserId();
var query = _friendRepository.GetAll().Where(c => c.UserId == user);
var userCount = await query.CountAsync();
var friends = await query
.OrderByDescending(c => c.CreationTime)
.PageBy(input)
.ToListAsync();
var dtos = friends.MapTo <List <FriendDto> >();
return(new PagedResultDto <FriendDto>(userCount, dtos));
}
//public async Task ImportState()
//{
// var dataJsonString = GetFileJson(@"C:\Users\Victor_Lo\Downloads\china-area-data-master\v4\data.json");
// var states = (JObject)JsonConvert.DeserializeObject(dataJsonString);
// var jsonProvices = states["86"];
// foreach (var jsonProvince in jsonProvices.Children())
// {
// var provinceName = jsonProvince.First().Value<string>();
// var province = await _stateManager.FindProvinceByNameAsync(provinceName);
// if (province == null)
// {
// province = new Province()
// {
// Name = provinceName,
// IsActive = true,
// };
// await _stateManager.CreateProvinceAsync(province);
// await CurrentUnitOfWork.SaveChangesAsync();
// }
// var provinceJsonId = ((JProperty)jsonProvince).Name;
// var jsonCitys = states[provinceJsonId];
// if (jsonCitys == null)
// continue;
// foreach (var jsonCity in jsonCitys.Children())
// {
// var cityName = jsonCity.First().Value<string>();
// var city = await _stateManager.FindCityByNameAsync(cityName);
// if (city == null)
// {
// city = new City()
// {
// Name = cityName,
// IsActive = true,
// ProvinceId = province.Id
// };
// await _stateManager.CreateCityAsync(city);
// await CurrentUnitOfWork.SaveChangesAsync();
// }
// var cityJsonId = ((JProperty)jsonCity).Name;
// var jsonDistricts = states[cityJsonId];
// if (jsonDistricts == null)
// continue;
// foreach (var jsonDistrict in jsonDistricts.Children())
// {
// var districtName = jsonDistrict.First().Value<string>();
// var district = await _stateManager.FindDistrictByNameAsync(districtName);
// if (district == null)
// {
// district = new District()
// {
// Name = districtName,
// IsActive = true,
// CityId = city.Id
// };
// await _stateManager.CreateDistrictAsync(district);
// await CurrentUnitOfWork.SaveChangesAsync();
// }
// }
// }
// }
//}
#region Provinces
/// <summary>
/// 获取所有省份
/// </summary>
/// <returns></returns>
public async Task <PagedResultDto <ProvinceListDto> > GetProvinces(PagedAndSortedInputDto input)
{
var query = _stateManager.Provinces;
var provinceCount = await query.CountAsync();
var province = await query
.OrderBy(t => t.Id)
.PageBy(input)
.ToListAsync();
var provinceListDto = ObjectMapper.Map <List <ProvinceListDto> >(province);
return(new PagedResultDto <ProvinceListDto>(
provinceCount,
provinceListDto));
}
public async Task <PagedResultDto <Job_SqlOutputDto> > GetJob_Sql(PagedAndSortedInputDto input)
{
var entities = await _Job_SqlManager.GetAllJob_SqlAsync();
if (string.IsNullOrEmpty(input.Sorting))
{
input.Sorting = "Id";
}
var orderEntities = await Task.FromResult(entities.OrderBy(input.Sorting));
var pageEntities = await Task.FromResult(orderEntities.Skip(input.SkipCount).Take(input.MaxResultCount));
var listDto = pageEntities.MapTo <List <Job_SqlOutputDto> >();
return(new PagedResultDto <Job_SqlOutputDto>(
entities.Count,
listDto
));
}
/// <summary>
///
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <PagedResultDto <CourseExperienceSummaryOutputDto> > GetAllCourseExperienceSummary(
PagedAndSortedInputDto input)
{
var query = (from a in _courseRepository.GetAll().Where(x => !x.IsDeleted && x.IsExperience)
let sendFlow = (from b in _repository.GetAll().Where(x => !x.IsDeleted && x.CourseId == a.Id)
select b.Id).Any()
let submit = (from c in _trainUserExperienceRepository.GetAll()
.Where(x => !x.IsDeleted && x.TrainId == a.Id && x.Type == TrainExperienceType.Course)
select c.Id).Count()
select new CourseExperienceSummaryOutputDto
{
CourseId = a.Id,
CourseName = a.CourseName,
CreateTime = a.CreationTime,
SubmitUser = submit,
LearnUser = a.LearnUser,
LearnType = a.LearnType,
IsSendFlow = sendFlow
}).Where(x => !x.IsSendFlow);
var toalCount = await query.CountAsync();
var ret = await query.OrderByDescending(r => r.CreateTime).PageBy(input).ToListAsync();
ret.ForEach(x =>
{
var unSubmitUser = -1;
switch (x.LearnType)
{
case CourseLearnType.MustAll:
unSubmitUser = UserManager.Users.Count() - x.SubmitUser;
unSubmitUser = unSubmitUser < 0 ? 0 : unSubmitUser;
break;
case CourseLearnType.Must:
unSubmitUser = x.LearnUser.Split(',').Length - x.SubmitUser;
unSubmitUser = unSubmitUser < 0 ? 0 : unSubmitUser;
break;
}
x.UnSubmitUser = unSubmitUser;
});
return(new PagedResultDto <CourseExperienceSummaryOutputDto>(toalCount, ret));
}
public PagedResultDto <ProjectAreaDto> GetList(PagedAndSortedInputDto input)
{
var list = from a in _projectAreaRepository.GetAll()
join b in _userRepository.GetAll() on a.User_Id equals b.Id
orderby a.CreationTime descending
select new ProjectAreaDto
{
CreationTime = a.CreationTime,
CreatorUserId = a.CreatorUserId,
Id = a.Id,
Name = a.Name,
ParentName = "",
Parent_Id = a.Parent_Id,
User_Id = a.User_Id,
Surname = b.Name,
IsDeleted = a.IsDeleted
};
var count = list.Count();
var result = list.PageBy(input).ToList();
return(new PagedResultDto <ProjectAreaDto>(count, result));
}
public async Task <PagedResultDto <Job_RPTEmailOutputDto> > GetJob_RPTEmail(PagedAndSortedInputDto input)
{
var jobEntities = await _Job_RPTEmailManager.GetAllJob_RPTEmailAsync();
var templateEntities = await _ReportTemplateManager.GetAllReportTemplatesAsync();
var jobGroupEntities = await _JobGroupManager.GetAllJobGroupsAsync();
var entities = jobEntities
.Join(jobGroupEntities, t => t.BGJM_JobGroup_Id, c => c.Id, (t, c) => new { t, c })
.Join(templateEntities, t => t.t.Template_Id, c => c.Id, (t, c) => new Job_RPTEmailOutputDto
{
Id = t.t.Id,
Job_RPTEmailName = t.t.Job_RPTEmailName,
BGJM_JobGroup_Id = t.t.BGJM_JobGroup_Id,
Emails = t.t.Emails,
Template_Id = t.t.Template_Id,
Parameters = t.t.Parameters,
Description = t.t.Description,
JobGroupName = t.c.JobGroupName,
TemplateName = c.TemplateName
});
if (string.IsNullOrEmpty(input.Sorting))
{
input.Sorting = "Id";
}
var orderEntities = await Task.FromResult(entities.OrderBy(input.Sorting));
var pageEntities = await Task.FromResult(entities.Skip(input.SkipCount).Take(input.MaxResultCount));
var listDto = pageEntities.MapTo <List <Job_RPTEmailOutputDto> >();
return(new PagedResultDto <Job_RPTEmailOutputDto>(
entities.Count(),
listDto
));
}
public async Task <PagedResultDto <ReportDataSourceOutputDto> > GetReportDataSources(PagedAndSortedInputDto input)
{
var entities = await _ReportDataSourceManager.GetAllReportDataSourcesAsync();
if (string.IsNullOrEmpty(input.Sorting))
{
input.Sorting = "Id";
}
var orderEntities = await Task.FromResult(entities.Where(d => d.Template_Id == 4).OrderBy(input.Sorting));
var pageEntities = await Task.FromResult(orderEntities.Skip(input.SkipCount).Take(input.MaxResultCount));
var listDto = pageEntities.MapTo <List <ReportDataSourceOutputDto> >();
return(new PagedResultDto <ReportDataSourceOutputDto>(
entities.Count,
listDto
));
}
public IActionResult GetAll([FromQuery] PagedAndSortedInputDto input)
{
var entity = _blogPostAppService.GetAll(input);
return(Ok(entity));
}
