1 using Microsoft.Office.Interop.Word;
2 using System;
3 using System.Collections.Generic;
4 using System.Data;
5 using System.IO;
6 using System.Linq;
7 using System.Reflection;
8 using System.Text;
9 using System.Threading.Tasks;
10
11 namespace ETWord
12 {
13 public class WordHelper
14 {
15 public static void CreateWordFile(string filePath)
16 {
17
18 try
19 {
20 CreateFile(filePath);
21 //
22 MessageFilter.Register();
23 object wdLine = WdUnits.wdLine;
24 object oMissing = Missing.Value;
25 object fileName = filePath;
26 object heading2 = WdBuiltinStyle.wdStyleHeading2;
27 object heading3 = WdBuiltinStyle.wdStyleHeading3;
28
29 _Application wordApp = new Application();
30 wordApp.Visible = true;
31 _Document wordDoc = wordApp.Documents.Open(ref fileName, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing);
32 System.Data.DataTable dtDepts = DatabaseHelper.getDept();
33 int ii = 0;
34 foreach (DataRow dr in dtDepts.Rows)
35 {
36 string dept = dr["dept"].ToString();
37 Paragraph oPara0 = wordDoc.Content.Paragraphs.Add(ref oMissing);
38 oPara0.Range.Text = string.Format("{0}-{1}", ii + 1, dept);
39 //oPara0.Range.Font.Bold = 1;
40 //oPara0.Format.SpaceAfter = 5;
41 oPara0.Range.Select();
42 oPara0.set_Style(ref heading2);
43 oPara0.Range.InsertParagraphAfter();
44 System.Data.DataTable dtTemplate = DatabaseHelper.getTemplateByDept(dept);
45 int jj = 0;
46 foreach (DataRow dr1 in dtTemplate.Rows)
47 {
48 string template = dr1["template"].ToString();
49 string user1 = dr1["user1"].ToString();
50 string remark = dr1["remark"].ToString();
51 System.Data.DataTable dtData = DatabaseHelper.getDataByDeptAndTemplate(dept, template);
52 int count = dtData.Rows.Count;
53 int row = count + 4;
54 int column = 5;
55 object ncount = 1;
56
57 wordApp.Selection.MoveDown(ref wdLine, ref ncount, ref oMissing);
58 wordApp.Selection.TypeParagraph();
59 Paragraph oPara1 = wordDoc.Content.Paragraphs.Add(ref oMissing);
60 oPara1.Range.Select();
61 oPara1.Range.Text = string.Format("{0}-{1}、{2}", ii + 1, jj + 1, template);
62 //oPara1.Range.Font.Bold = 1;
63 //oPara1.Format.SpaceAfter = 5;
64 oPara1.set_Style(ref heading3);
65 oPara1.Range.InsertParagraphAfter();
66 wordApp.Selection.MoveDown(ref wdLine, ref ncount, ref oMissing);
67 wordApp.Selection.TypeParagraph();
68 //设置表格
69 Table table = wordDoc.Tables.Add(wordApp.Selection.Range, row, column, ref oMissing, ref oMissing);
70
71 table.Borders.OutsideLineStyle = WdLineStyle.wdLineStyleSingle;
72 table.Borders.InsideLineStyle = WdLineStyle.wdLineStyleSingle;
73 table.Range.Font.Bold = 0;
74 table.PreferredWidthType = WdPreferredWidthType.wdPreferredWidthAuto;
75 table.Columns[1].Width = 60f;
76 table.Columns[2].Width = 100f;
77 table.Columns[3].Width = 100f;
78 table.Columns[4].Width = 60f;
79 table.Columns[5].Width = 100f;
80 //列的合并
81 Cell cell = table.Cell(1, 2);
82 cell.Merge(table.Cell(1, 5));
83 Cell cell2 = table.Cell(2, 2);
84 cell2.Merge(table.Cell(2, 5));
85 Cell cell3 = table.Cell(3, 2);
86 cell3.Merge(table.Cell(3, 5));
87 //赋值
88 table.Cell(1, 1).Range.Text = "流程名称:";
89 table.Cell(2, 1).Range.Text = "使用人:";
90 table.Cell(3, 1).Range.Text = "流程说明:";
91 table.Cell(4, 1).Range.Text = "节点";
92 table.Cell(4, 2).Range.Text = "节点名";
93 table.Cell(4, 3).Range.Text = "处理人员";
94 table.Cell(4, 4).Range.Text = "处理方式";
95 table.Cell(4, 5).Range.Text = "跳转信息";
96 table.Cell(1, 2).Range.Text = template;
97 table.Cell(2, 2).Range.Text = user1;
98 table.Cell(3, 2).Range.Text = remark;
99 int kk = 5;
100 foreach (DataRow dr2 in dtData.Rows)
101 {
102 table.Cell(kk, 1).Range.Text = (kk - 4).ToString();
103 table.Cell(kk, 2).Range.Text = dr2["NodeName"].ToString();
104 table.Cell(kk, 3).Range.Text = dr2["DoName"].ToString();
105 table.Cell(kk, 4).Range.Text = dr2["DoType"].ToString();
106 table.Cell(kk, 5).Range.Text = string.Empty;
107 kk++;
108 }
109 table.Cell(kk - 1, 5).Range.Select();
110
111 wordApp.Selection.MoveDown(ref wdLine, ref ncount, ref oMissing);//移动焦点
112 wordApp.Selection.TypeParagraph();//插入段落
113
114 jj++;
115 }
116 ii++;
117 }
118
119 //保存
120 wordDoc.Save();
121 wordDoc.Close(ref oMissing, ref oMissing, ref oMissing);
122 wordApp.Quit(ref oMissing, ref oMissing, ref oMissing);
123 MessageFilter.Revoke();
124
125 }
126 catch (Exception e)
127 {
128 Console.WriteLine(e.Message);
129 Console.WriteLine(e.StackTrace);
130
131 }
132 }
133
134 private static void CreateFile(string filePath)
135 {
136 if (!File.Exists(filePath))
137 {
138 using (FileStream fs = File.Create(filePath))
139 {
140
141 }
142 }
143 }
144 }
145 }