/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <XZGLCarBorrowListOutputDto> > GetList(GetXZGLCarBorrowListInput input) { var isAll = false; var userManager = Abp.AbpBootstrapper.Create <Abp.Modules.AbpModule>().IocManager.IocContainer.Resolve <UserManagerNotRemote>(); var userRoles = userManager.GetRoles(AbpSession.UserId.Value); if (userRoles.Any(r => r == "XZRY" || r == "ZJL")) { isAll = true; } var query = from a in _repository.GetAll().Where(x => !x.IsDeleted).WhereIf(input.CarType.HasValue, x => x.CarType == input.CarType.Value).WhereIf(input.Status.HasValue, x => x.Status == input.Status.Value) join b in _usersRepository.GetAll() on a.CreatorUserId equals b.Id let openModel = (from b in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value) select b) where (isAll || (a.CreatorUserId == AbpSession.UserId.Value || a.DealWithUsers.GetStrContainsArray(AbpSession.UserId.HasValue ? AbpSession.UserId.Value.ToString() : ""))) select new XZGLCarBorrowListOutputDto() { Id = a.Id, CreationTime = a.CreationTime, Status = a.Status, UserId = a.UserId, CreatorUserName = b.Name, Tel = a.Tel, StartTime = a.StartTime, EndTime = a.EndTime, CarType = a.CarType, CarTypeName = a.CarType.ToString(), Note = a.Note, Remark = a.Remark, CompanyRemark = a.CompanyRemark, SupplierId = a.SupplierId, SupplierTel = a.SupplierTel, SupplierRemark = a.SupplierRemark, CarRemark = a.CarRemark, Consumption = a.Consumption, CarReturnRemark = a.CarReturnRemark, OtherRemark = a.OtherRemark, UserCarRemark = a.UserCarRemark, IsCompanyCar = a.IsCompanyCar, IsCompanyRent = a.IsCompanyRent, IsUserRent = a.IsUserRent , OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0)) > 0 ? 1 : 2, }; if (!string.IsNullOrEmpty(input.SearchKey)) { query = query.Where(x => x.Note.Contains(input.SearchKey) || x.CreatorUserName.Contains(input.SearchKey)); } var toalCount = query.Count(); var ret = await query.OrderByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); foreach (var item in ret) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); } return(new PagedResultDto <XZGLCarBorrowListOutputDto>(toalCount, ret)); }
/// <summary> /// 行政查看维修申请列表 /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task<PagedResultDto<SupplyRepairDto>> GetAllV2(SupplyRepairListInputDtondSortedInputDto input) { var strflowid = input.FlowId.ToString(); var query = from a in _supplyRepairRepository.GetAll() join b in _userAppService.GetAll() on a.CreatorUserId equals b.Id join c in _supplyBaseRepository.GetAll() on a.SupplyId equals c.Id let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value && x.Type != 6 && strflowid.GetFlowContainHideTask(x.Status)) select c).Any() select new SupplyRepairDto() { Code = c.Code, Des = a.Des, Id = a.Id, IsImportant = a.IsImportant, Name = c.Name, Type = c.Type, TypeName = ((SupplyType)c.Type).ToString(), Money = c.Money, RepairEndTime = a.RepairEndTime, SupplyId = a.SupplyId, UserId = a.CreatorUserId.Value, UserId_Name = b.Name, Version = c.Version, CreationTime = a.CreationTime, Status = a.Status, SortStatus = ((openModel ? 1 : 2) == 1 && a.IsImportant) ? 1 : ((openModel ? 1 : 2) == 1 && !a.IsImportant) ? 2 : 3, }; if (string.IsNullOrWhiteSpace(input.SearchKey) == false) { query = query.Where(ite => ite.Name.Contains(input.SearchKey) || ite.UserId_Name.Contains(input.SearchKey)); } if (!string.IsNullOrWhiteSpace(input.Status)) { var statusArrty = input.Status.Split(","); query = query.Where(r => statusArrty.Contains(r.Status.ToString())); } var total = await query.CountAsync(); //var model = await query.OrderBy(r => r.OpenModel).ThenByDescending(ite => ite.IsImportant).ThenByDescending(ite => ite.CreationTime).PageBy(input).ToListAsync(); var model = await query.OrderBy(r => r.SortStatus).ThenByDescending(ite => ite.CreationTime).PageBy(input).ToListAsync(); var ret = new List<SupplyRepairDto>(); foreach (var i in model) { i.InstanceId = i.Id.ToString(); i.OldOpenModel = i.OpenModel; _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, i as BusinessWorkFlowListOutput); i.FileList = await _abpFileRelationAppService.GetListAsync(new GetAbpFilesInput() { BusinessId = i.Id.ToString(), BusinessType = (int)AbpFileBusinessType.申请用品维修附件 }); ret.Add(i); } return new PagedResultDto<SupplyRepairDto>(total, ret); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <CourseListOutputDto> > GetList(GetCourseListInput input) { var query = from a in _repository.GetAll().Where(x => !x.IsDeleted && (string.IsNullOrEmpty(input.CourseName) || x.CourseName.Contains(input.CourseName)) && (input.IsComplate ? x.Status == -1 : x.Status >= 0) && (input.CourseType == null || input.CourseType == x.CourseType) && !x.IsDelCourse ) join b1 in _dictionRepository.GetAll().Where(x => !x.IsDeleted).DefaultIfEmpty() on a.CourseType equals b1.Id into tmp1 from b in tmp1.DefaultIfEmpty() let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value) select c) select new CourseListOutputDto() { Id = a.Id, CourseName = a.CourseName, CourseType = a.CourseType, CourseTypeName = b == null ? "" : b.Title, CourseLink = a.CourseLink, CourseFileType = a.CourseFileType, LearnTime = a.LearnTime, Recommend = a.Recommend, RecommendWords = a.RecommendWords, CourseIntroduction = a.CourseIntroduction, IsExperience = a.IsExperience, LearnUser = a.LearnUser, LearnType = a.LearnType, ComplateTime = a.ComplateTime, IsSpecial = a.IsSpecial, FilePage = a.FilePage, CreationTime = a.CreationTime, DealWithUsers = a.DealWithUsers, Status = a.Status, CopyForUsers = a.CopyForUsers, OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0)) > 0 ? 1 : 2, }; var toalCount = await query.CountAsync(); var ret = await query.OrderByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); foreach (var item in ret) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); item.CourseFile = await _abpFileRelationAppService.GetListAsync(new GetAbpFilesInput() { BusinessId = item.InstanceId, BusinessType = (int)AbpFileBusinessType.培训课程文件 }); } return(new PagedResultDto <CourseListOutputDto>(toalCount, ret)); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <TrainListOutputDto> > GetList(GetTrainListInput input) { var query = from a in _repository.GetAll().Where(x => !x.IsDeleted) join b in _dictionaryRepository.GetAll().Where(x => !x.IsDeleted) on a.Type equals b.Id let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value) select c) select new TrainListOutputDto() { Id = a.Id, Title = a.Title, Type = a.Type, TypeName = b.Title, LecturerUser = a.LecturerUser, Address = a.Address, StartTime = a.StartTime, Status = a.Status, EndTime = a.EndTime, OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0)) > 0 ? 1 : 2 }; if (!string.IsNullOrEmpty(input.SearchKey)) { query = query.Where(x => x.Title.Contains(input.SearchKey) || x.TypeName.Contains(input.SearchKey)); } if (input.Type.HasValue) { query = query.Where(x => x.Type == input.Type.Value); } var toalCount = await query.CountAsync(); var ret = await query.OrderBy(r => r.OpenModel).ThenByDescending(r => r.StartTime).PageBy(input).ToListAsync(); foreach (var item in ret) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); var arr = item.LecturerUser.Split(',').ToArray(); item.LecturerUser = string.Join <string>(',', _lecturerRepository.GetAll().Where(x => arr.Contains(x.Id.ToString())).Select(x => x.Name)); item.FileList = _abpFileRelationAppService.GetList(new GetAbpFilesInput() { BusinessId = item.Id.ToString(), BusinessType = (int)AbpFileBusinessType.培训 }); } return(new PagedResultDto <TrainListOutputDto>(toalCount, ret)); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <CWGLTravelReimbursementListOutputDto> > GetList(GetCWGLTravelReimbursementListInput input) { var strflowid = input.FlowId.ToString(); var query = from a in _repository.GetAll().Where(x => !x.IsDeleted) join user in UserManager.Users on a.UserId equals user.Id join org in _organizationUnitRepository.GetAll() on a.OrgId equals org.Id let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value && x.Type != 6 && strflowid.GetFlowContainHideTask(x.Status)) select c).Any() select new CWGLTravelReimbursementListOutputDto() { Id = a.Id, UserId_Name = user.Name, OrgId_Name = org.DisplayName, Money = a.Money, CreationTime = a.CreationTime, Status = a.Status, OpenModel = openModel ? 1 : 2, }; var toalCount = await query.CountAsync(); var ret = await query.OrderBy(r => r.OpenModel).ThenByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); foreach (var item in ret) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); } return(new PagedResultDto <CWGLTravelReimbursementListOutputDto>(toalCount, ret)); }
public PagedResultDto <OATenderEnemyListDto> GetAll(WorkFlowPagedAndSortedInputDto input) { var ret = from a in _oaTenderEnemyRepository.GetAll() join b in _oABidProjectRepository.GetAll() on a.ProjectId equals b.Id select new OATenderEnemyDto() { AuditUser = a.AuditUser, Content = a.Content, CreationTime = a.CreationTime, Id = a.Id, ProjectId = a.ProjectId, ProjectName = b.ProjectName, ProjectType = a.ProjectType, Status = a.Status, }; if (string.IsNullOrWhiteSpace(input.SearchKey) == false) { ret = ret.Where(ite => ite.ProjectName.Contains(input.SearchKey)); } var total = ret.Count(); var model = ret.OrderByDescending(ite => ite.CreationTime).PageBy(input).ToList().MapTo <List <OATenderEnemyListDto> >(); foreach (var item in model) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item as BusinessWorkFlowListOutput); } return(new PagedResultDto <OATenderEnemyListDto>(total, model)); }
public async Task <PagedResultDto <OATaskListDto> > GetAll(GetOATaskListInput input) { var currentUserId = AbpSession.UserId.Value; var query = from m in _oATaskRepository.GetAll() join musers in _oATaskUserRepository.GetAll() on m.Id equals musers.OATaskId into muser where (input.ValByCurrentUser && m.ValUser == currentUserId) || (input.HasParticipate && muser.Select(r => r.UserId).Contains(currentUserId)) || (input.CreateByCurrentUser && m.CreatorUserId == currentUserId) select m; if (!input.SearchKey.IsNullOrWhiteSpace()) { query = query.Where(r => r.Title.Contains(input.SearchKey)); } var count = await query.CountAsync(); var oATasks = await query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); var oATaskDtos = new List <OATaskListDto>(); foreach (var oATask in oATasks) { var entity = new OATaskListDto() { Id = oATask.Id, Title = oATask.Title }; //entity.StatusTitle = _workFlowTaskManager.GetStatusTitle(input.FlowId, entity.Status); entity.InstanceId = oATask.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, entity as BusinessWorkFlowListOutput); oATaskDtos.Add(entity); } return(new PagedResultDto <OATaskListDto>(count, oATaskDtos)); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <CWGLRepaymentListOutputDto> > GetList(GetCWGLRepaymentListInput input) { var strflowid = input.FlowId.ToString(); var query = from a in _repository.GetAll().Where(x => !x.IsDeleted && x.BorrowMoneyId == input.BorrowMoneyId) let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value && x.Type != 6 && strflowid.GetFlowContainHideTask(x.Status)) select c).Any() select new CWGLRepaymentListOutputDto() { Id = a.Id, CreationTime = a.CreationTime, Status = a.Status, BorrowMoneyId = a.BorrowMoneyId, Money = a.Money, Mode = a.Mode, BankName = a.BankName, CardNumber = a.CardNumber, BankOpenName = a.BankOpenName , OpenModel = openModel ? 1 : 2, }; var toalCount = await query.CountAsync(); var ret = await query.OrderByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); foreach (var item in ret) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); } return(new PagedResultDto <CWGLRepaymentListOutputDto>(toalCount, ret)); }
public async Task <PagedResultDto <OAFixedAssetsPurchaseListDto> > GetAll(GetOAFixedAssetsPurchaseListInput input) { var currentUserId = AbpSession.UserId.Value; var query = from m in _oAFixedAssetsPurchaseRepository.GetAll() select m; if (!input.SearchKey.IsNullOrWhiteSpace()) { query = query.Where(r => r.Code.Contains(input.SearchKey)); } if (!input.ApplyTypeCode.IsNullOrWhiteSpace()) { query = query.Where(r => r.ApplyTypeCode == input.ApplyTypeCode); } query = query.WhereIf(!input.Status.IsNullOrWhiteSpace(), r => input.Status.Contains(r.Status.ToString())); var count = await query.CountAsync(); var oAFixedAssetsPurchases = await query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); var oAFixedAssetsPurchaseDtos = oAFixedAssetsPurchases.MapTo <List <OAFixedAssetsPurchaseListDto> >(); foreach (var item in oAFixedAssetsPurchaseDtos) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item as BusinessWorkFlowListOutput); } return(new PagedResultDto <OAFixedAssetsPurchaseListDto>(count, oAFixedAssetsPurchaseDtos)); }
public async Task <PagedResultDto <OAReportListDto> > GetAll(SearchReportInput input) { var ret = _oaReportrepository.GetAll().Where(ite => ite.CreatorUserId == AbpSession.UserId.Value); //if (input.ReportWay.HasValue) { // switch (input.ReportWay) { // case ReportWay.我写的: // ret = ret.Where(ite => ite.CreatorUserId == AbpSession.UserId.Value); // break; // case ReportWay.收到的: // ret = ret.Where(ite => ite.ReportAudits.Contains(userguid)); // break; // } //} if (input.ReportType.HasValue) { ret = ret.Where(ite => ite.ReportType == input.ReportType.Value); } if (string.IsNullOrWhiteSpace(input.Key) == false) { ret = ret.Where(ite => ite.Title.Contains(input.Key)); } var total = ret.Count(); var model = ret.OrderByDescending(ite => ite.CreationTime).PageBy(input).ToList().MapTo <List <OAReportListDto> >(); foreach (var item in model) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item as BusinessWorkFlowListOutput); } return(new PagedResultDto <OAReportListDto>(total, model)); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <CWGLWagePayListOutputDto> > GetList(GetCWGLWagePayListInput input) { var query = from a in _repository.GetAll().Where(x => !x.IsDeleted) let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value) select c) select new CWGLWagePayListOutputDto() { Id = a.Id, WageDate = a.WageDate, DoTime = a.DoTime, CreationTime = a.CreationTime, Status = a.Status, OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0)) > 0 ? 1 : 2 }; var toalCount = await query.CountAsync(); var ret = await query.OrderBy(r => r.OpenModel).ThenByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); foreach (var item in ret) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); } return(new PagedResultDto <CWGLWagePayListOutputDto>(toalCount, ret)); }
public async Task <PagedResultDto <ArchivesManagerListOutputDto> > GetArchivesManagers(GetArchivesManagerListInput input) { var query = from a in _archivesManagerRepository.GetAll() //join file in _archivesFileRepository.GetAll() on a.Id equals file.ArchivesId into g join project in _projectBaseRepository.GetAll() on a.ProjectId equals project.Id into p from pro in p.DefaultIfEmpty() let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value) select c) select new ArchivesManagerListOutputDto { Id = a.Id, ArchivesName = a.ArchivesName, ArchivesType = a.ArchivesType, SecrecyLevel = a.SecrecyLevel, ProjectName = pro == null ? "" : pro.ProjectName, ProjectCode = pro == null ? "" : pro.ProjectCode, SingleProjectName = pro == null ? "" : pro.SingleProjectName, SingleProjectCode = pro == null ? "" : pro.SingleProjectCode, CreationTime = a.CreationTime, Status = a.Status, CreatorUserId = a.CreatorUserId, ProjectId = a.ProjectId, OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0)) > 0 ? 1 : 2 }; if (!string.IsNullOrWhiteSpace(input.SearchKey)) { query = query.Where(r => r.ProjectName.Contains(input.SearchKey) || r.ArchivesName.Contains(input.SearchKey)); } if (input.ArchivesManagerType.HasValue) { query = query.Where(r => r.ArchivesType == input.ArchivesManagerType); } if (input.startDate.HasValue) { query = query.Where(r => r.CreationTime >= input.startDate.Value); } if (input.endDate.HasValue) { query = query.Where(r => r.CreationTime <= input.endDate.Value); } var count = await query.CountAsync(); var archivesManagers = await query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); foreach (var r in archivesManagers) { r.InstanceId = r.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, r as BusinessWorkFlowListOutput); } return(new PagedResultDto <ArchivesManagerListOutputDto>(count, archivesManagers)); }
/// <summary> /// 行政获取报废申请列表 /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultDto <SupplyScrapSubDto> > GetSub(PageSubDto input) { var strflowid = input.FlowId.ToString(); var query = from a in _supplyScrapSubRepository.GetAll() join b in _supplyBaseRepository.GetAll() on a.SupplyId equals b.Id join u in _userRepository.GetAll() on a.CreatorUserId equals u.Id let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value && x.Type != 6 && strflowid.GetFlowContainHideTask(x.Status)) select c).Any() select new SupplyScrapSubDto() { Code = b.Code, CreationTime = a.CreationTime, ExpiryDate = b.ExpiryDate, ProductDate = b.CreationTime, Id = a.Id, MainId = a.MainId, Money = b.Money, Name = b.Name, Status = a.Status, SupplyId = a.SupplyId, Type = b.Type, TypeName = ((SupplyType)b.Type).ToString(), UserId = a.CreatorUserId.Value, UserId_Name = u.Name, Version = b.Version, Reason = a.Reason, OpenModel = openModel ? 1 : 2, }; var count = await query.CountAsync(); var model = await query.OrderBy(ite => ite.OpenModel).ThenByDescending(ite => ite.CreationTime).PageBy(input).ToListAsync(); var retdata = new List <SupplyScrapSubDto>(); foreach (var item in model) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item as SupplyScrapSubDto); retdata.Add(item); } return(new PagedResultDto <SupplyScrapSubDto>(count, retdata)); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <CWGLBorrowMoneyListOutputDto> > GetList(GetCWGLBorrowMoneyListInput input) { var strflowid = input.FlowId.ToString(); var queryBase = _repository.GetAll().Where(x => !x.IsDeleted); if (input.GetMy) { queryBase = queryBase.Where(r => r.CreatorUserId == AbpSession.UserId.Value); } else { queryBase = queryBase.Where(a => a.CreatorUserId.Value == AbpSession.UserId.Value || a.DealWithUsers.GetStrContainsArray(AbpSession.UserId.HasValue ? AbpSession.UserId.Value.ToString() : "")); } var query = (from a in queryBase join b in _usersRepository.GetAll() on a.UserId equals b.Id let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value && x.Type != 6 && strflowid.GetFlowContainHideTask(x.Status)) select c).Any() select new CWGLBorrowMoneyListOutputDto { Id = a.Id, UserName = b.Name, CreationTime = a.CreationTime, Money = a.Money, Status = a.Status, OrgId = a.OrgId, IsPayBack = a.IsPayBack, TypeId = a.TypeId, OpenModel = openModel ? 1 : 2, }); var toalCount = await query.CountAsync(); var models = await query.OrderBy(r => r.OpenModel).ThenByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); List <CWGLBorrowMoneyListOutputDto> ret = null; using (_unitOfWorkManager.Current.DisableFilter(AbpDataFilters.SoftDelete)) { if (models.Count > 0) { ret = new List <CWGLBorrowMoneyListOutputDto>(); foreach (var tmp in models) { var orgModel = await _organizationUnitRepository.GetAsync(tmp.OrgId); tmp.DepartmentName = orgModel.DisplayName; tmp.InstanceId = tmp.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, tmp as BusinessWorkFlowListOutput); ret.Add(tmp); } } } return(new PagedResultDto <CWGLBorrowMoneyListOutputDto>(toalCount, ret)); }
/// <summary> /// 获取档案借阅记录 /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultDto <DocmentBorrowListDto> > GetAll(DocmentBorrowSearchInput input) { var query = from a in _docmentBorrowRepository.GetAll() join b in _userRepository.GetAll() on a.CreatorUserId equals b.Id join c in _userOrganizationUnitsRepository.GetAll() on new { UserId = a.CreatorUserId.GetValueOrDefault(), IsMain = true } equals new { UserId = c.UserId, IsMain = c.IsMain } join d in _orgRepository.GetAll() on c.OrganizationUnitId equals d.Id where a.CreatorUserId == AbpSession.UserId.Value || a.DealWithUsers.GetStrContainsArray(AbpSession.UserId.HasValue ? AbpSession.UserId.Value.ToString() : "") //只查看我申请的和参与的 let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value) select c) select new DocmentBorrowListDto() { CreationTime = a.CreationTime, Id = a.Id, UserId = a.CreatorUserId, UserId_Name = b.Name, OrgId = c.OrganizationUnitId, OrgName = d.DisplayName, Status = a.Status, Count = a.Count.Value, BackTime = a.BackTime, Des = a.Des, OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0 || y.Status == -1)) > 0 ? 1 : 2 }; if (input.OrgId.HasValue) { query = query.Where(ite => ite.OrgId == input.OrgId); } if (input.UserId.HasValue) { query = query.Where(ite => ite.UserId == input.UserId.Value); } if (string.IsNullOrWhiteSpace(input.SearchKey) == false) { query = query.Where(ite => ite.OrgName.Contains(input.SearchKey) || ite.UserId_Name.Contains(input.SearchKey)); } var count = query.Count(); var ret = (await query.OrderByDescending(r => r.CreationTime).PageBy(input).ToListAsync()).MapTo <List <DocmentBorrowListDto> >(); foreach (var r in ret) { r.InstanceId = r.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, r as BusinessWorkFlowListOutput); if (r.UserId.HasValue) { var u = _userRepository.Get(r.UserId.Value); r.UserId_Name = u.Name; } } return(new PagedResultDto <DocmentBorrowListDto>(count, ret)); }
/// <summary> /// 档案移交申请记录 /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultDto <DocmentMoveListDto> > GetAll(DocmentMoveSearchDto input) { var query = from a in _docmentMoveRepository.GetAll() join c in _docmentRepository.GetAll() on a.DocmentId equals c.Id join b in _abpDictionaryRepository.GetAll() on c.Type equals b.Id let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value) select c) select new DocmentMoveListDto() { CreationTime = a.CreationTime, Attr = c.Attr, Attr_Name = c.Attr.ToString(), Id = a.Id, Location = c.Location, Name = c.Name, No = c.No, Type = c.Type, Type_Name = b.Title, UserId = a.CreatorUserId, Status = a.Status, DocmentId = a.DocmentId, Des = a.Des, OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0)) > 0 ? 1 : 2 }; if (string.IsNullOrWhiteSpace(input.SearchKey) == false) { query = query.Where(ite => ite.Name.Contains(input.SearchKey) || ite.No.Contains(input.SearchKey)); } if (input.Status.HasValue) { query = query.Where(ite => ite.Status == (int)input.Status); } var count = query.Count(); var ret = (await query.OrderByDescending(r => r.CreationTime).PageBy(input).ToListAsync()).MapTo <List <DocmentMoveListDto> >(); foreach (var r in ret) { r.InstanceId = r.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, r as BusinessWorkFlowListOutput); if (r.UserId.HasValue) { var u = _userRepository.Get(r.UserId.Value); r.UserId_Name = u.Name; } } return(new PagedResultDto <DocmentMoveListDto>(count, ret)); }
public async Task <PagedResultDto <OAFixedAssetsUseApplyListDto> > GetAll(GetOAFixedAssetsUseApplyListInput input) { var currentUserId = AbpSession.UserId.Value; var query = from m in _oAFixedAssetsUseApplyRepository.GetAll() join a in _oAFixedAssetsRepository.GetAll() on m.FAId equals a.Id where m.CreatorUserId == AbpSession.UserId.Value select new OAFixedAssetsUseApplyListDto { ApplyDate = m.ApplyDate, Code = m.Code, FAName = a.Name, Id = m.Id, Reason = m.Reason, Status = m.Status, CreationTime = m.CreationTime, }; if (!input.SearchKey.IsNullOrWhiteSpace()) { query = query.Where(r => r.Code.Contains(input.SearchKey)); } var searchIds = new List <int>(); //if (!input.Status.IsNullOrWhiteSpace()) //{ // if (input.Status.Contains("1")) // searchIds.Add((int)); // if (input.Status.Contains("2")) // searchIds.Add(1); // if (input.Status.Contains("3")) // searchIds.Add(2); // if (searchIds.Count > 0) // query = query.Where(r => searchIds.Contains(r.Status)); //} var count = await query.CountAsync(); var oAFixedAssetsUseApplys = await query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); var oAFixedAssetsUseApplyDtos = oAFixedAssetsUseApplys.MapTo <List <OAFixedAssetsUseApplyListDto> >(); foreach (var item in oAFixedAssetsUseApplyDtos) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item as BusinessWorkFlowListOutput); } return(new PagedResultDto <OAFixedAssetsUseApplyListDto>(count, oAFixedAssetsUseApplyDtos)); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <EmployeeAdjustPostListOutputDto> > GetList(GetEmployeeAdjustPostListInput input) { //var user = await base.GetCurrentUserAsync(); var query = from a in _repository.GetAll() join b in _organizeRepository.GetAll() on a.OriginalDepId equals b.Id join c in _organizeRepository.GetAll() on a.AdjustDepId equals c.Id join d in _postRepository.GetAll() on a.OriginalPostId equals d.Id join e in _organizationUnitPostsRepository.GetAll() on a.AdjustPostId equals e.Id join f in _postRepository.GetAll() on e.PostId equals f.Id join g in _usersRepository.GetAll() on a.CreatorUserId equals g.Id let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value) select c) select new EmployeeAdjustPostListOutputDto() { AdjustDepId = a.AdjustDepId, CreatorUserId = a.CreatorUserId, AdjustDepName = c.DisplayName, AdjustPostId = a.AdjustPostId, AdjustPostName = f.Name, CreationTime = a.CreationTime, DepartmentName = b.DisplayName, Id = a.Id, Status = a.Status.HasValue?a.Status.Value:0, PostName = d.Name, Remark = a.Remark, UserName = g.Name, WorkNumber = g.WorkNumber, OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0)) > 0 ? 1 : 2 }; if (input.ShowMyCase == 0) { query = query.Where(ite => ite.CreatorUserId == AbpSession.UserId.Value); } var toalCount = await query.CountAsync(); var ret = await query.OrderByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); foreach (var item in ret) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); } return(new PagedResultDto <EmployeeAdjustPostListOutputDto>(toalCount, ret)); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <CWGLReceivableListOutputDto> > GetList(GetCWGLReceivableListInput input) { var strflowid = input.FlowId.ToString(); var queryBase = _repository.GetAll().Where(x => !x.IsDeleted); if (input.GetMy) { queryBase = queryBase.Where(r => r.CreatorUserId == AbpSession.UserId.Value); } else { queryBase = queryBase.Where(a => a.CreatorUserId.Value == AbpSession.UserId.Value || a.DealWithUsers.GetStrContainsArray(AbpSession.UserId.HasValue ? AbpSession.UserId.Value.ToString() : "")); } if (!string.IsNullOrEmpty(input.SearchKey)) { queryBase = queryBase.Where(r => r.UserName.Contains(input.SearchKey) || r.Name.Contains(input.SearchKey)); } var query = from a in queryBase let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value && x.Type != 6 && strflowid.GetFlowContainHideTask(x.Status)) select c).Any() select new CWGLReceivableListOutputDto() { Id = a.Id, UserName = a.UserName, Name = a.Name, Money = a.Money, Mode = a.Mode, BankName = a.BankName, CardNumber = a.CardNumber, BankOpenName = a.BankOpenName, Note = a.Note, Nummber = a.Nummber, CreationTime = a.CreationTime, Status = a.Status , OpenModel = openModel ? 1 : 2, }; var toalCount = await query.CountAsync(); var ret = await query.OrderByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); foreach (var item in ret) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); } return(new PagedResultDto <CWGLReceivableListOutputDto>(toalCount, ret)); }
/// <summary> /// 获取预约面试列表 /// </summary> /// <param name="input"></param> public async Task <PagedResultDto <EmployeePlanListDto> > GetList(EmployeePlanSearchInput input) { var ret = (from a in _repository.GetAll() join b in _postrepository.GetAll() on a.ApplyPostId equals b.Id let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value) select c) select new EmployeePlanListDto() { ApplyJob = b.Name, ApplyNo = a.ApplyNo, ApplyUser = a.ApplyUser, CreationTime = a.CreationTime, Id = a.Id, Phone = a.Phone, ApplyPostId = a.ApplyPostId, Status = a.Status, OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0)) > 0 ? 1 : 2 }); if (input.Status == 0) { ret = ret.Where(ite => ite.Status == 0); } else { ret = ret.Where(ite => ite.Status > 0); } if (string.IsNullOrWhiteSpace(input.SearchKey) == false) { ret = ret.Where(ite => ite.ApplyUser.Contains(input.SearchKey) || ite.ApplyJob.Contains(input.SearchKey) || ite.Phone.Contains(input.SearchKey)); } var total = ret.Count(); var model = (await ret.OrderByDescending(ite => ite.CreationTime).PageBy(input).ToListAsync()).MapTo <List <EmployeePlanListDto> >(); foreach (var item in model) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); item.FileList = await _abpFileRelationAppService.GetListAsync(new GetAbpFilesInput() { BusinessId = item.InstanceId, BusinessType = (int)AbpFileBusinessType.人力资源面试者简历 }); } return(new PagedResultDto <EmployeePlanListDto>(total, model)); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <CWGLPayMoneyListOutputDto> > GetList(GetCWGLPayMoneyListInput input) { var strflowid = input.FlowId.ToString(); var queryBase = _repository.GetAll().Where(x => !x.IsDeleted); if (input.GetMy) { queryBase = queryBase.Where(r => r.CreatorUserId == AbpSession.UserId.Value); } else { queryBase = queryBase.Where(a => a.CreatorUserId.Value == AbpSession.UserId.Value || a.DealWithUsers.GetStrContainsArray(AbpSession.UserId.HasValue ? AbpSession.UserId.Value.ToString() : "")); } var query = (from a in queryBase let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value && x.Type != 6 && strflowid.GetFlowContainHideTask(x.Status)) select c).Any() select new CWGLPayMoneyListOutputDto { Id = a.Id, CreationTime = a.CreationTime, Money = a.Money, UserName = a.UserName, CustomerName = a.CustomerName, Status = a.Status ?? 0, OpenModel = openModel ? 1 : 2, }); var toalCount = await query.CountAsync(); var models = await query.OrderBy(r => r.OpenModel).ThenByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); List <CWGLPayMoneyListOutputDto> ret = null; if (models.Count > 0) { ret = new List <CWGLPayMoneyListOutputDto>(); foreach (var tmp in models) { tmp.InstanceId = tmp.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, tmp as BusinessWorkFlowListOutput); ret.Add(tmp); } } return(new PagedResultDto <CWGLPayMoneyListOutputDto>(toalCount, ret)); }
public PagedResultDto <OAPayListDto> GetAll(WorkFlowPagedAndSortedInputDto input) { var ret = _oaPayRepository.GetAll().Where(ite => ite.CreatorUserId == AbpSession.UserId.Value); if (string.IsNullOrWhiteSpace(input.SearchKey) == false) { ret = ret.Where(ite => ite.Title.Contains(input.SearchKey)); } var total = ret.Count(); var model = ret.OrderByDescending(ite => ite.CreationTime).PageBy(input).ToList().MapTo <List <OAPayListDto> >(); foreach (var item in model) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item as BusinessWorkFlowListOutput); } return(new PagedResultDto <OAPayListDto>(total, model)); }
public async Task <PagedResultDto <CuringProcurementListOutputDto> > GetList(GetCuringProcurementListInput input) { var query = from a in _repository.GetAll().Where(x => !x.IsDeleted) let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value) select c) select new CuringProcurementListOutputDto() { Id = a.Id, Code = a.Code, NeedMember = a.NeedMember, Type = a.Type, ExecuteSummary = a.ExecuteSummary, Remark = a.Remark, Status = a.Status, CreationTime = a.CreationTime, OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0)) > 0 ? 1 : 2 }; if (!input.SearchKey.IsNullOrWhiteSpace()) { query = query.Where(r => r.Code.Contains(input.SearchKey)); } if (!input.Status.IsNullOrWhiteSpace()) { var statusArry = input.Status.Split(','); query = query.Where(r => statusArry.Contains(r.Status.ToString())); } var toalCount = await query.CountAsync(); var ret = await query.OrderBy(r => r.OpenModel).ThenByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); foreach (var item in ret) { //item.TypeName = ((SupplyType)item.Type.ToInt()).ToString(); item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item as BusinessWorkFlowListOutput); } return(new PagedResultDto <CuringProcurementListOutputDto>(toalCount, ret)); }
public async Task <PagedResultDto <OAProgressFundDeclareListDto> > GetAll(GetOAProgressFundDeclareListInput input) { var currentUserId = AbpSession.UserId.Value; var query = from m in _oAProgressFundDeclareRepository.GetAll() join u in UserManager.Users on m.WriteUser equals u.Id where m.CreatorUserId == AbpSession.UserId.Value select new OAProgressFundDeclareListDto() { Id = m.Id, Name = m.Name, ProjectName = m.ProjectName, WriteUser = m.WriteUser, WriteUserName = u.Name, WriteData = m.WriteData, ContractName = m.ContractName, UnitA = m.UnitA, Amount = m.Amount, CreationTime = m.CreationTime, Status = m.Status, }; if (!input.SearchKey.IsNullOrWhiteSpace()) { query = query.Where(r => r.Name.Contains(input.SearchKey)); } query = query.WhereIf(!input.Status.IsNullOrWhiteSpace(), r => input.Status.Contains(r.Status.ToString())); var count = await query.CountAsync(); var oAProgressFundDeclares = await query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); var oAProgressFundDeclareDtos = oAProgressFundDeclares.MapTo <List <OAProgressFundDeclareListDto> >(); foreach (var item in oAProgressFundDeclareDtos) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item as BusinessWorkFlowListOutput); } return(new PagedResultDto <OAProgressFundDeclareListDto>(count, oAProgressFundDeclareDtos)); }
/// <summary> /// 根据主键获取实体 /// </summary> /// <param name="input">主键</param> /// <returns></returns> public async Task <TaskManagementRelationOutputDto> Get(GetTaskManagementRelationInput input) { var models = _repository.GetAll().Where(x => x.FlowId == input.FlowId && x.TaskManagementId == input.RelationTaskId).Select(x => x.InStanceId).ToList(); if (models == null) { return(null); } var currentwfInstallModel = _workFlowCacheManager.GetWorkFlowModelFromCache(input.FlowId); if (currentwfInstallModel.TitleField != null && !currentwfInstallModel.TitleField.Table.IsNullOrEmpty() && !currentwfInstallModel.TitleField.Field.IsNullOrEmpty() && currentwfInstallModel.DataBases.Any()) { var firstDB = currentwfInstallModel.DataBases.First(); try { var indata = ""; foreach (var item in models) { indata += "'" + item + "',"; } var query_Sql = $"select top 1 Id,Status from {currentwfInstallModel.TitleField.Table} where {firstDB.PrimaryKey} in ({indata.TrimEnd(',')}) order by CreationTime desc"; var dynamicModel = _dynamicRepository.QueryFirst(query_Sql); if (dynamicModel != null) { var model = new TaskManagementRelationOutputDto(); model.InstanceId = Convert.ToString(dynamicModel.Id); model.Status = dynamicModel.Status; _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, model); return(model); } } catch (Exception e) { } } return(null); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <CWGLoanListOutputDto> > GetList(GetCWGLoanListInput input) { var query = from a in _repository.GetAll().Where(x => !x.IsDeleted) select new CWGLoanListOutputDto() { Id = a.Id, Money = a.Money, Remark = a.Remark, Status = a.Status, CreationTime = a.CreationTime }; var toalCount = await query.CountAsync(); var ret = await query.OrderByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); foreach (var item in ret) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); } return(new PagedResultDto <CWGLoanListOutputDto>(toalCount, ret)); }
public async Task <PagedResultDto <OABidFilePurchaseListDto> > GetAll(GetOABidFilePurchaseListInput input) { var currentUserId = AbpSession.UserId.Value; var query = from m in _oABidFilePurchaseRepository.GetAll() join p in _oABidProjectRepository.GetAll() on m.ProjectId equals p.Id into g from pro in g.DefaultIfEmpty() where m.CreatorUserId == AbpSession.UserId.Value select new OABidFilePurchaseListDto() { Amount = m.Amount, ApplyDate = m.ApplyDate, Code = m.Code, Id = m.Id, ProjectCode = pro.ProjectCode, ProjectName = pro.ProjectName, Status = m.Status, CreationTime = m.CreationTime }; if (!input.SearchKey.IsNullOrWhiteSpace()) { query = query.Where(r => r.Code.Contains(input.SearchKey)); } query = query.WhereIf(!input.Status.IsNullOrWhiteSpace(), r => input.Status.Contains(r.Status.ToString())); var count = await query.CountAsync(); var oABidFilePurchases = await query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); var oABidFilePurchaseDtos = oABidFilePurchases.MapTo <List <OABidFilePurchaseListDto> >(); foreach (var item in oABidFilePurchaseDtos) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item as BusinessWorkFlowListOutput); } return(new PagedResultDto <OABidFilePurchaseListDto>(count, oABidFilePurchaseDtos)); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <EmployeeReceiptV2ListOutputDto> > GetList(GetEmployeeReceiptV2ListInput input) { var query = from a in _repository.GetAll().Where(x => !x.IsDeleted).WhereIf(!input.PostName.IsNullOrEmpty(), x => x.PostName.Contains(input.PostName)).WhereIf(!input.SearchKey.IsNullOrEmpty(), x => x.PostName.Contains(input.SearchKey) || x.Number.Contains(input.SearchKey) || x.Remark.Contains(input.SearchKey)) let openModel = (from b in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value) select b) select new EmployeeReceiptV2ListOutputDto() { Id = a.Id, CreationTime = a.CreationTime, DepartmentId = a.DepartmentId, PostName = a.PostName, Number = a.Number, Address = a.Address, PostDemand = a.PostDemand, DemandGrade = a.DemandGrade, PostDemandName = a.PostDemandName, DemandGradeName = a.DemandGradeName, Sex = a.Sex, Age = a.Age, Status = a.Status, Education = a.Education, EducationName = a.EducationName, ProfessionalRequirements = a.ProfessionalRequirements, SkillRequirement = a.SkillRequirement, CertificateRequirements = a.CertificateRequirements, OtherRequirements = a.OtherRequirements, OperatingDuty = a.OperatingDuty, SalaryProposal = a.SalaryProposal, Remark = a.Remark, DepartmentName = a.DepartmentName, OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0)) > 0 ? 1 : 2, }; var toalCount = query.Count(); var ret = await query.OrderByDescending(r => r.CreationTime).PageBy(input).ToListAsync(); foreach (var item in ret) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); } return(new PagedResultDto <EmployeeReceiptV2ListOutputDto>(toalCount, ret)); }
public async Task <PagedResultDto <OAFixedAssetsReturnListDto> > GetAll(GetOAFixedAssetsReturnListInput input) { var currentUserId = AbpSession.UserId.Value; var query = from m in _oAFixedAssetsReturnRepository.GetAll() join a in _oAFixedAssetsRepository.GetAll() on m.FAId equals a.Id where m.Status > 0 select new OAFixedAssetsReturnListDto { Code = m.Code, FAName = a.Name, Id = m.Id, Remark = m.Remark, ReturnDate = m.ReturnDate, Status = m.Status, CreationTime = m.CreationTime }; if (!input.SearchKey.IsNullOrWhiteSpace()) { query = query.Where(r => r.Code.Contains(input.SearchKey)); } query = query.WhereIf(!input.Status.IsNullOrWhiteSpace(), r => input.Status.Contains(r.Status.ToString())); var count = await query.CountAsync(); var oAFixedAssetsReturns = await query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); var oAFixedAssetsReturnDtos = oAFixedAssetsReturns.MapTo <List <OAFixedAssetsReturnListDto> >(); foreach (var item in oAFixedAssetsReturnDtos) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item as BusinessWorkFlowListOutput); } return(new PagedResultDto <OAFixedAssetsReturnListDto>(count, oAFixedAssetsReturnDtos)); }
/// <summary> /// 根据条件分页获取列表 /// </summary> /// <param name="page">查询实体</param> /// <returns></returns> public async Task <PagedResultDto <CWGLAdvanceChargeListOutputDto> > GetList(GetCWGLAdvanceChargeListInput input) { var strflowid = input.FlowId.ToString(); var query = from a in _repository.GetAll().Where(x => !x.IsDeleted) let m = (from b in _advanceChargeDetailRepository.GetAll().Where(x => x.AdvanceChargeId == a.Id) select b).Sum(x => x.Money) let openModel = (from c in _workFlowTaskRepository.GetAll().Where(x => x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() && x.ReceiveID == AbpSession.UserId.Value && x.Type != 6 && strflowid.GetFlowContainHideTask(x.Status)) select c).Any() select new CWGLAdvanceChargeListOutputDto() { Id = a.Id, CreationTime = a.CreationTime, Name = a.Name, Cause = a.Cause, Status = a.Status, Money = a.Money, SettleState = a.SettleState, CreatorUserId = a.CreatorUserId, AdvanceChargeMoney = m, SettleState_Name = Enum.GetName(typeof(SettleState), a.SettleState), OpenModel = openModel ? 1 : 2, }; var toalCount = await query.CountAsync(); var ret = await query.OrderBy(x => x.OpenModel).ThenByDescending(x => x.CreationTime).PageBy(input).ToListAsync(); foreach (var item in ret) { item.InstanceId = item.Id.ToString(); _workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item); if (item.OpenModel == 2 && item.SettleState != 2 && item.CreatorUserId == AbpSession.UserId.Value) { item.OpenModel = 3; } } return(new PagedResultDto <CWGLAdvanceChargeListOutputDto>(toalCount, ret)); }