/// <summary>
/// データグリッドに検索結果を表示します
/// </summary>
private void SearchExecute()
{
SqlBuilder.MainViewSearchConditions sc = new SqlBuilder.MainViewSearchConditions();
sc.StatusCodeNotEqual = StatusCode.CODE_FINISHED;
SqlBuilder sql = new SqlBuilder(sc);
List <TodoTask> tasks = _dbAccessor_.TodoTaskSelect(sql);
this.DataGridItemsSource.Clear();
foreach (var task in tasks)
{
this.DataGridItemsSource.Add(task);
}
}
/// <summary>
/// ボタン〔検索〕押下処理
/// </summary>
private void SearchCommandExecute()
{
SqlBuilder.EditViewSearchConditions sc = new SqlBuilder.EditViewSearchConditions();
sc.Text = this.SearchConditionsText.Value;
sc.DueDateFrom = this.SearchConditionsTextDueDateFrom.Value;
sc.DueDateTo = this.SearchConditionsTextDueDateTo.Value;
SqlBuilder sql = new SqlBuilder(sc);
List <TodoTask> tasks = _dbAccessor_.TodoTaskSelect(sql);
this.DataGridItemsSource.Clear();
foreach (var task in tasks)
{
this.DataGridItemsSource.Add(task);
}
}
/// <summary>
/// ボタン〔エクスポート〕押下処理
/// </summary>
private void ExportCommandExecute()
{
SqlBuilder.FileViewExportSearchConditions sc = new SqlBuilder.FileViewExportSearchConditions();
sc.ExportStatusExceptFinished = this.ExportStatusExceptFinished.Value;
sc.ExportDueDateFrom = this.ExportDueDateFrom.Value;
sc.ExportDueDateTo = this.ExportDueDateTo.Value;
SqlBuilder sql = new SqlBuilder(sc);
List <TodoTask> tasks = _dbAccessor_.TodoTaskSelect(sql);
string exportPathAndFileName = this.ExportPathAndFileName.Value;
XlsxWriter.FileViewExport(exportPathAndFileName, tasks);
this.MainWindow.ShowMessageAsync("データのエクスポート", Path.GetFileName(exportPathAndFileName) + " にデータを出力しました。");
this.ExportPathAndFileName.Value = string.Empty;
}