/// <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); }