public TransitionViewer(DataManager dataManager) { if (dataManager == null) { throw new ArgumentNullException("dataManager"); } InitializeComponent(); _dataManager = dataManager; // DBから初期設定情報を読み込む。 _settings = _dataManager.GetTransitionViewerSettings(); this.comboBox_KindOfAmount.Items.AddRange(_dataManager.GetKindOfSpendingList()); this.comboBox_KindOfAmount.SelectedIndex = _settings.kindOfAmountID; this.dateTimePicker_From.ValueChanged -= new EventHandler(this.dateTimePicker_From_ValueChanged); this.dateTimePicker_To.ValueChanged -= new EventHandler(this.dateTimePicker_To_ValueChanged); this.dateTimePicker_From.Value = _settings.monthFrom; this.dateTimePicker_To.Value = _settings.monthTo; this.dateTimePicker_From.ValueChanged += new EventHandler(this.dateTimePicker_From_ValueChanged); this.dateTimePicker_To.ValueChanged += new EventHandler(this.dateTimePicker_To_ValueChanged); this.dataGridView_DetailViewer.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.False; this.dataGridView_DetailViewer.Font = new Font("メイリオ", 12, FontStyle.Regular); this.dataGridView_DetailViewer.EnableHeadersVisualStyles = false; this.dataGridView_DetailViewer.ColumnHeadersDefaultCellStyle.BackColor = CommonConst.TableHeaderColor; this.dataGridView_DetailViewer.Columns[0].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; this.dataGridView_DetailViewer.Columns[1].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; this.dataGridView_DetailViewer.Columns[2].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; this.dataGridView_DetailViewer.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; this.dataGridView_DetailViewer.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; this.dataGridView_DetailViewer.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; foreach (ChartArea a in this.chart_Transition.ChartAreas) { a.AxisY.LabelStyle.Format = "C"; } }
/// <summary> /// 家計の推移閲覧画面の初期表示内容を決定するためのパラメータをDBに保存する。 /// </summary> /// <returns></returns> public void SetTransitionViewerSettings(TransitionViewerSettings settings) { _command.CommandText = "update 家計の推移画面設定 "; _command.CommandText += "set 設定値='" + settings.monthFrom.ToString("yyyy/MM") + "' "; _command.CommandText += "where 設定項目='開始年月'"; _command.ExecuteNonQuery(); _command.CommandText = "update 家計の推移画面設定 "; _command.CommandText += "set 設定値='" + settings.monthTo.ToString("yyyy/MM") + "' "; _command.CommandText += "where 設定項目='終了年月'"; _command.ExecuteNonQuery(); _command.CommandText = "update 家計の推移画面設定 "; _command.CommandText += "set 設定値='" + settings.kindOfAmountID + "' "; _command.CommandText += "where 設定項目='費用項目ID'"; _command.ExecuteNonQuery(); }