/// <summary>
        /// Export to PDF
        /// </summary>
        public void ExportToPDF()
        {
            // If there are no rows in the grid then we cannot export
            if (this.applicationsDataSet.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("There is no data to Export", "Export Error");
            }

            else
            {
                // We need to temporarily set the grid view to 'Resize all columns' in order to get
                // the resultant PDF file formatted correctly.
                AutoFitStyle oldStyle = applicationsGridView.DisplayLayout.AutoFitStyle;
                applicationsGridView.DisplayLayout.AutoFitStyle = AutoFitStyle.ResizeAllColumns;

                // First browse for the folder / file that we will save
                SaveFileDialog saveFileDialog = new SaveFileDialog();
                saveFileDialog.ValidateNames = false;
                saveFileDialog.FileName      = headerLabel.Text + ".pdf";
                saveFileDialog.Filter        = "Adobe Acrobat Document (*.pdf)|*.pdf";

                if (saveFileDialog.ShowDialog(this) == DialogResult.OK)
                {
                    UltraGridDocumentExporter exporter = new UltraGridDocumentExporter();
                    exporter.Export(applicationsGridView, saveFileDialog.FileName, GridExportFileFormat.PDF);
                    DesktopAlert.ShowDesktopAlert("Data successfully exported to '" + saveFileDialog.FileName + "'");
                }

                // Populate the old autofit style
                this.applicationsGridView.DisplayLayout.AutoFitStyle = oldStyle;
            }
        }
        /// <summary>
        /// Export to XPS
        /// </summary>
        public void ExportToXPS()
        {
            // If there are no rows in the grid then we cannot export
            if (this.applicationsDataSet.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("There is no data to Export", "Export Error");
            }

            else
            {
                // First browse for the folder / file that we will save
                SaveFileDialog saveFileDialog = new SaveFileDialog();
                saveFileDialog.ValidateNames = false;
                saveFileDialog.FileName      = headerLabel.Text + ".xps";
                saveFileDialog.Filter        = "XML Paper Specification (*.xps)|*.xps";

                if (saveFileDialog.ShowDialog(this) == DialogResult.OK)
                {
                    UltraGridDocumentExporter exporter = new UltraGridDocumentExporter();
                    exporter.Export(applicationsGridView, saveFileDialog.FileName, GridExportFileFormat.XPS);
                    DesktopAlert.ShowDesktopAlert("Data successfully exported to '" + saveFileDialog.FileName + "'");
                }
            }
        }
示例#3
0
        private void btnExportToSelected_ButtonClick(object sender, EventArgs e)
        {
            var    item           = (ToolStripSplitButton)sender;
            string selectedFormat = item.Tag.ToString();

            if (selectedFormat == ExportFormats.Excel)
            {
                var exp = new UltraGridExcelExporter();

                SaveFileDialog sfd = DialogFactory.Instance.GetSaveFormatDialog("Excel|*.xls");
                if (sfd.ShowDialog() == DialogResult.OK)
                {
                    exp.Export(_view.grdData, sfd.FileName, WorkbookFormat.Excel97To2003);
                }
            }
            else if (selectedFormat == ExportFormats.Excel2007)
            {
                var exp = new UltraGridExcelExporter();

                SaveFileDialog sfd = DialogFactory.Instance.GetSaveFormatDialog("Excel 2007|*.xlsx");
                if (sfd.ShowDialog() == DialogResult.OK)
                {
                    exp.Export(_view.grdData, sfd.FileName, WorkbookFormat.Excel2007);
                }
            }
            else if (selectedFormat == ExportFormats.Pdf)
            {
                var exp = new UltraGridDocumentExporter();

                SaveFileDialog sfd = DialogFactory.Instance.GetSaveFormatDialog("Pdf|*.pdf");
                if (sfd.ShowDialog() == DialogResult.OK)
                {
                    exp.Export(_view.grdData, sfd.FileName, GridExportFileFormat.PDF);
                }
            }
            else if (selectedFormat == ExportFormats.Xps)
            {
                var exp = new UltraGridDocumentExporter();

                SaveFileDialog sfd = DialogFactory.Instance.GetSaveFormatDialog("Xps|*.xps");
                if (sfd.ShowDialog() == DialogResult.OK)
                {
                    exp.Export(_view.grdData, sfd.FileName, GridExportFileFormat.XPS);
                }
            }
            else if (selectedFormat == ExportFormats.Xml)
            {
//                var exp = new UltraGridDocumentExporter();

                SaveFileDialog sfd = DialogFactory.Instance.GetSaveFormatDialog("Xml|*.xml");
                if (sfd.ShowDialog() == DialogResult.OK)
                {
                    if (_view.grdData.DataSource is DataSet)
                    {
                        var ds = (DataSet)_view.grdData.DataSource;
                        ds.WriteXml(sfd.FileName, XmlWriteMode.IgnoreSchema);
                    }
                    else if (_view.grdData.DataSource is DataTable)
                    {
                        var dt = (DataTable)_view.grdData.DataSource;
                        dt.WriteXml(sfd.FileName, XmlWriteMode.IgnoreSchema);
                    }
                }
            }
        }
