Example #1
0
        /// <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"]);
            }

            dbAccess.CreateSqlConnect();

            if (LoginSetting.Authority == Consts.AuthorityEnum.SUPER)
            {
                _jobNetTable = _jobnetControlDAO.GetInfoByUserIdSuper();
            }
            else
            {
                _jobNetTable = _jobnetControlDAO.GetInfoByUserId(LoginSetting.UserID);
            }

            combJobNetId.ItemsSource       = _jobNetTable.DefaultView;
            combJobNetId.DisplayMemberPath = Convert.ToString(_jobNetTable.Columns["jobnet_id"]);
            combJobNetId.SelectedValuePath = Convert.ToString(_jobNetTable.Columns["jobnet_id"]);

            // タスクアイコン設定テーブルのデータを取得
            DataRow[] rowTask;
            if (_myJob.ContentItem.InnerJobId == null)
            {
                rowTask = _myJob.Container.IconTaskTable.Select("job_id='" + jobId + "'");
            }
            else
            {
                rowTask = _myJob.Container.IconTaskTable.Select("inner_job_id=" + _myJob.ContentItem.InnerJobId);
            }
            if (rowTask != null && rowTask.Length > 0)
            {
                string jobNetId = Convert.ToString(rowTask[0]["submit_jobnet_id"]);
                combJobNetId.SelectedValue = jobNetId;

                DataTable dtJobNet = _jobnetControlDAO.GetValidORMaxUpdateDateEntityById(jobNetId);
                if (dtJobNet != null && dtJobNet.Rows.Count > 0)
                {
                    tbJobNetName.Text = Convert.ToString(dtJobNet.Rows[0]["jobnet_name"]);
                }
            }
            dbAccess.CloseSqlConnect();
        }