/// <summary>
/// 根据条件查询任务
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns>符合条件的任务</returns>
public static JsonBaseModel <List <TaskUtil> > Query(QueryCondition condition)
{
JsonBaseModel <List <TaskUtil> > result = new JsonBaseModel <List <TaskUtil> >();
if (string.IsNullOrEmpty(condition.SortField))
{
condition.SortField = "CreatedOn";
condition.SortOrder = "DESC";
}
Hashtable ht = Pagination.QueryBase <TaskUtil>("SELECT * FROM p_Task", condition);
result.Result = ht["data"] as List <TaskUtil>;
result.TotalCount = Convert.ToInt32(ht["total"]);
result.TotalPage = result.CalculateTotalPage(condition.PageSize, result.TotalCount.Value, condition.IsPagination);
return(result);
}
/// <summary>
/// 根据条件查询任务
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns>符合条件的任务</returns>
public static JsonBaseModel <List <TaskLogUtil> > QueryLog(QueryCondition condition)
{
JsonBaseModel <List <TaskLogUtil> > result = new JsonBaseModel <List <TaskLogUtil> >();
if (string.IsNullOrEmpty(condition.SortField))
{
condition.SortField = "RunTime";
condition.SortOrder = "DESC";
}
Hashtable ht = Pagination.QueryBase <TaskLogUtil>(
@"SELECT p_Tasklog.*,p_Task.TaskName FROM dbo.p_Tasklog
LEFT JOIN dbo.p_Task ON dbo.p_Task.TaskID = p_Tasklog.TaskId", condition);
result.Result = ht["data"] as List <TaskLogUtil>;
result.TotalCount = Convert.ToInt32(ht["total"]);
result.TotalPage = result.CalculateTotalPage(condition.PageSize, result.TotalCount.Value, condition.IsPagination);
return(result);
}
