public List <ExecTaskTable> GetJoinQuery(RequestExecTask task)
{
List <ExecTaskTable> list = _dbcontext.ExecTaskTable.Include(t => t.ListEvent)
.WhereIf(task.TaskStateTableId.HasValue, t => t.TaskStateTableId == task.TaskStateTableId)
.WhereIf(task.UserTableId.HasValue, t => t.UserTableId == task.UserTableId)
.OrderByDescending(t => t.StartTime).ToList();
return(list);
}
public IActionResult SelectCondition([FromBody] RequestExecTask task)
{
try
{
List <ExecTaskTable> list = _repository.GetJoinQuery(task);
return(Json(new
{
table = list,
state = "0",
msg = "获取数据成功"
}, this.GetJsonSetting()));
}
catch (Exception ex)
{
return(Json(new
{
state = "-1",
msg = "获取数据出错",
error = ex.Message
}));
}
}
