protected override void ExecuteInternal(Quartz.JobExecutionContext context) { var startTime = DateTime.UtcNow; var logEntity = new SCHEDULERLOG { STARTTIME = startTime }; var strInfo = new StringBuilder(); strInfo.AppendFormat("ClearHistoryDataJob begin at {0}\n", DateTime.UtcNow.ToGmt8String()); using (SqlConnection conn = new SqlConnection("server=10.35.63.144;database=CnE;uid=sa;password=p@ssw0rd")) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { #region 执行数据同步程序 using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.Transaction = tran; cmd.CommandText = "[dbo].[CLEARSHIPPINGDATA]"; cmd.ExecuteNonQuery(); } using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.Transaction = tran; cmd.CommandText = "[dbo].[CLEARFANTAMETALDATA]"; cmd.ExecuteNonQuery(); } #endregion tran.Commit(); var endTime = DateTime.UtcNow; strInfo.AppendFormat("Synchronization completed at {0}.\n", endTime.ToGmt8String()); logEntity.ENDTIME = endTime; logEntity.JobStatus = JobStatus.Success; logEntity.RUNDETAIL = strInfo.ToString(); WriteLogEntity(logEntity); } catch (Exception exception) { tran.Rollback(); logEntity.ENDTIME = DateTime.UtcNow.AddDays(-1); logEntity.JobStatus = JobStatus.Fail; logEntity.RUNDETAIL = strInfo + "\n" + exception; WriteLogEntity(logEntity); } finally { conn.Close(); } } }
public override void DoJob(Quartz.JobExecutionContext context) { _bll.PreDispatchV1(new PreDispatchJobArgModel() { IntervalDay = Consts.IntervalDay, PerBatchCount = Consts.BATCH_COUNT }); }
protected override void ExecuteInternal(Quartz.JobExecutionContext context) { var startTime = DateTime.UtcNow; var logEntity = new SCHEDULERLOG { STARTTIME = startTime }; var strInfo = new StringBuilder(); strInfo.AppendFormat("Smm data Sync begin at {0}\n", DateTime.UtcNow.ToGmt8String()); StringBuilder sb = new StringBuilder(); try { #region 执行数据同步程序 Sail_Traval_Manager manager = new Sail_Traval_Manager(); manager.Manager(sb); using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["CnECon"])) { try { conn.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[dbo].[CreateShangHaiShippingMaxTable]"; cmd.Connection = conn; cmd.ExecuteNonQuery(); } } catch { } finally { conn.Close(); } } #endregion var endTime = DateTime.UtcNow; strInfo.Append(sb); strInfo.AppendFormat("Synchronization completed at {0}.\n", endTime.ToGmt8String()); logEntity.ENDTIME = endTime; logEntity.JobStatus = JobStatus.Success; logEntity.RUNDETAIL = strInfo.ToString(); WriteLogEntity(logEntity); } catch (Exception exception) { logEntity.ENDTIME = DateTime.UtcNow.AddDays(-1); logEntity.JobStatus = JobStatus.Fail; logEntity.RUNDETAIL = strInfo + "\n" + exception; WriteLogEntity(logEntity); } }
public void Execute(Quartz.JobExecutionContext context) { string extraText = "[none]"; if (context.MergedJobDataMap.Contains("ExtraText")) { extraText = context.MergedJobDataMap["ExtraText"].ToString(); } Console.WriteLine(string.Format("Hello from ConsoleJob1 - {0}\nExtra Text:{1}", DateTime.Now, extraText)); }
protected override void ExecuteInternal(Quartz.JobExecutionContext context) { var startTime = DateTime.UtcNow; var logEntity = new SCHEDULERLOG { STARTTIME = startTime }; var strInfo = new StringBuilder(); strInfo.AppendFormat("FanYaExponentJob begin at {0}\n", DateTime.UtcNow.ToGmt8String()); var sb = new StringBuilder(); try { #region 执行数据同步程序 ////FanYaStockData---FanYaExponentData FanYaExponent fanYaExponent = new FanYaExponent(); fanYaExponent.ManagerStock <FanYaStockData>(); fanYaExponent.ManagerStock <FanYaExponentData>(); #endregion var endTime = DateTime.UtcNow; strInfo.Append(sb); strInfo.AppendFormat("Synchronization completed at {0}.\n", endTime.ToGmt8String()); logEntity.ENDTIME = endTime; logEntity.JobStatus = JobStatus.Success; logEntity.RUNDETAIL = strInfo.ToString(); WriteLogEntity(logEntity); } catch (Exception exception) { logEntity.ENDTIME = DateTime.UtcNow.AddDays(-1); logEntity.JobStatus = JobStatus.Fail; logEntity.RUNDETAIL = strInfo + "\n" + exception; WriteLogEntity(logEntity); } }
protected override void ExecuteInternal(Quartz.JobExecutionContext context) { var startTime = DateTime.UtcNow; var logEntity = new SCHEDULERLOG { STARTTIME = startTime }; var connStr = ConfigurationManager.AppSettings["CnECon"]; var strInfo = new StringBuilder(); strInfo.AppendFormat("Destination [Type: Oracle DB, Address: {0}]\n", connStr); try { #region 执行数据同步程序 var ch = new LongZhongJob(); ch.Execute(); strInfo.AppendFormat(ch.LogMsg.ToString()); #endregion ModifyLongZhongMax max = new ModifyLongZhongMax(); max.ExecuteMax(); var endTime = DateTime.UtcNow; logEntity.ENDTIME = endTime; logEntity.JobStatus = JobStatus.Success; logEntity.RUNDETAIL = strInfo.ToString(); WriteLogEntity(logEntity); } catch (Exception exception) { logEntity.ENDTIME = DateTime.UtcNow.AddDays(-1); logEntity.JobStatus = JobStatus.Fail; logEntity.RUNDETAIL = strInfo + "\n" + exception; WriteLogEntity(logEntity); } }
protected override void ExecuteInternal(Quartz.JobExecutionContext context) { System.IO.File.AppendAllText(@"C:\David\test.txt", DateTime.Now.ToString() + "\r\n"); }
protected override void ExecuteInternal(Quartz.JobExecutionContext context) { throw new NotImplementedException(); }
protected override void ExecuteInternal(Quartz.JobExecutionContext context) { string connStr = ConfigurationManager.AppSettings["mergeData"].ToString(); OracleConnection conn = new OracleConnection(connStr); conn.Open(); OracleTransaction tran = conn.BeginTransaction(System.Data.IsolationLevel.ReadCommitted); var startTime = DateTime.UtcNow; var logEntity = new SCHEDULERLOG { STARTTIME = startTime }; var strInfo = new StringBuilder(); strInfo.AppendFormat("Source [Email:{0}]\n", ConfigurationManager.AppSettings["CoffedProductSenderFilter"]); strInfo.AppendFormat("Destination [Type: Oracle DB, Address: {0}]\n", connStr); var lastSyncTime = Convert.ToDateTime("2016-11-14"); using (var cneEntities = new CnEEntities()) { var date = cneEntities.SCHEDULERLOGs.Where(x => x.STATUS == 0 && x.JOBTYPE == JobType).Select( x => (DateTime?)x.STARTTIME).Max(); if (date != null) { lastSyncTime = date.Value.AddMinutes(-10); } } try { #region 执行数据同步程序 var attFetcherSever = ConfigurationManager.AppSettings["CnEServer"]; int attFetcherPort = int.Parse(ConfigurationManager.AppSettings["CnEPort"]); bool attFetcherUsingSsl = Convert.ToBoolean(ConfigurationManager.AppSettings["CnEUsingSsl"]); string attFetcherUserName = ConfigurationManager.AppSettings["CnEUserName"]; string attFetcherPassWord = ConfigurationManager.AppSettings["CnEPassWord"]; string attFetcherSavingPath = ConfigurationManager.AppSettings["CoffedProductSavingPath"]; var attFetcher = new IMAP4AttFetcher(attFetcherSever, attFetcherPort, attFetcherUsingSsl, attFetcherUserName, attFetcherPassWord, attFetcherSavingPath); var attFetcherSenderFilter = new SenderFilter(); string[] senders = ConfigurationManager.AppSettings["CoffedProductSenderFilter"].Split(';'); foreach (var sender in senders) { var senderRegex = new Regex(sender, RegexOptions.Compiled); attFetcherSenderFilter.SetRule(senderRegex); } attFetcher.AppendFilter(attFetcherSenderFilter); attFetcher.Execute(lastSyncTime); var attachmentFileNames = attFetcher.GetAttachmentFileNames(); // List<string> attachmentFileNames = Directory.GetFiles(@"C:\DataFeedApp\Scheduler\CnE\CoffedProductData").ToList<string>(); for (int i = attachmentFileNames.Count - 1; i >= 0; i--) { var tempattachname = attachmentFileNames[i]; if (tempattachname.IndexOf("Productinventory") != -1) { CofeedProductManager c = new CofeedProductManager(); c.GetCellsByFirstSheet(tempattachname, strInfo); } else if (tempattachname.IndexOf("week") != -1) { CoffedWeekManager c = new CoffedWeekManager(); c.GetCellsByFirstSheet(tempattachname, strInfo); } } var fold = new DirectoryInfo(attFetcherSavingPath); if (fold.Exists) { FileInfo[] files = fold.GetFiles(); foreach (FileInfo f in files)//删除目录下所有文件 { f.Delete(); } } if (attachmentFileNames.Count > 0) { MergeData m = new MergeData(); m.ExecuteCoffedAndMetalMax(conn, tran); strInfo.Append("Execute Procedure : CREATEMAXAGRICULTRUEOUTPUT\r\n"); strInfo.Append("Insert Into Table : GDT_AGRICULTRUEOUTPUTMAX, GDT_ENERGYYIELDMAX \r\n"); //生成MAX表; //ExecuteCoffedAndMetalMax tran.Commit(); } else { strInfo.Append("No files found\r\n"); } ; #endregion var endTime = DateTime.UtcNow; logEntity.ENDTIME = endTime; logEntity.JobStatus = JobStatus.Success; logEntity.RUNDETAIL = strInfo.ToString(); WriteLogEntity(logEntity); } catch (Exception exception) { tran.Rollback(); logEntity.ENDTIME = DateTime.UtcNow.AddDays(-1); logEntity.JobStatus = JobStatus.Fail; logEntity.RUNDETAIL = strInfo + "\n" + exception; WriteLogEntity(logEntity); } }