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