public IActionResult Word() { PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request); pageofficeCtrl.ServerPage = "/PageOffice/POServer"; PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument(); //获取Table所在的数据区域对象 PageOfficeNetCore.WordWriter.DataRegion dataRegion = doc.OpenDataRegion("PO_regTable"); //打开table,OpenTable(index)方法中的index代表Word文档中table位置的索引,从1开始 PageOfficeNetCore.WordWriter.Table table = dataRegion.OpenTable(1); //给table中的单元格赋值, OpenCellRC(行, 列) table.OpenCellRC(3, 1).Value = "A公司"; table.OpenCellRC(3, 2).Value = "开发部"; table.OpenCellRC(3, 3).Value = "李清"; //插入一空行,InsertRowAfter方法中的参数表示在哪个单元格下面插入一行 table.InsertRowAfter(table.OpenCellRC(3, 3)); table.OpenCellRC(4, 1).Value = "B公司"; table.OpenCellRC(4, 2).Value = "销售部"; table.OpenCellRC(4, 3).Value = "张三"; pageofficeCtrl.SetWriter(doc); //打开Word文档 pageofficeCtrl.WebOpen("doc/test.doc", PageOfficeNetCore.OpenModeType.docNormalEdit, "tom"); ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1"); return(View()); }
public IActionResult Word() { PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request); pageofficeCtrl.ServerPage = "/PageOffice/POServer"; PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument(); PageOfficeNetCore.WordWriter.DataRegion dataReg = doc.OpenDataRegion("PO_table"); PageOfficeNetCore.WordWriter.Table table = dataReg.OpenTable(1); //合并table中的单元格 table.OpenCellRC(1, 1).MergeTo(1, 4); //给合并后的单元格赋值 table.OpenCellRC(1, 1).Value = "销售情况表"; //设置单元格文本样式 table.OpenCellRC(1, 1).Font.Color = Color.Red; table.OpenCellRC(1, 1).Font.Size = 24; table.OpenCellRC(1, 1).Font.Name = "楷体"; table.OpenCellRC(1, 1).ParagraphFormat.Alignment = PageOfficeNetCore.WordWriter.WdParagraphAlignment.wdAlignParagraphCenter; pageofficeCtrl.SetWriter(doc);//不要忘记此句代码 pageofficeCtrl.CustomToolbar = false; //打开Word文档 pageofficeCtrl.WebOpen("doc/test.doc", PageOfficeNetCore.OpenModeType.docNormalEdit, "tom"); ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1"); return(View()); }
public IActionResult Word() { PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request); pageofficeCtrl.ServerPage = "/PageOffice/POServer"; PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument(); //获取Table所在的数据区域对象 PageOfficeNetCore.WordWriter.DataRegion dataRegion = doc.OpenDataRegion("PO_regTable"); //打开table,OpenTable(index)方法中的index代表Word文档中table位置的索引,从1开始 PageOfficeNetCore.WordWriter.Table table = dataRegion.OpenTable(1); //给table中的单元格赋值, OpenCellRC(行, 列) table.OpenCellRC(3, 1).Value = "A公司"; table.OpenCellRC(3, 2).Value = "开发部"; table.OpenCellRC(3, 3).Value = "李清"; //插入一空行,InsertRowAfter方法中的参数表示在哪个单元格下面插入一行 table.InsertRowAfter(table.OpenCellRC(3, 3)); table.OpenCellRC(4, 1).Value = "B公司"; table.OpenCellRC(4, 2).Value = "销售部"; table.OpenCellRC(4, 3).Value = "张三"; //设置表格行的高度 table.SetRowsHeight(30.5f); //设置表格的边框样式 PageOfficeNetCore.WordWriter.Border border = table.Border; // 设置边框的类型 border.BorderType = PageOfficeNetCore.WordWriter.WdBorderType.wdFullGrid; //包含内边框 //设置边框的颜色 border.LineColor = Color.Red; //设置边框的线条样式 border.LineStyle = PageOfficeNetCore.WordWriter.WdLineStyle.wdLineStyleDot; //设置边框的粗细 border.LineWidth = PageOfficeNetCore.WordWriter.WdLineWidth.wdLineWidth150pt; //设置表格字体样式 PageOfficeNetCore.WordWriter.Font font = dataRegion.Font; //设置字体的是否加粗 font.Bold = true; //设置字体的颜色 font.Color = Color.Blue; //设置字体是否为斜体 font.Italic = true; //设置字体名称 font.Name = "宋体"; //设置字体大小 font.Size = 15.5f; pageofficeCtrl.SetWriter(doc); //打开Word文档 pageofficeCtrl.WebOpen("doc/test.doc", PageOfficeNetCore.OpenModeType.docNormalEdit, "tom"); ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1"); return(View()); }
public IActionResult Compose() { PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request); pageofficeCtrl.ServerPage = "/PageOffice/POServer"; string idlist = Request.Query["ids"]; string sql = "select * from Salary where ID in(" + idlist + ") order by ID"; SqliteConnection conn = new SqliteConnection(connString); conn.Open(); SqliteCommand cmd = new SqliteCommand(sql, conn); cmd.ExecuteNonQuery(); cmd.CommandText = sql; SqliteDataReader dr = cmd.ExecuteReader(); PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument(); PageOfficeNetCore.WordWriter.DataRegion data = null; PageOfficeNetCore.WordWriter.Table table = null; int i = 0; while (dr.Read()) { data = doc.CreateDataRegion("reg" + i.ToString(), PageOfficeNetCore.WordWriter.DataRegionInsertType.Before, "[End]"); data.Value = "[word]doc/template.doc[/word]"; table = data.OpenTable(1); table.OpenCellRC(2, 1).Value = dr["ID"].ToString(); table.OpenCellRC(2, 2).Value = dr["UserName"].ToString(); table.OpenCellRC(2, 3).Value = dr["DeptName"].ToString(); if (dr["SalTotal"] != null && dr["SalTotal"].ToString() != "") { table.OpenCellRC(2, 4).Value = dr["SalTotal"].ToString(); } else { table.OpenCellRC(2, 4).Value = "¥0.00"; } if (dr["SalDeduct"] != null && dr["SalDeduct"].ToString() != "") { table.OpenCellRC(2, 5).Value = dr["SalDeduct"].ToString(); } else { table.OpenCellRC(2, 5).Value = "¥0.00"; } if (dr["SalCount"] != null && dr["SalCount"].ToString() != "") { table.OpenCellRC(2, 6).Value = dr["SalCount"].ToString(); } else { table.OpenCellRC(2, 6).Value = "¥0.00"; } if (dr["DataTime"] != null && dr["SalTotal"].ToString() != "") { table.OpenCellRC(2, 7).Value = dr["DataTime"].ToString(); } else { table.OpenCellRC(2, 7).Value = ""; } i++; } dr.Close(); conn.Close(); // 设置PageOffice组件服务页面 pageofficeCtrl.SetWriter(doc); pageofficeCtrl.Caption = "生成工资条"; pageofficeCtrl.CustomToolbar = false; pageofficeCtrl.WebOpen("doc/test.doc", PageOfficeNetCore.OpenModeType.docAdmin, "tom"); ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1"); return(View()); }
public IActionResult ViewWord() { String err = ""; PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request); pageofficeCtrl.ServerPage = "/PageOffice/POServer"; string id = Request.Query["ID"]; if (id != null && id.Length > 0) { string sql = "select * from Salary where id =" + id + " order by ID";; SqliteConnection conn = new SqliteConnection(connString); conn.Open(); SqliteCommand cmd = new SqliteCommand(sql, conn); cmd.ExecuteNonQuery(); cmd.CommandText = sql; SqliteDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { DateTime date = DateTime.Now; //创建WordDocment对象 PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument(); //打开数据区域 PageOfficeNetCore.WordWriter.DataRegion datareg = doc.OpenDataRegion("PO_table"); //打开Table PageOfficeNetCore.WordWriter.Table table = datareg.OpenTable(1); ////给单元格赋值 table.OpenCellRC(2, 1).Value = dr["ID"].ToString(); table.OpenCellRC(2, 2).Value = dr["UserName"].ToString(); table.OpenCellRC(2, 3).Value = dr["DeptName"].ToString(); if (dr["SalTotal"] != null && dr["SalTotal"].ToString() != "") { table.OpenCellRC(2, 4).Value = dr["SalTotal"].ToString(); } else { table.OpenCellRC(2, 4).Value = "¥0.00"; } if (dr["SalDeduct"] != null && dr["SalDeduct"].ToString() != "") { table.OpenCellRC(2, 5).Value = dr["SalDeduct"].ToString(); } else { table.OpenCellRC(2, 5).Value = "¥0.00"; } if (dr["SalCount"] != null && dr["SalCount"].ToString() != "") { table.OpenCellRC(2, 6).Value = dr["SalCount"].ToString(); } else { table.OpenCellRC(2, 6).Value = "¥0.00"; } if (dr["DataTime"] != null && dr["SalTotal"].ToString() != "") { table.OpenCellRC(2, 7).Value = dr["DataTime"].ToString(); } else { table.OpenCellRC(2, 7).Value = ""; } pageofficeCtrl.SetWriter(doc); } else { err = "<script>alert('未获得该员工的工资信息!');location.href='index'</script>"; } dr.Close(); conn.Close(); //打开Word文档 } else { err = "<script>alert('未获得该员工的工资信息!');location.href='index'</script>"; } pageofficeCtrl.CustomToolbar = false; pageofficeCtrl.WebOpen("doc/template.doc", PageOfficeNetCore.OpenModeType.docReadOnly, "tom"); ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1"); ViewBag.err = err; return(View()); }