示例#4
0
        private void esportaGridPdf()
        {
            try
            {
                ultraGridDocumentExporter1 = new UltraGridDocumentExporter();
                var grids = getFormGrid(MainStandardForm_Fill_Panel.Controls);

                if (grids.Count > 0)
                {
                    var opzioni = new OpzioniStampa();
                    if (opzioni.ShowDialog() == DialogResult.OK)
                    {
                        var grid = findCurrentGrid(grids);
                        var pathTempFile = Utility.GetTempFolder(grid.DisplayLayout.Bands[0].Header.Caption + ".pdf", "pdf");

                        if (opzioni.StampaLogo)
                            ultraGridDocumentExporter1.ExportStarted += ultraGridDocumentExporter1ExportStarted;     

                        var style = grid.DisplayLayout.ViewStyle;
                        if (!opzioni.VisualizzaDettagli)
                            grid.DisplayLayout.ViewStyle = ViewStyle.SingleBand;

                        var restoreDeleteColumn = false;
                        if (grid.DisplayLayout.Bands[0].Columns.Exists("DeleteColumn"))
                        {
                            grid.DisplayLayout.Bands[0].Columns["DeleteColumn"].Hidden = true;
                            restoreDeleteColumn = true;
                        }

                        var rowSelectors = grid.DisplayLayout.Bands[0].Override.RowSelectors;
                        grid.DisplayLayout.Bands[0].Override.RowSelectors = DefaultableBoolean.False;

                        ultraGridDocumentExporter1.TargetPaperOrientation = PageOrientation.Portrait;
                        if (opzioni.GetOrientamento() == OrientamentoStampa.Orizzontale)
                            ultraGridDocumentExporter1.TargetPaperOrientation = PageOrientation.Landscape;

                        try
                        {
                            ultraGridDocumentExporter1.Export(grid, pathTempFile, GridExportFileFormat.PDF);
                        }
                        catch (Exception ex)
                        {
                            log.ErrorFormat("Errore l'esportazione della grid in pdf - EXPORT - {0} - grid:{1} - form text:{2} - path:{3} - azienda:{4}", ex, Utility.GetMethodDescription(), grid.Name, Text, pathTempFile, Login.Instance.CurrentLogin().Azienda);
                            throw;
                        }

                        try
                        {
                            System.Diagnostics.Process.Start(pathTempFile);
                        }
                        catch (System.ComponentModel.Win32Exception exWin)
                        {
                            log.DebugFormat("Non è stata trovata nessuna applicazione per visualizzare il file pdf generato - {0} - grid:{1} - form text:{2} - path:{3} - azienda:{4}", exWin, Utility.GetMethodDescription(), grid.Name, Text, pathTempFile, Login.Instance.CurrentLogin().Azienda);
                            MessageBox.Show("Non è stata trovata nessuna applicazione per visualizzare il file pdf generato.", "Apertura Documento", MessageBoxButtons.OK, MessageBoxIcon.Warning);    
                        }
                        catch (Exception ex)
                        {
                            log.ErrorFormat("Errore l'esportazione della grid in pdf - APERTURA PDF - {0} - grid:{1} - form text:{2} - path:{3} - azienda:{4}", ex, Utility.GetMethodDescription(), grid.Name, Text, pathTempFile, Login.Instance.CurrentLogin().Azienda);
                            throw;
                        }

                        grid.DisplayLayout.ViewStyle = style;
                        grid.DisplayLayout.Bands[0].Override.RowSelectors = rowSelectors;
                        if (restoreDeleteColumn)
                            grid.DisplayLayout.Bands[0].Columns["DeleteColumn"].Hidden = false;

                    }

                    opzioni.Dispose();
                }
            }
            catch (Exception ex)
            {
                
                log.Error("Errore durante l'esportazione della grid in pdf - " + Utility.GetMethodDescription() + " - azienda:" + Login.Instance.CurrentLogin().Azienda, ex);
            }
        }
