/// <summary>ジョブネットIDを変える</summary>
/// <param name="sender">源</param>
/// <param name="e">イベント</param>
private void combJobNetId_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string jobNetId = Convert.ToString(combJobNetId.SelectedValue);
dbAccess.CreateSqlConnect();
DataTable dtJobNet = _jobnetControlDAO.GetValidORMaxUpdateDateEntityById(jobNetId);
if (dtJobNet != null && dtJobNet.Rows.Count > 0)
{
tbJobNetName.Text = Convert.ToString(dtJobNet.Rows[0]["jobnet_name"]);
}
dbAccess.CloseSqlConnect();
}
/// <summary>値のセットと表示処理</summary>
/// <param name="sender">源</param>
private void SetValues(string jobId)
{
// 当該ジョブのデータを取得
DataRow[] rowJob = _myJob.Container.JobControlTable.Select("job_id='" + jobId + "'");
if (rowJob != null && rowJob.Length > 0)
{
txtJobId.Text = jobId;
txtJobName.Text = Convert.ToString(rowJob[0]["job_name"]);
DataRow[] rowIconJobnet = _myJob.Container.IconJobnetTable.Select("jobnet_id='" + _myJob.Container.JobnetId + "' and job_id='" + jobId + "' and update_date=" + rowJob[0]["update_date"]);
if (rowIconJobnet != null && rowIconJobnet.Length > 0)
{
lblJobnetId.Text = Convert.ToString(rowIconJobnet[0]["link_jobnet_id"]);
DBConnect dbAccess = new DBConnect(LoginSetting.ConnectStr);
JobnetControlDAO jobnetControlDAO = new JobnetControlDAO(dbAccess);
dbAccess.CreateSqlConnect();
DataTable dt = jobnetControlDAO.GetValidORMaxUpdateDateEntityById(rowIconJobnet[0]["link_jobnet_id"]);
if (dt.Rows.Count > 0)
{
lblJobnetName.Text = Convert.ToString(dt.Rows[0]["jobnet_name"]);
}
}
}
// 開始アイコンの場合
if (ElementType.START == _myJob.ElementType)
{
txtJobId.IsEnabled = false;
}
}
/// <summary>ToolTip表示内容設定</summary>///
public void SetToolTip()
{
string jobNetId = "";
string jobNetName = "";
StringBuilder sb = new StringBuilder();
sb.Append(Properties.Resources.job_id_label_text);
if (!LoginSetting.Lang.StartsWith("ja_"))
{
sb.Append(" "); /* added by YAMA 2014/12/15 V2.1.0 No32 対応 */
}
sb.Append(_jobId);
sb.Append("\n");
sb.Append(Properties.Resources.job_name_label_text);
if (!LoginSetting.Lang.StartsWith("ja_"))
{
sb.Append(" "); /* added by YAMA 2014/12/15 V2.1.0 No32 対応 */
}
sb.Append(_jobName);
DataRow[] rowTask;
if (InnerJobId == null)
{
rowTask = _container.IconTaskTable.Select("job_id='" + _jobId + "'");
}
else
{
rowTask = _container.IconTaskTable.Select("inner_job_id=" + InnerJobId);
}
if (rowTask != null && rowTask.Length > 0)
{
jobNetId = Convert.ToString(rowTask[0]["submit_jobnet_id"]);
DBConnect dbAccess = new DBConnect(LoginSetting.ConnectStr);
JobnetControlDAO jobnetControlDAO = new JobnetControlDAO(dbAccess);
dbAccess.CreateSqlConnect();
DataTable dtJobNet = jobnetControlDAO.GetValidORMaxUpdateDateEntityById(jobNetId);
dbAccess.CloseSqlConnect();
if (dtJobNet != null && dtJobNet.Rows.Count > 0)
{
jobNetName = Convert.ToString(dtJobNet.Rows[0]["jobnet_name"]);
}
}
sb.Append("\n");
sb.Append(Properties.Resources.jobnet_id_label_text);
if (!LoginSetting.Lang.StartsWith("ja_"))
{
sb.Append(" "); /* added by YAMA 2014/12/15 V2.1.0 No32 対応 */
}
sb.Append(jobNetId);
sb.Append("\n");
sb.Append(Properties.Resources.jobnet_name_label_text);
if (!LoginSetting.Lang.StartsWith("ja_"))
{
sb.Append(" "); /* added by YAMA 2014/12/15 V2.1.0 No32 対応 */
}
sb.Append(jobNetName);
picToolTip.ToolTip = sb.ToString();
}
//*******************************************************************
/// <summary>登録ボタンをクリック</summary>
/// <param name="sender">源</param>
/// <param name="e">イベント</param>
//*******************************************************************
private void regist_Click(object sender, RoutedEventArgs e)
{
// 開始ログ
base.WriteStartLog("regist_Click", Consts.PROCESS_001);
DataRow[] rows = ParentContainer.ScheduleJobnetTable.Select("jobnet_id='" + JobnetId + "'");
if (rows.Length < 1)
{
DataRow row = ParentContainer.ScheduleJobnetTable.NewRow();
row["jobnet_id"] = JobnetId;
row["schedule_id"] = ParentContainer.ScheduleId;
ParentContainer.ScheduleJobnetTable.Rows.Add(row);
JobnetControlDAO jobnetControlDAO = new JobnetControlDAO(dbAccess);
DataTable dt = jobnetControlDAO.GetValidORMaxUpdateDateEntityById(_jobnetId);
row["jobnet_name"] = dt.Rows[0]["jobnet_name"];
}
this.Close();
// 終了ログ
base.WriteEndLog("regist_Click", Consts.PROCESS_001);
}
//*******************************************************************
/// <summary> ジョブネットデータの検索（編集、コピー新規用）</summary>
/// <param name="jobnetId">`ジョブネットID</param>
//*******************************************************************
private void FillTables(string jobnetId)
{
// ジョブネット管理テーブル
container.JobnetControlTable = _jobnetControlDAO.GetValidORMaxUpdateDateEntityById(jobnetId);
Object updDate = container.JobnetControlTable.Rows[0]["update_date"];
// ジョブ管理テーブル
container.JobControlTable = _jobControlDAO.GetEntityByJobIdForUpdate(jobnetId, updDate);
// フロー管理テーブル
container.FlowControlTable = _flowControlDAO.GetEntityByJobnet(jobnetId, updDate);
// 計算アイコン設定テーブル
container.IconCalcTable = _iconCalcDAO.GetEntityByJobnet(jobnetId, updDate);
// 終了アイコン設定テーブル
container.IconEndTable = _iconEndDAO.GetEntityByJobnet(jobnetId, updDate);
// 拡張ジョブアイコン設定テーブル
container.IconExtjobTable = _iconExtJobDAO.GetEntityByJobnet(jobnetId, updDate);
// 条件分岐アイコン設定テーブル
container.IconIfTable = _iconIfDAO.GetEntityByJobnet(jobnetId, updDate);
// 情報取得アイコン設定テーブル
container.IconInfoTable = _iconInfoDAO.GetEntityByJobnet(jobnetId, updDate);
// ジョブネットアイコン設定テーブル
container.IconJobnetTable = _iconJobnetDAO.GetEntityByJobnet(jobnetId, updDate);
// ジョブアイコン設定テーブル
container.IconJobTable = _iconJobDAO.GetEntityByJobnet(jobnetId, updDate);
// ジョブコマンド設定テーブル
container.JobCommandTable = _jobCommandDAO.GetEntityByJobnet(jobnetId, updDate);
// ジョブ変数設定テーブル
container.ValueJobTable = _valueJobDAO.GetEntityByJobnet(jobnetId, updDate);
// ジョブコントローラ変数設定テーブル
container.ValueJobConTable = _valueJobConDAO.GetEntityByJobnet(jobnetId, updDate);
// タスクアイコン設定テーブル
container.IconTaskTable = _iconTaskDAO.GetEntityByJobnet(jobnetId, updDate);
// ジョブコントローラ変数アイコン設定テーブル
container.IconValueTable = _iconValueDAO.GetEntityByJobnet(jobnetId, updDate);
// ファイル転送アイコン設定テーブル
container.IconFcopyTable = _iconFcopyDAO.GetEntityByJobnet(jobnetId, updDate);
// ファイル待ち合わせアイコン設定テーブル
container.IconFwaitTable = _iconFwaitDAO.GetEntityByJobnet(jobnetId, updDate);
// リブートアイコン設定テーブル
container.IconRebootTable = _iconRebootDAO.GetEntityByJobnet(jobnetId, updDate);
// 保留解除アイコン設定テーブル
container.IconReleaseTable = _iconReleaseDAO.GetEntityByJobnet(jobnetId, updDate);
//added by YAMA 2014/02/06
// Zabbix連携アイコン設定テーブル
container.IconCooperationTable = _iconCooperationDAO.GetEntityByJobnet(jobnetId, updDate);
//added by YAMA 2014/2014/05/19
/// 実行エージェントレスアイコン設定テーブル
container.IconAgentlessTable = _iconAgentlessDAO.GetEntityByJobnet(jobnetId, updDate);
}
