protected virtual void ExportData(DataTable dataTbl, Export.ExportFormat outputFormat, int[] columnList, string[] headerList)
{
try
{
switch (outputFormat)
{
case Export.ExportFormat.Excel:
this.saveFileDialog.DefaultExt = "xls";
this.saveFileDialog.Filter = "Microsoft Excel(*.xls)|*.xls";
break;
case Export.ExportFormat.CSV:
this.saveFileDialog.DefaultExt = "csv";
this.saveFileDialog.Filter = "Van ban(*.csv)|*.csv";
break;
case Export.ExportFormat.XML:
this.saveFileDialog.DefaultExt = "html";
this.saveFileDialog.Filter = "Trang web(*.html)|*.html";
break;
default: return;
}
this.saveFileDialog.CheckPathExists = true;
this.saveFileDialog.AddExtension = true;
this.saveFileDialog.RestoreDirectory = true;
this.saveFileDialog.Title = "Thu muc luu tap tin ?";
if (this.saveFileDialog.ShowDialog() != DialogResult.OK)
{
return;
}
// Get the datatable to export
DataTable dtTbl = dataTbl.Copy();
common.Export.ExportToExcel(dtTbl, this.saveFileDialog.FileName, columnList, headerList);
dtTbl.Dispose();
common.sysLibs.ShowMessage("Đã xuất dữ liệu ra tập tin : " + this.saveFileDialog.FileName);
}
catch (Exception er)
{
common.sysLibs.ShowMessage("Xuất dữ liệu gặp lỗi.\n\r\n\r" + er.Message.ToString());
}
}
protected virtual void ExportData(DataTable dataTbl, Export.ExportFormat outputFormat, int[] columnList)
{
ExportData(dataTbl, outputFormat, columnList, null);
}
protected virtual void ExportData(DataTable dataTbl, Export.ExportFormat outputFormat)
{
ExportData(dataTbl, outputFormat, null, null);
}