示例#5
0
        /// <summary>
        /// Constructor
        /// </summary>
        /// <param name="toFile">Name of the file to export to</param>
        /// <param name="headerText">Main Header text</param>
        /// <param name="subheadingText">Sub-heading text</param>
        /// <param name="footerText">footer text</param>
        /// <param name="grid">Grid View to export</param>
        /// <param name="outputFormat">Output format</param>
        public static void Export(String toFile
                                  , String headerText
                                  , String subheadingText
                                  , String footerText
                                  , UltraGrid grid
                                  , FileFormat outputFormat)
        {
            // Create the report itself
            Report report = new Report();

            // ...then the sections for header, footer and body
            ISection mainSection = report.AddSection();

            mainSection.PageMargins = new Infragistics.Documents.Reports.Report.Margins(50);
            ISectionHeader headerSection = mainSection.AddHeader();

            headerSection.Height = 50;
            headerSection.Repeat = true;

            // Add a footer for page numbering
            ISectionFooter footerSection = mainSection.AddFooter();

            // Create place-holder for header text
            Infragistics.Documents.Reports.Report.Text.IText headerTextSection = headerSection.AddText(0, 0);

            // ...and add the header in to this section, centralized
            headerTextSection.AddContent(headerText);
            headerTextSection.Alignment.Horizontal = Alignment.Center;
            headerTextSection.Alignment.Vertical   = Alignment.Middle;

            // Set style for the header
            Infragistics.Documents.Reports.Report.Text.Style HeaderStyle = new Infragistics.Documents.Reports.Report.Text.Style(new Infragistics.Documents.Reports.Graphics.Font("Verdana", 10, Infragistics.Documents.Reports.Graphics.FontStyle.Underline), Infragistics.Documents.Reports.Graphics.Brushes.DarkBlue);
            headerTextSection.Style = HeaderStyle;

            // Add in a sub-heading if required
            if (subheadingText != null && subheadingText != "")
            {
                headerTextSection = headerSection.AddText(0, 20);
                Infragistics.Documents.Reports.Report.Text.Style subHeaderStyle = new Infragistics.Documents.Reports.Report.Text.Style(new Infragistics.Documents.Reports.Graphics.Font("Verdana", 8, Infragistics.Documents.Reports.Graphics.FontStyle.Underline), Infragistics.Documents.Reports.Graphics.Brushes.DarkBlue);
                headerTextSection.Style = subHeaderStyle;
                headerTextSection.AddContent(subheadingText);
            }

            // Add the body of the report which is the contents of the grid
            UltraGridDocumentExporter exporter = new UltraGridDocumentExporter();

            exporter.Export(grid, mainSection);

            //-------------------------
            // Setup Footer content
            //-------------------------
            footerSection.Height = 50;

            // Do we have a footer to display?
            if (footerText != null && footerText != "")
            {
                // Create place-holder for footer text
                Infragistics.Documents.Reports.Report.Text.IText footerTextSection = footerSection.AddText(0, 0);

                // ...and add the footer text in to this section, left aligned
                footerTextSection.Alignment.Horizontal = Alignment.Left;
                footerTextSection.Alignment.Vertical   = Alignment.Top;

                // Set style for the text
                Infragistics.Documents.Reports.Report.Text.Style footerStyle = new Infragistics.Documents.Reports.Report.Text.Style(new Infragistics.Documents.Reports.Graphics.Font("Verdana", 6, Infragistics.Documents.Reports.Graphics.FontStyle.Underline), Infragistics.Documents.Reports.Graphics.Brushes.DarkBlue);
                footerTextSection.Style = footerStyle;

                // ...and set the text itself
                footerTextSection.AddContent(footerText);
            }

            PageNumbering pn = mainSection.PageNumbering;

            // The Template property is the actual string that shows the page numbering. Use the [Page #] place-
            // holder for the current page and the [TotalPages] place-holder for the total amount of pages in
            // the entire document.
            pn.Template = "Page [Page #] of [TotalPages]";

            // Setting SkipFirst to true does not place page numbering on the first page of the section. This
            // is useful if the first page is a Title page.
            pn.SkipFirst = false;

            // The page numbering will be aligned with the right side of the page. Valid values off the
            // Alignment enum include Left, Center, and Right.
            pn.Alignment.Horizontal = Alignment.Right;

            // The page numbering will be located at the bottom of the page. Valid values off the
            // Alignment enum include Top and Bottom.
            pn.Alignment.Vertical = Alignment.Bottom;

            // The page numbering is at the extreme bottom of the page, so we need to change the Y Offset
            // in order to bring it in line with the rest of the page footer text.
            pn.OffsetY = -18;

            // Delete the old report if it exists
            try
            {
                if (File.Exists(toFile))
                {
                    File.Delete(toFile);
                }
            }
            catch (Exception)
            {
                //Ignore any errors
            }

            // Generate the report
            try
            {
                report.Generate();
                report.Publish(toFile, outputFormat);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Failed to write the export file " + toFile + ", the error was " + ex.Message);
            }
        }
