public DocumentImageSource CreateImage() { Stream stream = CreateChart(); stream.Position = 0; return(DocumentImageSource.FromStream(stream)); }
static void ImageFromFile(Document document) { #region #ImageFromFile DocumentPosition pos = document.Range.Start; document.Images.Insert(pos, DocumentImageSource.FromFile("beverages.png")); #endregion #ImageFromFile }
private void richEditControl1_Loaded(object sender, RoutedEventArgs e) { richEditControl1.CreateNewDocument(); richEditControl1.Document.Images.Append(DocumentImageSource.FromUri("http://www.devexpress.com/Support/Center/Attachment/GetAttachmentFile/e71fc07d-1c4e-4e08-a9be-65eb6f409c8b", null)); embedImagesCheck.EditValue = true; richEditControl1.ContentChanged += new EventHandler(richEditControl1_ContentChanged); }
private void FillData(Document document) { #region #DataInserting Table table = document.Tables[0]; //Insert the header data document.InsertSingleLineText(table.Rows[0].Cells[1].Range.Start, "Active Customers"); document.InsertSingleLineText(table[2, 0].Range.Start, "Photo"); document.InsertSingleLineText(table[2, 1].Range.Start, "Customer Info"); document.InsertSingleLineText(table[2, 2].Range.Start, "Rentals"); //Insert the customer photo document.Images.Insert(table[3, 0].Range.Start, DocumentImageSource.FromFile("photo.png")); //Insert the customer info document.InsertText(table[3, 1].Range.Start, "Ryan Anita W"); document.InsertText(table[3, 2].Range.Start, "Intermediate"); document.InsertText(table[4, 1].Range.Start, "3/28/1984"); document.InsertText(table[5, 1].Range.Start, "*****@*****.**"); document.InsertText(table[5, 2].Range.Start, "(555)421-0059"); document.InsertText(table[6, 1].Range.Start, "5119 Beryl Dr, San Antonio, TX 78212"); document.InsertSingleLineText(table[3, 3].Range.Start, "18"); #endregion #DataInserting }
public void AppendChart(Document doc, string path, string filename) { float scaleX = 1.0f; float scaleY = 1.0f; string chartfile = String.Format("{0}{1}", path, filename); try { DocumentPosition pos = doc.Range.End; DocumentImageSource.FromFile(chartfile); doc.Images.Insert(pos, DocumentImageSource.FromFile(chartfile)); var size = doc.Images[doc.Images.Count - 1].Size; if (size.Width > 7.5) { scaleX = 7.5f / size.Width; scaleY = scaleX; } doc.Images[doc.Images.Count - 1].ScaleX = scaleX; doc.Images[doc.Images.Count - 1].ScaleY = scaleY; } catch (Exception ex) { } }
public static bool ConvertImageToPdf(Image image, string naziv, RevizijaAPI.Models.Database.dms_file folderOstalo, int id_operater) { using (RichEditDocumentServer server = new RichEditDocumentServer()) { try { //Insert an image DocumentImage docImage = server.Document.Images.Append(DocumentImageSource.FromImage(image)); //Adjust the page width and height to the image's size server.Document.Sections[0].Page.Width = docImage.Size.Width + server.Document.Sections[0].Margins.Right + server.Document.Sections[0].Margins.Left; server.Document.Sections[0].Page.Height = docImage.Size.Height + server.Document.Sections[0].Margins.Top + server.Document.Sections[0].Margins.Bottom; var result = Upload2DMS(folderOstalo, naziv, image, id_operater); if (result.result) { using (FileStream fs = new FileStream(System.Web.Hosting.HostingEnvironment.MapPath($"~\\Uploads\\{result.guid}"), FileMode.OpenOrCreate)) { server.ExportToPdf(fs); } return(true); } else { return(false); } } catch (Exception ex) { return(false); } } }
private void btnFromUri_Click(object sender, EventArgs e) { #region #fromuri DocumentPosition pos = richEditControl1.Document.CaretPosition; string imageUri = "http://www.devexpress.com/App_Themes/DX/Common/footer_logo.gif"; richEditControl1.Document.Images.Insert(pos, DocumentImageSource.FromUri(imageUri, richEditControl1)); #endregion #fromuri }
static void ImageFromFile(RichEditDocumentServer wordProcessor) { #region #ImageFromFile Document document = wordProcessor.Document; DocumentPosition pos = document.Range.Start; document.Images.Insert(pos, DocumentImageSource.FromFile("Documents\\beverages.png")); #endregion #ImageFromFile }
private DocumentImageSource CreateImageFromResx(string name) { Assembly assembly = Assembly.GetExecutingAssembly(); Stream stream = assembly.GetManifestResourceStream("Export_Import_Example.Images." + name); DocumentImageSource dim = DocumentImageSource.FromStream(stream); return(dim); }
public Form1() { InitializeComponent(); server = new RichEditDocumentServer(); server.CreateNewDocument(); server.Document.Images.Append (DocumentImageSource.FromUri("http://www.devexpress.com/i/pagetitles/xtrarichedit.png", null)); embedImagesCheck.EditValue = true; server.ContentChanged += new EventHandler(richEditControl1_ContentChanged); }
private void btnFromStream_Click(object sender, EventArgs e) { #region #fromstream DocumentPosition pos = richEditControl1.Document.CaretPosition; string imageToInsert = "information.png"; Assembly a = Assembly.GetExecutingAssembly(); Stream imageStream = a.GetManifestResourceStream("InlinePictures.Resources." + imageToInsert); richEditControl1.Document.Images.Insert(pos, DocumentImageSource.FromStream(imageStream)); #endregion #fromstream }
public Form1() { InitializeComponent(); richEditControl1.DocumentLoaded += richEditControl1_DocumentLoaded; richEditControl1.CreateNewDocument(); DocumentPosition pos = richEditControl1.Document.CaretPosition; richEditControl1.Document.Images.Insert(pos, DocumentImageSource.FromUri(imageUri, null)); embedImagesCheck.EditValue = true; richEditControl1.ContentChanged += new EventHandler(richEditControl1_ContentChanged); }
private void btnLoadImage_Click(object sender, RoutedEventArgs e) { if (featureComplete) { richEditControl1.Document.Images.Insert(richEditControl1.Document.Range.End, DocumentImageSource.FromUri("http://www.devexpress.com/Home/i/logos/preview.png", richEditControl1)); } else { MessageBox.Show(errorMessage); } }
private void richEditControl1_CalculateDocumentVariable(object sender, DevExpress.XtraRichEdit.CalculateDocumentVariableEventArgs e) { if (e.VariableName == "CHART") { ChartImage chart = new ChartImage(e.Arguments[0].Value.ToString()); chart.Initialize(); DocumentImageSource image = chart.CreateImage(); RichEditDocumentServer srv = new RichEditDocumentServer(); srv.Document.Images.Append(image); e.Value = srv.Document; e.Handled = true; } }
static void Main() { #region #inlinepictures RichEditDocumentServer server = new RichEditDocumentServer(); server.LoadDocument("Texts\\InlinePictures.rtf", DocumentFormat.Rtf); Document doc = server.Document; // Insert an image from a file. DocumentRange rangeFound = doc.FindAll("Visual Studio Magazine", SearchOptions.CaseSensitive)[0]; DocumentPosition pos = doc.Paragraphs[doc.Paragraphs.Get(rangeFound.End).Index + 2].Range.Start; doc.Images.Insert(pos, DocumentImageSource.FromFile("Pictures\\ReadersChoice.png")); // Insert an image from a stream. pos = doc.Paragraphs[4].Range.Start; string imageToInsert = "information.png"; Assembly a = Assembly.GetExecutingAssembly(); Stream imageStream = a.GetManifestResourceStream("InlinePictures.Resources." + imageToInsert); doc.Images.Insert(pos, DocumentImageSource.FromStream(imageStream)); // Insert an image using its URI. string imageUri = "http://i.gyazo.com/798a2ed48a3535c6c8add0ea7a4fc4e6.png"; SubDocument docHeader = doc.Sections[0].BeginUpdateHeader(); docHeader.Images.Append(DocumentImageSource.FromUri(imageUri, server)); doc.Sections[0].EndUpdateHeader(docHeader); // Insert a barcode. DevExpress.BarCodes.BarCode barCode = new DevExpress.BarCodes.BarCode(); barCode.Symbology = DevExpress.BarCodes.Symbology.QRCode; barCode.CodeText = "http://www.devexpress.com"; barCode.CodeBinaryData = System.Text.Encoding.Default.GetBytes(barCode.CodeText); barCode.Module = 0.5; SubDocument docFooter = doc.Sections[0].BeginUpdateFooter(); docFooter.Images.Append(barCode.BarCodeImage); doc.Sections[0].EndUpdateFooter(docFooter); #endregion #inlinepictures #region #getimages // Scale down images in the document body. ReadOnlyDocumentImageCollection images = server.Document.Images.Get(doc.Range); for (int i = 0; i < images.Count; i++) { images[i].ScaleX /= 4; images[i].ScaleY /= 4; } #endregion #getimages // Save the resulting document. server.SaveDocument("InlinePictures.docx", DocumentFormat.OpenXml); Process.Start("InlinePictures.docx"); }
static void ImageFromFile(Document document) { #region #ImageFromFile DocumentPosition pos = document.Range.Start; StreamResourceInfo streamResInfo = Application.GetResourceStream(new Uri("beverages.png", UriKind.Relative)); if (streamResInfo != null) { using (Stream s = streamResInfo.Stream) { document.Images.Insert(pos, DocumentImageSource.FromStream(s)); } } #endregion #ImageFromFile }
private void Form2_MouseUp(object sender, MouseEventArgs e) { _nowX = MousePosition.X + 1; _nowY = MousePosition.Y + 1; var cutImg = Snap(_x < _nowX ? _x : _nowX, _y < _nowY ? _y : _nowY, Math.Abs(_nowX - _x), Math.Abs(_nowY - _y)); Clipboard.SetImage(cutImg); if (_myRich != null) { _myRich.Document.InsertImage(_myRich.Document.CaretPosition, DocumentImageSource.FromImage(cutImg)); _myRich = null; } DialogResult = DialogResult.OK; Close(); }
static void AddFloatingPicture(Document document) { #region #AddFloatingPicture document.AppendText("Line One\nLine Two\nLine Three"); StreamResourceInfo streamResInfo = Application.GetResourceStream(new Uri("beverages.png", UriKind.Relative)); if (streamResInfo != null) { using (Stream s = streamResInfo.Stream) { Shape myPicture = document.Shapes.InsertPicture(document.CreatePosition(15), DocumentImageSource.FromStream(s)); myPicture.HorizontalAlignment = ShapeHorizontalAlignment.Center; } } #endregion #AddFloatingPicture }
private void btnFromFile_Click(object sender, EventArgs e) { #region #fromfile DocumentPosition pos = richEditControl1.Document.CaretPosition; OpenFileDialog dialog = new OpenFileDialog(); dialog.Filter = "Image Files|*.jpg;*.gif;*.bmp;*.png;*.jpeg|All Files|*.*"; dialog.FilterIndex = 1; dialog.RestoreDirectory = true; if (dialog.ShowDialog() == DialogResult.OK) { string imageToInsert = dialog.FileName; richEditControl1.Document.Images.Insert(pos, DocumentImageSource.FromFile(imageToInsert)); } #endregion #fromfile }
protected virtual void AppendImage(Document doc, ScriptOutputMessage output, string fileName) { doc.BeginUpdate(); try { fileName = Project.Current.MapPath(fileName); doc.Images.Append(DocumentImageSource.FromFile(fileName)); var paragraph = doc.Paragraphs.Append(); doc.CaretPosition = paragraph.Range.End; ScrollToCaret(); } catch (Exception ex) { ReportError(doc, ex); } finally { doc.EndUpdate(); } }
protected void DemoRichEdit_CalculateDocumentVariable(object sender, CalculateDocumentVariableEventArgs e) { switch (e.VariableName) { case "Chart": var sales = GetSales(e.Arguments[0].Value); DocumentImageSource chart = DocumentImageSource.FromStream(CreateChart(sales)); RichEditDocumentServer srv = new RichEditDocumentServer(); srv.Document.Images.Append(chart); e.Value = srv.Document; e.Handled = true; break; case "CommonSales": var commonSales = GetCommonSales(e.Arguments[0].Value); e.Value = commonSales.ToString("C"); e.Handled = true; break; default: break; } }
protected void DoWriteImage(string fileName, ImageOptions options) { options ??= new ImageOptions(); var book = options.Book?.Document ?? Document; using (new UsingProcessor(() => book.BeginUpdate(), () => book.EndUpdate())) { DocumentPosition rangeStart = null, rangeEnd = null; DocumentImage image; if (options.Image != null) { image = book.Images.Append(options.Image); } else if (!string.IsNullOrWhiteSpace(fileName)) { fileName = Project.Current.MapPath(fileName); var source = DocumentImageSource.FromFile(fileName); image = book.Images.Append(source); } else { throw new Exception("WriteImage - unknown input object."); } image.ScaleX = options.ScaleX; image.ScaleY = options.ScaleY; var imageRange = image.Range; if (rangeStart == null) { rangeStart = imageRange.Start; } if (!options.NoLineBreaks) { imageRange = book.AppendText(Environment.NewLine); } rangeEnd = imageRange.End; if (rangeStart != null && rangeEnd != null) { var range = book.CreateRange(rangeStart, rangeEnd.ToInt() - rangeStart.ToInt()); if (!string.IsNullOrWhiteSpace(options.ParagraphStyle) || options.FirstLineIdent.HasValue || options.FirstLineIndentType.HasValue || options.LeftIndent.HasValue || options.RightIndent.HasValue) { var pp = book.BeginUpdateParagraphs(range); try { if (!string.IsNullOrWhiteSpace(options.ParagraphStyle)) { var style = book.ParagraphStyles[options.ParagraphStyle] ?? throw new Exception($"Paragraph style '{options.ParagraphStyle}' does not exist."); pp.Style = style; } if (options.FirstLineIdent.HasValue) { pp.FirstLineIndent = options.FirstLineIdent; } if (options.FirstLineIndentType.HasValue) { pp.FirstLineIndentType = (DevExpress.XtraRichEdit.API.Native.ParagraphFirstLineIndent)options.FirstLineIndentType; } if (options.LeftIndent.HasValue) { pp.LeftIndent = options.LeftIndent; } if (options.RightIndent.HasValue) { pp.RightIndent = options.RightIndent; } } finally { book.EndUpdateParagraphs(pp); } } Script.Book.SCBook.AddComments(book, range, options); } if (rangeEnd != null) { book.CaretPosition = rangeEnd; ResetBookFormatting(book, rangeEnd); ScrollToCaret(); } } }
private void btnSnapFullScreen_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { var img = Snap(0, 0, Screen.PrimaryScreen.Bounds.Width, Screen.PrimaryScreen.Bounds.Height); myRich.Document.InsertImage(myRich.Document.CaretPosition, DocumentImageSource.FromImage(img)); }
private void btnInsertImage_Click(object sender, EventArgs e) { DocumentPosition pos = richEditControl1.Document.CaretPosition; richEditControl1.Document.Images.Insert(pos, DocumentImageSource.FromUri(imageUri, null)); }
protected internal void PicturePrint(MemoryStream image) { reds.Document.Sections[0].Page.PaperKind = System.Drawing.Printing.PaperKind.A4; reds.Document.Unit = DevExpress.Office.DocumentUnit.Centimeter; reds.Document.Sections[0].Paragraphs[0].Alignment = ParagraphAlignment.Center; reds.Document.Shapes.InsertPicture(reds.Document.Sections[0].Paragraphs[0].Range.Start, DocumentImageSource.FromStream(new MemoryStream(image.ToArray()))); reds.Document.Shapes[0].LockAspectRatio = true; reds.Document.Shapes[0].HorizontalAlignment = ShapeHorizontalAlignment.Center; reds.Document.Shapes[0].VerticalAlignment = ShapeVerticalAlignment.Center; float X = (reds.Document.Sections[0].Page.Width - 2) / reds.Document.Shapes[0].Size.Width; float Y = (reds.Document.Sections[0].Page.Height - 2) / reds.Document.Shapes[0].Size.Height; reds.Document.Shapes[0].ScaleX = reds.Document.Shapes[0].ScaleY = X > Y ? Y : X; LegacyPrintableComponentLink link = new LegacyPrintableComponentLink(reds); dpc = new DocumentPreviewControl(); dpc.DocumentSource = link; link.CreateDocument(); dpc.PrintCommand.Execute(null); }
/// <summary> /// 生成条形码 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnBuildCode_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!string.IsNullOrEmpty(txtBills.Text)) { var billCodeArray = StringUtil.SplitMobile(txtBills.Text.Trim()); foreach (var s in billCodeArray) { Image img = GetBarcode2(100, billCodeRich.Width / 3, BarcodeLib.TYPE.CODE128C, s); if (img != null) { billCodeRich.Document.InsertImage(billCodeRich.Document.CaretPosition, DocumentImageSource.FromImage(img)); // billCodeRich.Document.InsertText(billCodeRich.Document.CaretPosition, Environment.NewLine ); } } } }
public void SendEmail() { DataTable zamok = Zamowienia_DoWyslaniaOK().Result; foreach (DataRow r in zamok.Rows) { #region Pobieranie danych i tworzenie ciała maila. rec1.CreateNewDocument(); rec1.LoadDocument("Zamowienie_OK.docx"); string Status_Zam = ""; string Producent; string PH_Producent; string Numer_Zam; string FileDate; string ZamDate; string Uwagi; string Rodzaj_zam; string XL_Akronim; string Prod_Akronim; string Prod_Adres; if (bool.TryParse(r["Zpn_Alert"].ToString(), out bool al)) { if (al) { Status_Zam = "Błędy mapowania towarów. Obsługa CallCenter"; } else { Status_Zam = "OK. Wysłane do Mobiusa."; } } else { Status_Zam = "OK. Wysłane do Mobiusa."; } if (r["Zpn_Producent"].ToString().Length > 1) { Producent = r["Zpn_Producent"].ToString(); } else { Producent = "BŁĄD"; } if (r["Zpn_NAZWISKO"].ToString().Length > 1) { PH_Producent = r["Zpn_NAZWISKO"].ToString() + " " + r["Zpn_IMIE"].ToString(); } else { PH_Producent = "BŁĄD"; } if (r["Zpn_NR_ZAM"].ToString().Length > 1) { Numer_Zam = r["Zpn_NR_ZAM"].ToString(); } else { Numer_Zam = "BŁĄD"; } if (DateTime.TryParse(r["Zpn_DataPliku"].ToString(), out DateTime Data_Otrz)) { FileDate = Data_Otrz.ToShortDateString() + " " + Data_Otrz.ToShortTimeString(); } else { FileDate = "BŁĄD"; } if (DateTime.TryParse(r["Zpn_DATA_ZAM"].ToString(), out DateTime Data_Zam)) { ZamDate = Data_Zam.ToShortDateString() + " " + Data_Zam.ToShortTimeString(); } else { ZamDate = "BŁĄD"; } if (r["Zpn_UWAGI"].ToString().Length > 1) { Uwagi = r["Zpn_UWAGI"].ToString(); } else { Uwagi = "BŁĄD"; } if (r["Zpn_TYP_ZAM"].ToString().Length > 1) { if (r["Zpn_TYP_ZAM"].ToString() == "ZG") { Rodzaj_zam = "Gratisowe"; } else { Rodzaj_zam = "Standard"; } } else { Rodzaj_zam = "BŁĄD"; } if (r["Knt_Akronim"].ToString().Length > 1) { XL_Akronim = r["Knt_Akronim"].ToString(); } else { XL_Akronim = "BŁĄD"; } if (r["Zpn_NAZWA"].ToString().Length > 1) { Prod_Akronim = r["Zpn_NAZWA"].ToString(); } else { Prod_Akronim = "BŁĄD"; } if ((r["Zpn_MIASTO"].ToString() + r["Zpn_ULICA"].ToString()).Length > 1) { Prod_Adres = r["Zpn_MIASTO"].ToString() + ", " + r["Zpn_ULICA"].ToString(); } else { Prod_Adres = "BŁĄD"; } if (Int32.TryParse(r["Zpn_Id"].ToString(), out int Zpn_id)) { } else { Zpn_id = 0; } rec1.Document.ReplaceAll("<@Status_Zam>", Status_Zam, SearchOptions.None); rec1.Document.ReplaceAll("<@Producent>", Producent, SearchOptions.None); rec1.Document.ReplaceAll("<@PH_Producent>", PH_Producent, SearchOptions.None); rec1.Document.ReplaceAll("<@Numer_Zam>", Numer_Zam, SearchOptions.None); rec1.Document.ReplaceAll("<@Data_Otrz>", FileDate, SearchOptions.None); rec1.Document.ReplaceAll("<@Data_Zam>", ZamDate, SearchOptions.None); rec1.Document.ReplaceAll("<@Uwagi>", Uwagi, SearchOptions.None); rec1.Document.ReplaceAll("<@Rodzaj_Zam>", Rodzaj_zam, SearchOptions.None); rec1.Document.ReplaceAll("<@Knt_XLAkr>", XL_Akronim, SearchOptions.None); rec1.Document.ReplaceAll("<@Knt_ZamProd>", Prod_Akronim, SearchOptions.None); rec1.Document.ReplaceAll("<@Knt_Adres>", Prod_Adres, SearchOptions.None); DocumentRange[] wyniki = rec1.Document.FindAll("<@TABELA>", SearchOptions.None); if (wyniki.Length > 0) { // Paragraph par = rec1.Document.Paragraphs.Get(wyniki[0].Start); DocumentPosition pos = wyniki[0].Start; SubDocument doc = pos.BeginUpdateDocument(); // Add the table rec1.Document.Tables.Create(pos, 1, 9, AutoFitBehaviorType.AutoFitToContents); // Format the table Table tbl = rec1.Document.Tables[0]; pos.EndUpdateDocument(doc); try { tbl.BeginUpdate(); CharacterProperties cp_Tbl = doc.BeginUpdateCharacters(tbl.Range); cp_Tbl.FontSize = 10; cp_Tbl.FontName = "Calibri"; doc.EndUpdateCharacters(cp_Tbl); //tbl.BeginUpdate(); // Insert header caption and format the columns tbl.Rows[0].HeightType = HeightType.Exact; tbl.Rows[0].Height = 80f; doc.InsertSingleLineText(tbl[0, 0].Range.Start, "Lp."); doc.InsertSingleLineText(tbl[0, 1].Range.Start, "Alert"); doc.InsertSingleLineText(tbl[0, 2].Range.Start, "Kod"); doc.InsertSingleLineText(tbl[0, 3].Range.Start, "Towar"); doc.InsertSingleLineText(tbl[0, 4].Range.Start, "il. szt."); doc.InsertSingleLineText(tbl[0, 5].Range.Start, "Ilość"); doc.InsertSingleLineText(tbl[0, 6].Range.Start, "JM"); doc.InsertSingleLineText(tbl[0, 7].Range.Start, "Cena"); doc.InsertSingleLineText(tbl[0, 8].Range.Start, "Gratis"); tbl[0, 0].PreferredWidthType = WidthType.Fixed; tbl[0, 0].PreferredWidth = DevExpress.Office.Utils.Units.InchesToDocumentsF(0.2f); tbl[0, 0].VerticalAlignment = TableCellVerticalAlignment.Center; tbl[0, 1].PreferredWidthType = WidthType.Fixed; tbl[0, 1].PreferredWidth = DevExpress.Office.Utils.Units.InchesToDocumentsF(0.4f); tbl[0, 1].VerticalAlignment = TableCellVerticalAlignment.Center; tbl[0, 2].PreferredWidthType = WidthType.Fixed; tbl[0, 2].PreferredWidth = DevExpress.Office.Utils.Units.InchesToDocumentsF(0.8f); tbl[0, 2].VerticalAlignment = TableCellVerticalAlignment.Center; tbl[0, 3].PreferredWidthType = WidthType.Fixed; tbl[0, 3].PreferredWidth = DevExpress.Office.Utils.Units.InchesToDocumentsF(2.6f); tbl[0, 3].VerticalAlignment = TableCellVerticalAlignment.Center; tbl[0, 4].PreferredWidthType = WidthType.Fixed; tbl[0, 4].PreferredWidth = DevExpress.Office.Utils.Units.InchesToDocumentsF(0.5f); tbl[0, 4].VerticalAlignment = TableCellVerticalAlignment.Center; tbl[0, 5].PreferredWidthType = WidthType.Fixed; tbl[0, 5].PreferredWidth = DevExpress.Office.Utils.Units.InchesToDocumentsF(0.6f); tbl[0, 5].VerticalAlignment = TableCellVerticalAlignment.Center; tbl[0, 6].PreferredWidthType = WidthType.Fixed; tbl[0, 6].PreferredWidth = DevExpress.Office.Utils.Units.InchesToDocumentsF(0.3f); tbl[0, 6].VerticalAlignment = TableCellVerticalAlignment.Center; tbl[0, 7].PreferredWidthType = WidthType.Fixed; tbl[0, 7].PreferredWidth = DevExpress.Office.Utils.Units.InchesToDocumentsF(0.6f); tbl[0, 7].VerticalAlignment = TableCellVerticalAlignment.Center; tbl[0, 8].PreferredWidthType = WidthType.Fixed; tbl[0, 8].PreferredWidth = DevExpress.Office.Utils.Units.InchesToDocumentsF(0.4f); tbl[0, 8].VerticalAlignment = TableCellVerticalAlignment.Center; /* * //Apply formatting to the "Active Customers" cell * CharacterProperties properties = rec1.Document.BeginUpdateCharacters(tbl[0, 1].ContentRange); * properties.FontName = "Segoe UI"; * properties.FontSize = 16; * document.EndUpdateCharacters(properties); * ParagraphProperties alignment = document.BeginUpdateParagraphs(table[0, 1].ContentRange); * alignment.Alignment = ParagraphAlignment.Center; * document.EndUpdateParagraphs(alignment); * table[0, 1].VerticalAlignment = TableCellVerticalAlignment.Center; */ int wiersz = 0; DataTable dt_poz = ZamowieniaPozycje_DoWyslaniaOK(Zpn_id).Result; foreach (DataRow r_poz in dt_poz.Rows) { wiersz++; tbl.Rows.InsertAfter(wiersz - 1); tbl.Rows[wiersz].HeightType = HeightType.Auto; if (bool.TryParse(r_poz["Alert"].ToString(), out bool ale)) { if (ale) { doc.Images.Insert(tbl[wiersz, 1].Range.Start, DocumentImageSource.FromFile("alert.png")); } } else { ale = false; } doc.InsertSingleLineText(tbl[wiersz, 0].Range.Start, r_poz["Poz"].ToString()); doc.InsertSingleLineText(tbl[wiersz, 2].Range.Start, r_poz["Kod"].ToString()); doc.InsertSingleLineText(tbl[wiersz, 3].Range.Start, r_poz["Towar_MAG"].ToString()); doc.InsertSingleLineText(tbl[wiersz, 4].Range.Start, r_poz["Ilosc_szt"].ToString()); doc.InsertSingleLineText(tbl[wiersz, 5].Range.Start, r_poz["Ilosc_JM"].ToString()); doc.InsertSingleLineText(tbl[wiersz, 6].Range.Start, r_poz["JM"].ToString().ToUpper()); doc.InsertSingleLineText(tbl[wiersz, 7].Range.Start, r_poz["Cena_Netto"].ToString()); if (bool.TryParse(r_poz["Gratis"].ToString(), out bool gratt)) { } else { gratt = false; } if (bool.TryParse(r_poz["Promocja"].ToString(), out bool dol)) { } else { ale = false; } if (gratt || dol || r["Zpn_TYP_ZAM"].ToString() == "ZG") { doc.Images.Insert(tbl[wiersz, 8].Range.Start, DocumentImageSource.FromFile("gift.png")); } } //Apply formatting to the header cells CharacterProperties headerRowProperties = rec1.Document.BeginUpdateCharacters(tbl.Rows[0].Range); headerRowProperties.FontName = "Calibri"; headerRowProperties.FontSize = 10; headerRowProperties.Bold = true; //headerRowProperties.ForeColor = Color.FromArgb(212, 236, 183); rec1.Document.EndUpdateCharacters(headerRowProperties); ParagraphProperties headerRowParagraphProperties = rec1.Document.BeginUpdateParagraphs(tbl.Rows[0].Range); headerRowParagraphProperties.Alignment = ParagraphAlignment.Center; float f = 0.4f; headerRowParagraphProperties.LeftIndent = f; headerRowParagraphProperties.SpacingBefore = 2; headerRowParagraphProperties.SpacingAfter = 2; rec1.Document.EndUpdateParagraphs(headerRowParagraphProperties); //Apply formatting to Row cells if (tbl.Rows.Count > 1) { DocumentRange targetRange = rec1.Document.CreateRange(tbl[1, 0].Range.Start, tbl[tbl.Rows.Count - 1, 8].Range.End.ToInt()); ParagraphProperties RowParagraphProperties = rec1.Document.BeginUpdateParagraphs(targetRange); RowParagraphProperties.LeftIndent = DevExpress.Office.Utils.Units.InchesToDocumentsF(0.1f);; RowParagraphProperties.SpacingBefore = 8; RowParagraphProperties.SpacingAfter = 8; rec1.Document.EndUpdateParagraphs(RowParagraphProperties); CharacterProperties infoProperties = rec1.Document.BeginUpdateCharacters(targetRange); infoProperties.FontSize = 10; infoProperties.FontName = "Calibri"; rec1.Document.EndUpdateCharacters(infoProperties); } //Apply formatting to Number cells for (int i = 1; i < tbl.Rows.Count; i++) { ParagraphProperties RrParagraphProperties = rec1.Document.BeginUpdateParagraphs(tbl[i, 4].Range); RrParagraphProperties.Alignment = ParagraphAlignment.Right; rec1.Document.EndUpdateParagraphs(RrParagraphProperties); RrParagraphProperties = rec1.Document.BeginUpdateParagraphs(tbl[i, 5].Range); RrParagraphProperties.Alignment = ParagraphAlignment.Right; rec1.Document.EndUpdateParagraphs(RrParagraphProperties); RrParagraphProperties = rec1.Document.BeginUpdateParagraphs(tbl[i, 7].Range); RrParagraphProperties.Alignment = ParagraphAlignment.Right; rec1.Document.EndUpdateParagraphs(RrParagraphProperties); RrParagraphProperties = rec1.Document.BeginUpdateParagraphs(tbl[i, 0].Range); RrParagraphProperties.Alignment = ParagraphAlignment.Right; rec1.Document.EndUpdateParagraphs(RrParagraphProperties); } } finally { tbl.EndUpdate(); doc.BeginUpdate(); TableStyle tStyleMain = rec1.Document.TableStyles.CreateNew(); //Specify style options tStyleMain.TableBorders.InsideHorizontalBorder.LineStyle = TableBorderLineStyle.Single; tStyleMain.TableBorders.InsideHorizontalBorder.LineColor = Color.White; tStyleMain.TableBorders.InsideVerticalBorder.LineStyle = TableBorderLineStyle.Single; tStyleMain.TableBorders.InsideVerticalBorder.LineColor = Color.White; tStyleMain.CellBackgroundColor = Color.FromArgb(227, 238, 220); tStyleMain.Name = "MyTableStyle"; //Add the style to the document collection rec1.Document.TableStyles.Add(tStyleMain); //Create conditional styles (styles for specific table elements) TableConditionalStyle myNewStyleForOddRows = tStyleMain.ConditionalStyleProperties.CreateConditionalStyle(ConditionalTableStyleFormattingTypes.OddRowBanding); myNewStyleForOddRows.CellBackgroundColor = Color.FromArgb(196, 220, 182); TableConditionalStyle myNewStyleForBottomRightCell = tStyleMain.ConditionalStyleProperties.CreateConditionalStyle(ConditionalTableStyleFormattingTypes.BottomRightCell); myNewStyleForBottomRightCell.CellBackgroundColor = Color.FromArgb(188, 214, 201); doc.EndUpdate(); doc.BeginUpdate(); // Apply a previously defined style to the table tbl.Style = tStyleMain; doc.EndUpdate(); rec1.Document.ReplaceAll("<@TABELA>", "", SearchOptions.None); } } #endregion #region Wysyłanie Maila i update statusów if (r["prc_email"].ToString().Length > 0) { string Temat = "Nowe zamówienie producenckie."; try { MailMessage mailMessage = new MailMessage("*****@*****.**", r["prc_email"].ToString()); mailMessage.Subject = Temat; RichEditMailMessageExporter exporter = new RichEditMailMessageExporter(rec1, mailMessage); exporter.Export(); SmtpClient mailSender = new SmtpClient(); mailSender.Port = 587; mailSender.Host = "mag-ol.home.pl"; mailSender.Timeout = 10000; mailSender.DeliveryMethod = SmtpDeliveryMethod.Network; mailSender.UseDefaultCredentials = false; mailSender.Credentials = new NetworkCredential("*****@*****.**", "!Raporty123"); mailSender.EnableSsl = true; mailMessage.From = new MailAddress("*****@*****.**"); //specify your login/password to log on to the SMTP server, if required //mailSender.Credentials = new NetworkCredential("login", "password"); mailSender.Send(mailMessage); int.TryParse(r["Zpn_ID"].ToString(), out int id); if (id > 0) { SQL.UpdateDocumentMailStatus(id); } } catch (Exception exc) { MessageBox.Show(exc.Message); } } #endregion } }
public DocumentImageSource CreateImage() { return(DocumentImageSource.FromStream(CreateChart())); }
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; } } }