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