public async Task PostSystemTask(string token, SystemTask model)
{
HouseWebClient client = new HouseWebClient(token);
Dictionary <string, string> uriParams = new Dictionary <string, string>();
string result = await client.SendRequest(MPEDHttpMethodType.Post, "api/SystemTasks",
null, model, uriParams);
}
private void ResetAgentLastRunDates()
{
DateTime today = Today;
int dailyAgentCodeId = Utils.GetCodeIdByCodeValue("SystemTaskType", "DAILY");
int monthlyAgentCodeId = Utils.GetCodeIdByCodeValue("SystemTaskType", "MONTHLY");
SystemTask dailyTask = DataContext.SystemTasks.Where(st => st.TaskTypeCodeId == dailyAgentCodeId).FirstOrDefault();
SystemTask monthlyTask = DataContext.SystemTasks.Where(st => st.TaskTypeCodeId == monthlyAgentCodeId).FirstOrDefault();
dailyTask.LastRunDate = today.AddDays(-1).AddHours(23);
int monthlyTaskDayToRun = int.Parse(Utils.GetSystemValue("MonthlyFinanceProcessDay"));
if (today.Day <= monthlyTaskDayToRun)
{
monthlyTask.LastRunDate = new DateTime(today.Year, Today.Month, monthlyTaskDayToRun).AddMonths(-1).AddHours(23);
}
else
{
monthlyTask.LastRunDate = new DateTime(today.Year, Today.Month, monthlyTaskDayToRun).AddHours(23);
}
DataContext.SaveChanges();
LoadAgentLastRunDates();
}
protected override void Seed(TaskControlSystem.DataAccess.TaskContext context)
{
var Task1 = new SystemTask
{
Title = "title1",
Description = "Description1",
RegisterDate = DateTime.Now,
CompletionDate = DateTime.Now,
Status = TaskStatus.Appointed,
Executors = "Executor1",
ParentSystemTask = null,
ChildSystemTasks = new ObservableCollection <SystemTask>()
};
var Task2 = new SystemTask
{
Title = "title1.1",
Description = "Description1.1",
RegisterDate = DateTime.Now,
CompletionDate = DateTime.Now,
Status = TaskStatus.Appointed,
Executors = "Executor1.1",
ParentSystemTask = Task1,
ChildSystemTasks = new ObservableCollection <SystemTask>()
};
var Task3 = new SystemTask
{
Title = "title1.1.1",
Description = "Description1.1.1",
RegisterDate = DateTime.Now,
CompletionDate = DateTime.Now,
Status = TaskStatus.Appointed,
Executors = "Executor1.1.1",
ParentSystemTask = Task2,
ChildSystemTasks = new ObservableCollection <SystemTask>()
};
var Task4 = new SystemTask
{
Title = "title1.2",
Description = "Description1.2",
RegisterDate = DateTime.Now,
CompletionDate = DateTime.Now,
Status = TaskStatus.Appointed,
Executors = "Executor1.2",
ParentSystemTask = Task1,
ChildSystemTasks = new ObservableCollection <SystemTask>()
};
Task2.ChildSystemTasks.Add(Task3);
Task1.ChildSystemTasks.Add(Task2);
Task1.ChildSystemTasks.Add(Task4);
context.Tasks.Add(Task1);
context.SaveChanges();
}
/// <summary>
/// Updates the task schedule to to reflect the latest run date and time.
/// </summary>
private void UpdateLastRunDate()
{
using (StageBitzDB dataContext = new StageBitzDB())
{
SystemTask task = dataContext.SystemTasks.Where(t => t.TaskTypeCodeId == TaskTypeCodeId).FirstOrDefault();
task.LastRunDate = Utils.Now;
dataContext.SaveChanges();
}
}
public void Execute(SystemTask selectedTask)
{
var repository = _repositoryProvider.GetRepository <SystemTask>();
var taskToRemove = repository.Find(selectedTask.Id);
repository.Remove(taskToRemove);
_repositoryProvider.SaveChanges();
}
public void Execute(SystemTask selectedTask)
{
var repository = _repositoryProvider.GetRepository <SystemTask>();
var taskToEdit = repository.Find(selectedTask.Id);
taskToEdit.Title = selectedTask.Title;
taskToEdit.Description = selectedTask.Description;
taskToEdit.Executors = selectedTask.Executors;
taskToEdit.RegisterDate = selectedTask.RegisterDate;
taskToEdit.CompletionDate = selectedTask.CompletionDate;
_repositoryProvider.SaveChanges();
}
static void Main(string[] args)
{
SetConsoleInfo("新版测试");
#region 花顺数据测试
var inst = THS.GetInst();
//inst.GetTodayNewData();
#endregion
#region 数据库测试
// var res = mongo.GetCollectionStatistic("ths");
#endregion
#region 接口测试
//var res = FanyYiJunAPI.Invoke("你好");
#endregion
#region 数据转换测试
//DBConvertor.FromMongoDBToSQLServer("", "", "", "", "", "");
#endregion
#region 新浪大单测试
SinaFin sina = new SinaFin();
//sina.ConvertKLine2D("", "", "", "", "", "");
#endregion
#region 金融街
var jrj = new JRJ();
//jrj.GetKLine();
#endregion
#region SQL Server 测试
//mssql.IsExistUserTable("Test");
#endregion
#region Task测试
SystemTask task = new SystemTask();
task.ExecuteTask(TaskItem.CreateAsInterval());
#endregion
Console.WriteLine("全部结束");
Console.ReadKey();
}
public SystemTask SelectOne()
{
OracleCommand command = (OracleCommand)Session.Connection.CreateCommand();
command.CommandText = string.Format("select * from {0} where {1}", TableName,
"");
var reader = Session.ExecuteDataReader(command);
SystemTask result = null;
if (reader.Read())
{
result = new SystemTask(reader);
}
return(result);
}
public void Execute(SystemTask createdTask)
{
var repository = _repositoryProvider.GetRepository <SystemTask>();
SystemTask task = new SystemTask
{
Title = createdTask.Title,
Description = createdTask.Description,
Executors = createdTask.Executors,
Status = TaskStatus.Appointed,
RegisterDate = DateTime.Now,
ParentSystemTask = null
};
repository.Add(task);
_repositoryProvider.SaveChanges();
}
public int Insert(SystemTask entity)
{
OracleCommand command = (OracleCommand)Session.Connection.CreateCommand();
command.AppendText(string.Format("insert into {0}({1}) values ({2})", TableName,
"Id,Name,MetricField,TargetValue,Type"));
command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.ID, SystemTask.IDProperty));
command.AppendText(", ");
command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.NAME, SystemTask.NAMEProperty));
command.AppendText(", ");
command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.METRICFIELD, SystemTask.METRICFIELDProperty));
command.AppendText(", ");
command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.TARGETVALUE, SystemTask.TARGETVALUEProperty));
command.AppendText(", ");
command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.TYPE, SystemTask.TYPEProperty));
return(Session.ExecuteNonQuery(command));
}
public void Execute(SystemTask parentTask)
{
var repository = _repositoryProvider.GetRepository <SystemTask>();
//SystemTask task = new SystemTask
//{
// Title = childTask.Title,
// Description = childTask.Descriptiion,
// Executors = childTask.Executors,
// Status = TaskStatus.Appointed,
// RegisterDate = childTask.RegisterDate,
// CompletionDate = childTask.CompletionDate,
// ParentSystemTask = parentTask
//};
//repository.Find(parentTask.Id).ChildSystemTasks.Add(task);
//_repositoryProvider.SaveChanges();
}
/// <summary>
/// Checks the task schedule to see whether this task handler should be run now.
/// </summary>
private bool ShouldRunTask()
{
using (StageBitzDB dataContext = new StageBitzDB())
{
SystemTask task = dataContext.SystemTasks.Where(t => t.TaskTypeCodeId == TaskTypeCodeId).FirstOrDefault();
if (task == null || !task.IsActive)
{
return(false);
}
else
{
if (task.LastRunDate == null)
{
return(true);
}
return(ShouldRunTask(task.LastRunDate.Value));
}
}
}
