public static void Export(int exportType, string name, DevExpress.XtraGrid.Views.Grid.GridView gridView)
{
SaveFileDialog saveFile = new SaveFileDialog();
string title = name + "_export_" + DateTime.Now.ToString("dd_MM_yyyy");
switch (exportType)
{
case Utilities.EXPORT_EXCEL:
title += ".xlsx";
break;
case Utilities.EXPORT_PDF:
title += ".pdf";
break;
}
saveFile.FileName = title;
if (saveFile.ShowDialog() == DialogResult.OK)
{
switch (exportType)
{
case Utilities.EXPORT_EXCEL:
gridView.ExportToXlsx(saveFile.FileName);
break;
case Utilities.EXPORT_PDF:
gridView.ExportToPdf(saveFile.FileName);
break;
}
}
}
public void ViewExcel(DevExpress.XtraGrid.Views.Grid.GridView view, string name)
{
string targetFilename = "D:\\Danhsach.xlsx";
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.FileName = name;
saveFileDialog1.Filter = "Excel 2007 files (*.xlsx)|*.xlsx|All files (*.*)|*.*";
saveFileDialog1.FilterIndex = 1;
saveFileDialog1.RestoreDirectory = true;
saveFileDialog1.OverwritePrompt = false;
if (saveFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
targetFilename = saveFileDialog1.FileName;
System.Globalization.CultureInfo customCulture = (System.Globalization.CultureInfo)System.Threading.Thread.CurrentThread.CurrentCulture.Clone();
customCulture.NumberFormat.NumberGroupSeparator = ",";
customCulture.NumberFormat.NumberDecimalSeparator = ".";
System.Threading.Thread.CurrentThread.CurrentCulture = customCulture;
view.ExportToXlsx(targetFilename);
customCulture.NumberFormat.NumberGroupSeparator = ".";
customCulture.NumberFormat.NumberDecimalSeparator = ",";
System.Threading.Thread.CurrentThread.CurrentCulture = customCulture;
DialogResult dr = DevExpress.XtraEditors.XtraMessageBox.Show("Bạn có muốn mở tập tin?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
if (dr == DialogResult.Yes)
{
Process p = new Process();
p.StartInfo = new ProcessStartInfo(targetFilename);
p.Start();
}
}
