private void exportButton_Click(object sender, EventArgs e)
{
var reportName = (string)reportsNames.SelectedItem;
var exportType = (string)exportTypes.SelectedItem;
IDocumentExportEx documentExportEx = null;
var report = new SectionReport();
System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(@"..\..\..\..\Reports\" + reportName);
report.LoadLayout(xtr);
report.Run();
var exporTypeLower = exportType.ToLower();
switch (exporTypeLower)
{
case _pdf:
documentExportEx = new GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport();
break;
case _xlsx:
documentExportEx = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport()
{
FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx
};
break;
case _rtf:
documentExportEx = new GrapeCity.ActiveReports.Export.Word.Section.RtfExport();
break;
case _mht:
documentExportEx = new GrapeCity.ActiveReports.Export.Html.Section.HtmlExport();
break;
case _csv:
documentExportEx = new GrapeCity.ActiveReports.Export.Xml.Section.TextExport();
break;
}
var fileName = Path.GetFileNameWithoutExtension(reportName);
var saveFileDialog = new SaveFileDialog()
{
FileName = fileName + GetSaveDialogExtension(exporTypeLower),
Filter = GetSaveDialogFilter(exporTypeLower)
};
if (saveFileDialog.ShowDialog() != DialogResult.OK)
{
return;
}
exportButton.Enabled = false;
using (var stream = new FileStream(Path.Combine(saveFileDialog.FileName), FileMode.Create))
documentExportEx.Export(report.Document, stream);
exportButton.Enabled = true;
}
private void PrintActiveRecordsLabel(InventurlistenArt la)
{
PageDocument pageDocument = null;
switch (la)
{
case InventurlistenArt.Zaehliste:
{
pageDocument = ActiveReportsTools <int> .GetDocument(StaticMethods.GetPath(@"Drucklisten\Inventurliste.rdlx"));
pageDocument.LocateDataSource += new GrapeCity.ActiveReports.LocateDataSourceEventHandler(pageDocument_LocateDataSource);
break;
}
case InventurlistenArt.Differenzliste:
{
pageDocument = ActiveReportsTools <int> .GetDocument(StaticMethods.GetPath(@"Drucklisten\Differenzliste.rdlx"));
pageDocument.LocateDataSource += new GrapeCity.ActiveReports.LocateDataSourceEventHandler(pageDocument_LocateDataSource);
break;
}
case InventurlistenArt.Artikelliste:
{
pageDocument = ActiveReportsTools <int> .GetDocument(StaticMethods.GetPath(@"Drucklisten\Artikelliste.rdlx"));
pageDocument.LocateDataSource += new GrapeCity.ActiveReports.LocateDataSourceEventHandler(pageDocument_LocateDataSource);
if (DoExportExcel)
{
string fName = ConfigEntry <string> .GetConfigEntry("ArtikellisteExport", @"F:\ALLGEMEIN\EDV\Datenbank_Neu\Export\Artikellisten\liste.xls");
GrapeCity.ActiveReports.Export.Excel.Section.XlsExport XLSExport1 = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport();
XLSExport1.Export(pageDocument, fName);
}
break;
}
default:
break;
}
viewer1.LoadDocument(pageDocument);
}
private void ExcelSimpleButton_Click(object sender, EventArgs e)
{
try
{
var _file = string.Format(@"{0}.xlsx", DateTime.Now.Ticks);
GrapeCity.ActiveReports.Export.Excel.Section.XlsExport PdfExport1 = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport();
PdfExport1.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx;
PdfExport1.Export(this._doc, "ExportFile\\" + _file);
if (MessageBox.Show("File Exported Successfully, Do You want to open File ?", "Export",
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string windir = Environment.GetEnvironmentVariable("WINDIR");
Process prc = new Process();
prc.StartInfo.FileName = windir + @"\explorer.exe";
prc.StartInfo.Arguments = "ExportFile\\" + _file;;
prc.Start();
}
}
catch (Exception ex)
{
Serilog.Log.Error(ex, "excel Export");
MessageBox.Show(ex.ToString());
}
}
