/// <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"]); } // 拡張ジョブ定義テーブルのデータを取得 DBConnect dbAccess = new DBConnect(LoginSetting.ConnectStr); dbAccess.CreateSqlConnect(); DefineExtJobDAO _defineExtJobDAO = new DefineExtJobDAO(dbAccess); _dtDefine = _defineExtJobDAO.GetEntityByLang(LoginSetting.Lang); dbAccess.CloseSqlConnect(); combExtJob.Items.Clear(); combExtJob.ItemsSource = _dtDefine.DefaultView; combExtJob.DisplayMemberPath = Convert.ToString(_dtDefine.Columns["command_name"]); combExtJob.SelectedValuePath = Convert.ToString(_dtDefine.Columns["command_id"]); // 拡張ジョブアイコン設定テーブルのデータを取得 string cmdId = ""; DataRow[] rowExtJob; if (_myJob.ContentItem.InnerJobId == null) { rowExtJob = _myJob.Container.IconExtjobTable.Select("job_id='" + jobId + "'"); } else { rowExtJob = _myJob.Container.IconExtjobTable.Select("inner_job_id=" + _myJob.ContentItem.InnerJobId); } if (rowExtJob != null && rowExtJob.Length > 0) { cmdId = Convert.ToString(rowExtJob[0]["command_id"]); combExtJob.SelectedValue = cmdId; if (!CheckUtil.IsNullOrEmpty(cmdId)) { DataRow[] rowDefine = _dtDefine.Select("command_id='" + cmdId + "'"); if (rowDefine != null && rowDefine.Length > 0) { tbMemo.Text = Convert.ToString(rowDefine[0]["memo"]); } } txtParameter.Text = Convert.ToString(rowExtJob[0]["value"]); } }
/// <summary>ToolTip表示内容設定</summary>/// public void SetToolTip() { string cmdName = ""; string parameter = ""; string memo = ""; 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[] rowExtJob; if (InnerJobId == null) { rowExtJob = _container.IconExtjobTable.Select("job_id='" + _jobId + "'"); } else { rowExtJob = _container.IconExtjobTable.Select("inner_job_id=" + InnerJobId); } if (rowExtJob != null && rowExtJob.Length > 0) { DBConnect dbAccess = new DBConnect(LoginSetting.ConnectStr); dbAccess.CreateSqlConnect(); DefineExtJobDAO defineExtJobDAO = new DefineExtJobDAO(dbAccess); DataTable dtDefine = defineExtJobDAO.GetEntityByLang(LoginSetting.Lang); dbAccess.CloseSqlConnect(); string cmdId = Convert.ToString(rowExtJob[0]["command_id"]); if (!CheckUtil.IsNullOrEmpty(cmdId)) { DataRow[] rowDefine = dtDefine.Select("command_id='" + cmdId + "'"); if (rowDefine != null && rowDefine.Length > 0) { cmdName = Convert.ToString(rowDefine[0]["command_name"]); memo = Convert.ToString(rowDefine[0]["memo"]); } } parameter = Convert.ToString(rowExtJob[0]["value"]); } sb.Append("\n"); sb.Append(Properties.Resources.extend_job_label_text); if (!LoginSetting.Lang.StartsWith("ja_")) { sb.Append(" "); /* added by YAMA 2014/12/15 V2.1.0 No32 対応 */ } sb.Append(cmdName); sb.Append("\n"); sb.Append(Properties.Resources.parameter_label_text); if (!LoginSetting.Lang.StartsWith("ja_")) { sb.Append(" "); /* added by YAMA 2014/12/15 V2.1.0 No32 対応 */ } sb.Append(parameter); sb.Append("\n"); //added by YAMA 2014/12/04 sb.Append(Properties.Resources.memo_col_head_textToolTip); if (!LoginSetting.Lang.StartsWith("ja_")) { sb.Append(" "); /* added by YAMA 2014/12/15 V2.1.0 No32 対応 */ } sb.Append(memo); picToolTip.ToolTip = sb.ToString(); }