/// <summary>
/// 通过任务编码获得任务信息
/// </summary>
/// <param name="missionCode"></param>
/// <returns></returns>
public static ZD_SyncTaskConfig GetTaskInfoByCode(string missionCode)
{
string sql = @"SELECT [MissionCode]
,[MissionName]
,[SyncTime]
,[SyncSuccessTime]
,[IsAyncSuccess]
,[JobClassName]
,[State]
,[CronExplain],[SyncSuccessBeginTime],[HostName] FROM [H3Cloud].[dbo].[ZD_SyncTaskConfig] where MissionCode='" + missionCode + "'";
OThinker.Data.Database.CommandFactory factory = OThinker.H3.WorkSheet.AppUtility.Engine.EngineConfig.CommandFactory;
OThinker.Data.Database.ICommand command = factory.CreateCommand();
var dataTable = command.ExecuteDataTable(sql);
ZD_SyncTaskConfig result = new ZD_SyncTaskConfig();
if (dataTable.Rows.Count > 0)
{
result.MissionCode = missionCode;
result.MissionName = dataTable.Rows[0]["MissionName"] + string.Empty;
result.SyncSuccessTime = Convert.ToDateTime(dataTable.Rows[0]["SyncSuccessTime"]);
result.SyncTime = Convert.ToDateTime(dataTable.Rows[0]["SyncTime"]);
result.SyncSuccessBeginTime = Convert.ToDateTime(dataTable.Rows[0]["SyncSuccessBeginTime"]);
result.IsAyncSuccess = Convert.ToInt32(dataTable.Rows[0]["IsAyncSuccess"]);
result.State = Convert.ToInt32(dataTable.Rows[0]["State"]);
result.JobClassName = dataTable.Rows[0]["JobClassName"] + string.Empty;
result.CronExplain = dataTable.Rows[0]["CronExplain"] + string.Empty;
result.HostName = dataTable.Rows[0]["HostName"] + string.Empty;
}
else
{
result = null;
}
return(result);
}
/// <summary>
/// 应用程序启动时从新启动已开启的任务
/// </summary>
public static void StartPlan()
{
try
{
string sql = @"SELECT [MissionCode]
,[MissionName]
,[SyncTime]
,[SyncSuccessTime]
,[IsAyncSuccess]
,[JobClassName]
,[State]
,[CronExplain],[SyncSuccessBeginTime],[HostName] FROM [H3Cloud].[dbo].[ZD_SyncTaskConfig] where State=1 and HostName='" + Dns.GetHostName() + "'";
OThinker.Data.Database.CommandFactory factory = OThinker.H3.WorkSheet.AppUtility.Engine.EngineConfig.CommandFactory;
OThinker.Data.Database.ICommand command = factory.CreateCommand();
var dataTable = command.ExecuteDataTable(sql);
if (dataTable.Rows.Count > 0)
{
for (int i = 0; i < dataTable.Rows.Count; i++)
{
ZD_SyncTaskConfig result = new ZD_SyncTaskConfig();
result.MissionCode = dataTable.Rows[i]["MissionCode"] + string.Empty;
result.MissionName = dataTable.Rows[i]["MissionName"] + string.Empty;
result.SyncSuccessTime = Convert.ToDateTime(dataTable.Rows[i]["SyncSuccessTime"]);
result.SyncTime = Convert.ToDateTime(dataTable.Rows[i]["SyncTime"]);
result.SyncSuccessBeginTime = Convert.ToDateTime(dataTable.Rows[i]["SyncSuccessBeginTime"]);
result.IsAyncSuccess = Convert.ToInt32(dataTable.Rows[i]["IsAyncSuccess"]);
result.State = 1;
result.JobClassName = dataTable.Rows[i]["JobClassName"] + string.Empty;
result.CronExplain = dataTable.Rows[i]["CronExplain"] + string.Empty;
result.HostName = dataTable.Rows[i]["HostName"] + string.Empty;
OThinker.H3.Portal.JobScheduler.Start(result);
}
}
}
catch (Exception e)
{
_logger.InfoFormat(e.Message.ToString());
throw;
}
}
