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.Table table1 = doc.OpenDataRegion("PO_T001").OpenTable(1);
table1.OpenCellRC(1, 1).Value = "[image]doc/wang.gif[/image]";
int oldRowCount = 3; //表格中原有的行数
int dataRowCount = 5; //要填充数据的行数
// 扩充表格
for (int j = 0; j < dataRowCount - oldRowCount; j++)
{
table1.InsertRowAfter(table1.OpenCellRC(2, 5)); //在第2行的最后一个单元格下插入新行
}
// 填充数据
int i = 1;
while (i <= dataRowCount)
{
table1.OpenCellRC(i, 2).Value = "AA" + i.ToString();
table1.OpenCellRC(i, 3).Value = "BB" + i.ToString();
table1.OpenCellRC(i, 4).Value = "CC" + i.ToString();
table1.OpenCellRC(i, 5).Value = "DD" + i.ToString();
i++;
}
pageofficeCtrl.SetWriter(doc);
//打开Word文档
pageofficeCtrl.WebOpen("doc/test_table.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();
//打开数据区域
PageOfficeNetCore.WordWriter.DataRegion dTable = doc.OpenDataRegion("PO_table");
//设置数据区域可编辑性
dTable.Editing = true;
//打开数据区域中的表格，OpenTable(index)方法中的index为word文档中表格的下标，从1开始
PageOfficeNetCore.WordWriter.Table table1 = doc.OpenDataRegion("PO_Table").OpenTable(1);
// 给表头单元格赋值
table1.OpenCellRC(1, 2).Value = "产品1";
table1.OpenCellRC(1, 3).Value = "产品2";
table1.OpenCellRC(2, 1).Value = "A部门";
table1.OpenCellRC(3, 1).Value = "B部门";
pageofficeCtrl.SetWriter(doc);
//添加自定义按钮
pageofficeCtrl.AddCustomToolButton("保存", "Save", 1);
pageofficeCtrl.AddCustomToolButton("全屏/还原", "IsFullScreen", 4);
//设置保存页面
pageofficeCtrl.SaveDataPage = "SaveData";
//打开Word文档
pageofficeCtrl.WebOpen("doc/test.doc", PageOfficeNetCore.OpenModeType.docSubmitForm, "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 Word()
{
PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request);
pageofficeCtrl.ServerPage = "/PageOffice/POServer";
PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument();
PageOfficeNetCore.WordWriter.Table table1 = doc.OpenDataRegion("PO_table").OpenTable(1);
PageOfficeNetCore.WordWriter.Cell cell = table1.OpenCellRC(2, 1);
//删除坐标为(2,1)的单元格所在行
table1.RemoveRowAt(cell);
pageofficeCtrl.CustomToolbar = false;
pageofficeCtrl.SetWriter(doc);
//打开Word文档
pageofficeCtrl.WebOpen("doc/test_table.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.Table table1 = doc.OpenDataRegion("PO_table1").CreateTable(3, 5, PageOfficeNetCore.WordWriter.WdAutoFitBehavior.wdAutoFitWindow);
table1.OpenCellRC(1, 1).MergeTo(3, 1);
table1.OpenCellRC(1, 1).Value = "合并后的单元格";
//给表格table1中剩余的单元格赋值
for (int i = 1; i < 4; i++)
{
table1.OpenCellRC(i, 2).Value = "AA" + i.ToString();
table1.OpenCellRC(i, 3).Value = "BB" + i.ToString();
table1.OpenCellRC(i, 4).Value = "CC" + i.ToString();
table1.OpenCellRC(i, 5).Value = "DD" + i.ToString();
}
//在"PO_table1"后面动态创建一个新的数据区域"PO_table2",用于创建新的一个5行5列的表格table2
PageOfficeNetCore.WordWriter.DataRegion drTable2 = doc.CreateDataRegion("PO_table2", PageOfficeNetCore.WordWriter.DataRegionInsertType.After, "PO_table1");
PageOfficeNetCore.WordWriter.Table table2 = drTable2.CreateTable(5, 5, PageOfficeNetCore.WordWriter.WdAutoFitBehavior.wdAutoFitWindow);
//给新表格table2赋值
for (int i = 1; i < 6; i++)
{
table2.OpenCellRC(i, 1).Value = "AA" + i.ToString();
table2.OpenCellRC(i, 2).Value = "BB" + i.ToString();
table2.OpenCellRC(i, 3).Value = "CC" + i.ToString();
table2.OpenCellRC(i, 4).Value = "DD" + i.ToString();
table2.OpenCellRC(i, 5).Value = "EE" + i.ToString();
}
pageofficeCtrl.CustomToolbar = false;//隐藏用户自定义工具栏
pageofficeCtrl.SetWriter(doc);
//打开Word文档
pageofficeCtrl.WebOpen("doc/createTable.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());
}
