/// <summary>
/// 获取相关的任务
/// </summary>
/// <param name="page">分页</param>
/// <param name="taskRequestData">查询的数据</param>
/// <returns></returns>
public async Task <ResponseData> GetTask(Page page, SelectRequestData taskRequestData)
{
//var TaskDataMap = mapper.Map<SelectRequestData>(taskRequestData);
var sql = helperFunction.SqlAssembly(taskRequestData);
var Data = await Db.PageAsync <TaskData>(page.PageNumber, page.PageSize, sql);
return(new ResponseData("查询成功", Data, StatusCode.Success));
}
public Sql SqlAssembly(SelectRequestData taskDataMap)
{
Sql selectSql = new Sql();
selectSql.Append("select * from Tasks where Task_IsExists=1 ");
if (taskDataMap != null)
{
//任务名字不为空
if (!string.IsNullOrEmpty(taskDataMap.Task_Name))
{
selectSql.Append("and Task_Name like @0", "%" + taskDataMap.Task_Name + "%");
}
//任务类型不为空
if (!string.IsNullOrEmpty(taskDataMap.Task_TaskType))
{
selectSql.Append("and Task_TaskType like @0", "%" + taskDataMap.Task_TaskType + "%");
}
//业务类型不为空
if (!string.IsNullOrEmpty(taskDataMap.Task_BusinessType))
{
selectSql.Append("and Task_BusinessType like @0", "%" + taskDataMap.Task_BusinessType + "%");
}
//创建时间不为空
if (!string.IsNullOrEmpty(taskDataMap.Task_CreateTime))
{
selectSql.Append("and Task_CreateTime like @0", "%" + taskDataMap.Task_CreateTime + "%");
}
//预定时间不为空
if (!string.IsNullOrEmpty(taskDataMap.Task_PresetTime))
{
selectSql.Append("and Task_PresetTime like @0", "%" + taskDataMap.Task_PresetTime + "%");
}
//时间间隔不为空
if (!string.IsNullOrEmpty(taskDataMap.Task_Interval))
{
selectSql.Append("and Task_Interval like @0", "%" + taskDataMap.Task_Interval + "%");
}
////间隔时间
//if (!string.IsNullOrEmpty(taskDataMap.Task_IntervalTime))
//{
// selectSql.Append("and Task_Interval like @0", "%" + taskDataMap.Task_IntervalTime + "%");
//}
}
//完成状态不为空
if (taskDataMap.Task_ExecuteReuslt == 0 || taskDataMap.Task_ExecuteReuslt == 1)
{
selectSql.Append("and Task_ExecuteReuslt like @0", taskDataMap.Task_ExecuteReuslt);
}
//创建时间
selectSql.Append(PeriodOfTimeQuery("Task_CreateTime", taskDataMap.CreatTimeStart, taskDataMap.CreatTimeEnd));
//预定时间
selectSql.Append(PeriodOfTimeQuery("Task_PresetTime", taskDataMap.TaskPresetTimeStart, taskDataMap.TaskPresetTimeEnd));
//执行时间
selectSql.Append(PeriodOfTimeQuery("Task_LastExecuteTime", taskDataMap.TaskLastExecuteTimeStart, taskDataMap.TaskLastExecuteTimeEnd));
return(selectSql);
}
public async Task <IActionResult> GetTask([FromQuery] Page page, [FromBody] SelectRequestData taskRequestData)
{
return(Ok(await tasksServer.GetTask(page, taskRequestData)));
}