public static void ExportXLS(GridControl grid, string tenBaoCao, string FileName)
{
#region Thiết kế trước khi in
if(grid != null)
{
GridView view = grid.MainView as GridView;
if(view != null)
{
//view.AppearancePrint.EvenRow.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.EvenRow.Options.UseFont = true;
//view.AppearancePrint.FilterPanel.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.FilterPanel.Options.UseFont = true;
//view.AppearancePrint.FooterPanel.BorderColor = System.Drawing.Color.Black;
//view.AppearancePrint.FooterPanel.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.FooterPanel.Options.UseBorderColor = true;
//view.AppearancePrint.FooterPanel.Options.UseFont = true;
//view.AppearancePrint.GroupFooter.BorderColor = System.Drawing.Color.Black;
//view.AppearancePrint.GroupFooter.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.GroupFooter.Options.UseBorderColor = true;
//view.AppearancePrint.GroupFooter.Options.UseFont = true;
//view.AppearancePrint.GroupRow.BorderColor = System.Drawing.Color.Black;
//view.AppearancePrint.GroupRow.Font = new System.Drawing.Font("Times New Roman", 11F, System.Drawing.FontStyle.Bold);
//view.AppearancePrint.GroupRow.Options.UseBorderColor = true;
//view.AppearancePrint.GroupRow.Options.UseFont = true;
//view.AppearancePrint.HeaderPanel.BorderColor = System.Drawing.Color.Black;
//view.AppearancePrint.HeaderPanel.Font = new System.Drawing.Font("Times New Roman", 11F, System.Drawing.FontStyle.Bold);
//view.AppearancePrint.HeaderPanel.Options.UseBorderColor = true;
//view.AppearancePrint.HeaderPanel.Options.UseFont = true;
//view.AppearancePrint.HeaderPanel.Options.UseTextOptions = true;
//view.AppearancePrint.HeaderPanel.Options.UseBackColor = true;
//view.AppearancePrint.HeaderPanel.BackColor = Color.FromArgb(192, 255, 255);
//view.AppearancePrint.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
//view.AppearancePrint.HeaderPanel.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
//view.AppearancePrint.Lines.BackColor = System.Drawing.Color.Black;
//view.AppearancePrint.Lines.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.Lines.Options.UseBackColor = true;
//view.AppearancePrint.Lines.Options.UseFont = true;
//view.AppearancePrint.OddRow.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.OddRow.Options.UseFont = true;
//view.AppearancePrint.Preview.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.Preview.Options.UseFont = true;
//view.AppearancePrint.Row.BorderColor = System.Drawing.Color.Black;
//view.AppearancePrint.Row.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.Row.Options.UseBorderColor = true;
//view.AppearancePrint.Row.Options.UseFont = true;
//view.AppearancePrint.EvenRow.BackColor = Color.MintCream;
//view.OptionsPrint.EnableAppearanceEvenRow = true;
}
}
#endregion
var r = new rptCommon();
r.m_lbl_ten_bao_cao.Text = tenBaoCao.ToUpper();
//r.PaperKind = System.Drawing.Printing.PaperKind.A4;
//r.Landscape = true;
//r.TenCoSo = "Khách sạn Sao Mai"; // tu tu tính
//r.DiaChi = "384 Nguyễn Văn Linh, Dư Hàng Kênh – Lê Chân – Hải Phòng"; // tu tu tinh
r.Bands[BandKind.Detail].Controls.Add(CopyGridControl(grid));
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "xls files (*.xls)|*.xls|All files (*.*)|*.*";
saveFileDialog1.RestoreDirectory = true;
saveFileDialog1.FileName = FileName;
if(saveFileDialog1.ShowDialog() == DialogResult.OK)
{
XlsExportOptions opt = new XlsExportOptions();
opt.TextExportMode = TextExportMode.Value;
r.ExportToXls(saveFileDialog1.FileName, opt);
XtraMessageBox.Show("Xuất báo cáo thành công!", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}