/// <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));
}
