/// <summary> /// 添加作业 /// </summary> public static void AddJob(task_proc task) { if (task.typeid == 2) { AddDllJob(task); return; } DeleteJob(task);//判断是否存在,存在删除(伪更新) try { IJobDetail job = new JobDetailImpl(task.id.ToString(), typeof(ProcJob)); //添加任务执行参数 job.JobDataMap.Add("TaskParam", task.procname); job.JobDataMap.Add("taskid", task.id); job.JobDataMap.Add("taskname", task.taskname); CronTriggerImpl trigger = new CronTriggerImpl(); trigger.CronExpressionString = task.cronstr; trigger.Name = task.id.ToString(); trigger.Description = task.procname; scheduler.ScheduleJob(job, trigger); DapperHelper.EditTaskSt(4, task.id); } catch (Exception ex) { DapperHelper.EditTaskSt(0, task.id); LogHelper.AddLog("任务:" + task.taskname + " 异常,异常原因:" + ex.Message); } }
/// <summary> /// 添加任务 /// </summary> /// <param name="t"></param> /// <returns></returns> public int Add(task_proc t) { using (IDbConnection conn = new SqlConnection(SQLStr.SqlStrCon)) { StringBuilder sql = new StringBuilder(); sql.Append("insert into task_proc(procname,parm,state,cronstr,typeid,dllname,classname,taskname,remake) values (@procname,@parm,@state,@cronstr,@typeid,@dllname,@classname,@taskname,@remake)"); var model = conn.Query <int>(sql.ToString(), t ).FirstOrDefault(); return(model); } }
/// <summary> /// 更新任务 /// </summary> /// <param name="t"></param> /// <returns></returns> public int Update(task_proc t) { using (IDbConnection conn = new SqlConnection(SQLStr.SqlStrCon)) { StringBuilder sql = new StringBuilder(); sql.Append("update task_proc set procname=@procname,parm=@parm,state=3,cronstr=@cronstr,typeid=@typeid,dllname=@dllname,classname=@classname,taskname=@taskname,remake=@remake where id=@ID"); var model = conn.Query <int>(sql.ToString(), t ).FirstOrDefault(); return(model); } }
/// <summary> /// 删除作业 /// </summary> /// <param name="task"></param> public static void DeleteJob(task_proc task) { try { JobKey jk = new JobKey(task.id.ToString()); if (scheduler.CheckExists(jk)) { //任务已经存在则删除 scheduler.DeleteJob(jk); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新任务 /// </summary> /// <param name="t"></param> /// <returns></returns> public int Update(task_proc t) { return(dal.Update(t)); }
/// <summary> /// 添加任务 /// </summary> /// <param name="t"></param> /// <returns></returns> public int Add(task_proc t) { return(dal.Add(t)); }
public int Update([FromBody] task_proc t) { return(_bll.Update(t)); }
public int Add([FromBody] task_proc t) { return(_bll.Add(t)); }