示例#6
0
        /// <summary>
        /// Export the
        /// </summary>
        /// <param name="ToFile"></param>
        /// <param name="listSections"></param>
        /// <param name="outputFormat"></param>
        public static void Export(string toFile, UltraGrid grid, ExportSectionList listSections, FileFormat outputFormat)
        {
            // Create the report itself
            Report report = new Report();

            // ...then the sections for header, footer and body
            ISection mainSection = report.AddSection();

            mainSection.PageMargins = new Infragistics.Documents.Reports.Report.Margins(50);
            ISectionHeader headerSection = mainSection.AddHeader();

            headerSection.Height = 50;
            headerSection.Repeat = true;
            ISectionFooter footerSection = mainSection.AddFooter();

            footerSection.Height = 50;

            // Add the body of the report which is the contents of the grid
            UltraGridDocumentExporter exporter = new UltraGridDocumentExporter();

            exporter.Export(grid, mainSection);

            // Setup the page numbering
            PageNumbering pn = mainSection.PageNumbering;

            // The Template property is the actual string that shows the page numbering. Use the [Page #] place-
            // holder for the current page and the [TotalPages] place-holder for the total amount of pages in
            // the entire document.
            pn.Template = "Page [Page #] of [TotalPages]";

            // Setting SkipFirst to true does not place page numbering on the first page of the section. This
            // is useful if the first page is a Title page.
            pn.SkipFirst = false;

            // The page numbering will be aligned with the right side of the page. Valid values off the
            // Alignment enum include Left, Center, and Right.
            pn.Alignment.Horizontal = Alignment.Right;

            // The page numbering will be located at the bottom of the page. Valid values off the
            // Alignment enum include Top and Bottom.
            pn.Alignment.Vertical = Alignment.Bottom;

            // The page numbering is at the extreme bottom of the page, so we need to change the Y Offset
            // in order to bring it in line with the rest of the page footer text.
            pn.OffsetY = -18;

            // Delete the old report if it exists
            try
            {
                if (File.Exists(toFile))
                {
                    File.Delete(toFile);
                }
            }
            catch (Exception)
            {
                //Ignore any errors
            }

            // Generate the report
            try
            {
                report.Generate();
                report.Publish(toFile, outputFormat);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Failed to write the export file " + toFile + ", the error was " + ex.Message);
            }
        }