public void Execute(IJobExecutionContext context) { var procname = context.JobDetail.JobDataMap.Get("TaskParam"); var taskid = context.JobDetail.JobDataMap.Get("taskid"); var taskname = context.JobDetail.JobDataMap.Get("taskname"); DateTime excutytime = DateTime.Now; try { DapperHelper.ExecuteProc(procname.ToString(), null); task_log log = new task_log(); log.msg = "成功"; log.stat = 1; log.taskid = (int)taskid; log.taskname = taskname.ToString(); log.excutetime = excutytime; DapperHelper.AddLog(log); } catch (Exception ex) { task_log log = new task_log(); log.msg = ex.Message; log.stat = 0; log.taskid = (int)taskid; log.taskname = taskname.ToString(); log.excutetime = excutytime; DapperHelper.AddLog(log); } //LogHelper.AddLog("触发存储过程作业,函数名:"+ procname); }
/// <summary> /// 修改状态 /// </summary> /// <param name="state"></param> /// <param name="id"></param> /// <returns></returns> public static int AddLog(task_log l) { using (IDbConnection conn = new SqlConnection(SQLStr.SqlStrCon)) { conn.Open(); string sql = "insert into task_log(taskid, taskname, stat, msg, excutetime) values(@taskid,@taskname,@stat,@msg,@excutetime)"; var rowcouny = conn.Execute(sql, l ); return(rowcouny); } }
public void AddTaskLog(task_log task_log) { taskLog.Add(task_log); SaveChanges(); }