/// <summary>
/// 根据日期段分页查询记录
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <IActionResult> GetPagedList(GetPagedListInput input)
{
var pagination = new Pagination
{
rows = input.rows,
page = input.page,
sidx = input.orderField ?? "F_ReportDate",
sord = input.orderType
};
var users = _usersService.GetUserNameDict("").Select(t => new
{
id = t.F_Id,
name = t.F_RealName
}).ToList();
var list = (await _infectionApp.GetList(pagination, input.startDate.ToDate(), input.endDate.ToDate()))
.Select(t => new
{
id = t.F_Id,
reportDate = t.F_ReportDate,
item1 = t.F_Item1.ToFloat(2),
item2 = t.F_Item2.ToFloat(2),
item3 = t.F_Item3.ToFloat(2),
item4 = t.F_Item4.ToFloat(2),
item5 = t.F_Item5.ToFloat(2),
item6 = t.F_Item6.ToFloat(2),
item7 = t.F_Item7.ToFloat(2),
recordPerson = t.F_RecordPerson == null ? "" : users.First(u => u.id.Equals(t.F_RecordPerson)).name,
memo = t.F_Memo
});
var source = list.OrderByDescending(t => t.reportDate).Select(t => new
{
t.id,
t.recordPerson,
t.reportDate,
t.item1,
t.item2,
t.item3,
t.item4,
t.item5,
t.item6,
t.item7,
isAbnormal = t.item1 > 4 || t.item2 > 10 || t.item3 > 10 || t.item4 > 100 || t.item5 > 0.25 || t.item6 > 100 || t.item7 > 0.25
}).ToList();
var data = new
{
rows = source,
abnormalCount = source.Count(t => t.isAbnormal == true),
pagination.total,
pagination.page,
pagination.records
};
return(Ok(data));
}
public async Task <IActionResult> GetPagedList(GetPagedListInput input)
{
var pagination = new Pagination
{
rows = input.rows,
page = input.page,
sidx = input.orderField ?? "F_DisinfectDate",
sord = input.orderType
};
var users = _usersService.GetUserNameDict("").Select(t => new
{
id = t.F_Id,
name = t.F_RealName
}).ToList();
var list = (await _waterMDisinfectApp.GetList(pagination, input.startDate.ToDate(), input.endDate.ToDate()))
.Select(t => new
{
id = t.F_Id,
disinfectDate = t.F_DisinfectDate,
disinfectantName = t.F_DisinfectantName,
disinfectantVolume = t.F_DisinfectantVolume,
disinfectantUnit = t.F_DisinfectantUnit,
disinfectType = t.F_DisinfectType,
option1 = t.F_Option1,
recyclingStartTime = t.F_RecyclingStartTime,
recyclingEndTime = t.F_RecyclingEndTime,
recyclingMinutes = t.F_RecyclingMinutes,
soakStartTime = t.F_SoakStartTime,
soakEndTime = t.F_SoakEndTime,
soakMinutes = t.F_SoakMinutes,
rinseStartTime = t.F_RinseStartTime,
rinseEndTime = t.F_RinseEndTime,
rinseMinutes = t.F_RinseMinutes,
option2 = t.F_Option2,
option3 = t.F_Option3,
operatePerson = t.F_OperatePerson == null ? "" : users.First(u => u.id.Equals(t.F_OperatePerson)).name,
checkPerson = t.F_CheckPerson == null ? "" : users.First(u => u.id.Equals(t.F_CheckPerson)).name
});
var data = new
{
rows = list,
pagination.total,
pagination.page,
pagination.records
};
return(Ok(data));
}
