/// <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); }