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