/// <summary>
/// The report button_ click.
/// </summary>
/// <param name="sender">
/// The sender.
/// </param>
/// <param name="e">
/// The e.
/// </param>
private void ReportButtonClick(object sender, EventArgs e)
{
var milestoneReportDal = new MilestoneReportDal();
var milestoneReportCommonInfo = milestoneReportDal.GetMilestoneReportCommonInfo();
var startDate = Convert.ToDateTime("01.09.2017");
var finishDate = Convert.ToDateTime("30.09.2017");
var dates_filter_type = 1;
var case_id = 9;
// var milestoneReportData = milestoneReportDal.GetMilestoneReportData(startDate, finishDate, dates_filter_type, case_id, "11169", 20);
var milestoneReportData = milestoneReportDal.GetMilestoneReportData(startDate, finishDate, dates_filter_type, case_id, string.Empty, 2000);
var report = new Report();
report.Load(this.ReportTemplatePathTextBox.Text);
report.RegisterData(milestoneReportCommonInfo, "CommonInfo");
report.RegisterData(milestoneReportData, "Data");
if (this.DesignModeCheckBox.Checked)
{
report.Design(false);
}
else
{
report.Show(false);
}
}
protected void MilestoneReportButtonClick(object sender, EventArgs e)
{
var milestoneReportDal = new MilestoneReportDal();
var startDate = Convert.ToDateTime("01.09.2017");
var finishDate = DateTime.Now;
var dates_filter_type = 1;
var case_id = 9;
var milestoneReportDataList = milestoneReportDal.GetMilestoneReportData(startDate, finishDate, dates_filter_type, case_id, "11169"); // Получение данных только для одного договора
// var milestoneReportDataList = milestoneReportDal.GetMilestoneReportData(startDate, finishDate, dates_filter_type, case_id, string.Empty); // Получение данных для всех договоров
// Получение полного списка категорий
var fullMilestoneCategoriesInfoList = milestoneReportDal.GetMilestoneFullCategoriesInfoList(); // Получение полного списка категорий контрольных точек
var filteredMilestoneCategoriesInfoList = fullMilestoneCategoriesInfoList.Where(c => c.CatId == 4); // Фильтрация категорий контрольных точек (только те категории, которые надо вывести на экран)
// Вывод на экран только выбранных категорий контрольных точек
this.CreateGridStructure(milestoneReportDataList, filteredMilestoneCategoriesInfoList);
this.MSGridView.DataSource = this.PrepareForDataBinding(milestoneReportDataList, filteredMilestoneCategoriesInfoList);
// Вывод на экран только тех контрольных точек, по которым есть данные
//this.CreateGridStructure(milestoneReportDataList);
//this.MSGridView.DataSource = this.PrepareForDataBinding(milestoneReportDataList); // Создание данных для биндинга
this.MSGridView.DataBind();
}
/// <summary>
/// The report from db butto_ click.
/// </summary>
/// <param name="sender">
/// The sender.
/// </param>
/// <param name="e">
/// The e.
/// </param>
private void ReportFromDbButtoClick(object sender, EventArgs e)
{
var milestoneReportDal = new MilestoneReportDal();
var milestoneReportCommonInfo = milestoneReportDal.GetMilestoneReportCommonInfo();
var startDate = Convert.ToDateTime("01.09.2017");
var finishDate = Convert.ToDateTime("30.09.2017");
var dates_filter_type = 1;
var case_id = 9;
var milestoneReportData = milestoneReportDal.GetMilestoneReportData(startDate, finishDate, dates_filter_type, case_id, "12181", 20);
var report = new Report();
var reportTemplate = this.ReadReportTemplate("MilestoneReport");
report.Load(reportTemplate);
report.RegisterData(milestoneReportCommonInfo, "CommonInfo");
report.RegisterData(milestoneReportData, "Data");
report.Show(false);
}
/// <summary>
/// The export button_ click.
/// </summary>
/// <param name="sender">
/// The sender.
/// </param>
/// <param name="e">
/// The e.
/// </param>
private void ExportButtonClick(object sender, EventArgs e)
{
var milestoneReportDal = new MilestoneReportDal();
var milestoneReportCommonInfo = milestoneReportDal.GetMilestoneReportCommonInfo();
var startDate = Convert.ToDateTime("01.09.2017");
var finishDate = Convert.ToDateTime("30.09.2017");
var dates_filter_type = 1;
var case_id = 9;
var milestoneReportData = milestoneReportDal.GetMilestoneReportData(startDate, finishDate, dates_filter_type, case_id, "12181", 20);
var report = new Report();
report.Load(this.ReportTemplatePathTextBox.Text);
report.RegisterData(milestoneReportCommonInfo, "CommonInfo");
report.RegisterData(milestoneReportData, "Data");
report.Prepare();
//// var xmlExport = new XMLExport { OpenAfterExport = true };
//// report.Export(xmlExport, "D:\\DupelReport.xml");
//// var pptExport = new PowerPoint2007Export{ OpenAfterExport = true };
//// report.Export(pptExport, "D:\\DupelReport.ppt");
var excelExport = new Excel2007Export {
OpenAfterExport = true
};
report.Export(excelExport, "D:\\DupelReport.xlsx");
////var worldExport = new Word2007Export { OpenAfterExport = true };
////report.Export(worldExport, "D:\\DupelReport.doc");
//var pdfExport = new PDFExport { OpenAfterExport = true };
//report.Export(pdfExport, @"D:\DupelReport.pdf");
}
