/// <summary>
/// 返回工单列表 非管理员
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public PagedResultDto <WorkOrderListDto> GetStaffList(GetListInput input)
{
var query = _workOrderRepository
.GetAll()
//接单人过滤
.Where(e => e.AssignedPersonId == AbpSession.UserId)
//搜索条件
.WhereIf(!string.IsNullOrEmpty(input.KeyWord),
e => (e.Customer.Name.Contains(input.KeyWord) ||
e.Product.Name.Contains(input.KeyWord) ||
e.Number.Contains(input.KeyWord)
)
)
//待处理
.WhereIf(input.QueryType.Equals(WorkOrderListType.Undo),
e => e.BillStatus == BillStatus.Dispatch
//|| e.BillStatus == BillStatus.Complete
)
//已处理
.WhereIf(input.QueryType.Equals(WorkOrderListType.Done),
e => e.BillStatus == BillStatus.Complete ||
e.BillStatus == BillStatus.ReturnVisit ||
e.BillStatus == BillStatus.Close);
var recordCount = query.Count();
var list = query.OrderByDescending(e => e.DispatchTime)
.PageBy(input)
.ToList();
var billList = list.MapTo <List <WorkOrderListDto> >();
return(new PagedResultDto <WorkOrderListDto>(recordCount, billList));
}
/// <summary>
///
/// </summary>
/// <param name="ownerId"></param>
/// <param name="ownerType"></param>
/// <returns></returns>
//[HttpGet, Route("")]
public async Task <List <NoteDto> > GetListAsync(GetListInput input)
{
var notes = await Repository.GetAll()
.Where(c => c.OwnerId == input.OwnerId && c.OwnerType == input.OwnerType && (input.AllCategories || c.Category == input.Category))
.OrderBy(c => c.CreationTime)
.ToListAsync();
return(notes.Select(c => ObjectMapper.Map <NoteDto>(c)).ToList());
}
public GetListOutput GetList(GetListInput input)
{
try
{
Expression <Func <GameEntity, bool> > expression = Spec.Specification <GameEntity> .Eval(x => x.Id > 0).Expression;
if (!string.IsNullOrEmpty(input.GameName))
{
expression = Spec.SpecExprExtensions.And(expression, x => x.GameName.IndexOf(input.GameName) >= 0);
}
if (!string.IsNullOrEmpty(input.GameType))
{
expression = Spec.SpecExprExtensions.And(expression, x => x.GameName.IndexOf(input.GameType) >= 0);
}
Spec.ExpressionSpecification <GameEntity> spec = new Spec.ExpressionSpecification <GameEntity>(expression);
var list = _gameRepository.GetAll(
spec,
x => x.Id,
Infrastructure.Utils.SortOrder.Descending,
input.PageIndex,
input.PageSize
);
return(new GetListOutput()
{
IsSuccess = true,
Games = list.PageData,
ErrMessage = ""
});
}
catch (Exception ex)
{
return(new GetListOutput()
{
IsSuccess = false,
Games = new List <GameEntity>(),
ErrMessage = ex.Message
});
}
}
public async Task<PagedResultDto<SupplyRepairDto>> GetMy(GetListInput input)
{
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
where a.CreatorUserId == AbpSession.UserId.Value
select new SupplyRepairDto()
{
Code = c.Code,
Des = a.Des,
Type = c.Type,
TypeName = ((SupplyType)c.Type).ToString(),
Id = a.Id,
IsImportant = a.IsImportant,
Name = c.Name,
RepairEndTime = a.RepairEndTime,
SupplyId = a.SupplyId,
UserId = a.CreatorUserId.Value,
UserId_Name = b.Name,
Version = c.Version,
CreationTime = a.CreationTime,
Money = c.Money,
Status = a.Status,
StatusTitle = ((SupplyRepairStatus)a.Status).ToString()
};
if (string.IsNullOrWhiteSpace(input.SearchKey) == false)
{
query = query.Where(ite => ite.Name.Contains(input.SearchKey) || ite.UserId_Name.Contains(input.SearchKey));
}
var total = await query.CountAsync();
var model = await query.OrderByDescending(ite => ite.IsImportant).ThenByDescending(ite => ite.CreationTime).PageBy(input).ToListAsync();
foreach (var i in model)
{
i.FileList = await _abpFileRelationAppService.GetListAsync(new GetAbpFilesInput() { BusinessId = i.Id.ToString(), BusinessType = (int)AbpFileBusinessType.申请用品维修附件 });
i.InstanceId = i.Id.ToString();
_workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, i as BusinessWorkFlowListOutput);
}
return new PagedResultDto<SupplyRepairDto>(total, model);
}
/// <summary>
/// 获取我申请的报废记录
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <PagedResultDto <SupplyScrapMainDto> > GetAll(GetListInput input)
{
var query = from a in _supplyScrapMainRepository.GetAll()
join b in _userRepository.GetAll() on a.CreatorUserId equals b.Id
let openModel = (from c in _workFlowTaskRepository2.GetAll().Where(x =>
x.FlowID == input.FlowId && x.InstanceID == a.Id.ToString() &&
x.ReceiveID == AbpSession.UserId.Value)
select c)
//join sub in _supplyScrapSubRepository.GetAll() on a.Id equals sub.MainId into subs
where a.CreatorUserId == AbpSession.UserId.Value
select new
{
Id = a.Id,
CreationTime = a.CreationTime,
UserId = a.CreatorUserId.Value,
Status = a.Status,
//SupplyBackSub = subs,
UserId_Name = b.Name,
OpenModel = openModel.Count(y => y.Type != 6 && (y.Status == 1 || y.Status == 0)) > 0
? 1
: 2
};
query = query.WhereIf(!input.Status.IsNullOrWhiteSpace(), r => input.Status.Contains(r.Status.ToString()));
var count = await query.CountAsync();
var model = await query.OrderByDescending(ite => ite.CreationTime).OrderBy(ite => ite.OpenModel).PageBy(input).ToListAsync();
var ret = new List <SupplyScrapMainDto>();
foreach (var r in model)
{
var item = new SupplyScrapMainDto()
{
Id = r.Id,
UserId_Name = r.UserId_Name,
CreationTime = r.CreationTime,
UserId = r.UserId,
Status = r.Status,
OpenModel = r.OpenModel,
};
item.InstanceId = r.Id.ToString();
item.SupplyScrapSub = new List <SupplyScrapSubDto>();
_workFlowBusinessTaskManager.SupplementWorkFlowBusinessList(input.FlowId, item as BusinessWorkFlowListOutput);
var querysub = (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
where a.MainId == r.Id
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,
StatusTitle = ((SupplyScrapSubStatus)a.Status).ToString(),
Reason = a.Reason,
}).ToList();
item.SupplyScrapSub = querysub;
ret.Add(item);
}
return(new PagedResultDto <SupplyScrapMainDto>(count, ret));
}
public Task <PagedResultDto <CommentDto> > GetListAsync(GetListInput input)
{
return(_service.GetListAsync(input));
}
public async Task <IList <BusWithDetailsDto> > GetListWithDetailsAsync(GetListInput input)
{
var buses = await _busRepository.GetListWithDetailsAsync(input.CompanyId, input.Filter);
return(ObjectMapper.Map <IList <Bus>, IList <BusWithDetailsDto> >(buses));
}
public virtual Task <PagedResultDto <DynamicEntityDto> > GetListAsync(GetListInput input)
{
return(_service.GetListAsync(input));
}
public IActionResult GetList(GetListInput input)
{
var list = _patVisitApp.GetList(input.visitDate, input.visitNo).ToList();
if (!string.IsNullOrEmpty(input.bedNo))
{
list = list.Where(t => t.F_DialysisBedNo.Equals(input.bedNo)).ToList();
}
var groups = (input.groupNames + "").Split(',');
list = list.Where(t => groups.Contains(t.F_GroupName))
.Where(t => t.F_DialysisStartTime != null && t.F_DialysisEndTime != null)
.ToList();
var target = _machineDisinfectionApp.GetListByDate(input.visitDate, input.visitDate)
.Select(t => new
{
t.F_Id,
t.F_Vid,
t.F_StartTime,
t.F_EndTime,
t.F_Option1,
t.F_Option1Value,
t.F_Option2,
t.F_Option2Value,
t.F_Option3,
t.F_Option4,
t.F_Option5,
t.F_OperatePerson,
t.F_WipeStartTime,
t.F_WipeEndTime,
t.F_Option6,
t.F_Option6Value,
t.F_CheckPerson
});
var output = new GetListOutput();
//保存操作用户字典
//Hashtable table = new Hashtable();
var users = _usersService.GetUserNameDict("").Select(t => new
{
id = t.F_Id,
name = t.F_RealName
}).ToList();
foreach (var item in list)
{
DisinfectionInfo disinfection = new DisinfectionInfo
{
vId = item.F_Id,
groupName = item.F_GroupName,
bedNo = item.F_DialysisBedNo,
visitNo = item.F_VisitNo.ToInt(),
patientName = item.F_Name,
dialysisStartTime = item.F_DialysisStartTime,
dialysisEndTime = item.F_DialysisEndTime
};
var find = target.FirstOrDefault(t => t.F_Vid.Equals(item.F_Id));
if (find == null)
{
disinfection.beDisinfected = false;
}
else
{
if (string.IsNullOrEmpty(find.F_OperatePerson) || string.IsNullOrEmpty(find.F_CheckPerson))
{
disinfection.beDisinfected = false;
}
else
{
disinfection.beDisinfected = true;
}
disinfection.StartTime = find.F_StartTime;
disinfection.EndTime = find.F_EndTime;
disinfection.Option1 = find.F_Option1;
disinfection.Option1Value = find.F_Option1Value;
disinfection.Option2 = find.F_Option2;
disinfection.Option2Value = find.F_Option2Value;
disinfection.Option3 = find.F_Option3;
disinfection.Option4 = find.F_Option4;
disinfection.Option5 = find.F_Option5;
disinfection.Option6 = find.F_Option6;
disinfection.Option6Value = find.F_Option6Value;
disinfection.WipeStartTime = find.F_WipeStartTime;
disinfection.WipeEndTime = find.F_WipeEndTime;
disinfection.OperatePerson = find.F_OperatePerson == null ? "" : users.First(t => t.id.Equals(find.F_OperatePerson)).name;
disinfection.CheckPerson = find.F_CheckPerson == null ? "" : users.First(t => t.id.Equals(find.F_CheckPerson)).name;
}
output.items.Add(disinfection);
}
output.bedNo = input.bedNo;
output.groupNames = input.groupNames;
output.visitDate = input.visitDate;
output.visitNo = input.visitNo;
return(Ok(output));
}
public virtual Task <PagedResultDto <FieldDefinitionDto> > GetListAsync(GetListInput input)
{
return(_service.GetListAsync(input));
}
public IActionResult GetList(GetListInput input)
{
var listSource = _billingApp.GetQueryable()
.Where(t => t.F_Pid.Equals(input.patientId))
.Where(t => t.F_BillingDateTime >= input.startDate)
.Where(t => t.F_BillingDateTime <= input.endDate.AddDays(1))
.Where(t => string.IsNullOrEmpty(input.billType) || t.F_ItemClass.Equals(input.billType))
.Where(t => t.F_EnabledMark == true)
.Where(t => t.F_DeleteMark != true)
.Select(t => new
{
t.F_Id,
t.F_BillingDateTime,
t.F_BillingPerson,
t.F_ItemClass,
t.F_ItemCode,
t.F_ItemName,
t.F_ItemSpec,
t.F_ItemUnit,
t.F_Amount,
t.F_Costs
})
.ToList();
var list = listSource.Select(t => new
{
t.F_Id,
F_BillingDate = t.F_BillingDateTime.Date,
t.F_BillingDateTime,
t.F_BillingPerson,
t.F_ItemClass,
t.F_ItemCode,
t.F_ItemName,
t.F_ItemSpec,
t.F_ItemUnit,
F_Amount = t.F_Amount.ToFloat(2),
F_Costs = t.F_Costs.ToFloat(2)
});
//合计费用
var totalCosts = list.Sum(t => t.F_Costs);
//费用日期
var dates = list.Select(t => t.F_BillingDate).Distinct().ToList().OrderByDescending(t => t);
var detail = new List <BillModel>();
foreach (var date in dates)
{
var model = new BillModel
{
billingDate = date
};
var filter = list.Where(t => t.F_BillingDate == date).OrderBy(t => t.F_ItemClass).ThenBy(t => t.F_BillingDateTime).ToList();
foreach (var item in filter)
{
model.items.Add(new BillItem
{
id = item.F_Id,
billingTime = item.F_BillingDateTime,
billingPerson = item.F_BillingPerson,
itemClass = item.F_ItemClass,
itemCode = item.F_ItemCode,
itemName = item.F_ItemName,
itemSpec = item.F_ItemSpec,
itemUnit = item.F_ItemUnit,
amount = item.F_Amount,
costs = item.F_Costs
});
}
model.sum = filter.Sum(t => t.F_Costs);
detail.Add(model);
}
var data = new
{
totalCosts,
rows = detail
};
return(Ok(data));
}
