/// <summary>
/// 削除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected override async void ButtonF6_Click(object sender, EventArgs e)
{
try
{
Logger.WriteLine(MethodBase.GetCurrentMethod().Name);
base.ButtonF6_Click(sender, e);
// ▼▼▼ 業務処理 ▼▼▼
if (DialogResult.OK == MessageBox.Show("削除します。よろしいですか？", "確認", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2))
{
FormKakeiboSqlService sv = FormKakeiboSqlService.GetInstance(this);
int ret = sv.Delete(gridRireki);
if (ret > 0)
{
// 画面更新
await Search(sv);
MessageBox.Show($"{ret}件削除しました。");
}
else
{
Debug.WriteLine($"{MethodBase.GetCurrentMethod().Name} Error:{ret}");
}
}
// ▲▲▲ 業務処理 ▲▲▲
}
catch (Exception ex)
{
Logger.WriteException(MethodBase.GetCurrentMethod().Name, ex);
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 登録
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected async override void ButtonF1_Click(object sender, EventArgs e)
{
try
{
Logger.WriteLine(MethodBase.GetCurrentMethod().Name);
base.ButtonF1_Click(sender, e);
// ▼▼▼ 業務処理 ▼▼▼
FormKakeiboSqlService sv = FormKakeiboSqlService.GetInstance(this);
// 登録
int ret = sv.Touroku();
if (ret != 1)
{
Logger.WriteLine($"登録処理でエラーが発生しました。ErrorCode[{ret}]");
}
// 検索
ret = await Search(sv);
if (ret < 0)
{
Logger.WriteLine($"検索処理でエラーが発生しました。ErrorCode[{ret}]");
}
// ▲▲▲ 業務処理 ▲▲▲
}
catch (Exception ex)
{
Logger.WriteException(MethodBase.GetCurrentMethod().Name, ex);
MessageBox.Show(ex.Message);
}
}
private void GridRireki_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
try
{
// 更新処理
FormKakeiboSqlService sv = FormKakeiboSqlService.GetInstance(this);
int ret = sv.UpdateAll();
}
catch (Exception ex)
{
Logger.WriteException(MethodBase.GetCurrentMethod().Name, ex);
MessageBox.Show(ex.Message);
}
}
private void ComboBoxShukeiMode_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
Logger.WriteLine($"{MethodBase.GetCurrentMethod().Name}");
FormKakeiboSqlService sv = FormKakeiboSqlService.GetInstance(this);
DataTable rireki = (gridRireki.DataSource as BindingSource).DataSource as DataTable;
DataTable shukei = sv.GetShukeiTable(rireki);
gridShukei.Columns.Clear();
(gridShukei.DataSource as BindingSource).DataSource = shukei;
}
catch (Exception ex)
{
Logger.WriteException(MethodBase.GetCurrentMethod().Name, ex);
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// フォームロード
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void FormKakeibo_Load(object sender, EventArgs e)
{
try
{
Logger.WriteLine($"{MethodBase.GetCurrentMethod().Name}");
dateTimePicker1.Value = DateTime.Now;
dtpFrom.Value = DateTime.Now.AddMonths(-1);
dtpTo.Value = DateTime.Now;
FormKakeiboSqlService sv = FormKakeiboSqlService.GetInstance(this);
await Search(sv);
}
catch (Exception ex)
{
Logger.WriteException(MethodBase.GetCurrentMethod().Name, ex);
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 検索処理
/// </summary>
/// <param name="sv"></param>
/// <returns>取得件数</returns>
private async Task <int> Search(FormKakeiboSqlService sv)
{
Logger.StartMethod(MethodBase.GetCurrentMethod().Name);
gridRireki.DataSource = new BindingSource();
gridShukei.DataSource = new BindingSource();
// 新規Model生成
Model = new FormKakeiboSqlService.ModelKakeibo();
// 履歴・残金を読み込む
int ret = await sv.GetKakeiboData(Model);
if (ret >= 0)
{
// 検索結果を画面に設定
SetScreenValues(Model);
// 残金を編集不可にする
gridRireki.Columns["zankin"].ReadOnly = true;
// スクロールを最終に移動
gridRireki.ScrollToLast();
// 選択を解除
gridRireki.ClearSelection();
// 最終行を選択
int lastindex = gridRireki.Rows.GetLastRow(DataGridViewElementStates.None);
if (lastindex >= 0)
{
gridRireki.Rows[lastindex].Selected = true;
}
}
Logger.EndMethod(MethodBase.GetCurrentMethod().Name, ret.ToString());
return(ret);
}
private async void BtnRirekiChange_Click(object sender, EventArgs e)
{
FormKakeiboSqlService sv = FormKakeiboSqlService.GetInstance(this);
await Search(sv);
}
