private void XuatExcel(string titleName, ShGridControl grvData)
{
try
{
var svd = new SaveFileDialog();
svd.Title = "Chọn nơi lưu file...";
svd.Filter = "Excel Workbook|*.xlsx|Excel 97-2003 Workbook|*.xls";
svd.FileName = string.Format("{0}_{1}", titleName, DateTime.Now.ToString("ddMMyyyy_HH_mm"));
svd.OverwritePrompt = true;
if (svd.ShowDialog() == DialogResult.Cancel)
{
return;
}
if (svd.FileName.EndsWith("xlsx"))
{
grvData.MainView.As <GridView>().OptionsPrint.AutoWidth = false;
grvData.ExportToXlsx(svd.FileName, new XlsxExportOptions {
TextExportMode = TextExportMode.Text, ExportMode = XlsxExportMode.SingleFile
});
new MessageBoxBA().Show("Kết xuất file excel thành công!", "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Information);
}
else
{
grvData.ExportToXls(svd.FileName, new XlsExportOptions {
TextExportMode = TextExportMode.Text, ExportMode = XlsExportMode.SingleFile
});
}
}
catch (Exception ex)
{
LogError.WriteLogError("XuatExcel: ", ex);
}
}
/// <summary>
/// Lấy lại cầu hình mặc định ban đầu
/// </summary>
/// <param name="grid"></param>
public static void GetLayOutDefault(ShGridControl grid)
{
string fileName = Application.StartupPath + "\\LayoutGrid\\" + grid.Name + "_Layout.xml";
if (File.Exists(fileName))
{
grid.MainView.RestoreLayoutFromXml(fileName);
SaveLayoutGrid(grid);
}
}
/// <summary>
/// Lưu lại layout tại thời điểm hiện tại
/// </summary>
/// <param name="grid"></param>
public static void SaveLayoutGrid(ShGridControl grid)
{
foreach (GridColumn col in ((ColumnView)grid.Views[0]).Columns)
{
ConfigLayout conf = new ConfigLayout();
conf.GridName = grid.Name;
conf.ColumnName = col.Name;
conf.Width = col.Width;
conf.VisibleIndex = col.VisibleIndex;
conf.Visible = col.Visible;
conf.UserID = ThongTinDangNhap.USER_ID;
conf.SaveLayout();
}
}
/// <summary>
/// Lấy layout lần lưu gần đây nhất
/// </summary>
/// <param name="grid"></param>
public static void GetLayOutGrid(ShGridControl grid)
{
List <ConfigLayout> lstConfigLayout = ConfigLayout.Inst.GetLayoutGrid(grid.Name, ThongTinDangNhap.USER_ID);
if (lstConfigLayout != null && lstConfigLayout.Count > 0)
{
foreach (GridColumn col in ((ColumnView)grid.Views[0]).Columns)
{
ConfigLayout item = lstConfigLayout.Where(x => x.ColumnName == col.Name).First();
col.Width = item.Width;
col.Visible = item.Visible;
col.VisibleIndex = item.VisibleIndex;
}
}
}
public static void SaveLayoutDefault(ShGridControl grid)
{
string fileName = Application.StartupPath;
fileName += "\\LayoutGrid";
if (!Directory.Exists(fileName))
{
Directory.CreateDirectory(fileName);
}
fileName += "\\" + grid.Name + "_Layout.xml";
if (!File.Exists(fileName))
{
grid.MainView.SaveLayoutToXml(fileName);
}
GetLayOutGrid(grid);
}
