public ScheduleSetting GetScheduleById(string scheduleId)
{
if (!string.IsNullOrEmpty(scheduleId))
{
_repository.SetSomething();
ScheduleSetting settings = _repository.GetScheduleById(scheduleId);
_repository.UnSetSomething();
return(LoadScheduleSettings(settings));
}
else
{
throw new ArgumentException("The scheduleId parameter cannot be empty.");
}
}
/// <summary>
/// 画面状態を読み込む
/// </summary>
private Alerm LoadFormSetting()
{
try
{
string appDir = AppUtil.GetAppDirPath() + @"\" + SCHEDULE_SETTING_FILE;
ScheduleSetting setting = new ScheduleSetting();
if (!System.IO.File.Exists(appDir))
{
string jsonString = JsonConvert.SerializeObject(setting);
using (StreamWriter sw = new StreamWriter(appDir, false))
{
sw.WriteLine(jsonString);
}
}
else
{
using (StreamReader sr = new StreamReader(appDir))
{
string jsonString = sr.ReadToEnd();
setting = JsonConvert.DeserializeObject <ScheduleSetting>(jsonString);
}
}
Alerm alerm = new Alerm();
alerm.EdgeColor = setting.EdgeColor;
alerm.LabelColor = setting.LabelColor;
alerm.ForeColor = setting.ForeColor;
alerm.AlermDelete = setting.AlermDelete;
alerm.FontName = setting.FontName;
alerm.TimeAddUpDown = setting.TimeAddUpDown;
return(alerm);
}
catch (Exception ex)
{
throw ex;
}
}
protected override void ExecuteCommand(JobExecutionContext context)
{
logger.Debug(m => m("Sql job:{0} has been executed.", context.JobDetail.FullName));
JobDataMap dataMap = context.JobDetail.JobDataMap;
projectId = dataMap["projectId"].ToString();
gatewayId = SystemInternalSetting.Projects[projectId].ToString();
DateTime dt = dataMap["lastTime"] == null ? DateTime.Now : dataMap.GetDateTime("lastTime");
logger.Debug(m => m("where datetime > {0}", dt));
string connectionString = SystemInternalSetting.ConnectionString;
string sqlSyntax = SystemInternalSetting.QueryProjectUpdateSQL;
sqlSyntax = string.Format(sqlSyntax, projectId, dt);
logger.Debug(sqlSyntax);
DateTime dt2 = DateTime.Now;
DataSet dataSet = DatabaseUtility.Query(connectionString, sqlSyntax, "");
if (dataSet.Tables.Count == 0)
{
return;
}
if (dataSet.Tables[0].Rows.Count > 0)
{
//Enqueue data
Report(dataSet);
}
dataMap.Put("lastTime", dt2);
ScheduleSetting.SetLastTime(projectId, dt2);
}
/// <summary>
/// 画面状態を保存する
/// </summary>
private void SaveFormSetting(Alerm alerm)
{
try
{
string appDir = AppUtil.GetAppDirPath() + @"\" + SCHEDULE_SETTING_FILE;
ScheduleSetting setting = new ScheduleSetting();
setting.EdgeColor = new byte[] { alerm.EdgeColor[0], alerm.EdgeColor[1], alerm.EdgeColor[2], alerm.EdgeColor[3] };
setting.LabelColor = new byte[] { alerm.LabelColor[0], alerm.LabelColor[1], alerm.LabelColor[2], alerm.LabelColor[3] };
setting.ForeColor = new byte[] { alerm.ForeColor[0], alerm.ForeColor[1], alerm.ForeColor[2], alerm.ForeColor[3] };
setting.AlermDelete = alerm.AlermDelete;
setting.FontName = alerm.FontName;
setting.TimeAddUpDown = alerm.TimeAddUpDown;
string jsonString = JsonConvert.SerializeObject(setting);
using (StreamWriter sw = new StreamWriter(appDir, false))
{
sw.WriteLine(jsonString);
}
}
catch (Exception ex)
{
throw ex;
}
}
public CustomerReturnDownload(ScheduleSetting settings) : base(settings)
{
}
public AdjustmentUpload(ScheduleSetting settings) : base(settings)
{
}
public PurchaseOrderUpload(ScheduleSetting settings) : base(settings)
{
}
public SalesOrderUpload(ScheduleSetting settings) : base(settings)
{
}
public ProductDownload(ScheduleSetting settings) : base(settings)
{
}
public InventorySyncUpload(ScheduleSetting settings) : base(settings)
{
}
public WorkOrderUpload(ScheduleSetting settings) : base(settings)
{
}
private ScheduleSetting LoadScheduleSettings(ScheduleSetting settings)
{
//...code ....
}
public void SetScheduleSetting(ScheduleSetting setting)
{
WebClient http = new WebClient();
string response = http.UploadString(this.Url + "/setting", String.Format("schedule={0}", (int)setting));
if (response.Contains(SUCCESS_KEYWORD))
{
this.ScheduleSetting = setting;
}
else
{
this.logger.Error(String.Format("Error setting schedule setting. {0}.", response));
}
}
