public void Execute(IJobExecutionContext context) { //生成日志工具 var LogPath = AppDomain.CurrentDomain.BaseDirectory + "/TaskLog"; var FileName = DateTime.Now.ToString("yyyy-MM-dd") + ".txt"; LogTool = new FileTool(LogPath); LogTool.FileExists(FileName); try { LogTool.AppendFile($"[{DateTime.Now.ToString()}]开始执行Sql{Environment.NewLine}"); var SQLFilePath = AppDomain.CurrentDomain.BaseDirectory.ToString() + "/SQLFile"; var SQLFileTool = new FileTool(SQLFilePath); var FileList = SQLFileTool.FileDetailsList; FileList.ForEach(m => { try { LogTool.AppendFile($"[{DateTime.Now.ToString()}]开始执行Sql文件[{m.FileName}]{Environment.NewLine}"); var sql = SQLFileTool.GetFileContent(SQLFilePath, m.FileName); SqlHelp.ExSql(sql, LogTool); LogTool.AppendFile($"[{DateTime.Now.ToString()}]Sql文件[{m.FileName}]执行成功{Environment.NewLine}"); } catch (Exception ex) { LogTool.AppendFile($"[{DateTime.Now.ToString()}]Sql文件[{m.FileName}]执行失败,ex:{ex.Message}{Environment.NewLine}"); } }); } catch (Exception ex) { LogTool.AppendFile($"[{DateTime.Now.ToString()}]任务执行失败,ex:{ex.Message}{Environment.NewLine}"); } }