public static byte[] GetExportData(ASPxGridViewExporter exporter, ExportType type) { byte[] data = null; if (exporter != null) { exporter.DataBind(); using (MemoryStream ms = new MemoryStream()) { switch (type) { case ExportType.XLS: exporter.WriteXls(ms); break; case ExportType.PDF: exporter.WritePdf(ms); break; case ExportType.CSV: exporter.WriteCsv(ms); break; case ExportType.RTF: exporter.WriteRtf(ms); break; default: break; } data = ms.GetBuffer(); } } return(data); }
protected void Page_Load(object sender, EventArgs e) { try { using (MemoryStream ms = new MemoryStream()) { PrintableComponentLink pcl = new PrintableComponentLink(new PrintingSystem()); ASPxGridViewExporter export = (ASPxGridViewExporter)Session["exporter"]; export.Styles.Header.Wrap = DevExpress.Utils.DefaultBoolean.True; export.MaxColumnWidth = 180; pcl.Component = export; pcl.Margins.Left = pcl.Margins.Right = 10; pcl.Landscape = true; pcl.CreateDocument(false); pcl.PrintingSystem.Document.AutoFitToPagesWidth = 0; pcl.ExportToPdf(ms); WriteResponse(this.Response, ms.ToArray(), System.Net.Mime.DispositionTypeNames.Inline.ToString()); } } catch (Exception ex) { cm.log.Error("Kontrolka : generowanie pdf :" + ex.Message); } }
// Public Methods (3) public static void ExportData(ASPxGridViewExporter exporter, ExportType type) { if (exporter != null) { exporter.DataBind(); switch (type) { case ExportType.XLS: exporter.WriteXlsToResponse(); break; case ExportType.PDF: exporter.WritePdfToResponse(); break; case ExportType.CSV: exporter.WriteCsvToResponse(); break; case ExportType.RTF: exporter.WriteRtfToResponse(); break; default: break; } } }
protected void Grid_ContextMenuItemClick(object sender, ASPxGridViewContextMenuItemClickEventArgs e) { try { switch (e.Item.Name) { case "ExportToPDF": ASPxGridViewExporter.WritePdfToResponse(); break; case "ExportToXLS": ASPxGridViewExporter.WriteXlsToResponse(); break; case "ExportToWORD": ASPxGridViewExporter.WriteRtfToResponse(); break; case "ExportToCSV": ASPxGridViewExporter.WriteCsvToResponse(); break; } } catch (Exception ex) { _Security.ErrorDesscription = ex.Message; _Security.ErrorModule = "Exporting Deleted Loan Applications Inquiry"; _Security.SaveError(); } }
private void SetupASPxGridViewExporter() { gridExporter = new ASPxGridViewExporter { ID = "ASPxGridViewExporter", GridViewID = ChildGrid.ID }; PlaceHolder1.Controls.Add(gridExporter); }
void webExportController_CustomExport(object sender, CustomExportEventArgs e) { if (e.ExportTarget == ExportTarget.Pdf) { ASPxGridViewExporter exporter = e.Printable as ASPxGridViewExporter; exporter.Styles.Default.Font.Name = "Angsana"; //TH SarabunPSK } }
public ASPxGridViewExporter CreateGridExport() { masterGridExport = new ASPxGridViewExporter(); masterGridExport.GridViewID = string.Concat(tableMeta.Children[0], "GridView"); masterGridExport.ID = "GridExport"; masterGridExport.ExportedRowType = GridViewExportedRowType.All; return(masterGridExport); }
protected override void CustomExport(object sender, DevExpress.ExpressApp.SystemModule.CustomExportEventArgs e) { base.CustomExport(sender, e); //Export only selected rows ASPxGridViewExporter exporter = e.Printable as ASPxGridViewExporter; if (exporter != null) { exporter.ExportSelectedRowsOnly = true; } }
protected ASPxGridViewExporter GetGridExporter() { foreach (Control item in this.Controls) { ASPxGridViewExporter exp = item as ASPxGridViewExporter; if (exp != null) { return(exp); } } return(null); }
public static void ExportGridToPdf(string fileName, string gridId, ASPxGridViewExporter exporter) { exporter.GridViewID = gridId; exporter.Landscape = true; exporter.ExportEmptyDetailGrid = false; exporter.LeftMargin = 10; exporter.RightMargin = 10; exporter.MaxColumnWidth = 100; exporter.TopMargin = 10; exporter.BottomMargin = 10; exporter.WritePdfToResponse(fileName, true); }
public static void ExportToPDFFitToPage(ASPxGridViewExporter GridViewExporter, Page pg) { using (MemoryStream ms = new MemoryStream()) { PrintableComponentLinkBase pcl = new PrintableComponentLinkBase(new DevExpress.XtraPrinting.PrintingSystemBase()); pcl.Component = GridViewExporter; pcl.Margins.Left = pcl.Margins.Right = 50; pcl.Landscape = true; pcl.CreateDocument(false); pcl.PrintingSystemBase.Document.AutoFitToPagesWidth = 1; pcl.ExportToPdf(ms); WriteResponse(pg.Response, ms.ToArray(), System.Net.Mime.DispositionTypeNames.Inline.ToString()); } }
/// <summary> /// Creates detail grid view and its header (H3) in a container. /// </summary> /// <param name="container">The container control in which this template is instantiated.</param> public void InstantiateIn(Control container) { parent = container; masterKey = ((GridViewDetailRowTemplateContainer)parent).KeyValue; var gridCreator = new DetailGridCreator(detailTable, masterTableMeta, masterKey, connectionString, permissions); btnExport = buttonExportGrid(); masterGridExport = CreateGridExport(); if (masterTableMeta.Caption.ToLower() == "alterations" || masterTableMeta.Caption.ToLower() == "vehicleorders" || masterTableMeta.Caption.ToLower() == "packinglists" || masterTableMeta.Caption.ToLower() == "dialogs" || masterTableMeta.Caption.ToLower() == "productionsequence") { parent.Controls.Add(btnExport); } parent.Controls.Add(new LiteralControl(string.Format("<h3>{0}</h3>", detailTable.Caption))); parent.Controls.Add(gridCreator.CreateDetailGrid()); parent.Controls.Add(masterGridExport); }
public void InstantiateIn(Control container) { this.grid = (ExportGridView)((GridViewPagerBarTemplateContainer)container).Grid; Table tblContent = new Table(); tblContent.Width = Unit.Percentage(100); TableRow rwContent = new TableRow(); TableCell cellPager = new TableCell(); ASPxGridViewTemplateReplacement replacement = new ASPxGridViewTemplateReplacement(); replacement.ID = "Pager"; replacement.ReplacementType = GridViewTemplateReplacementType.Pager; cellPager.Controls.Add(replacement); rwContent.Cells.Add(cellPager); if (this.ExportTypes != ExportType.none) { String callBackID = String.IsNullOrEmpty(this.grid.ClientInstanceName) ? this.grid.UniqueID.Remove(0, this.grid.UniqueID.LastIndexOf("$") + 1) : this.grid.ClientInstanceName; ASPxGridViewExporter exporter = new ASPxGridViewExporter(); exporter.ID = callBackID + "_Exporter"; exporter.GridViewID = this.grid.ID; this.grid.Controls.Add(exporter); TableCell cellExportTable = new TableCell(); cellExportTable.Width = Unit.Percentage(100); Table tblExport = new Table(); tblExport.HorizontalAlign = HorizontalAlign.Right; TableRow rwExport = new TableRow(); TableCell exportCell = new TableCell(); exportCell.Text = "Export"; rwExport.Cells.Add(exportCell); rwExport.Cells.AddRange(this.GetExportCells(callBackID)); cellExportTable.Controls.Add(tblExport); tblExport.Rows.Add(rwExport); rwContent.Cells.Add(cellExportTable); } tblContent.Rows.Add(rwContent); container.Controls.Add(tblContent); }
protected void btnXlsExport_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { this.hdnClick.Value = "0"; DataSet dataSet = new DataSet(); dataSet = (DataSet)this.Session["TransferGridData"]; this.grdTransfer.DataSource = dataSet; this.grdTransfer.DataBind(); ASPxGridViewExporter aSPxGridViewExporter = this.gridExport; DateTime now = DateTime.Now; aSPxGridViewExporter.FileName = string.Concat("Transfer_Details(", now.ToString("ddMMMMyyyy"), ")"); this.gridExport.WriteXlsToResponse(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void Page_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.GridID)) throw new NullReferenceException("GridID property is null."); grid = NamingContainer.FindControl(GridID) as ASPxGridView; if (grid == null) throw new InvalidOperationException("ASPxGridView control was not found in NamingContainer."); if (string.IsNullOrEmpty(this.SqlDataSourceID)) throw new NullReferenceException("SqlDataSourceID property is null."); sqlDataSource = NamingContainer.FindControl(SqlDataSourceID) as SqlDataSource; if (sqlDataSource == null) throw new InvalidOperationException("SqlDataSourceID control was not found in NamingContainer."); if (string.IsNullOrEmpty(this.GridViewExportID)) throw new NullReferenceException("GridViewExportID property is null."); gridViewExport = NamingContainer.FindControl(GridViewExportID) as ASPxGridViewExporter; if (gridViewExport == null) throw new InvalidOperationException("ASPxGridViewExporter control was not found in NamingContainer."); CreateControlCheckBoxes(); }
private void ExportRegister_Execute(object sender, SimpleActionExecuteEventArgs e) { ASPxGridListEditor listEditor = ((ListView)View).Editor as ASPxGridListEditor; Type TypeObject = View.ObjectTypeInfo.Type; string strObj=""; int countobj = 0; if (View.ObjectTypeInfo.Type == typeof(ReportData)) { foreach (ReportData obj in View.SelectedObjects) { strObj = (strObj == "" ? string.Format("ReportName='{0}'", obj.ReportName) : string.Format("{0} or ReportName='{1}'", strObj, obj.ReportName)); countobj++; } } else { foreach (BaseObject obj in View.SelectedObjects) { strObj = (strObj == "" ? string.Format("Oid='{0}'", obj.Oid) : string.Format("{0} or Oid='{1}'", strObj, obj.Oid)); countobj++; } } if (countobj > 2000) throw new UserFriendlyException(string.Format("Không thể export dữ liệu nhiều hơn 2000 dòng. Bạn đã chọn {0} dòng!!", countobj)); if (strObj != "") { if (listEditor != null) { ASPxGridView gv = listEditor.Grid; using (ASPxGridViewExporter gridViewExporter = new ASPxGridViewExporter()) { using (MemoryStream stream = new MemoryStream()) { //gridViewExporter.WriteXlsToResponse(); gridViewExporter.GridViewID = gv.ID; gridViewExporter.Page = gv.Page; gv.Parent.Controls.Add(gridViewExporter); gv.BeginUpdate(); gv.DataSource = new XPCollection(View.ObjectSpace.Session, TypeObject, CriteriaOperator.Parse(strObj)); gv.DataBind(); gv.EndUpdate(); gridViewExporter.DataBind(); XlsExportOptions xlsExportOptions = new DevExpress.XtraPrinting.XlsExportOptions(); xlsExportOptions.SheetName = View.Caption.Replace(" ", ""); xlsExportOptions.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Value; xlsExportOptions.ShowGridLines = true; gridViewExporter.WriteXls(stream, xlsExportOptions); byte[] buffer = stream.GetBuffer(); string contentType = "application/ms-excel"; string contentDisposition = "attachment; filename=Export_Result.xls"; HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Buffer = false; HttpContext.Current.Response.AppendHeader("Content-Type", contentType); HttpContext.Current.Response.AppendHeader("Content-Transfer-Encoding", "binary"); HttpContext.Current.Response.AppendHeader("Content-Disposition", contentDisposition); HttpContext.Current.Response.BinaryWrite(buffer); HttpContext.Current.Response.End(); } } } } }
internal static void ToolBarClick(ucABM ucABM1, string itemName, ASPxGridView gv, ASPxGridViewExporter ASPxGridViewExporter1) { switch (itemName) { case "btnAdd": ucABM1.LimpiarControles(); FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Add); ucABM1.Visible = true; ucABM1.HeaderText = "Agregar Registro"; break; case "btnEdit": if (FormsHelper.GetSelectedId(gv) != null) { ucABM1.LimpiarControles(); var entity = ucABM1.ReadMethod(FormsHelper.GetSelectedId(gv).Value); FormsHelper.FillControls(entity, ucABM1.tablaABM); FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Edit); ucABM1.Attributes.Add("RecId", entity.RecId.ToString()); ucABM1.Visible = true; ucABM1.HeaderText = "Modificar Registro"; } else { ucABM1.Visible = false; } break; case "btnDelete": if (FormsHelper.GetSelectedId(gv) != null) { FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Delete); ucABM1.Attributes.Add("RecId", FormsHelper.GetSelectedId(gv).ToString()); ucABM1.Visible = true; ucABM1.HeaderText = "Eliminar Registros"; } else { ucABM1.Visible = false; } break; case "btnExport": case "btnExportXls": if (ASPxGridViewExporter1 != null) ASPxGridViewExporter1.WriteXlsToResponse(); break; case "btnExportPdf": if (ASPxGridViewExporter1 != null) ASPxGridViewExporter1.WritePdfToResponse(); break; default: break; } }
/// <summary> /// Page Init event; creates all required controls in a page. /// </summary> /// <param name="sender">The page sending the event.</param> /// <param name="e"></param> protected void Page_Init(object sender, EventArgs e) { var user = HttpContext.Current.Session["user"] as User; int userId = 0; if (user != null) { userId = user.Id; } int assemblyTypeId = HttpContext.Current.Session["assemblyType"].ToString().ToInt32(0); //if (userId == 0 || assemblyTypeId == 0) //{ // invalid state. forced to logout // TODO: User RolePermissionHelper.Logout // RolePermissionHelper.RedirectToLogin(); // Response.Redirect("/Account/Logout.aspx"); //} var masterPage = this.Controls[0] as IMainMaster; if (masterPage == null) { Response.Write("<p>Your master page must implement IMainMaster interface.</p>"); } //Schema is loaded during login var schemaInfo = Application["SchemaInfo"] as SchemaInfo; tableMeta = schemaInfo.Tables.Where(s => s.Name.Equals(tableName, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); if (tableMeta == null) { var page = this.Controls[0] as IMainMaster; page.MainContent.Controls.Add(new LiteralControl(string.Format("<h2>{0}</h2>", "Invalid Page"))); return; } //header info string StationAct = Request.QueryString["StationAct"].ToString(); int ProductionLineId = Convert.ToInt32(Request.QueryString["ProductionLineId"]); string Date1 = Request.QueryString["Date1"].ToString(); //DateTime Date = DateTime.Parse(dt); string header = ""; //parameter to the stored procedure //if it is a stored procedure, use comma as separator for paramater/filter. do not user AND/OR logical operation string queryFilter = null; if (tableMeta.TableType == ETableType.StoredProcedure) { queryFilter = string.Format("Date1={0}{1}ProductionLineId={2}{3}StationAct={4}", Date1, AppConfiguration.SP_FILTER_SEPARATOR, ProductionLineId, AppConfiguration.SP_FILTER_SEPARATOR, StationAct); } else { if (StationAct != "") { queryFilter = "StationAct=" + StationAct; if (ProductionLineId > 0) { queryFilter += " AND ProductionLineId=" + ProductionLineId; } if (Date1 != null) { queryFilter += " AND Date=" + Date1; } } } //create the page var gridCreator = new MasterGrid(this, this.tableMeta); masterGrid = gridCreator.Render(userId, assemblyTypeId, queryFilter); //create filter panel var filterPanelCreator = new FilterPanel(this, this.tableMeta); filterPanel = filterPanelCreator.Render(userId, assemblyTypeId); //create hidden field to store temporary data var field = new ASPxHiddenField(); field.ID = HIDDEN_FIELD_ID; field.ClientInstanceName = HIDDEN_FIELD_ID; //var scriptManager = new ASPxScriptManager(); var panel = new System.Web.UI.WebControls.Panel(); panel.CssClass = "mainContent"; panel.Controls.Add(new LiteralControl(string.Format("<h2 class='grid-header'>{0}</h2>", tableMeta.Caption))); panel.Controls.Add(new LiteralControl(string.Format("<p>" + StationAct + " Line " + ProductionLineId + " On " + Date1 + "</p>"))); if (filterPanel != null) { panel.Controls.Add(filterPanel); } panel.Controls.Add(masterGrid); if (masterGrid.Width.Value > 0) { panel.Width = masterGrid.Width; } panel.Controls.Add(field); if (tableMeta.ShowExportButton) { var buttonPanel = new System.Web.UI.WebControls.Panel(); buttonPanel.CssClass = "grid-button-panel"; buttonPanel.Width = new Unit("100%"); //buttonPanel.BorderWidth = new Unit("1px"); //add export button ASPxButton btnExport = new ASPxButton(); btnExport.ID = "btnExportGrid"; btnExport.Text = "Export to Excel"; btnExport.Click += btnExport_click; btnExport.CssClass = "btn-export-xls"; //btnExport.Width = new Unit("100%"); #if _BTN_NATIVE_ btnExport.CssClass = "btn btn-export btn-xs"; btnExport.Native = true; #endif buttonPanel.Controls.Add(btnExport); panel.Controls.Add(buttonPanel); //add exporter grid gridExporter = new ASPxGridViewExporter(); gridExporter.GridViewID = masterGrid.ID; //string.Concat(table, "GridView"); gridExporter.ID = "GridExport"; gridExporter.FileName = tableMeta.Name + " (" + header + ")"; gridExporter.ExportedRowType = GridViewExportedRowType.All; panel.Controls.Add(gridExporter); ////add script manager //panel.Controls.Add(scriptManager); } masterPage.MainContent.Controls.Add(panel); masterPage.PageTitle.Controls.Add(new LiteralControl(tableMeta.Caption)); ////re-apply the filtering if necessary //if (tableMeta.ShowFilterPanel) //{ // GridViewHelper.ApplyGridViewFilter(masterGrid, filterPanel, tableMeta); //} //else //{ // masterGrid.DataBind(); //} }
static internal void ToolBarClick(ucABM ucABM1, string itemName, ASPxGridView gv, ASPxGridViewExporter ASPxGridViewExporter1) { switch (itemName) { case "btnAdd": ucABM1.LimpiarControles(); FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Add); ucABM1.Visible = true; ucABM1.HeaderText = "Agregar Registro"; break; case "btnEdit": if (FormsHelper.GetSelectedId(gv) != null) { ucABM1.LimpiarControles(); var entity = ucABM1.ReadMethod(FormsHelper.GetSelectedId(gv).Value); FormsHelper.FillControls(entity, ucABM1.tablaABM); FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Edit); ucABM1.Attributes.Add("RecId", entity.RecId.ToString()); ucABM1.Visible = true; ucABM1.HeaderText = "Modificar Registro"; } else { ucABM1.Visible = false; } break; case "btnDelete": if (FormsHelper.GetSelectedId(gv) != null) { FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Delete); ucABM1.Attributes.Add("RecId", FormsHelper.GetSelectedId(gv).ToString()); ucABM1.Visible = true; ucABM1.HeaderText = "Eliminar Registros"; } else { ucABM1.Visible = false; } break; case "btnExport": case "btnExportXls": if (ASPxGridViewExporter1 != null) { ASPxGridViewExporter1.WriteXlsToResponse(); } break; case "btnExportPdf": if (ASPxGridViewExporter1 != null) { ASPxGridViewExporter1.WritePdfToResponse(); } break; default: break; } }