/// <summary>
/// Job集合(分页 )
/// </summary>
/// <param name="parameter">参数集</param>
/// <returns></returns>
public PagerModel <BackgroundJobInfo> GeBackgroundJobInfoPagerList(PageParameter parameter)
{
int TotalRecord = 0;
List <BackgroundJobInfo> dataList = null;
string Name = parameter.GetParameter("Name");
if (!string.IsNullOrWhiteSpace(Name))
{
dataList = db.Queryable <BackgroundJobInfo>()
.Where(it => it.Name.Contains(Name) && it.IsDelete == 0)
.OrderBy(it => it.CreatedDateTime, OrderByType.Desc)
.ToPageList(parameter.currentPageIndex, parameter.rows, ref TotalRecord);
}
else
{
dataList = db.Queryable <BackgroundJobInfo>()
.Where(it => it.IsDelete == 0)
.OrderBy(it => it.CreatedDateTime, OrderByType.Desc)
.ToPageList(parameter.currentPageIndex, parameter.rows, ref TotalRecord);
}
PagerModel <BackgroundJobInfo> pagerModel = new PagerModel <BackgroundJobInfo>();
pagerModel.dataList = dataList;
pagerModel.TotalRecord = TotalRecord;
pagerModel.CurrentPage = parameter.currentPageIndex;
pagerModel.CalculateTotalPage(parameter.rows, TotalRecord);
return(pagerModel);
}
/// <summary>
/// Job日志集合（分页）
/// </summary>
/// <param name="parameter">参数集</param>
/// <returns></returns>
public PagerModel <ScheduledTaskHistory> GetScheduledTaskHistoryInfoPagerList(PageParameter parameter)
{
int TotalRecord = 0;
List <ScheduledTaskHistory> dataList = null;
string JobName = parameter.GetParameter("JobName");
if (!string.IsNullOrWhiteSpace(JobName))
{
dataList = db.Queryable <ScheduledTaskHistory>()
.Where(it => it.JobName.Contains(JobName))
.OrderBy(it => it.CreatedDateTime, OrderByType.Desc)
.ToPageList(parameter.currentPageIndex, parameter.rows, ref TotalRecord);
}
else
{
dataList = db.Queryable <ScheduledTaskHistory>()
.OrderBy(it => it.CreatedDateTime, OrderByType.Desc)
.ToPageList(parameter.currentPageIndex, parameter.rows, ref TotalRecord);
}
PagerModel <ScheduledTaskHistory> pagerModel = new PagerModel <ScheduledTaskHistory>();
pagerModel.dataList = dataList;
pagerModel.TotalRecord = TotalRecord;
pagerModel.CurrentPage = parameter.currentPageIndex;
pagerModel.CalculateTotalPage(parameter.rows, TotalRecord);
return(pagerModel);
}
public PagerModel <JobIndexViewModel> GeBackgroundJobInfoPagerList(PageParameter parameter)
{
int TotalRecord = 0;
List <JobIndexViewModel> datalist = null;
datalist = db.Queryable <JobDetail, Trigger, Cron>((jobdetail, qrttrigger, cron) => new object[] {
JoinType.Left, jobdetail.SCHED_NAME == qrttrigger.SCHED_NAME && jobdetail.JOB_NAME == qrttrigger.JOB_NAME && jobdetail.JOB_GROUP == qrttrigger.JOB_GROUP,
JoinType.Left, qrttrigger.SCHED_NAME == cron.SCHED_NAME && qrttrigger.TRIGGER_NAME == cron.TRIGGER_NAME && qrttrigger.TRIGGER_GROUP == cron.TRIGGER_GROUP,
//JoinType.Left,jobdetail.SCHED_NAME==qrtstate.SCHED_NAME&&jobdetail.JOB_NAME==qrtstate.JOB_NAME&&jobdetail.JOB_GROUP==qrtstate.JOB_GROUP
})
.Select((jobdetail, qrttrigger, cron) => new JobIndexViewModel
{
Name = jobdetail.JOB_NAME,
GroupName = jobdetail.JOB_GROUP,
State = qrttrigger.TRIGGER_STATE + "", //EnumHelper.GetDescriptionByValue<JobStateEnum>(),
ClassName = jobdetail.JOB_CLASS_NAME,
LastRunTime = qrttrigger.PREV_FIRE_TIME.ToString(), //GetDateTime().ToString("yyyy-MM-dd HH:mm:ss"),
NextRunTime = qrttrigger.NEXT_FIRE_TIME.ToString(), //GetDateTime().ToString("yyyy-MM-dd HH:mm:ss"),
Description = jobdetail.DESCRIPTION,
CronExpression = cron.CRON_EXPRESSION
}).ToPageList(parameter.currentPageIndex, parameter.rows, ref TotalRecord);
if (datalist != null && datalist.Count > 0)
{
foreach (var item in datalist)
{
item.State = EnumHelper.GetDescriptionByName <JobStateEnum>(item.State);
item.LastRunTime = item.LastRunTime == null?"": GetDateTime(long.Parse(item.LastRunTime)).ToString("yyyy-MM-dd HH:mm:ss");
item.NextRunTime = item.NextRunTime == null?"": GetDateTime(long.Parse(item.NextRunTime)).ToString("yyyy-MM-dd HH:mm:ss");
}
}
var pagerModel = new PagerModel <JobIndexViewModel>();
pagerModel.dataList = datalist;
pagerModel.TotalRecord = TotalRecord;
pagerModel.CurrentPage = parameter.currentPageIndex;
pagerModel.CalculateTotalPage(parameter.rows, TotalRecord);
return(pagerModel);
}