public static void Run() { //ExStart:DocumentBuilderInsertParagraph // The path to the documents directory. string dataDir = RunExamples.GetDataDir_WorkingWithDocument(); // Initialize document. Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Specify font formatting Aspose.Words.Font font = builder.Font; font.Size = 16; font.Bold = true; font.Color = System.Drawing.Color.Blue; font.Name = "Arial"; font.Underline = Underline.Dash; // Specify paragraph formatting ParagraphFormat paragraphFormat = builder.ParagraphFormat; paragraphFormat.FirstLineIndent = 8; paragraphFormat.Alignment = ParagraphAlignment.Justify; paragraphFormat.KeepTogether = true; builder.Writeln("A whole paragraph."); dataDir = dataDir + "DocumentBuilderInsertParagraph_out_.doc"; doc.Save(dataDir); //ExEnd:DocumentBuilderInsertParagraph Console.WriteLine("\nParagraph inserted successfully into the document using DocumentBuilder.\nFile saved at " + dataDir); }
public void InsertParagraph() { //ExStart:InsertParagraph Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); Font font = builder.Font; font.Size = 16; font.Bold = true; font.Color = Color.Blue; font.Name = "Arial"; font.Underline = Underline.Dash; ParagraphFormat paragraphFormat = builder.ParagraphFormat; paragraphFormat.FirstLineIndent = 8; paragraphFormat.Alignment = ParagraphAlignment.Justify; paragraphFormat.KeepTogether = true; builder.Writeln("A whole paragraph."); doc.Save(ArtifactsDir + "AddContentUsingDocumentBuilder.InsertParagraph.docx"); //ExEnd:InsertParagraph }
static void Main(string[] args) { // Open the document. Document doc = new Document("Create and add a paragraph style.doc"); DocumentBuilder builder = new DocumentBuilder(doc); // Set font formatting properties Aspose.Words.Font font = builder.Font; font.Bold = true; font.Color = System.Drawing.Color.Red; font.Italic = true; font.Name = "Arial"; font.Size = 24; font.Spacing = 5; font.Underline = Underline.Double; // Output formatted text builder.MoveToDocumentEnd(); builder.Writeln("I'm a very nice formatted string. zeeshan"); string txt = builder.CurrentParagraph.GetText(); doc.Save("Create and add a paragraph style.doc"); }
private void InsertTasks(DocumentBuilder builder, List <InvoiceLine> invoiceLineData, int projectId, string timeSpecifier, bool fixedProject) { var tasks = _invoiceService.GetSpecificationDataTasks(invoiceLineData.Select(i => i.InvoiceID).First(), fixedProject); foreach (var t in tasks.Where(x => projectId == x.ProjectID)) { builder.InsertCell(); BuilderSettings(builder, 2, LineStyle.None, ParagraphAlignment.Left); builder.CellFormat.Shading.BackgroundPatternColor = Color.White; Aspose.Words.Font font3 = builder.Font; font3.Size = 11; font3.Bold = false; font3.Color = Color.Black; builder.PageSetup.RightMargin = 50; builder.InsertCell(); builder.CellFormat.WrapText = true; builder.CellFormat.Shading.BackgroundPatternColor = Color.White; BuilderSettings(builder, 88, LineStyle.None, ParagraphAlignment.Left); builder.RowFormat.Height = CalculateCellHeigth(t.TaskName, 88, builder) * 15; builder.Write(t.TaskName); builder.InsertCell(); BuilderSettings(builder, 10, LineStyle.None, ParagraphAlignment.Right); builder.Write(t.TimeUsed.Value.ToString(timeSpecifier)); builder.EndRow(); } }
public void CreateFormattedRun() { //ExStart //ExFor:Document.#ctor //ExFor:Font //ExFor:Font.Name //ExFor:Font.Size //ExFor:Font.HighlightColor //ExFor:Run //ExFor:Run.#ctor(DocumentBase,String) //ExFor:Story.FirstParagraph //ExSummary:Shows how to add a formatted run of text to a document using the object model. // Create an empty document. It contains one empty paragraph. Document doc = new Document(); // Create a new run of text. Run run = new Run(doc, "Hello"); // Specify character formatting for the run of text. Aspose.Words.Font f = run.Font; f.Name = "Courier New"; f.Size = 36; f.HighlightColor = Color.Yellow; // Append the run of text to the end of the first paragraph // in the body of the first section of the document. doc.FirstSection.Body.FirstParagraph.AppendChild(run); //ExEnd }
public void DocumentBuilderInsertParagraph() { //ExStart //ExFor:DocumentBuilder.InsertParagraph //ExFor:ParagraphFormat.FirstLineIndent //ExFor:ParagraphFormat.Alignment //ExFor:ParagraphFormat.KeepTogether //ExFor:ParagraphFormat.AddSpaceBetweenFarEastAndAlpha //ExFor:ParagraphFormat.AddSpaceBetweenFarEastAndDigit //ExFor:Paragraph.IsEndOfDocument //ExSummary:Shows how to insert a paragraph into the document. Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Specify font formatting Font font = builder.Font; font.Size = 16; font.Bold = true; font.Color = Color.Blue; font.Name = "Arial"; font.Underline = Underline.Dash; // Specify paragraph formatting ParagraphFormat paragraphFormat = builder.ParagraphFormat; paragraphFormat.FirstLineIndent = 8; paragraphFormat.Alignment = ParagraphAlignment.Justify; paragraphFormat.AddSpaceBetweenFarEastAndAlpha = true; paragraphFormat.AddSpaceBetweenFarEastAndDigit = true; paragraphFormat.KeepTogether = true; // Using Writeln() ends the paragraph after writing and makes a new one, while Write() stays on the same paragraph builder.Writeln("A whole paragraph."); // We can use this flag to ensure that we are at the end of the document Assert.True(builder.CurrentParagraph.IsEndOfDocument); //ExEnd doc = DocumentHelper.SaveOpen(doc); Paragraph paragraph = doc.FirstSection.Body.FirstParagraph; Assert.AreEqual(8, paragraph.ParagraphFormat.FirstLineIndent); Assert.AreEqual(ParagraphAlignment.Justify, paragraph.ParagraphFormat.Alignment); Assert.True(paragraph.ParagraphFormat.AddSpaceBetweenFarEastAndAlpha); Assert.True(paragraph.ParagraphFormat.AddSpaceBetweenFarEastAndDigit); Assert.True(paragraph.ParagraphFormat.KeepTogether); Assert.AreEqual("A whole paragraph.", paragraph.GetText().Trim()); Font runFont = paragraph.Runs[0].Font; Assert.AreEqual(16.0d, runFont.Size); Assert.True(runFont.Bold); Assert.AreEqual(Color.Blue.ToArgb(), runFont.Color.ToArgb()); Assert.AreEqual("Arial", runFont.Name); Assert.AreEqual(Underline.Dash, runFont.Underline); }
private void InsertProjects(DocumentBuilder builder, IEnumerable <GetSpecificationData_Project_Result> projectResults, List <InvoiceLine> invoiceLineData, string timeSpecifier) { try { Color original = Color.FromArgb(228, 244, 221); double hue; double saturation; double value; ColorToHSV(original, out hue, out saturation, out value); Color taskBar = ColorFromHSV(hue, saturation, value); // Compare that to the HSL values that the .NET framework provides: original.GetHue(); // 212.0 original.GetSaturation(); // 0.6 original.GetBrightness(); // 0.490196079 foreach (var p in projectResults) { builder.InsertCell(); builder.PageSetup.RightMargin = 50; builder.RowFormat.Height = 18; builder.RowFormat.HeightRule = HeightRule.Exactly; BuilderSettings(builder, 80, LineStyle.None, ParagraphAlignment.Left); builder.CellFormat.HorizontalMerge = CellMerge.First; builder.CellFormat.Shading.BackgroundPatternColor = taskBar; builder.CellFormat.WrapText = true; Aspose.Words.Font font2 = builder.Font; font2.Size = 11; font2.Bold = true; font2.Color = Color.Black; builder.Write(p.ProjectName); builder.InsertCell(); BuilderSettings(builder, 20, LineStyle.None, ParagraphAlignment.Right); builder.CellFormat.HorizontalMerge = CellMerge.None; builder.CellFormat.Shading.BackgroundPatternColor = taskBar; if (p.FixedPriceProject == false) { builder.Write(p.TimeUsed.Value.ToString(timeSpecifier)); } builder.EndRow(); builder.EndTable(); InsertTasks(builder, invoiceLineData, p.ProjectID.Value, timeSpecifier, p.FixedPriceProject == true); } } catch (Exception ex) { LogError(ex); throw; } }
public void DocumentBuilderInsertParagraph() { //ExStart //ExFor:DocumentBuilder.InsertParagraph //ExFor:ParagraphFormat.FirstLineIndent //ExFor:ParagraphFormat.Alignment //ExFor:ParagraphFormat.KeepTogether //ExFor:ParagraphFormat.AddSpaceBetweenFarEastAndAlpha //ExFor:ParagraphFormat.AddSpaceBetweenFarEastAndDigit //ExFor:Paragraph.IsEndOfDocument //ExSummary:Shows how to insert a paragraph into the document. Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); Font font = builder.Font; font.Size = 16; font.Bold = true; font.Color = Color.Blue; font.Name = "Arial"; font.Underline = Underline.Dash; ParagraphFormat paragraphFormat = builder.ParagraphFormat; paragraphFormat.FirstLineIndent = 8; paragraphFormat.Alignment = ParagraphAlignment.Justify; paragraphFormat.AddSpaceBetweenFarEastAndAlpha = true; paragraphFormat.AddSpaceBetweenFarEastAndDigit = true; paragraphFormat.KeepTogether = true; // The "Writeln" method ends the paragraph after appending text // and then starts a new line, adding a new paragraph. builder.Writeln("Hello world!"); Assert.True(builder.CurrentParagraph.IsEndOfDocument); //ExEnd doc = DocumentHelper.SaveOpen(doc); Paragraph paragraph = doc.FirstSection.Body.FirstParagraph; Assert.AreEqual(8, paragraph.ParagraphFormat.FirstLineIndent); Assert.AreEqual(ParagraphAlignment.Justify, paragraph.ParagraphFormat.Alignment); Assert.True(paragraph.ParagraphFormat.AddSpaceBetweenFarEastAndAlpha); Assert.True(paragraph.ParagraphFormat.AddSpaceBetweenFarEastAndDigit); Assert.True(paragraph.ParagraphFormat.KeepTogether); Assert.AreEqual("Hello world!", paragraph.GetText().Trim()); Font runFont = paragraph.Runs[0].Font; Assert.AreEqual(16.0d, runFont.Size); Assert.True(runFont.Bold); Assert.AreEqual(Color.Blue.ToArgb(), runFont.Color.ToArgb()); Assert.AreEqual("Arial", runFont.Name); Assert.AreEqual(Underline.Dash, runFont.Underline); }
/// <summary> /// Ghi giá trị vào word /// </summary> /// <param name="value">gái trị</param> /// <param name="fontName">tên font</param> /// <param name="fontSize">kích thước chữ</param> /// <param name="fontStyle">Kiểu, dùng | của FontStyle</param> /// <param name="color">màu (mặc định đen)</param> /// <param name="underline">gạch dưới</param> public void WriteToWord(string value, string fontName = "", double fontSize = 0, int fontStyle = 0, System.Drawing.Color?color = null, Underline underline = Underline.None) { try { Aspose.Words.Font oldFont = this._builder.Font; if (!string.IsNullOrWhiteSpace(fontName)) { this._builder.Font.Name = fontName; } if (fontSize > 0) { this._builder.Font.Size = fontSize; } if (color != null) { this._builder.Font.Color = color.Value; } this._builder.Font.AllCaps = (fontStyle & (int)FontStyle.AllCaps) == (int)FontStyle.AllCaps; this._builder.Font.Bold = (fontStyle & (int)FontStyle.Bold) == (int)FontStyle.Bold; this._builder.Font.Italic = (fontStyle & (int)FontStyle.Italic) == (int)FontStyle.Italic; this._builder.Font.Outline = (fontStyle & (int)FontStyle.Outline) == (int)FontStyle.Outline; this._builder.Font.SmallCaps = (fontStyle & (int)FontStyle.SmallCaps) == (int)FontStyle.SmallCaps; this._builder.Font.StrikeThrough = (fontStyle & (int)FontStyle.StrikeThrough) == (int)FontStyle.StrikeThrough; this._builder.Font.Subscript = (fontStyle & (int)FontStyle.Subscript) == (int)FontStyle.Subscript; this._builder.Font.Superscript = (fontStyle & (int)FontStyle.Superscript) == (int)FontStyle.Superscript; this._builder.Font.Underline = underline; this._builder.Write(value); this._builder.Font.Name = oldFont.Name; this._builder.Font.Size = oldFont.Size; this._builder.Font.Color = oldFont.Color; this._builder.Font.AllCaps = oldFont.AllCaps; this._builder.Font.Bold = oldFont.Bold; this._builder.Font.Italic = oldFont.Italic; this._builder.Font.Outline = oldFont.Outline; this._builder.Font.SmallCaps = oldFont.SmallCaps; this._builder.Font.StrikeThrough = oldFont.StrikeThrough; this._builder.Font.Subscript = oldFont.Subscript; this._builder.Font.Superscript = oldFont.Superscript; this._builder.Font.Underline = oldFont.Underline; } catch (Exception ex) { if (indebugMode) { throw ex; } } }
private void toolStripButton3_Click(object sender, EventArgs e) { var allxlsfalsewords = Xldata.Select(r => r.FalseWord).ToArray(); string[] falewordsindoc = allxlsfalsewords.Intersect(Splitted).ToArray(); Falewordsindoc = Xldata.Where(r => falewordsindoc.Contains(r.FalseWord)); listBox1.Items.Clear(); var falsewordLists = Falewordsindoc as WordList[] ?? Falewordsindoc.ToArray(); listBox1.Items.AddRange(falsewordLists.Select(q => new { S = q.FalseWord + " ====> " + q.TrueWord }).Select(a => a.S).ToArray()); Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); builder.Font.Bidi = true; builder.CurrentParagraph.ParagraphFormat.Bidi = true; builder.Font.LocaleIdBi = 1025; Aspose.Words.Font font = builder.Font; builder.Font.NameBi = "Arial"; builder.Font.SizeBi = 16; builder.Write(richTextBox1.Text); var options = new FindReplaceOptions { FindWholeWordsOnly = true, ReplacingCallback = new ReplaceEvaluatorFindAndHighlight(), Direction = FindReplaceDirection.Backward }; foreach (WordList falsewarod in falsewordLists) { doc.Range.Replace(falsewarod.FalseWord, "", options); } string temppath = Path.GetDirectoryName(Sourcewdpath) + "\\" + Path.GetFileNameWithoutExtension(Sourcewdpath) + "-temp.rtf"; builder.Document.Save(temppath, SaveFormat.Rtf); richTextBox1.LoadFile(temppath); File.Delete(temppath); }
public void GetFontLineSpacing() { //ExStart:GetFontLineSpacing Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); builder.Font.Name = "Calibri"; builder.Writeln("qText"); Font font = builder.Document.FirstSection.Body.FirstParagraph.Runs[0].Font; Console.WriteLine($"lineSpacing = {font.LineSpacing}"); //ExEnd:GetFontLineSpacing }
private void EscreverLinhaEmBranco(int size = 5) { Builder.EndTable(); Font font = Builder.Font; font.Size = 0; Builder.Writeln(ControlChar.SpaceChar.ToString()); font.Size = size; Builder.StartTable(); }
public void CheckDMLTextEffect() { //ExStart:CheckDMLTextEffect Document doc = new Document(MyDir + "DrawingML text effects.docx"); RunCollection runs = doc.FirstSection.Body.FirstParagraph.Runs; Font runFont = runs[0].Font; // One run might have several Dml text effects applied. Console.WriteLine(runFont.HasDmlEffect(TextDmlEffect.Shadow)); Console.WriteLine(runFont.HasDmlEffect(TextDmlEffect.Effect3D)); Console.WriteLine(runFont.HasDmlEffect(TextDmlEffect.Reflection)); Console.WriteLine(runFont.HasDmlEffect(TextDmlEffect.Outline)); Console.WriteLine(runFont.HasDmlEffect(TextDmlEffect.Fill)); //ExEnd:CheckDMLTextEffect }
static void Main(string[] args) { Document doc = new Document("Sample Aspose.doc"); DocumentBuilder builder = new DocumentBuilder(doc); // Specify font formatting before adding text. Aspose.Words.Font font = builder.Font; font.Size = 16; font.Bold = true; font.Color = Color.Blue; font.Name = "Arial"; font.Underline = Underline.Dash; builder.Write("Insert text"); doc.Save("Add text Out.doc"); }
private void InitFormats(Paragraph para, ref DocumentBuilder builder, out Aspose.Words.Font font, out ParagraphFormat paragraphFormat) { Aspose.Words.Font origFont = para.ParagraphBreakFont; font = builder.Font; font.Size = origFont.Size; font.Bold = origFont.Bold; font.Color = origFont.Color; font.Name = origFont.Name; font.Underline = origFont.Underline; paragraphFormat = builder.ParagraphFormat; //paragraphFormat.FirstLineIndent = para.ParagraphFormat.FirstLineIndent; //paragraphFormat.Alignment = para.ParagraphFormat.Alignment; //paragraphFormat.KeepTogether = para.ParagraphFormat.KeepTogether; }
public void FontFormatting() { //ExStart:WriteAndFont Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); Font font = builder.Font; font.Size = 16; font.Bold = true; font.Color = Color.Blue; font.Name = "Arial"; font.Underline = Underline.Dash; builder.Write("Sample text."); doc.Save(ArtifactsDir + "WorkingWithFonts.FontFormatting.docx"); //ExEnd:WriteAndFont }
static void Main(string[] args) { string FilePath = @"..\..\..\..\Sample Files\"; string File = FilePath + "Open and add text.docx"; Document doc = new Document(File); DocumentBuilder builder = new DocumentBuilder(doc); // Specify font formatting before adding text. Aspose.Words.Font font = builder.Font; font.Size = 16; font.Bold = true; font.Color = Color.Blue; font.Name = "Arial"; font.Underline = Underline.Dash; builder.Write("Insert text"); doc.Save(File); }
public void SetFontFormatting() { //ExStart:DocumentBuilderSetFontFormatting Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); Font font = builder.Font; font.Bold = true; font.Color = Color.DarkBlue; font.Italic = true; font.Name = "Arial"; font.Size = 24; font.Spacing = 5; font.Underline = Underline.Double; builder.Writeln("I'm a very nice formatted string."); doc.Save(ArtifactsDir + "WorkingWithFonts.SetFontFormatting.docx"); //ExEnd:DocumentBuilderSetFontFormatting }
public static byte[] Txt2PDF(byte[] fileBuffer) { MemoryStream mystream = new MemoryStream(fileBuffer); var encoding = System.Text.Encoding.Default; if (fileBuffer.Length >= 2 && fileBuffer[0] >= 0xEF) { if (fileBuffer[0] == 0xEF && fileBuffer[1] == 0xBB) { encoding = System.Text.Encoding.UTF8; } else if (fileBuffer[0] == 0xFE && fileBuffer[1] == 0xFF) { encoding = System.Text.Encoding.BigEndianUnicode; } else if (fileBuffer[0] == 0xFF && fileBuffer[1] == 0xFE) { encoding = System.Text.Encoding.Unicode; } } System.IO.TextReader tr = new StreamReader(mystream, encoding); var text = tr.ReadToEnd(); var pdfStream = new MemoryStream(); var doc = new Aspose.Words.Document(); Aspose.Words.DocumentBuilder builder = new Aspose.Words.DocumentBuilder(doc); Aspose.Words.Font font = builder.Font; font.Name = "宋体"; builder.Write(text); // 转PDF doc.Save(pdfStream, Aspose.Words.SaveFormat.Pdf); var buffer = pdfStream.ToArray(); pdfStream.Close(); return(buffer); }
public void CreateTestPaper(string content, string savepath) { string doctemplatepath = DocTemplatePath(); // 获取Word模板文件路径 Document doc = new Document(); DocumentBuilder docbuilder = new DocumentBuilder(doc); Section section = docbuilder.CurrentSection; section.PageSetup.LeftMargin = 36.4; // 内容与页面左边距 section.PageSetup.TopMargin = 5; // 内容与页面上边距 section.PageSetup.RightMargin = 25.7; // 内容与页面右边距 section.PageSetup.BottomMargin = 30; // 内容与页面下边距 section.PageSetup.PageWidth = 750; section.PageSetup.PageHeight = 5000; Aspose.Words.Font font = docbuilder.Font; font.Size = 13; //font.Bold = false; //font.Color = Color.Red; font.Name = "Arial"; //docbuilder.Write("雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁雄关漫道真如铁"); //docbuilder.InsertBreak(BreakType.LineBreak); // 当前页中插入空行 //docbuilder.InsertBreak(BreakType.LineBreak); // 当前页中插入空行 //docbuilder.InsertHtml("<table border='0' cellpadding='0' cellspacing='0' style='width:100%;text-align:center;'><tr><td style='height:35px;border-top:solid 1px #000;'>1</td><td>2</td><td>3</td><td>4</td><td>5</td><td>6</td></tr></table>"); //docbuilder.InsertHtml("<img alt='' width='320' height='240' src='https://p3.ssl.cdn.btime.com/t010608c9db47b81e51.jpg?size=640x426' />"); //docbuilder.InsertHtml("<img alt='' width='320' height='240' src='https://p0.ssl.cdn.btime.com/t015464ec52443b63a6.jpg?size=600x720' />"); //docbuilder.InsertBreak(BreakType.LineBreak); //docbuilder.InsertHtml("<img alt='' width='320' height='240' src='https://p3.ssl.cdn.btime.com/t010608c9db47b81e51.jpg?size=640x426' />"); //docbuilder.InsertHtml("<img alt='' width='320' height='240' src='https://p0.ssl.cdn.btime.com/t015464ec52443b63a6.jpg?size=600x720' />"); //docbuilder.InsertHtml("<div style='width:100px;height:120px;background-color:silver;font-weight:bold;color:orangered;'>而今迈步从头越</div>"); docbuilder.InsertHtml(content); doc.Save(savepath); }
public static void SetFontFormatting(string dataDir) { //ExStart:DocumentBuilderSetFontFormatting Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Set font formatting properties Aspose.Words.Font font = builder.Font; font.Bold = true; font.Color = System.Drawing.Color.DarkBlue; font.Italic = true; font.Name = "Arial"; font.Size = 24; font.Spacing = 5; font.Underline = Underline.Double; // Output formatted text builder.Writeln("I'm a very nice formatted string."); dataDir = dataDir + "DocumentBuilderSetFontFormatting_out_.doc"; doc.Save(dataDir); //ExEnd:DocumentBuilderSetFontFormatting Console.WriteLine("\nFont formatting using DocumentBuilder set successfully.\nFile saved at " + dataDir); }
public static void Run() { //ExStart:WriteAndFont // The path to the documents directory. string dataDir = RunExamples.GetDataDir_WorkingWithDocument(); // Initialize document. Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Specify font formatting before adding text. Aspose.Words.Font font = builder.Font; font.Size = 16; font.Bold = true; font.Color = Color.Blue; font.Name = "Arial"; font.Underline = Underline.Dash; builder.Write("Sample text."); dataDir = dataDir + "WriteAndFont_out_.doc"; doc.Save(dataDir); //ExEnd:WriteAndFont Console.WriteLine("\nFormatted text using DocumentBuilder inserted successfully.\nFile saved at " + dataDir); }
public ActionResult Approval(int PROPOSAL_ID = 0, string PROPOSAL_PNPS_CODEZZ = "", int PROPOSAL_KOMTEK_ID = 0, int[] PROPOSAL_ICS_REF_ICS_ID = null) { var DataProposal = (from proposal in db.VIEW_PROPOSAL where proposal.PROPOSAL_ID == PROPOSAL_ID select proposal).SingleOrDefault(); var PROPOSAL_PNPS_CODE = db.Database.SqlQuery <string>("SELECT CAST(TO_CHAR (SYSDATE, 'YYYY') || '.' || KOMTEK_CODE || '.' || ( SELECT CAST ( ( CASE WHEN LENGTH (COUNT(PROPOSAL_ID) + 1) = 1 THEN '0' || CAST ( COUNT (PROPOSAL_ID) + 1 AS VARCHAR2 (255) ) ELSE CAST ( COUNT (PROPOSAL_ID) + 1 AS VARCHAR2 (255) ) END ) AS VARCHAR2 (255) ) PNPSCODE FROM TRX_PROPOSAL WHERE PROPOSAL_KOMTEK_ID = KOMTEK_ID ) AS VARCHAR2(255)) AS PNPSCODE FROM MASTER_KOMITE_TEKNIS WHERE KOMTEK_ID = " + PROPOSAL_KOMTEK_ID).SingleOrDefault(); string test = "SELECT CAST(TO_CHAR (SYSDATE, 'YYYY') || '.' || KOMTEK_CODE || '.' || ( SELECT CAST ( ( CASE WHEN LENGTH (COUNT(PROPOSAL_ID) + 1) = 1 THEN '0' || CAST ( COUNT (PROPOSAL_ID) + 1 AS VARCHAR2 (255) ) ELSE CAST ( COUNT (PROPOSAL_ID) + 1 AS VARCHAR2 (255) ) END ) AS VARCHAR2 (255) ) PNPSCODE FROM TRX_PROPOSAL WHERE PROPOSAL_KOMTEK_ID = KOMTEK_ID ) AS VARCHAR2(255)) AS PNPSCODE FROM MASTER_KOMITE_TEKNIS WHERE KOMTEK_ID = " + PROPOSAL_KOMTEK_ID; var USER_ID = Convert.ToInt32(Session["USER_ID"]); var PROPOSAL_PNPS_CODE_FIXER = DataProposal.PROPOSAL_CODE; var DATENOW = MixHelper.ConvertDateNow(); db.Database.ExecuteSqlCommand("UPDATE TRX_PROPOSAL SET PROPOSAL_STATUS = 3, PROPOSAL_STATUS_PROSES = 1,PROPOSAL_KOMTEK_ID = " + PROPOSAL_KOMTEK_ID + ", PROPOSAL_IS_POLLING = 0, PROPOSAL_POLLING_ID = NULL, PROPOSAL_UPDATE_DATE = " + DATENOW + ", PROPOSAL_UPDATE_BY = " + USER_ID + " WHERE PROPOSAL_ID = " + PROPOSAL_ID); var PROPOSAL_LOG_CODE = db.Database.SqlQuery <string>("SELECT PROPOSAL_LOG_CODE FROM TRX_PROPOSAL WHERE PROPOSAL_ID = " + PROPOSAL_ID).SingleOrDefault(); String objek1 = "UPDATE TRX_PROPOSAL SET PROPOSAL_STATUS = 3,PROPOSAL_KOMTEK_ID = " + PROPOSAL_KOMTEK_ID + ", PROPOSAL_STATUS_PROSES = 1, PROPOSAL_IS_POLLING = 0, PROPOSAL_POLLING_ID = NULL, PROPOSAL_UPDATE_DATE = " + DATENOW + ", PROPOSAL_UPDATE_BY = " + USER_ID + " WHERE PROPOSAL_ID = " + PROPOSAL_ID; MixHelper.InsertLog(PROPOSAL_LOG_CODE, objek1.Replace("'", "-"), 2); int APPROVAL_ID = MixHelper.GetSequence("TRX_PROPOSAL_APPROVAL"); db.Database.ExecuteSqlCommand("UPDATE TRX_PROPOSAL_APPROVAL SET APPROVAL_STATUS = 0 WHERE APPROVAL_PROPOSAL_ID = " + PROPOSAL_ID); db.Database.ExecuteSqlCommand("INSERT INTO TRX_PROPOSAL_APPROVAL (APPROVAL_ID,APPROVAL_PROPOSAL_ID,APPROVAL_TYPE,APPROVAL_DATE,APPROVAL_BY,APPROVAL_STATUS,APPROVAL_STATUS_PROPOSAL,APPROVAL_STATUS_SESSION) VALUES (" + APPROVAL_ID + "," + PROPOSAL_ID + ",1," + DATENOW + "," + USER_ID + ",1,2,1)"); db.Database.ExecuteSqlCommand("UPDATE TRX_MONITORING SET MONITORING_TGL_APP_MTPS = " + DATENOW + ", MONITORING_HASIL_APP_MTPS = 1 WHERE MONITORING_PROPOSAL_ID = " + PROPOSAL_ID); int LASTID = MixHelper.GetSequence("TRX_DOCUMENTS"); var TGL_SEKARANG = DateTime.Now.ToString("yyyyMMddHHmmss"); var DataTanggapan = db.Database.SqlQuery <VIEW_POLLING_DETAIL>("SELECT * FROM VIEW_POLLING_DETAIL WHERE POLLING_DETAIL_POLLING_ID = " + DataProposal.PROPOSAL_POLLING_ID + " ORDER BY POLLING_DETAIL_INPUT_TYPE ASC,POLLING_DETAIL_CREATE_DATE DESC").ToList(); string path = Server.MapPath("~/Upload/Dokumen/RANCANGAN_SNI/MTPS/" + PROPOSAL_PNPS_CODE_FIXER + "/"); string dataFormat = Server.MapPath("~/Format/Laporan/"); Stream stream = System.IO.File.OpenRead(dataFormat + "FORMAT_TANGGAPAN_PUBLIKASI_MTPS.docx"); Aspose.Words.Document Tanggapan = new Aspose.Words.Document(stream); ReplaceHelper helper = new ReplaceHelper(Tanggapan); helper.Replace("JudulPNPS", DataProposal.PROPOSAL_JUDUL_PNPS); DateTime dt = Convert.ToDateTime(DataProposal.POLLING_START_DATE); helper.Replace("TanggalJP", dt.ToString("dd/MM/yyyy")); helper.Replace("RuangLingkupPNPS", DataProposal.PROPOSAL_RUANG_LINGKUP); Paragraph paragraph = new Paragraph(Tanggapan); DocumentBuilder builder = new DocumentBuilder(Tanggapan); Aspose.Words.Font font = builder.Font; font.Bold = false; font.Color = System.Drawing.Color.Black; font.Italic = false; font.Name = "Calibri"; font.Size = 11; builder.MoveToDocumentEnd(); var number = 0; string html = "<table width='100%' border='1' bordercolor='#111111' cellpadding='2' style='border-collapse: collapse' cellpadding='0' cellspacing='0'>" + "<tr>" + "<td width='5%' style='text-align:center'><b>No</b></td>" + "<td width='15%' style='text-align:center'><b>Nama</b></td>" + "<td width='15%' style='text-align:center'><b>Tipe tanggapan</b></td>" + "<td width='65%' style='text-align:center'><b>Tanggapan</b></td>" + "</tr>"; foreach (var i in DataTanggapan) { number++; html += "<tr>" + "<td>" + number + "</td>" + "<td>" + i.USER_PUBLIC_NAMA + "</td>" + "<td>" + i.POLLING_DETAIL_INPUT_TYPE_NAME + "</td>" + "<td>" + i.POLLING_DETAIL_REASON + "</td>" + "</tr>"; } html += "</table>"; builder.InsertHtml(html); Tanggapan.Save(@"" + path + "DAFTAR_TANGGAPAN_PUBLIKASI_USULAN_PNPS_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + ".docx", Aspose.Words.SaveFormat.Docx); Tanggapan.Save(@"" + path + "DAFTAR_TANGGAPAN_PUBLIKASI_USULAN_PNPS_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + ".pdf", Aspose.Words.SaveFormat.Pdf); Tanggapan.Save(@"" + path + "DAFTAR_TANGGAPAN_PUBLIKASI_USULAN_PNPS_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + ".xml"); var LOGCODE_TANGGAPAN_MTPS = MixHelper.GetLogCode(); var FNAME_TANGGAPAN_MTPS = "DOC_ID,DOC_FOLDER_ID,DOC_RELATED_TYPE,DOC_RELATED_ID,DOC_NAME,DOC_DESCRIPTION,DOC_FILE_PATH,DOC_FILE_NAME,DOC_FILETYPE,DOC_EDITABLE,DOC_CREATE_BY,DOC_CREATE_DATE,DOC_STATUS,DOC_LOG_CODE"; var FVALUE_TANGGAPAN_MTPS = "'" + LASTID + "', " + "'10', " + "'1', " + "'" + PROPOSAL_ID + "', " + "'" + "(" + PROPOSAL_PNPS_CODE_FIXER + ") Daftar Tanggapan Publikasi Usulan PNPS" + "', " + "'Daftar Tanggapan Hasil Publikasi Usulan PNPS dengan Judul PNPS : " + DataProposal.PROPOSAL_JUDUL_PNPS + "', " + "'" + "/Upload/Dokumen/RANCANGAN_SNI/MTPS/" + PROPOSAL_PNPS_CODE_FIXER + "/" + "', " + "'" + "DAFTAR_TANGGAPAN_PUBLIKASI_USULAN_PNPS_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "" + "', " + "'DOCX', " + "'0', " + "'" + USER_ID + "', " + DATENOW + "," + "'1', " + "'" + LOGCODE_TANGGAPAN_MTPS + "'"; db.Database.ExecuteSqlCommand("INSERT INTO TRX_DOCUMENTS (" + FNAME_TANGGAPAN_MTPS + ") VALUES (" + FVALUE_TANGGAPAN_MTPS.Replace("''", "NULL") + ")"); String objekTanggapan = FVALUE_TANGGAPAN_MTPS.Replace("'", "-"); MixHelper.InsertLog(LOGCODE_TANGGAPAN_MTPS, objekTanggapan, 1); db.Database.ExecuteSqlCommand("UPDATE TRX_POLLING SET POLLING_IS_KUORUM = 1,POLLING_UPDATE_DATE = " + DATENOW + ", POLLING_UPDATE_BY = '" + USER_ID + "' WHERE POLLING_ID = " + DataProposal.PROPOSAL_POLLING_ID); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data Berhasil Disimpan"; return(RedirectToAction("Index")); }
public DadosFontes(Aspose.Words.Font fnt, bool bold, int size) { _fnt = fnt; _bold = bold; _size = size; }
/// <summary> /// txt转换成word /// </summary> /// <param name="folder"></param> public void TxtToWord(string folder) { string contentPath = string.Empty, imgPath = string.Empty; contentPath = folder + @"\内容.txt"; if (!Directory.Exists(folder)) { return; } DirectoryInfo dir = new DirectoryInfo(folder); string wordTitle = dir.Name; try { List <string> imgNameList = myUtils.GetImgs(folder); string contentStr = File.ReadAllText(contentPath); string newcontent = string.Empty; //newcontent = UseApi(contentStr); //if (string.IsNullOrEmpty(newcontent)) newcontent = contentStr; string[] contentArr = myUtils.SplitByStr(newcontent, "\r\n"); Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); Font font = builder.Font; if (wordTitle.Length > 30 || wordTitle.Length < 6) { font.Color = Color.Red; } builder.Writeln(wordTitle); font.Color = Color.Black; foreach (var content in contentArr) { try { string resStr = CheckIsImage(imgNameList, content); if (string.IsNullOrEmpty(resStr)) { builder.Writeln(content); } else { imgPath = folder + @"\" + resStr; builder.InsertImage(imgPath); builder.Write("\r\n"); } } catch (Exception ex) { myUtils.WriteLog("插入文字或者图片时出错" + ex); } } string savePath = targetPath + @"\" + wordTitle + ".docx"; doc.Save(savePath); ChangeWordColor(savePath); this.dataGridView1.Invoke(new Action(() => { this.dataGridView1.Rows.Add(wordTitle, "成功"); this.dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells["Column2"].Style.ForeColor = Color.Blue; this.dataGridView1.FirstDisplayedScrollingRowIndex = dataGridView1.Rows[dataGridView1.Rows.Count - 2].Index; })); currentfolderCount++; this.label9.Invoke(new Action(() => { this.label9.Text = currentfolderCount + "/" + folderTotalCount; })); } catch (Exception ex) { this.dataGridView1.Invoke(new Action(() => { this.dataGridView1.Rows.Add(wordTitle, "失败"); this.dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells["Column2"].Style.ForeColor = Color.Red; this.dataGridView1.FirstDisplayedScrollingRowIndex = dataGridView1.Rows[dataGridView1.Rows.Count - 2].Index; })); myUtils.WriteLog(ex); if (!Directory.Exists(errorFolder1)) { Directory.CreateDirectory(errorFolder1); } dir.MoveTo(errorFolder1 + dir.Name); } }
public static Aspose.Words.Document Populate(Aspose.Words.Document doc1, string path, ApplicationForm model) { DocumentBuilder b = new DocumentBuilder(doc1); b.PageSetup.PageStartingNumber = 1; b.PageSetup.PageNumberStyle = NumberStyle.Number; b.MoveToDocumentStart(); b.MoveToMergeField("ISO1"); b.InsertCheckBox("ISO9001", (bool)model.ISO9001, 0); b.MoveToMergeField("ISO2"); b.InsertCheckBox("ISO22301", (bool)model.ISO22301, 0); b.MoveToMergeField("ISO3"); b.InsertCheckBox("ISO14001", (bool)model.ISO14001, 0); b.MoveToMergeField("ISO4"); b.InsertCheckBox("BSOHSAS18001", (bool)model.BSOHSAS18001, 0); b.MoveToMergeField("ISO5"); b.InsertCheckBox("ISO27001", (bool)model.ISO27001, 0); b.MoveToMergeField("OtherIso"); b.InsertCheckBox("OtherIso", (bool)model.OtherIso, 0); b.MoveToMergeField("1"); b.InsertCheckBox("1", (bool)model.ISO9001_2, 0); b.MoveToMergeField("2"); b.InsertCheckBox("2", (bool)model.ISO22301_2, 0); b.MoveToMergeField("3"); b.InsertCheckBox("3", (bool)model.ISO14001_2, 0); b.MoveToMergeField("4"); b.InsertCheckBox("4", (bool)model.BSOHSAS18001_2, 0); b.MoveToMergeField("5"); b.InsertCheckBox("5", (bool)model.ISO27001_2, 0); b.MoveToMergeField("6"); b.InsertCheckBox("6", (bool)model.OtherIso_2, 0); b.MoveToMergeField("CompanyName"); Aspose.Words.Font font = b.Font; font.Size = 14; font.Name = "Calibri"; b.Write(model.CompanyName); b.MoveToMergeField("Address"); b.Write(model.Adress); b.MoveToMergeField("Telephone"); b.Write(model.Telephone); b.MoveToMergeField("Email"); b.Write(model.Email); if (model.Extension != null) { b.MoveToMergeField("Extension"); b.Write(model.Extension); } if (model.Other != null) { b.MoveToMergeField("Other"); b.Write(model.Other); } if (model.Other_2 != null) { b.MoveToMergeField("Other_2"); b.Write(model.Other_2); } if (model.CompanyWebsite != null) { b.MoveToMergeField("CompanyWebsite"); b.Write(model.CompanyWebsite); } if (model.PrimaryContactForAuditPurposes != null) { b.MoveToMergeField("PrimaryContactForAuditPurposes"); b.Write(model.PrimaryContactForAuditPurposes); } if (model.PrimaryContactTelephone != null) { b.MoveToMergeField("PrimaryContactTelephone"); b.Write(model.PrimaryContactTelephone); } if (model.NatureOfBusiness != null) { b.MoveToMergeField("NatureOfBusiness"); b.Write(model.NatureOfBusiness); } if (model.NumberOfYearsAtThisSite != null) { b.MoveToMergeField("NumberOfYearsAtThisSite"); b.Write(model.NumberOfYearsAtThisSite); } if (model.ActivitiesOnClientsSites != null) { b.MoveToMergeField("ActivitiesOnClientsSites"); b.Write(model.ActivitiesOnClientsSites); b.MoveToMergeField("yes"); b.InsertCheckBox("yes", true, 0); b.MoveToMergeField("no"); b.InsertCheckBox("yes", false, 0); } else { b.MoveToMergeField("yes"); b.InsertCheckBox("yes", false, 0); b.MoveToMergeField("no"); b.InsertCheckBox("yes", true, 0); } if (model.NameOfPresentCertificationBody != null) { b.MoveToMergeField("NameOfPresentCertificationBody"); b.Write(model.NameOfPresentCertificationBody); } if (model.CertificateExpiryDate != null) { b.MoveToMergeField("CertificateExpiryDate"); b.Write(model.CertificateExpiryDate); } if (model.ManagementRepresentativeName != null) { b.MoveToMergeField("ManagementRepresentativeName"); b.Write(model.ManagementRepresentativeName); } if (model.JobTitle != null) { b.MoveToMergeField("JobTitle"); b.Write(model.JobTitle); } if (model.NameOfConsultant != null) { b.MoveToMergeField("NameOfConsultant"); b.Write(model.NameOfConsultant); } if (model.ConsultantTelephone != null) { b.MoveToMergeField("ConsultantTelephone"); b.Write(model.ConsultantTelephone); } if (model.StandardTransferred != null) { b.MoveToMergeField("StandardTransferred"); b.Write(model.StandardTransferred); } if (model.DateNextCertificationBodyVisit != null) { b.MoveToMergeField("DateNextCertificationBodyVisit"); b.Write(model.DateNextCertificationBodyVisit); } if (model.NumberOfLocations != null) { b.MoveToMergeField("NumberOfLocations"); b.Write(model.NumberOfLocations); } if (model.locationActivities.Count > 0) { foreach (var item in model.locationActivities) { b.MoveToMergeField("location"); b.Write(item.location); b.InsertParagraph(); } foreach (var item in model.locationActivities) { b.MoveToMergeField("activity"); b.Write(item.activity); b.InsertParagraph(); } } if (model.Categories.Count > 0) { foreach (var item in model.Categories) { b.MoveToMergeField("Category"); if (item.Category != null) { b.Write(item.Category); b.InsertParagraph(); } } foreach (var item in model.Categories) { b.MoveToMergeField("TotalPermanent"); if (item.TotalPermanent != null) { b.Write(item.TotalPermanent); b.InsertParagraph(); } } foreach (var item in model.Categories) { b.MoveToMergeField("TotalTemporary"); if (item.TotalTemporary != null) { b.Write(item.TotalTemporary); b.InsertParagraph(); } } } if (model.TotalPermanent != null) { b.MoveToMergeField("TotalP"); b.Write(model.TotalPermanent); } if (model.TotalTemporary != null) { b.MoveToMergeField("TotalT"); b.Write(model.TotalTemporary); } b.MoveToDocumentEnd(); doc1.MailMerge.DeleteFields(); if (model.ISO22301 == true || model.ISO9001 == true) { Aspose.Words.Document standardDoc = new Aspose.Words.Document(path + @"Templates\ISO_9001_22301_Template.doc"); doc1.AppendDocument(standardDoc, ImportFormatMode.KeepSourceFormatting); } if (model.ISO14001 == true) { Aspose.Words.Document standardDoc = new Aspose.Words.Document(path + @"Templates\ISO_14001_Template.doc"); doc1.AppendDocument(standardDoc, ImportFormatMode.KeepSourceFormatting); } if (model.BSOHSAS18001 == true) { Aspose.Words.Document standardDoc = new Aspose.Words.Document(path + @"Templates\BS_OHSAS_1800_Template.doc"); doc1.AppendDocument(standardDoc, ImportFormatMode.KeepSourceFormatting); } if (model.ISO27001 == true) { Aspose.Words.Document standardDoc = new Aspose.Words.Document(path + @"Templates\ISO27001_Template.doc"); doc1.AppendDocument(standardDoc, ImportFormatMode.KeepSourceFormatting); } return(doc1); }
public ActionResult PrintSubKomtek(string Type = "docx") { var Data = db.Database.SqlQuery <VIEW_SUBKOMTEK>("SELECT * FROM VIEW_SUBKOMTEK WHERE KOMTEK_STATUS = 1").ToList(); string dataDir = Server.MapPath("~/Format/"); Stream stream = System.IO.File.OpenRead(dataDir + "komite_teknis_list.docx"); Aspose.Words.Document doc = new Aspose.Words.Document(stream); stream.Close(); doc.Range.Replace("KOMITE TEKNIS", "SUB KOMITE TEKNIS", false, true); DocumentBuilder builder = new DocumentBuilder(doc); Aspose.Words.Font font = builder.Font; font.Bold = false; font.Color = System.Drawing.Color.Black; font.Italic = false; font.Name = "Calibri"; font.Size = 11; builder.MoveToDocumentEnd(); //var DataKomtek = (from komtek in db.VIEW_ANGGOTA where komtek.KOMTEK_ANGGOTA_STATUS == 1 && komtek.KOMTEK_ANGGOTA_KOMTEK_ID == Data.KOMTEK_ID orderby komtek.KOMTEK_ANGGOTA_JABATAN select komtek).ToList(); var no = 0; Table myTable = (Table)doc.GetChild(NodeType.Table, 0, true); Row myRow = myTable.LastRow; foreach (var list in Data) { no++; Row newRow = (Row)myRow.Clone(true); myTable.AppendChild(newRow); foreach (Cell cell in newRow) { cell.FirstParagraph.ChildNodes.Clear(); } builder.MoveToCell(0, no, 0, 0); builder.Write("" + no); builder.MoveToCell(0, no, 1, 0); builder.Write("" + list.KOMTEK_CODE); builder.MoveToCell(0, no, 2, 0); builder.Write("" + list.SUB_KOMTEK); builder.MoveToCell(0, no, 3, 0); builder.Write("" + list.KOMTEK_SEKRETARIAT); builder.MoveToCell(0, no, 4, 0); builder.Write("" + list.KOMTEK_ADDRESS); builder.MoveToCell(0, no, 5, 0); builder.Write("" + ((list.KOMTEK_PHONE != null) ? list.KOMTEK_PHONE : list.KOMTEK_FAX)); } Row LastROW = myTable.LastRow; LastROW.Remove(); MemoryStream dstStream = new MemoryStream(); var mime = ""; if (Type == "pdf") { doc.Save(dstStream, SaveFormat.Pdf); mime = "application/pdf"; } else { doc.Save(dstStream, SaveFormat.Docx); mime = "application/vnd.openxmlformats-officedocument.wordprocessingml.document"; } byte[] byteInfo = dstStream.ToArray(); dstStream.Write(byteInfo, 0, byteInfo.Length); dstStream.Position = 0; Response.ContentType = mime; Response.AddHeader("content-disposition", "attachment; filename=sub_Komite_Teknis." + Type); Response.BinaryWrite(byteInfo); Response.End(); return(new FileStreamResult(dstStream, mime)); }
public ActionResult PrintDetailKomtek(string Type = "pdf", int id = 0) { var DataPantek = (from pantek in db.MASTER_KOMITE_TEKNIS where pantek.KOMTEK_ID == id select pantek).SingleOrDefault(); var DataIcs = (from ics in db.VIEW_KOMTEK_ICS where ics.KOMTEK_ICS_KOMTEK_ID == id orderby ics.ICS_CODE ascending select ics).ToList(); var DataAnggota = (from ics in db.VIEW_ANGGOTA where ics.KOMTEK_ANGGOTA_KOMTEK_ID == id && ics.KOMTEK_ANGGOTA_STATUS == 1 && ics.JABATAN != "Sekretariat" orderby ics.KOMTEK_ANGGOTA_JABATAN ascending select ics).ToList(); var komposis_anggota = db.Database.SqlQuery <KomposisiKomtek>("SELECT CAST(VA.KOMTEK_ANGGOTA_STAKEHOLDER AS DECIMAL) AS KOMTEK_ANGGOTA_STAKEHOLDER,VA.STAKEHOLDER,CAST(VA.KOMTEK_ANGGOTA_KOMTEK_ID AS DECIMAL) AS KOMTEK_ANGGOTA_KOMTEK_ID, CAST(COUNT (VA.KOMTEK_ANGGOTA_STAKEHOLDER) AS DECIMAL) AS JML, CAST(ROUND((COUNT (VA.KOMTEK_ANGGOTA_STAKEHOLDER)/(SELECT COUNT(VAS.KOMTEK_ANGGOTA_STAKEHOLDER) FROM VIEW_ANGGOTA VAS WHERE VAS.KOMTEK_ANGGOTA_KOMTEK_ID = " + id + " AND VAS.JABATAN != 'Sekretariat')* 100),2) AS DECIMAL) AS PERSENTASE FROM VIEW_ANGGOTA VA WHERE VA.KOMTEK_ANGGOTA_KOMTEK_ID = " + id + " AND VA.JABATAN != 'Sekretariat' AND VA.KOMTEK_ANGGOTA_STAKEHOLDER IS NOT NULL GROUP BY VA.KOMTEK_ANGGOTA_STAKEHOLDER, VA.STAKEHOLDER, VA.KOMTEK_ANGGOTA_KOMTEK_ID").ToList(); //var Data = db.Database.SqlQuery<VIEW_PROPOSAL>("SELECT * FROM KOMTE WHERE PROPOSAL_ID = " + PROPOSAL_ID).SingleOrDefault(); string dataDir = Server.MapPath("~/Format/"); Stream stream = System.IO.File.OpenRead(dataDir + "Komite_teknis.docx"); Aspose.Words.Document doc = new Aspose.Words.Document(stream); stream.Close(); if (DataPantek != null) { //var DataKomtek = db.Database.SqlQuery<VIEW_ANGGOTA>("SELECT * FROM VIEW_ANGGOTA WHERE KOMTEK_ANGGOTA_KOMTEK_ID = " + Data.KOMTEK_ID + " AND JABATAN = 'Ketua'").SingleOrDefault(); doc.Range.Replace("a1", DataPantek.KOMTEK_CODE + "-" + DataPantek.KOMTEK_NAME, false, true); doc.Range.Replace("a2", (DataPantek.KOMTEK_SEKRETARIAT == null) ? "-" : DataPantek.KOMTEK_SEKRETARIAT, false, true); doc.Range.Replace("a3", (DataPantek.KOMTEK_ADDRESS == null) ? "-" : DataPantek.KOMTEK_ADDRESS, false, true); doc.Range.Replace("a4", (DataPantek.KOMTEK_PHONE == null) ? "-" : DataPantek.KOMTEK_PHONE, false, true); doc.Range.Replace("a5", (DataPantek.KOMTEK_FAX == null) ? "-" : DataPantek.KOMTEK_FAX, false, true); doc.Range.Replace("a6", (DataPantek.KOMTEK_EMAIL == null) ? "-" : DataPantek.KOMTEK_EMAIL, false, true); doc.Range.Replace("a7", (DataPantek.KOMTEK_CONTACT_PERSON == null) ? "-" : DataPantek.KOMTEK_CONTACT_PERSON, false, true); doc.Range.Replace("a8", (DataPantek.KOMTEK_STATUS == 1)?"Aktif":"Tidak Aktif", false, true); doc.Range.Replace("a9", (DataPantek.KOMTEK_KETERANGAN == null) ? "-" : DataPantek.KOMTEK_KETERANGAN, false, true); } DocumentBuilder builder = new DocumentBuilder(doc); Aspose.Words.Font font = builder.Font; font.Bold = false; font.Color = System.Drawing.Color.Black; font.Italic = false; font.Name = "Calibri"; font.Size = 11; builder.MoveToDocumentEnd(); //var DataKomtek = (from komtek in db.VIEW_ANGGOTA where komtek.KOMTEK_ANGGOTA_STATUS == 1 && komtek.KOMTEK_ANGGOTA_KOMTEK_ID == Data.KOMTEK_ID orderby komtek.KOMTEK_ANGGOTA_JABATAN select komtek).ToList(); var no = 0; Table myTable = (Table)doc.GetChild(NodeType.Table, 1, true); Row myRow = myTable.LastRow; foreach (var list in DataIcs) { no++; Row newRow = (Row)myRow.Clone(true); myTable.AppendChild(newRow); foreach (Cell cell in newRow) { cell.FirstParagraph.ChildNodes.Clear(); } builder.MoveToCell(1, no, 0, 0); builder.Write("" + no); builder.MoveToCell(1, no, 1, 0); builder.Write("" + list.ICS_CODE); builder.MoveToCell(1, no, 2, 0); builder.Write("" + list.ICS_NAME_IND); builder.MoveToCell(1, no, 3, 0); builder.Write("" + list.ICS_NAME); } Row LastROW = myTable.LastRow; LastROW.Remove(); //DocumentBuilder builders = new DocumentBuilder(doc); //Aspose.Words.Font fonts = builders.Font; //font.Bold = false; //font.Color = System.Drawing.Color.Black; //font.Italic = false; //font.Name = "Calibri"; //font.Size = 11; //builders.MoveToDocumentEnd(); var nos = 0; Table table2 = (Table)doc.GetChild(NodeType.Table, 2, true); Row myRow2 = table2.LastRow; foreach (var list in DataAnggota) { nos++; Row newRow2 = (Row)myRow2.Clone(true); table2.AppendChild(newRow2); foreach (Cell cell2 in newRow2) { cell2.FirstParagraph.ChildNodes.Clear(); } builder.MoveToCell(2, nos, 0, 0); builder.Write("" + nos); builder.MoveToCell(2, nos, 1, 0); builder.Write("" + list.JABATAN); builder.MoveToCell(2, nos, 2, 0); builder.Write("" + list.STAKEHOLDER); builder.MoveToCell(2, nos, 3, 0); builder.Write("" + list.KOMTEK_ANGGOTA_NAMA); builder.MoveToCell(2, nos, 4, 0); builder.Write("" + list.KOMTEK_ANGGOTA_INSTANSI); builder.MoveToCell(2, nos, 5, 0); builder.Write("" + list.KOMTEK_ANGGOTA_ADDRESS); } Row LastROW2 = table2.LastRow; LastROW2.Remove(); //DocumentBuilder builderss = new DocumentBuilder(doc); //Aspose.Words.Font fontss = builderss.Font; //font.Bold = false; //font.Color = System.Drawing.Color.Black; //font.Italic = false; //font.Name = "Calibri"; //font.Size = 11; //builder.MoveToDocumentEnd(); int noss = 1; int JumlahJamleh = 0; Table table3 = (Table)doc.GetChild(NodeType.Table, 3, true); Row myRow3 = table3.LastRow; foreach (var list in komposis_anggota) { noss++; Row newRow3 = (Row)myRow3.Clone(true); table3.AppendChild(newRow3); foreach (Cell cell in newRow3) { cell.FirstParagraph.ChildNodes.Clear(); } builder.MoveToCell(3, noss, 0, 0); builder.Write((noss - 1).ToString()); builder.MoveToCell(3, noss, 1, 0); builder.Write("" + list.STAKEHOLDER); builder.MoveToCell(3, noss, 2, 0); builder.Write("" + list.JML); builder.MoveToCell(3, noss, 3, 0); builder.Write("" + list.PERSENTASE + " %"); JumlahJamleh += Convert.ToInt32(list.JML); } noss++; builder.MoveToCell(3, noss, 0, 0); builder.CellFormat.HorizontalMerge = CellMerge.First; builder.Write("Jumlah"); builder.MoveToCell(3, noss, 1, 0); builder.CellFormat.HorizontalMerge = CellMerge.Previous; builder.MoveToCell(3, noss, 2, 0); builder.Write("" + JumlahJamleh); builder.MoveToCell(3, noss, 3, 0); builder.Write("" + 100); MemoryStream dstStream = new MemoryStream(); var mime = ""; if (Type == "pdf") { doc.Save(dstStream, SaveFormat.Pdf); mime = "application/pdf"; } else { doc.Save(dstStream, SaveFormat.Docx); mime = "application/vnd.openxmlformats-officedocument.wordprocessingml.document"; } byte[] byteInfo = dstStream.ToArray(); dstStream.Write(byteInfo, 0, byteInfo.Length); dstStream.Position = 0; Response.ContentType = mime; Response.AddHeader("content-disposition", "attachment; filename=KOMITE_TEKNIS" + DataPantek.KOMTEK_CODE + "." + Type); Response.BinaryWrite(byteInfo); Response.End(); return(new FileStreamResult(dstStream, mime)); }
/// <summary> /// 创建表格数据Cell,增加Font传入 /// author:du /// date:20130111 /// </summary> /// <param name="builder"></param> /// <param name="strCellValue"></param> /// <param name="cellwidth"></param> /// <param name="font"></param> public void CreateCell3(DocumentBuilder builder, string strCellValue, double cellwidth, Aspose.Words.Font font) { if (strCellValue == null) { strCellValue = ""; } builder.InsertCell(); // 添加一个单元格 builder.CellFormat.Borders.LineStyle = LineStyle.Single; builder.CellFormat.Borders.Color = System.Drawing.Color.Black; builder.CellFormat.WrapText = false; builder.Font.Name = font.Name; builder.Font.Size = 10.5; builder.Bold = false; builder.CellFormat.Width = cellwidth; builder.CellFormat.VerticalAlignment = CellVerticalAlignment.Center; builder.CellFormat.VerticalMerge = Aspose.Words.Tables.CellMerge.None; builder.Write(strCellValue); }
public float GetStrWidth(string text, Aspose.Words.Font font) { Graphics g = Graphics.FromImage(new Bitmap(1, 1)); return(g.MeasureString(text, new System.Drawing.Font(font.Name, (float)font.Size)).Width); }