Example #1
0
    private void FormatTableBorders(DevExpress.XtraRichEdit.API.Native.Table t)
    {
        t.Borders.Top.LineColor    = Color.White;
        t.Borders.Bottom.LineColor = Color.White;
        t.Borders.Left.LineColor   = Color.White;
        t.Borders.Right.LineColor  = Color.White;

        t.Borders.InsideHorizontalBorder.LineStyle = TableBorderLineStyle.None;
        t.Borders.InsideVerticalBorder.LineStyle   = TableBorderLineStyle.None;
    }
 private void btnCheckLayout_Click(object sender, EventArgs e)
 {
     #region #CheckLayout
     DevExpress.XtraRichEdit.API.Native.Table table = richEditControl1.Document.Tables.First;
     if (table != null)
     {
         // Obtain the layout element related to the table.
         LayoutTable ltable = richEditControl1.DocumentLayout.GetElement <LayoutTable>(table.Range.Start);
         // Obtain zero-based page index of the page containing the layout element.
         int pageIndex = this.richEditControl1.DocumentLayout.GetPageIndex(ltable);
         // Check whether the layout element is located at the second page.
         string s = "Layout verified.";
         if (pageIndex != 1)
         {
             s = "The first table is not on the page 2. Review pagination.";
         }
         MessageBox.Show(s, "Check Layout", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     #endregion #CheckLayout
 }
Example #3
0
        protected void Page_Init(object sender, EventArgs e)
        {
            if (!IsCallback && !IsPostBack)
            {
                HiddenInvoiceId.Value = Request.Params["OrderID"];

                var arrayInvoice = new ArrayList();

                using (SqlConnection con = new SqlConnection(conStr))
                {
                    using (SqlCommand cmd = new SqlCommand())
                    {
                        cmd.CommandType = CommandType.Text;
                        cmd.Connection  = con;

                        cmd.CommandText = @"select i.InvoiceID, i.OrderID, i.InvoiceRtf 
                                            from Invoices i                                                             
                                            where i.OrderID = " + HiddenInvoiceId.Value + " order by i.InvoiceID desc";

                        con.Open();
                        SqlDataReader reader = cmd.ExecuteReader();

                        while (reader.Read())
                        {
                            arrayInvoice.Add(reader["InvoiceID"]);
                            arrayInvoice.Add(reader["OrderID"]);
                            arrayInvoice.Add(reader["InvoiceRtf"]);
                        }

                        reader.Close();
                        con.Close();
                    }
                }

                if (arrayInvoice.Count > 0)
                {
                    // Stream var
                    MemoryStream updatedStream = new MemoryStream();

                    // Load stream from database
                    MemoryStream stream = new MemoryStream((byte[])arrayInvoice[2]);

                    // Load document from stream
                    RichEditDocumentServer docServer = new RichEditDocumentServer();
                    docServer.LoadDocument(stream, DocumentFormat.Rtf);

                    // Create document server
                    Document document = docServer.Document;

                    // If the document is not protected
                    if (!document.IsDocumentProtected)
                    {
                        // Protect the document with a password
                        document.Protect("123", DocumentProtectionType.ReadOnly);

                        // Tables
                        DevExpress.XtraRichEdit.API.Native.Table table1 = document.Tables[1];
                        DocumentRange rangeTable1 = table1.Rows[1].Range;

                        DevExpress.XtraRichEdit.API.Native.Table table2 = document.Tables[2];
                        DocumentRange rangeTable2 = table2.Rows[1].Range;

                        // Add table1 as range / Allow editing row 1 over table1
                        RangePermissionCollection coletionTable1   = document.BeginUpdateRangePermissions();
                        RangePermission           permissionTable1 = coletionTable1.CreateRangePermission(rangeTable1);
                        permissionTable1.Group = "Everyone";
                        coletionTable1.Add(permissionTable1);
                        document.EndUpdateRangePermissions(coletionTable1);

                        // Add table2 as range / Allow editing row 1 over table2
                        RangePermissionCollection coletionTable2   = document.BeginUpdateRangePermissions();
                        RangePermission           permissionTable2 = coletionTable2.CreateRangePermission(rangeTable2);
                        permissionTable2.Group = "Everyone";
                        coletionTable2.Add(permissionTable2);
                        document.EndUpdateRangePermissions(coletionTable2);
                    }

                    // Update updatedStream var from stream var
                    document.SaveDocument(updatedStream, DocumentFormat.Rtf);

                    // Open document from updatedStream var
                    ASPxRichEdit1.Open(Guid.NewGuid().ToString(), DocumentFormat.Rtf, () => { return(updatedStream.ToArray()); });
                }
            }
        }
Example #4
0
    public void TablaDoc(ref RichEditDocumentServer wordDoc, int filas, string _poliza)
    {
        DocumentPosition pos = wordDoc.Document.CreatePosition(1075);

        System.Data.DataTable content = AccesoDatos.RegresaTablaSql("select asegurado as nombre, certificado, clase as descripcion from asegurado where poliza = '" + _poliza + "' order by asegurado, certificado");
        DevExpress.XtraRichEdit.API.Native.Table table = wordDoc.Document.Tables.Add(pos, filas, 5);

        // Major adjustments
        table.TableLayout = TableLayoutType.Fixed;

        table.PreferredWidthType = WidthType.Fixed;
        table.PreferredWidth     = Units.InchesToDocumentsF(8f);

        table.Rows[1].HeightType = HeightType.Exact;
        table.Rows[1].Height     = Units.InchesToDocumentsF(0.25f);
        wordDoc.Document.InsertText(table[0, 0].Range.Start, "Nombre");
        wordDoc.Document.InsertText(table[0, 2].Range.Start, "Cert.");
        wordDoc.Document.InsertText(table[0, 4].Range.Start, "DescripciĆ³n");
        //table[0, 0].Style.Bold = true;
        //table[0, 2].Style.Bold = true;
        //table[0, 4].Style.Bold = true;
        //table[0, 0].Style.FontSize = 12;
        //table[0, 2].Style.FontSize = 12;
        //table[0, 4].Style.FontSize = 12;

        table[0, 0].Borders.Bottom.LineColor = Color.White;
        table[0, 0].Borders.Top.LineColor    = Color.White;
        table[0, 0].Borders.Left.LineColor   = Color.White;
        table[0, 0].Borders.Right.LineColor  = Color.White;
        table[0, 1].Borders.Bottom.LineColor = Color.White;
        table[0, 1].Borders.Top.LineColor    = Color.White;
        table[0, 1].Borders.Left.LineColor   = Color.White;
        table[0, 1].Borders.Right.LineColor  = Color.White;
        table[0, 2].Borders.Bottom.LineColor = Color.White;
        table[0, 2].Borders.Top.LineColor    = Color.White;
        table[0, 2].Borders.Left.LineColor   = Color.White;
        table[0, 2].Borders.Right.LineColor  = Color.White;
        table[0, 3].Borders.Bottom.LineColor = Color.White;
        table[0, 3].Borders.Top.LineColor    = Color.White;
        table[0, 3].Borders.Left.LineColor   = Color.White;
        table[0, 3].Borders.Right.LineColor  = Color.White;
        table[0, 4].Borders.Bottom.LineColor = Color.White;
        table[0, 4].Borders.Top.LineColor    = Color.White;
        table[0, 4].Borders.Left.LineColor   = Color.White;
        table[0, 4].Borders.Right.LineColor  = Color.White;
        // table[0, 0]..Right.LineColor = Color.White;
        int tupla = 1;

        // Additional adjustments
        //DocumentPosition pos = wordDoc.Document.CreatePosition(60);
        foreach (System.Data.DataRow rw in content.Rows)
        {
            try
            {
                table.Rows[tupla].Cells[0].BackgroundColor = Color.Yellow;
                table.Rows[tupla].Cells[2].BackgroundColor = Color.Yellow;
                table.Rows[tupla].Cells[4].BackgroundColor = Color.Yellow;
                table[tupla, 0].PreferredWidthType         = WidthType.Fixed;
                table[tupla, 0].PreferredWidth             = Units.InchesToDocumentsF(8f);
                table[tupla, 1].PreferredWidthType         = WidthType.Fixed;
                table[tupla, 1].PreferredWidth             = Units.InchesToDocumentsF(1f);
                table[tupla, 1].BackgroundColor            = Color.White;
                table[tupla, 2].PreferredWidthType         = WidthType.Fixed;
                table[tupla, 2].PreferredWidth             = Units.InchesToDocumentsF(1f);
                table[tupla, 3].PreferredWidthType         = WidthType.Fixed;
                table[tupla, 3].PreferredWidth             = Units.InchesToDocumentsF(1f);
                table[tupla, 3].BackgroundColor            = Color.White;
                table[tupla, 4].PreferredWidthType         = WidthType.Fixed;
                table[tupla, 4].PreferredWidth             = Units.InchesToDocumentsF(2f);


                wordDoc.Document.InsertText(table[tupla, 0].Range.Start, rw["nombre"].ToString().Trim());
                wordDoc.Document.InsertText(table[tupla, 1].Range.Start, "");
                wordDoc.Document.InsertText(table[tupla, 2].Range.Start, rw["certificado"].ToString().Trim());
                wordDoc.Document.InsertText(table[tupla, 3].Range.Start, "");
                wordDoc.Document.InsertText(table[tupla, 4].Range.Start, rw["descripcion"].ToString().Trim());

                tupla += 1;
            }
            catch (Exception we)
            {
                Helper.RegistrarEvento("Cargando wordDoc : " + tupla.ToString() + " - " + we.Message);
            }
        }

        table[1, 1].LeftPadding = 0;
    }
Example #5
0
    //public static int GetDiagIndex(int r, int c, int n)
    //{
    //	//k = (n * (n - 1) / 2) - (n - r) * ((n - r) - 1) / 2 + c - r - 1
    //	int idx = (n * (n - 1) / 2) - (n - r) * ((n - r) - 1) / 2 + c - r - 1;
    //	return idx;

    //}


    private void AppendDataTable(Document document, DataTable dataTable)
    {
        int           dataTableRows    = dataTable.Rows.Count;
        int           dataTableColumns = dataTable.Columns.Count;
        List <string> columnsToDisplay = new List <string>();

        for (int i = 0; i < dataTableColumns; i++)
        {
            string name = dataTable.Columns[i].ColumnName;

            // Skip PrimaryKey columns
            if (!name.ToUpper().EndsWith("ID"))
            {
                columnsToDisplay.Add(name);
            }
        }

        document.BeginUpdate();

        DevExpress.XtraRichEdit.API.Native.Table table = document.Tables.Create(document.Range.End, dataTableRows + 1, columnsToDisplay.Count, AutoFitBehaviorType.AutoFitToContents);

        //table.Borders.InsideHorizontalBorder.LineColor = Color.DarkBlue;
        //table.Borders.InsideVerticalBorder.LineColor = Color.DarkBlue;
        //table.Borders.InsideHorizontalBorder.LineThickness = 0.5f;
        //table.Borders.InsideHorizontalBorder.LineStyle = TableBorderLineStyle.Single;
        //table.Borders.InsideVerticalBorder.LineThickness = 0.5f;
        //table.Borders.InsideVerticalBorder.LineStyle = TableBorderLineStyle.Single;

        //table.LeftPadding = Units.InchesToDocumentsF(0.01f);

        //table.FirstRow.Height = Units.InchesToDocumentsF(0.5f);
        //table.FirstRow.HeightType = HeightType.Exact;

        ParagraphProperties pp = document.BeginUpdateParagraphs(table.FirstRow.Range);

        pp.Alignment = ParagraphAlignment.Left;
        document.EndUpdateParagraphs(pp);

        CharacterProperties cp = document.BeginUpdateCharacters(table.FirstRow.Range);

        //cp.FontName = "Courier New";
        cp.Bold      = true;
        cp.ForeColor = Color.Gray;
        cp.FontSize  = 9f;
        document.EndUpdateCharacters(cp);

        CharacterProperties cp2 = document.BeginUpdateCharacters(table.Range);

        //cp.FontName = "Courier New";
        cp2.FontSize = 9f;
        document.EndUpdateCharacters(cp2);


        //for (int i = 0; i < table.FirstRow.Cells.Count; i++)
        //{
        //	table.FirstRow.Cells[i].HeightType = HeightType.Auto;
        //	table.FirstRow.Cells[i].VerticalAlignment = TableCellVerticalAlignment.Top;
        //table.FirstRow.Cells[i].BackgroundColor = Color.DarkBlue;
        //table.FirstRow.Cells[i].VerticalAlignment = TableCellVerticalAlignment.Center;
        //}

        // Fill table header with column names
        for (int i = 0; i < columnsToDisplay.Count; i++)
        {
            document.InsertText(table[0, i].Range.Start, columnsToDisplay[i]);
        }

        // Fill table body with data
        table.ForEachCell(delegate(DevExpress.XtraRichEdit.API.Native.TableCell cell, int rowIndex, int cellIndex) {
            if (rowIndex > 0)
            {
                document.InsertText(cell.Range.Start, dataTable.Rows[rowIndex - 1][columnsToDisplay[cellIndex]].ToString());
            }
        });
        document.EndUpdate();
    }
Example #6
0
    private void AppendCharts(DocumentPosition pos, DxChartBatch batch, Document doc, float scaleX, float scaleY)
    {
        bool addHeaderRow = true;

        if (batch.layout == DxLayout.Upper)
        {
            int numcols = LayoutOutput.NCols(batch.charts.Count);
            int numrows = (addHeaderRow) ? numcols + 1 : numcols;

            //int numrows = (addHeaderRow) ? batch.maxRow + 1 : batch.maxRow;



            doc.BeginUpdate();
            DevExpress.XtraRichEdit.API.Native.Table t = doc.Tables.Create(doc.Range.End, numrows, numcols, AutoFitBehaviorType.AutoFitToContents);

            FormatTableBorders(t);


            if (addHeaderRow)
            {
                for (int h = 0; h < numcols; h++)
                {
                    doc.InsertText(t[0, h].Range.Start, batch.vars[h]);
                    doc.InsertText(t[h, 0].Range.Start, batch.vars[h - 1]);
                    //if (h > 0 & h < batch.vars.Count) doc.InsertText(t[0, h].Range.Start, batch.vars[h]);
                    //if (h > 0 & h < batch.vars.Count) doc.InsertText(t[h, 0].Range.Start, batch.vars[h - 1]);

                    t.Cell(h, 0).VerticalAlignment = TableCellVerticalAlignment.Center;
                }
            }

            //t.Rows.Add(CreateHeaderRow(batch.vars, ncols));
            int counter = 0;
            for (int r = 0; r < numrows; r++)
            {
                //for (int c = r; c < batch.maxCol; c++)
                for (int c = r; c < numcols; c++)
                {
                    if (c > r)
                    {
                        int bumprow = (addHeaderRow) ? 1 : 0;

                        int idx = LayoutOutput.GetDiagIndex(r, c, batch.maxRow);



                        string chartfile = String.Format(@"{0}{1}.png", _temppath, batch.charts[counter].guid);
                        counter++;

                        DevExpress.XtraRichEdit.API.Native.TableCell cell = t.Cell(r + bumprow, c);
                        doc.Images.Insert(cell.Range.Start, DocumentImageSource.FromFile(chartfile));

                        doc.Images[doc.Images.Count - 1].ScaleX = scaleX;
                        doc.Images[doc.Images.Count - 1].ScaleY = scaleY;
                    }
                }
            }



            doc.EndUpdate();
        }
        else
        {
            foreach (DxChart chart in batch.charts)
            {
                string chartfile = String.Format(@"{0}{1}.png", _temppath, chart.guid);
                log(chartfile);
                //MemoryStream s = new MemoryStream();
                //chart.chart.ExportToImage(s, System.Drawing.Imaging.ImageFormat.Png);

                doc.Images.Insert(pos, DocumentImageSource.FromFile(chartfile));

                doc.Images[doc.Images.Count - 1].ScaleX = 0.5f;
                doc.Images[doc.Images.Count - 1].ScaleY = 0.5f;
            }
        }
    }