public IActionResult AllList(GrabRecordRequestPaload payload)
{
using (_dbContext)
{
var query = from gw in _dbContext.GrabageWeightSon //称重表
join gr in _dbContext.GrabageRoom //箱房表
on gw.GrabageRoomId equals gr.GarbageRoomUuid
join v in _dbContext.Village //社区表
on gr.VillageId equals v.VillageUuid
select new
{
gw.GrabageWeighingRecordUuid,
gw.GrabageRoomId,
gw.AddTime, //收运时间
gw.Type,
State = gr.State == "0" ? "使用中" : gr.State == "1" ? "暂停使用" : "",
v.Vname, //社区名字
v.Towns, //街道名称
gr.Ljname, //垃圾箱房名字
gw.Weight, //称重重量
v.VillageUuid
};
//街道筛选
if (!string.IsNullOrEmpty(payload.street))
{
query = query.Where(x => x.Towns == payload.street);
}
//社区筛选
if (!string.IsNullOrEmpty(payload.ccmmunity))
{
query = query.Where(x => x.Vname == payload.ccmmunity);
}
//社区管理员筛选
if (!string.IsNullOrEmpty(payload.vuuid))
{
query = query.Where(x => x.VillageUuid == Guid.Parse(payload.vuuid));
}
//箱房名字筛选
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.Ljname.ToString().Contains(payload.Kw));
}
//所在社区筛选
if (!string.IsNullOrEmpty(payload.Kw1))
{
query = query.Where(x => x.Vname.ToString().Contains(payload.Kw1));
}
//收运日期筛选
if (!string.IsNullOrEmpty(payload.time[0]))
{
DateTime d1 = DateTime.Parse(payload.time[0]);
DateTime d2 = DateTime.Parse(payload.time[1]);
d2 = d2.AddDays(1);
query = query.Where(x => DateTime.Parse(x.AddTime) >= d1 && DateTime.Parse(x.AddTime) <= d2);
}
if (payload.FirstSort != null)
{
query = query.OrderByDescending(x => x.AddTime);
}
//分页
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult RecordList(GrabRecordRequestPaload payload)
{
using (_dbContext)
{
var query = from dow in _dbContext.DayOfWeight
join gr in _dbContext.GrabageRoom
on dow.GrabageRoomId equals gr.GarbageRoomUuid
join v in _dbContext.Village
on gr.VillageId equals v.VillageUuid
where dow.GrabageRoomId != null
select new
{
GrabageRoomID = dow.GrabageRoomId,
WTime = dow.Wtime,
Proportion = dow.Proportion,
WingID = gr.WingId,
State = gr.State == "0" ? "使用中" : gr.State == "1" ? "暂停使用" : "",
v.Vname,
v.Towns,
gr.Ljname,
v.VillageUuid
};
//街道筛选
if (!string.IsNullOrEmpty(payload.street))
{
query = query.Where(x => x.Towns == payload.street);
}
//社区筛选
if (!string.IsNullOrEmpty(payload.ccmmunity))
{
query = query.Where(x => x.Vname == payload.ccmmunity);
}
//社区管理员筛选
if (!string.IsNullOrEmpty(payload.vuuid))
{
query = query.Where(x => x.VillageUuid == Guid.Parse(payload.vuuid));
}
//箱房名字筛选
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.Ljname.ToString().Contains(payload.Kw));
}
//所在社区筛选
if (!string.IsNullOrEmpty(payload.Kw1))
{
query = query.Where(x => x.Vname.ToString().Contains(payload.Kw1));
}
//收运日期筛选
if (payload.time != null && !string.IsNullOrEmpty(payload.time[0]))
{
DateTime d1 = DateTime.Parse(payload.time[0]);
DateTime d2 = DateTime.Parse(payload.time[1]);
d2 = d2.AddDays(1);
var date1 = Convert.ToDateTime(d1).ToString("yyyy-MM-dd HH:mm:ss");
var date2 = Convert.ToDateTime(d2).ToString("yyyy-MM-dd HH:mm:ss");
query = query.Where(x => x.WTime.CompareTo(date1) >= 0 && x.WTime.CompareTo(date2) <= 0);
}
if (payload.FirstSort != null)
{
query = query.OrderByDescending(x => x.WTime);
}
//分页
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
