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