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_deptName");
//为方便用户知道哪些地方可以编辑，所以设置了数据区域的背景色
dataReg.Shading.BackgroundPatternColor = Color.Pink;
//dataReg.Editing = true;
pageofficeCtrl.SetWriter(doc); // 不要忘记此句代码
// 设置数据区域点击时的响应js函数
pageofficeCtrl.JsFunction_OnWordDataRegionClick = "OnWordDataRegionClick()";
pageofficeCtrl.AddCustomToolButton("保存", "Save", 1);
pageofficeCtrl.OfficeToolbars = false;
pageofficeCtrl.Caption = "为方便用户知道哪些地方可以编辑，所以设置了数据区域的背景色";
//设置保存页面
pageofficeCtrl.SaveFilePage = "SaveDoc";
//打开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();
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 wordDoc = new PageOfficeNetCore.WordWriter.WordDocument();
pageofficeCtrl.AddCustomToolButton("保存", "Save()", 1);
pageofficeCtrl.CustomToolbar = true;
//打开数据区域，openDataRegion方法的参数代表Word文档中的书签名称
PageOfficeNetCore.WordWriter.DataRegion dataRegion1 = wordDoc.OpenDataRegion("PO_test1");
dataRegion1.SubmitAsFile = true;
PageOfficeNetCore.WordWriter.DataRegion dataRegion2 = wordDoc.OpenDataRegion("PO_test2");
dataRegion2.SubmitAsFile = true;
dataRegion2.Editing = true;
PageOfficeNetCore.WordWriter.DataRegion dataRegion3 = wordDoc.OpenDataRegion("PO_test3");
dataRegion3.SubmitAsFile = true;
pageofficeCtrl.SetWriter(wordDoc);
pageofficeCtrl.SaveDataPage = "SaveData";
//打开Word文档
pageofficeCtrl.WebOpen("doc/test.doc", PageOfficeNetCore.OpenModeType.docSubmitForm, "tom");
ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1");
return(View());
}
public IActionResult Compose2()
{
int num = 1;//试题编号
string idlist = Request.Query["ids"];
string[] ids = idlist.Split(',');//将idlist按照","截取后存到ids数组中，然后遍历数组用js插入文件即可
PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request);
pageofficeCtrl.ServerPage = "/PageOffice/POServer";
string temp = "PO_begin";//新添加的数据区域名称
PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument();
for (int i = 0; i < ids.Length; i++)
{
PageOfficeNetCore.WordWriter.DataRegion dataNum = doc.CreateDataRegion("PO_" + num, PageOfficeNetCore.WordWriter.DataRegionInsertType.After, temp);
dataNum.Value = num + ".\t";
PageOfficeNetCore.WordWriter.DataRegion dataReg = doc.CreateDataRegion("PO_begin" + (i + 1), PageOfficeNetCore.WordWriter.DataRegionInsertType.After, "PO_" + num);
dataReg.Value = "[word]Openfile?id=" + ids[i] + "[/word]";
num++;
temp = "PO_begin" + (i + 1);
}
pageofficeCtrl.SetWriter(doc);
pageofficeCtrl.Caption = "生成试卷";
pageofficeCtrl.CustomToolbar = false;
//打开Word文档
pageofficeCtrl.WebOpen("doc/test.doc", PageOfficeNetCore.OpenModeType.docReadOnly, "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 = "张三";
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 wordDoc = new PageOfficeNetCore.WordWriter.WordDocument();
//打开数据区域，OpenDataRegion方法的参数代表Word文档中的书签名称
PageOfficeNetCore.WordWriter.DataRegion dataRegion1 = wordDoc.OpenDataRegion("PO_userName");
//为DataRegion赋值
dataRegion1.Value = "张三";
//设置字体样式
dataRegion1.Font.Color = Color.Blue;
dataRegion1.Font.Size = 24f;
dataRegion1.Font.Name = "隶书";
dataRegion1.Font.Bold = true;
PageOfficeNetCore.WordWriter.DataRegion dataRegion2 = wordDoc.OpenDataRegion("PO_deptName");
dataRegion2.Value = "人事部";
dataRegion2.Font.Color = Color.Red;
pageofficeCtrl.SetWriter(wordDoc);
//打开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 wordDoc = new PageOfficeNetCore.WordWriter.WordDocument();
//打开数据区域，OpenDataRegion方法的参数代表Word文档中的书签名称
PageOfficeNetCore.WordWriter.DataRegion dataRegion1 = wordDoc.OpenDataRegion("PO_userName");
//设置DataRegion的可编辑性
dataRegion1.Editing = true;
//为DataRegion赋值,此处的值可在页面中打开Word文档后在自己进行修改
dataRegion1.Value = "";
PageOfficeNetCore.WordWriter.DataRegion dataRegion2 = wordDoc.OpenDataRegion("PO_deptName");
dataRegion2.Editing = true;
dataRegion2.Value = "";
pageofficeCtrl.SetWriter(wordDoc);
pageofficeCtrl.SaveDataPage = "SaveData";
pageofficeCtrl.AddCustomToolButton("保存", "Save()", 1);
//打开Word文档
pageofficeCtrl.WebOpen("doc/test.doc", PageOfficeNetCore.OpenModeType.docSubmitForm, "tom");
ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1");
return(View());
}
public IActionResult SubmitDataOfDoc()
{
string docID = Request.Query["ID"];
string sql = "select * from leaveRecord where ID = " + docID;
SqliteConnection conn = new SqliteConnection(connString);
conn.Open();
SqliteCommand cmd = new SqliteCommand(sql, conn);
cmd.ExecuteNonQuery();
cmd.CommandText = sql;
SqliteDataReader dr = cmd.ExecuteReader();
PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request);
pageofficeCtrl.ServerPage = "../PageOffice/POServer";
PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument();
PageOfficeNetCore.WordWriter.DataRegion drName = doc.OpenDataRegion("PO_name");
drName.Editing = true;
PageOfficeNetCore.WordWriter.DataRegion drDept = doc.OpenDataRegion("PO_dept");
drDept.Shading.BackgroundPatternColor = Color.Silver;
//drDept.Editing = true;
PageOfficeNetCore.WordWriter.DataRegion drCause = doc.OpenDataRegion("PO_cause");
drCause.Editing = true;
PageOfficeNetCore.WordWriter.DataRegion drNum = doc.OpenDataRegion("PO_num");
drNum.Editing = true;
PageOfficeNetCore.WordWriter.DataRegion drDate = doc.OpenDataRegion("PO_date");
drDate.Shading.BackgroundPatternColor = Color.Pink;
//drDate.Editing = true;
PageOfficeNetCore.WordWriter.DataRegion drTip = doc.OpenDataRegion("PO_tip");
drTip.Font.Italic = true;
drTip.Value = "提示：带背景色的文字是只能通过选择设置，[]中的文字是可以录入编辑的。";
if (dr.Read())
{
doc.OpenDataRegion("PO_name").Value = dr["Name"].ToString();
doc.OpenDataRegion("PO_dept").Value = dr["Dept"].ToString();
doc.OpenDataRegion("PO_cause").Value = dr["Cause"].ToString();
doc.OpenDataRegion("PO_num").Value = dr["Num"].ToString();;
doc.OpenDataRegion("PO_date").Value = dr["SubmitTime"].ToString();;
}
dr.Close();
conn.Close();
// 设置界面样式
pageofficeCtrl.Caption = "用户填写请假条";
pageofficeCtrl.BorderStyle = PageOfficeNetCore.BorderStyleType.BorderThin;
// 添加自定义工具条按钮
pageofficeCtrl.AddCustomToolButton("保存", "poSave", 1);
pageofficeCtrl.AddCustomToolButton("全屏/还原", "poSetFullScreen", 4);
pageofficeCtrl.JsFunction_OnWordDataRegionClick = "OnWordDataRegionClick()";
//获取数据对象
pageofficeCtrl.SetWriter(doc);
//设置保存页面
pageofficeCtrl.SaveDataPage = "SaveData?ID=" + docID;
//打开Word文档
pageofficeCtrl.WebOpen("/doc/template.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()
{
string user = "";
string userName = Request.Form["userName"];
PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request);
pageofficeCtrl.ServerPage = "/PageOffice/POServer";
//***************************卓正PageOffice组件的使用********************************
PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument();
PageOfficeNetCore.WordWriter.DataRegion dA1 = doc.OpenDataRegion("PO_A_pro1");
PageOfficeNetCore.WordWriter.DataRegion dA2 = doc.OpenDataRegion("PO_A_pro2");
PageOfficeNetCore.WordWriter.DataRegion dB1 = doc.OpenDataRegion("PO_B_pro1");
PageOfficeNetCore.WordWriter.DataRegion dB2 = doc.OpenDataRegion("PO_B_pro2");
//根据登录用户名设置数据区域可编辑性
//A部门经理登录后
if (userName.Equals("zhangsan"))
{
dA1.Editing = true;
dA2.Editing = true;
dB1.Editing = false;
dB2.Editing = false;
user = "******";
}
//B部门经理登录后
else
{
dB1.Editing = true;
dB2.Editing = true;
dA1.Editing = false;
dA2.Editing = false;
user = "******";
}
pageofficeCtrl.SetWriter(doc);
//添加自定义按钮
pageofficeCtrl.AddCustomToolButton("保存", "Save", 1);
pageofficeCtrl.AddCustomToolButton("全屏/还原", "IsFullScreen", 4);
//设置保存页面
pageofficeCtrl.SaveFilePage = "SaveDoc";
//打开Word文档
pageofficeCtrl.WebOpen("doc/test.doc", PageOfficeNetCore.OpenModeType.docSubmitForm, user);
ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1");
ViewBag.user = user;
return(View());
}
public IActionResult Word()
{
string userName = Request.Form["userName"];
PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request);
pageofficeCtrl.ServerPage = "/PageOffice/POServer";
PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument();
//打开数据区域
PageOfficeNetCore.WordWriter.DataRegion d1 = doc.OpenDataRegion("PO_com1");
//给数据区域赋值
d1.Value = "[word]doc/content1.doc[/word]";
//若要将数据区域内容存入文件中，则必须设置属性“SubmitAsFile”值为true
d1.SubmitAsFile = true;
PageOfficeNetCore.WordWriter.DataRegion d2 = doc.OpenDataRegion("PO_com2");
d2.Value = "[word]doc/content2.doc[/word]";
d2.SubmitAsFile = true;
//根据登录用户名设置数据区域可编辑性
//甲客户：zhangsan 登录后登录后
if (userName.Equals("zhangsan"))
{
d1.Editing = true;
d2.Editing = false;
}
//乙客户：lisi 登录后登录后
else
{
d2.Editing = true;
d1.Editing = false;
}
pageofficeCtrl.SetWriter(doc);
//添加自定义按钮
pageofficeCtrl.AddCustomToolButton("保存", "Save", 1);
pageofficeCtrl.AddCustomToolButton("全屏/还原", "IsFullScreen", 4);
//设置保存页面
pageofficeCtrl.SaveDataPage = "SaveData?userName="******"doc/test.doc", PageOfficeNetCore.OpenModeType.docSubmitForm, userName);
ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1");
ViewBag.userName = userName;
return(View());
}
public IActionResult Word()
{
PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request);
pageofficeCtrl.ServerPage = "/PageOffice/POServer";
//添加自定义的保存按钮
pageofficeCtrl.AddCustomToolButton("保存图片", "Save", 1);
PageOfficeNetCore.WordWriter.WordDocument wordDoc = new PageOfficeNetCore.WordWriter.WordDocument();
PageOfficeNetCore.WordWriter.DataRegion dataRegion1 = wordDoc.OpenDataRegion("PO_image");
dataRegion1.Editing = true;//放图片的数据区域是可以编辑的，其它部分不可编辑
pageofficeCtrl.SetWriter(wordDoc);
//设置保存页面
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();
PageOfficeNetCore.WordWriter.DataRegion data1 = doc.OpenDataRegion("PO_p1");
data1.Value = "[image width=200.2 height=200]doc/1.jpg[/image]";
pageofficeCtrl.SetWriter(doc);
pageofficeCtrl.Caption = "演示：后台编程插入图片到数据区域并设置图片大小(企业版)";
//隐藏菜单栏
pageofficeCtrl.Menubar = false;
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 dataRegion1 = doc.OpenDataRegion("PO_userName");
dataRegion1.Value = "张三";
PageOfficeNetCore.WordWriter.DataRegion dataRegion2 = doc.OpenDataRegion("PO_deptName");
dataRegion2.Value = "销售部";
pageofficeCtrl.SetWriter(doc);
//打开Word文档
pageofficeCtrl.WebOpen("doc/test.doc", PageOfficeNetCore.OpenModeType.docNormalEdit, "tom");
ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1");
return(View());
}
public IActionResult taoHong()
{
String mb = Request.Query["mb"];
PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request);
pageofficeCtrl.ServerPage = "/PageOffice/POServer";
String fileName = "test.doc";
if (mb != null && mb.Trim() != "")
{
string webRootPath = _webHostEnvironment.WebRootPath;
fileName = "zhengshi.doc";
System.IO.File.Copy(webRootPath + "/TaoHong/doc/" + mb,
webRootPath + "/TaoHong/doc/" + fileName, true);
//给正式发文的文件填充数据
PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument();
PageOfficeNetCore.WordWriter.DataRegion copies = doc.OpenDataRegion("PO_Copies");
copies.Value = "6";
PageOfficeNetCore.WordWriter.DataRegion docNum = doc.OpenDataRegion("PO_DocNum");
docNum.Value = "001";
PageOfficeNetCore.WordWriter.DataRegion issueDate = doc.OpenDataRegion("PO_IssueDate");
issueDate.Value = "2013-5-30";
PageOfficeNetCore.WordWriter.DataRegion issueDept = doc.OpenDataRegion("PO_IssueDept");
issueDept.Value = "开发部";
PageOfficeNetCore.WordWriter.DataRegion sTextS = doc.OpenDataRegion("PO_STextS");
sTextS.Value = "[word]doc/test.doc[/word]"; // 把正文文件插入到正式文件中
PageOfficeNetCore.WordWriter.DataRegion sTitle = doc.OpenDataRegion("PO_sTitle");
sTitle.Value = "北京某公司文件";
PageOfficeNetCore.WordWriter.DataRegion topicWords = doc.OpenDataRegion("PO_TopicWords");
topicWords.Value = "Pageoffice、 套红";
pageofficeCtrl.SetWriter(doc);
}
pageofficeCtrl.AddCustomToolButton("全屏/还原", "IsFullScreen", 4);
pageofficeCtrl.SaveFilePage = "SaveDoc";
pageofficeCtrl.WebOpen("doc/" + fileName, 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 wordDoc = new PageOfficeNetCore.WordWriter.WordDocument();
//CreateDataRegion方法的三个参数分别代表：将要新建数据区域处的标签的名称、DataRegion的插入位置、与将要创建的DataRegion相关联的书签名称
//若打开的Word文档中尚无书签或者想在Word文档的开头新建数据区域，则第三那个参数使用“[home]”若想在结尾处新建使用“[end]”
PageOfficeNetCore.WordWriter.DataRegion dataRegion1 = wordDoc.CreateDataRegion("createDataRegion1", PageOfficeNetCore.WordWriter.DataRegionInsertType.After, "[home]");
//为创建的DataRegion赋值
dataRegion1.Value = "新建DataRegion1\r\n";
PageOfficeNetCore.WordWriter.DataRegion dataRegion2 = wordDoc.CreateDataRegion("createDataRegion2", PageOfficeNetCore.WordWriter.DataRegionInsertType.After, "createDataRegion1");
dataRegion2.Value = "新建DataRegion2\r\n";
pageofficeCtrl.SetWriter(wordDoc);
//打开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 worddoc = new PageOfficeNetCore.WordWriter.WordDocument();
//先在要插入word文件的位置手动插入书签,书签必须以“PO_”为前缀
//给DataRegion赋值,值的形式为："[word]word文件路径[/word]"
PageOfficeNetCore.WordWriter.DataRegion data1 = worddoc.OpenDataRegion("PO_p1");
data1.Value = "[excel]doc/1.xls[/excel]";
PageOfficeNetCore.WordWriter.DataRegion data2 = worddoc.OpenDataRegion("PO_p2");
data2.Value = "[word]doc/2.doc[/word]";
PageOfficeNetCore.WordWriter.DataRegion data3 = worddoc.OpenDataRegion("PO_p3");
data3.Value = "[word]doc/3.doc[/word]";
pageofficeCtrl.SetWriter(worddoc);
pageofficeCtrl.Caption = "演示：后台编程插入excel文件到数据区域(企业版)";
//打开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_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 Word()
{
PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request);
pageofficeCtrl.ServerPage = "/PageOffice/POServer";
//在文档末尾插入分页符，并且在新的页中创建新的数据区域插入另一篇文档
PageOfficeNetCore.WordWriter.WordDocument wordDocument = new PageOfficeNetCore.WordWriter.WordDocument();
PageOfficeNetCore.WordWriter.DataRegion mydr1 = wordDocument.CreateDataRegion("PO_first", PageOfficeNetCore.WordWriter.DataRegionInsertType.After, "[end]");
mydr1.SelectEnd();
wordDocument.InsertPageBreak();//插入分页符
PageOfficeNetCore.WordWriter.DataRegion mydr2 = wordDocument.CreateDataRegion("PO_second", PageOfficeNetCore.WordWriter.DataRegionInsertType.After, "[end]");
mydr2.Value = "[word]doc/test2.doc[/word]";
pageofficeCtrl.AddCustomToolButton("保存", "Save()", 1);
pageofficeCtrl.SetWriter(wordDocument);
//设置保存页面
pageofficeCtrl.SaveFilePage = "SaveDoc";
//打开Word文档
pageofficeCtrl.WebOpen("doc/test1.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 Openfile()
{
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");
//给数据区域赋值
doc.OpenDataRegion("PO_ID").Value = id;
//设置数据区域的可编辑性
doc.OpenDataRegion("PO_UserName").Editing = true;
doc.OpenDataRegion("PO_DeptName").Editing = true;
doc.OpenDataRegion("PO_SalTotal").Editing = true;
doc.OpenDataRegion("PO_SalDeduct").Editing = true;
doc.OpenDataRegion("PO_SalCount").Editing = true;
doc.OpenDataRegion("PO_DataTime").Editing = true;
doc.OpenDataRegion("PO_UserName").Value = dr["UserName"].ToString();
doc.OpenDataRegion("PO_DeptName").Value = dr["DeptName"].ToString();
if (dr["SalTotal"] != null && dr["SalTotal"].ToString() != "")
{
doc.OpenDataRegion("PO_SalTotal").Value = dr["SalTotal"].ToString();
}
else
{
doc.OpenDataRegion("PO_SalTotal").Value = "￥0.00";
}
if (dr["SalDeduct"] != null && dr["SalDeduct"].ToString() != "")
{
doc.OpenDataRegion("PO_SalDeduct").Value = dr["SalDeduct"].ToString();
}
else
{
doc.OpenDataRegion("PO_SalDeduct").Value = "￥0.00";
}
if (dr["SalCount"] != null && dr["SalCount"].ToString() != "")
{
doc.OpenDataRegion("PO_SalCount").Value = dr["SalCount"].ToString();
}
else
{
doc.OpenDataRegion("PO_SalCount").Value = "￥0.00";
}
if (dr["DataTime"] != null && dr["DataTime"].ToString() != "")
{
doc.OpenDataRegion("PO_DataTime").Value = dr["DataTime"].ToString();;
}
else
{
doc.OpenDataRegion("PO_DataTime").Value = DateTime.Now.ToString("yyyy-MM-dd");
}
pageofficeCtrl.AddCustomToolButton("保存", "Save()", 1);
pageofficeCtrl.SaveDataPage = "SaveData?id=" + id;
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.WebOpen("doc/template.doc", PageOfficeNetCore.OpenModeType.docSubmitForm, "tom");
ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1");
ViewBag.err = err;
return(View());
}
public IActionResult Word()
{
PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request);
pageofficeCtrl.ServerPage = "/PageOffice/POServer";
PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument();
//设置内容标题
//创建DataRegion对象，PO_title为自动添加的书签名称,书签名称需以“PO_”为前缀，切书签名称不能重复
//三个参数分别为要新插入书签的名称、新书签的插入位置、相关联的书签名称（“[home]”代表Word文档的第一个位置）
PageOfficeNetCore.WordWriter.DataRegion title = doc.CreateDataRegion("PO_title",
PageOfficeNetCore.WordWriter.DataRegionInsertType.After, "[home]");
//给DataRegion对象赋值
title.Value = "C#中Socket多线程编程实例\n";
//设置字体：粗细、大小、字体名称、是否是斜体
title.Font.Bold = true;
title.Font.Size = 20;
title.Font.Name = "黑体";
title.Font.Italic = false;
//定义段落对象
PageOfficeNetCore.WordWriter.ParagraphFormat titlePara = title.ParagraphFormat;
//设置段落对齐方式
titlePara.Alignment = PageOfficeNetCore.WordWriter.WdParagraphAlignment.wdAlignParagraphCenter;
//设置段落行间距
titlePara.LineSpacingRule = PageOfficeNetCore.WordWriter.WdLineSpacing.wdLineSpaceMultiple;
//设置内容
//第一段
//创建DataRegion对象，PO_body为自动添加的书签名称
PageOfficeNetCore.WordWriter.DataRegion body = doc.CreateDataRegion("PO_body", PageOfficeNetCore.WordWriter.DataRegionInsertType.After, "PO_title");
//设置字体：粗细、是否是斜体、大小、字体名称、字体颜色
body.Font.Bold = false;
body.Font.Italic = true;
body.Font.Size = 10;
//设置中文字体名称
body.Font.Name = "楷体";
//设置英文字体名称
body.Font.NameAscii = "Times New Roman";
body.Font.Color = Color.Red;
//给DataRegion对象赋值
body.Value = "是微软随着VS.net新推出的一门语言。它作为一门新兴的语言，有着C++的强健，又有着VB等的RAD特性。而且，微软推出C#主要的目的是为了对抗Sun公司的Java。大家都知道Java语言的强大功能，尤其在网络编程方面。于是，C#在网络编程方面也自然不甘落后于人。本文就向大家介绍一下C#下实现套接字（Sockets）编程的一些基本知识，以期能使大家对此有个大致了解。首先，我向大家介绍一下套接字的概念。\n";
//创建ParagraphFormat对象
PageOfficeNetCore.WordWriter.ParagraphFormat bodyPara = body.ParagraphFormat;
//设置段落的行间距、对齐方式、首行缩进
bodyPara.LineSpacingRule = PageOfficeNetCore.WordWriter.WdLineSpacing.wdLineSpaceAtLeast;
bodyPara.Alignment = PageOfficeNetCore.WordWriter.WdParagraphAlignment.wdAlignParagraphLeft;
bodyPara.FirstLineIndent = 21;
//第二段
PageOfficeNetCore.WordWriter.DataRegion body2 = doc.CreateDataRegion("PO_body2", PageOfficeNetCore.WordWriter.DataRegionInsertType.After, "PO_body");
body2.Font.Bold = false;
body2.Font.Size = 12;
body2.Font.Name = "黑体";
body2.Value = "套接字是通信的基石，是支持TCP/IP协议的网络通信的基本操作单元。可以将套接字看作不同主机间的进程进行双向通信的端点，它构成了单个主机内及整个网络间的编程界面。套接字存在于通信域中，通信域是为了处理一般的线程通过套接字通信而引进的一种抽象概念。套接字通常和同一个域中的套接字交换数据（数据交换也可能穿越域的界限，但这时一定要执行某种解释程序）。各种进程使用这个相同的域互相之间用Internet协议簇来进行通信。\n";
//body2.Value ="[image]../images/logo.jpg[/image]";
PageOfficeNetCore.WordWriter.ParagraphFormat bodyPara2 = body2.ParagraphFormat;
bodyPara2.LineSpacingRule = PageOfficeNetCore.WordWriter.WdLineSpacing.wdLineSpace1pt5;
bodyPara2.Alignment = PageOfficeNetCore.WordWriter.WdParagraphAlignment.wdAlignParagraphLeft;
bodyPara2.FirstLineIndent = 21;
//第三段
PageOfficeNetCore.WordWriter.DataRegion body3 = doc.CreateDataRegion("PO_body3", PageOfficeNetCore.WordWriter.DataRegionInsertType.After, "PO_body2");
body3.Font.Bold = false;
body3.Font.Color = Color.FromArgb(0, 128, 128);
body3.Font.Size = 14;
body3.Font.Name = "华文彩云";
body3.Value = "套接字可以根据通信性质分类，这种性质对于用户是可见的。应用程序一般仅在同一类的套接字间进行通信。不过只要底层的通信协议允许，不同类型的套接字间也照样可以通信。套接字有两种不同的类型：流套接字和数据报套接字。\n";
PageOfficeNetCore.WordWriter.ParagraphFormat bodyPara3 = body3.ParagraphFormat;
bodyPara3.LineSpacingRule = PageOfficeNetCore.WordWriter.WdLineSpacing.wdLineSpaceDouble;
bodyPara3.Alignment = PageOfficeNetCore.WordWriter.WdParagraphAlignment.wdAlignParagraphLeft;
bodyPara3.FirstLineIndent = 21;
PageOfficeNetCore.WordWriter.DataRegion body4 = doc.CreateDataRegion("PO_body4", PageOfficeNetCore.WordWriter.DataRegionInsertType.After, "PO_body3");
body4.Value = "[image]doc/logo.png[/image]";
//body4.Value = "[word]doc/1.doc[/word]";//还可嵌入其他Word文件
PageOfficeNetCore.WordWriter.ParagraphFormat bodyPara4 = body4.ParagraphFormat;
bodyPara4.Alignment = PageOfficeNetCore.WordWriter.WdParagraphAlignment.wdAlignParagraphCenter;
//PageOffice组件的使用
//隐藏自定义工具栏
pageofficeCtrl.CustomToolbar = false;
pageofficeCtrl.SetWriter(doc);
pageofficeCtrl.JsFunction_AfterDocumentSaved = "SaveOK()";
//打开Word文档
pageofficeCtrl.WebOpen("doc/template.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";
string userName = Request.Query["userName"];
//***************************卓正PageOffice组件的使用********************************
PageOfficeNetCore.WordWriter.WordDocument doc = new PageOfficeNetCore.WordWriter.WordDocument();
PageOfficeNetCore.WordWriter.DataRegion d1 = doc.OpenDataRegion("PO_1");
PageOfficeNetCore.WordWriter.DataRegion d2 = doc.OpenDataRegion("PO_2");
PageOfficeNetCore.WordWriter.DataRegion d3 = doc.OpenDataRegion("PO_3");
//设置数据区域文本样式
d1.Font.Color = Color.Green;
d2.Font.Color = Color.Blue;
d3.Font.Color = Color.Magenta;
//根据登录用户名设置数据区域可编辑性
//张三登录后
if (userName.Equals("zhangsan"))
{
userName = "******";
d1.Editing = true;
d2.Editing = false;
d3.Editing = false;
}
//李四登录后
else if (userName.Equals("lisi"))
{
userName = "******";
d1.Editing = false;
d2.Editing = true;
d3.Editing = false;
}
//王五登录后
else
{
userName = "******";
d1.Editing = false;
d2.Editing = false;
d3.Editing = true;
}
//添加自定义按钮
pageofficeCtrl.AddCustomToolButton("保存", "Save", 1);
pageofficeCtrl.AddCustomToolButton("-", "", 0);
pageofficeCtrl.AddCustomToolButton("盖章方式一", "AddSeal", 2);
pageofficeCtrl.AddCustomToolButton("盖章方式二", "AddSeal2", 2);
pageofficeCtrl.AddCustomToolButton("-", "", 0);
pageofficeCtrl.AddCustomToolButton("签字方式一", "AddSign", 3);
pageofficeCtrl.AddCustomToolButton("签字方式二", "AddSign2", 3);
pageofficeCtrl.AddCustomToolButton("-", "", 0);
pageofficeCtrl.AddCustomToolButton("全屏/还原", "IsFullScreen", 4);
pageofficeCtrl.SetWriter(doc);
//设置保存页面
pageofficeCtrl.SaveFilePage = "SaveDoc";
//打开Word文档
pageofficeCtrl.WebOpen("/doc/test.doc", PageOfficeNetCore.OpenModeType.docSubmitForm, "tom");
ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1");
ViewBag.userName = userName;
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());
}
