/// <summary>
/// Selects Asynchronous task from LayerD
/// </summary>
/// <param name="parameterValue">Async Parameter Value</param>
private void UOC_SelectTask(ApsParameterValue parameterValue)
{
ApsReturnValue returnValue = new ApsReturnValue();
this.ReturnValue = returnValue;
ApsLayerD layerD = new ApsLayerD(this.GetDam());
layerD.SelectTask(parameterValue, returnValue);
DataTable dt = (DataTable)returnValue.Obj;
returnValue.Obj = null;
if (dt != null)
{
if (dt.Rows.Count != 0)
{
returnValue.TaskId = Convert.ToInt32(dt.Rows[0]["Id"]);
returnValue.UserId = dt.Rows[0]["UserId"].ToString();
returnValue.ProcessName = dt.Rows[0]["ProcessName"].ToString();
returnValue.Data = dt.Rows[0]["Data"].ToString();
returnValue.NumberOfRetries = Convert.ToInt32(dt.Rows[0]["NumberOfRetries"]);
returnValue.ReservedArea = dt.Rows[0]["ReservedArea"].ToString();
returnValue.CommandId = Convert.ToInt32(dt.Rows[0]["CommandId"]);
}
}
}
/// <summary>
/// Updates information in the database that the asynchronous task is failed and can be retried later
/// </summary>
/// <param name="parameterValue">Asynchronous Parameter Values</param>
private void UOC_UpdateTaskRetry(ApsParameterValue parameterValue)
{
ApsReturnValue returnValue = new ApsReturnValue();
this.ReturnValue = returnValue;
ApsLayerD layerD = new ApsLayerD(this.GetDam());
layerD.UpdateTaskRetry(parameterValue, returnValue);
}
/// <summary>
/// Selects user command from Database through LayerD
/// </summary>
/// <param name="parameterValue"></param>
private void UOC_SelectCommand(ApsParameterValue parameterValue)
{
ApsReturnValue returnValue = new ApsReturnValue();
this.ReturnValue = returnValue;
ApsLayerD layerD = new ApsLayerD(this.GetDam());
layerD.SelectCommand(parameterValue, returnValue);
}
/// <summary>
/// Set stop command for all running asynchronous task
/// </summary>
/// <param name="parameterValue">Asynchronous Parameter Values</param>
private void UOC_StopAllTask(ApsParameterValue parameterValue)
{
ApsReturnValue returnValue = new ApsReturnValue();
this.ReturnValue = returnValue;
ApsLayerD layerD = new ApsLayerD(this.GetDam());
layerD.StopAllTask(parameterValue, returnValue);
}
/// <summary>
/// Inserts Async Parameter values to Database through LayerD
/// </summary>
/// <param name="parameterValue"></param>
public void UOC_InsertTask(ApsParameterValue parameterValue)
{
// 戻り値クラスを生成して、事前に戻り値に設定しておく。
ApsReturnValue returnValue = new ApsReturnValue();
this.ReturnValue = returnValue;
ApsLayerD layerD = new ApsLayerD(this.GetDam());
layerD.InsertTask(parameterValue, returnValue);
}
/// <summary>
/// Updates the command of selected task
/// </summary>
/// <param name="taskID">Task ID</param>
/// <param name="commandId">Command ID</param>
/// <param name="returnValue">user parameter value</param>
/// <param name="dam">BaseDam</param>
public static void UpdateTaskCommand(int taskID, int commandId, ApsReturnValue returnValue, BaseDam dam)
{
// Sets parameters of AsyncProcessingServiceParameterValue to update the command of selected task.
ApsParameterValue parameterValue = new ApsParameterValue(
"AsyncProcessingService", "UpdateTaskCommand", "UpdateTaskCommand", "SQL",
new MyUserInfo("AsyncProcessingService", "AsyncProcessingService"));
parameterValue.TaskId = taskID;
parameterValue.CommandId = commandId;
// Calls data access part of asynchronous processing service.
ApsLayerD layerD = new ApsLayerD(dam);
layerD.UpdateTaskCommand(parameterValue, returnValue);
}
/// <summary>
/// Updates the progress rate in the database.
/// </summary>
/// <param name="taskID">asynchronous task id</param>
/// <param name="returnValue">ApsReturnValue</param>
/// <param name="progressRate">progress rate</param>
/// <param name="dam">BaseDam</param>
public static void UpdateProgressRate(int taskID, ApsReturnValue returnValue, decimal progressRate, BaseDam dam)
{
// Sets parameters of AsyncProcessingServiceParameterValue to Update progress rate
ApsParameterValue parameterValue = new ApsParameterValue(
"AsyncProcessingService", "UpdateTaskProgress", "UpdateTaskProgress", "SQL",
new MyUserInfo("AsyncProcessingService", "AsyncProcessingService"));
parameterValue.TaskId = taskID;
parameterValue.ProgressRate = progressRate;
// Calls data access part of asynchronous processing service.
ApsLayerD layerD = new ApsLayerD(dam);
layerD.UpdateTaskProgress(parameterValue, returnValue);
}
/// <summary>Get command information from database. </summary>
/// <param name="taskID">asynchronous task id</param>
/// <param name="returnValue">asynchronous return value</param>
/// <param name="dam">BaseDam</param>
public static void GetCommandValue(int taskID, ApsReturnValue returnValue, BaseDam dam)
{
// Sets parameters of AsyncProcessingServiceParameterValue to get command value.
ApsParameterValue parameterValue = new ApsParameterValue(
"AsyncProcessingService", "SelectCommand", "SelectCommand", "SQL",
new MyUserInfo("AsyncProcessingService", "AsyncProcessingService"));
parameterValue.TaskId = taskID;
// Calls data access part of asynchronous processing service.
ApsLayerD layerD = new ApsLayerD(dam);
layerD.SelectCommand(parameterValue, returnValue);
returnValue.CommandId = (int)returnValue.Obj;
}
/// <summary>
/// Tests the connection with the specified database
/// </summary>
/// <param name="parameterValue">Async Parameter Value</param>
private void UOC_TestConnection(ApsParameterValue parameterValue)
{
ApsLayerD layerD = new ApsLayerD(this.GetDam());
}
