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