/// <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);
}
}
/// <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);
}
}
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);
}
}
private async void BtnRirekiChange_Click(object sender, EventArgs e)
{
FormKakeiboSqlService sv = FormKakeiboSqlService.GetInstance(this);
await Search(sv);
}