/// <summary>
/// 保存job
/// </summary>
/// <param name="TriggerName"></param>
/// <param name="TriggerUrl"></param>
/// <param name="CronExpr"></param>
/// <param name="Explain"></param>
/// <returns></returns>
public long SaveJob(string TriggerName, string TriggerUrl, string CronExpr, string Explain, long Id = 0)
{
using (var db = new ECIRadarEntities())
{
var JobData = new jobconfiguration();
if (Id == 0)
{
JobData.TriggerName = TriggerName;
JobData.TriggerUrl = TriggerUrl;
JobData.CronExpr = CronExpr;
JobData.Explain = Explain;
JobData.RunStatus = 1;
JobData.IsValid = 1;
db.jobconfiguration.Add(JobData);
}
else
{
JobData = db.jobconfiguration.Where(x => x.Id == Id).FirstOrDefault();
JobData.TriggerName = TriggerName;
JobData.TriggerUrl = TriggerUrl;
JobData.CronExpr = CronExpr;
JobData.Explain = Explain;
}
db.SaveChanges();
return(JobData.Id);
}
}
/// <summary>
/// 获取job列表
/// </summary>
/// <returns></returns>
public jobconfiguration GetJobData(long id)
{
using (var db = new ECIRadarEntities())
{
return(db.jobconfiguration.Where(x => x.Id == id && x.IsValid == 1).FirstOrDefault());
}
}
/// <summary>
/// 获取job列表
/// </summary>
/// <returns></returns>
public List <jobconfiguration> GetJobDataList()
{
using (var db = new ECIRadarEntities())
{
return(db.jobconfiguration.Where(x => x.IsValid == 1).ToList());
}
}
/// <summary>
/// 设置job状态
/// </summary>
/// <returns></returns>
public bool SetJobRowStatus(long id, int rowStatus)
{
using (var db = new ECIRadarEntities())
{
var jobData = db.jobconfiguration.Where(x => x.Id == id && x.IsValid == 1).FirstOrDefault();
jobData.IsValid = rowStatus;
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 更新作业在数据库中的运行状态
/// </summary>
/// <param name="jobName"></param>
/// <param name="runStatus"></param>
private static void UpdateDataJobRunStatus(string jobName, int runStatus)
{
using (var db = new ECIRadarEntities())
{
var data = db.jobconfiguration.Where(x => x.TriggerName == jobName).FirstOrDefault();
if (data != null)
{
data.RunStatus = runStatus;
db.SaveChanges();
}
}
}
/// <summary>
/// 获取job列表
/// </summary>
/// <returns></returns>
public List <jobconfiguration> GetJobDataList(JobSelectModel jobSelect)
{
using (var db = new ECIRadarEntities())
{
jobSelect.TotalCount = db.jobconfiguration.Count(x =>
(string.IsNullOrEmpty(jobSelect.TriggerName) || x.TriggerName == jobSelect.TriggerName) &&
(jobSelect.RunStaus == -1 || x.RunStatus == jobSelect.RunStaus) &&
(jobSelect.IsValid == -1 || x.IsValid == jobSelect.IsValid));
var dataList = db.jobconfiguration.Where(x =>
(string.IsNullOrEmpty(jobSelect.TriggerName) || x.TriggerName == jobSelect.TriggerName) &&
(jobSelect.RunStaus == -1 || x.RunStatus == jobSelect.RunStaus) &&
(jobSelect.IsValid == -1 || x.IsValid == jobSelect.IsValid))
.OrderByDescending(x => x.Id)
.Skip(jobSelect.PageSize * (jobSelect.PageIndex - 1))
.Take(jobSelect.PageSize).ToList();
return(dataList);
}
}
