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