protected void ASPxMenu1_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e) { if (e.Item.Name == "ExportXLSItem") { ServerGridViewExporter.ExportXlsToResponse("DailyMemoryUsed.xls"); } else if (e.Item.Name == "ExportXLSXItem") { ServerGridViewExporter.ExportXlsxToResponse("DailyMemoryUsed.xlsx"); } else if (e.Item.Name == "ExportPDFItem") { //ServerGridViewExporter.Landscape = true; using (MemoryStream ms = new MemoryStream()) { PrintableComponentLink pcl = new PrintableComponentLink(new PrintingSystem()); pcl.Component = ServerGridViewExporter; pcl.Margins.Left = pcl.Margins.Right = 50; pcl.Landscape = true; pcl.CreateDocument(false); pcl.PrintingSystem.Document.AutoFitToPagesWidth = 1; pcl.ExportToPdf(ms); WriteResponse(this.Response, ms.ToArray(), System.Net.Mime.DispositionTypeNames.Attachment.ToString()); //ServerGridViewExporter.WritePdfToResponse(); } } }
protected void EventSettings_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e) { if (e.Item.Name == "ExportXLSItem") { if (startDate.Value != "") { ServerGridViewExporter.FileName = "EventsHistory" + "_" + startDate.Value; ServerGridViewExporter.WriteXlsToResponse(); } else { ServerGridViewExporter.FileName = "EventsHistory" + "_" + DateTime.Now.ToString(); ServerGridViewExporter.WriteXlsToResponse(); } } else if (e.Item.Name == "ExportXLSXItem") { if (startDate.Value != "") { ServerGridViewExporter.FileName = "EventsHistory" + "_" + startDate.Value; ServerGridViewExporter.WriteXlsxToResponse(); } else { ServerGridViewExporter.FileName = "EventsHistory" + "_" + DateTime.Now.ToString(); ServerGridViewExporter.WriteXlsxToResponse(); } } else if (e.Item.Name == "ExportPDFItem") { if (startDate.Value != "") { ServerGridViewExporter.FileName = "EventsHistory" + "_" + startDate.Value; //ServerGridViewExporter.WriteXlsxToResponse(); } else { ServerGridViewExporter.FileName = "EventsHistory" + "_" + DateTime.Now.ToString(); //ServerGridViewExporter.WriteXlsxToResponse(); } ServerGridViewExporter.Landscape = true; using (MemoryStream ms = new MemoryStream()) { PrintableComponentLink pcl = new PrintableComponentLink(new PrintingSystem()); pcl.Component = ServerGridViewExporter; pcl.Margins.Left = pcl.Margins.Right = 50; pcl.Landscape = true; pcl.CreateDocument(false); pcl.PrintingSystem.Document.AutoFitToPagesWidth = 1; pcl.ExportToPdf(ms); WriteResponse(this.Response, ms.ToArray(), System.Net.Mime.DispositionTypeNames.Attachment.ToString()); //ServerGridViewExporter.WritePdfToResponse(); } } }
protected void ExportPdfButton_Click(object sender, EventArgs e) { ServerGridViewExporter.WritePdfToResponse(); }
protected void ExportXlsButton_Click(object sender, EventArgs e) { //AlertsHistory.SettingsText.Title = DateTime.Now.ToString(); ServerGridViewExporter.WriteXlsToResponse(); }