public async Task <ActionResult> SaveDoc()
{
String conment = "";
string docID = Request.Query["id"];
PageOfficeNetCore.WordReader.WordDocument doc = new PageOfficeNetCore.WordReader.WordDocument(Request, Response);
await doc.LoadAsync();
String sName = doc.OpenDataRegion("PO_name").Value;
String sDept = doc.OpenDataRegion("PO_dept").Value;
String sCause = doc.OpenDataRegion("PO_cause").Value;
String sNum = doc.OpenDataRegion("PO_num").Value;
String sDate = doc.OpenDataRegion("PO_date").Value;
conment += "提交的数据为：<br/>";
conment += "姓名：" + sName + "<br/>";
conment += "原因：" + sCause + "<br/>";
conment += "天数：" + sNum + "<br/>";
conment += "日期：" + sDate + "<br/>";
await Response.Body.WriteAsync(Encoding.GetEncoding("GB2312").GetBytes(conment));
doc.ShowPage(578, 380);
doc.Close();
return(Content("OK"));
}
public async Task <ActionResult> SaveData()
{
//----------- PageOffice 服务器端编程开始 -------------------//
PageOfficeNetCore.WordReader.WordDocument doc = new PageOfficeNetCore.WordReader.WordDocument(Request, Response);
await doc.LoadAsync();
PageOfficeNetCore.WordReader.DataRegion dataReg = doc.OpenDataRegion("PO_table");
PageOfficeNetCore.WordReader.Table table = dataReg.OpenTable(1);
//输出提交的table中的数据
//Response.Write("表格中的各个单元的格数据为：<br/><br/>");
StringBuilder dataStr = new StringBuilder();
for (int i = 1; i <= table.RowsCount; i++)
{
dataStr.Append("<div style='width:220px;'>");
for (int j = 1; j <= table.ColumnsCount; j++)
{
dataStr.Append("<div style='float:left;width:70px;border:1px solid red;'>" + table.OpenCellRC(i, j).Value + "</div>");
}
dataStr.Append("</div>");
}
//Response.Write(dataStr.ToString());
//向客户端显示提交的数据
await Response.Body.WriteAsync(Encoding.GetEncoding("GB2312").GetBytes(dataStr.ToString()));
doc.ShowPage(300, 300);
doc.Close();
return(Content("OK"));
}
public async Task <ActionResult> SaveData()
{
string id = Request.Query["id"];
PageOfficeNetCore.WordReader.WordDocument doc = new PageOfficeNetCore.WordReader.WordDocument(Request, Response);
await doc.LoadAsync();
string userName = "", deptName = "", salTotoal = "0", salDeduct = "0", salCount = "0", dateTime = "";
//----------- PageOffice 服务器端编程开始 -------------------//
userName = doc.OpenDataRegion("PO_UserName").Value;
deptName = doc.OpenDataRegion("PO_DeptName").Value;
salTotoal = doc.OpenDataRegion("PO_SalTotal").Value;
salDeduct = doc.OpenDataRegion("PO_SalDeduct").Value;
salCount = doc.OpenDataRegion("PO_SalCount").Value;
dateTime = doc.OpenDataRegion("PO_DataTime").Value;
string sql = "UPDATE Salary SET UserName='******',DeptName='" + deptName + "',SalTotal='" + salTotoal
+ "',SalDeduct='" + salDeduct + "',SalCount='" + salCount
+ "',DataTime='" + dateTime + "' WHERE ID=" + id;
SqliteConnection conn = new SqliteConnection(connString);
conn.Open();
SqliteCommand cmd = new SqliteCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
doc.Close();
return(Content("OK"));
}
public async Task <ActionResult> SaveData()
{
PageOfficeNetCore.WordReader.WordDocument doc = new PageOfficeNetCore.WordReader.WordDocument(Request, Response);
await doc.LoadAsync();
string webRootPath = _webHostEnvironment.WebRootPath;
if (Request.Query["userName"] != "" && Request.Query["userName"].Equals("zhangsan"))
{
saveBytesToFile(doc.OpenDataRegion("PO_com1").FileBytes, webRootPath + "/SetDrByUserWord2/doc/content1.doc");
}
else
{
saveBytesToFile(doc.OpenDataRegion("PO_com2").FileBytes, webRootPath + "/SetDrByUserWord2/doc/content2.doc");
}
doc.Close();
return(Content("OK"));
}
public async Task <ActionResult> SaveData()
{
PageOfficeNetCore.WordReader.WordDocument doc = new PageOfficeNetCore.WordReader.WordDocument(Request, Response);
await doc.LoadAsync();
PageOfficeNetCore.WordReader.DataRegion dataRegion1 = doc.OpenDataRegion("PO_image");
//将提取的图片保存到服务器上，图片的名称为:a.jpg
string webRootPath = _webHostEnvironment.WebRootPath;
dataRegion1.OpenShape(1).SaveAsJPG(webRootPath + "/ExtractImage/doc/a.jpg");
//注册编码提供程序
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
//UrlEncoder
doc.CustomSaveResult = HttpUtility.UrlEncode("保存成功,文件保存到：" + "wwwroot/ExtractImage/doc/a.jpg");
doc.Close();
return(Content("OK"));
}
public async Task <ActionResult> SaveData()
{
string content = "";
PageOfficeNetCore.WordReader.WordDocument doc = new PageOfficeNetCore.WordReader.WordDocument(Request, Response);
await doc.LoadAsync();
//获取提交的数值
PageOfficeNetCore.WordReader.DataRegion dataUserName = doc.OpenDataRegion("PO_userName");
PageOfficeNetCore.WordReader.DataRegion dataDeptName = doc.OpenDataRegion("PO_deptName");
content += "公司名称：" + doc.GetFormField("txtCompany");
content += "<br/>员工姓名：" + dataUserName.Value;
content += "<br/>部门名称：" + dataDeptName.Value;
await Response.Body.WriteAsync(Encoding.GetEncoding("GB2312").GetBytes(content));
doc.ShowPage(400, 300);
doc.Close();
return(Content("OK"));
}
public async Task <ActionResult> SaveData()
{
PageOfficeNetCore.WordReader.WordDocument doc = new PageOfficeNetCore.WordReader.WordDocument(Request, Response);
await doc.LoadAsync();
//获取提交的数值
String dataUserName = doc.OpenDataRegion("PO_userName").Value;
String dataDeptName = doc.OpenDataRegion("PO_deptName").Value;
String companyName = doc.GetFormField("txtCompany");
/**获取到的公司名称,员工姓名,部门名称等内容可以保存到数据库,这里可以连接开发人员自己的数据库,例如连接sqlServer2008数据库。
* string constr = "server=ACER-PC\\LI;database=db_test;uid=sa;pwd=123";
* conn = new SqlConnection(constr); //数据库连接
* conn.Open();
* SqlCommand cmd = new SqlCommand("update user set userName='******',deptName='"+dataDeptName+"',companyName='"+companyName+"' where userId=1",conn);
* cmd.ExecuteNonQuery();
* conn.Close();
* */
doc.Close();
return(Content("OK"));
}
public async Task <ActionResult> SaveData()
{
PageOfficeNetCore.WordReader.WordDocument doc = new PageOfficeNetCore.WordReader.WordDocument(Request, Response);
await doc.LoadAsync();
string webRootPath = _webHostEnvironment.WebRootPath;
Byte[] bWord;
// 读取数据区域PO_test1中的内容，保存为一个新的word文档：new1.doc
PageOfficeNetCore.WordReader.DataRegion dr1 = doc.OpenDataRegion("PO_test1");
bWord = dr1.FileBytes;
Stream s1 = new FileStream(webRootPath + "/SplitWord/doc/new1.doc", System.IO.FileMode.Create);
s1.Write(bWord, 0, bWord.Length);
s1.Close();
// 读取数据区域PO_test2中的内容，保存为一个新的word文档：new2.doc
PageOfficeNetCore.WordReader.DataRegion dr2 = doc.OpenDataRegion("PO_test2");
bWord = dr2.FileBytes;
Stream s2 = new FileStream(webRootPath + "/SplitWord/doc/new2.doc", System.IO.FileMode.Create);
s2.Write(bWord, 0, bWord.Length);
s2.Close();
// 读取数据区域PO_test3中的内容，保存为一个新的word文档：new3.doc
PageOfficeNetCore.WordReader.DataRegion dr3 = doc.OpenDataRegion("PO_test3");
bWord = dr3.FileBytes;
Stream s3 = new FileStream(webRootPath + "/SplitWord/doc/new3.doc", FileMode.Create);
s3.Write(bWord, 0, bWord.Length);
s3.Close();
doc.Close();
return(Content("OK"));
}
public async Task <ActionResult> SaveData()
{
string content = "";
PageOfficeNetCore.WordReader.WordDocument doc = new PageOfficeNetCore.WordReader.WordDocument(Request, Response);
await doc.LoadAsync();
//获取提交的数值
PageOfficeNetCore.WordReader.DataRegion poName = doc.OpenDataRegion("PO_Name");
try
{
PageOfficeNetCore.WordReader.DataRegion dataDeptName = doc.OpenDataRegion("PO_deptName");
content += "后台获取 PO_Name的值：" + poName.Value;
}
catch
{
content += "客户端提交的数据区域中没有包含名称为 PO_Name 的数据区域。";
}
await Response.Body.WriteAsync(Encoding.GetEncoding("GB2312").GetBytes(content));
doc.ShowPage(400, 300);
doc.Close();
return(Content("OK"));
}
public async Task <ActionResult> SaveData()
{
string ErrorMsg = "";
PageOfficeNetCore.WordReader.WordDocument doc = new PageOfficeNetCore.WordReader.WordDocument(Request, Response);
await doc.LoadAsync();
string sName = doc.OpenDataRegion("PO_name").Value;
string sDept = doc.OpenDataRegion("PO_dept").Value;
string sCause = doc.OpenDataRegion("PO_cause").Value;
string sNum = doc.OpenDataRegion("PO_num").Value;
string sDate = doc.OpenDataRegion("PO_date").Value;
if (sName == "")
{
ErrorMsg = ErrorMsg + "<li>申请人</li>";
}
if (sDept == "")
{
ErrorMsg = ErrorMsg + "<li>部门名称</li>";
}
if (sCause == "")
{
ErrorMsg = ErrorMsg + "<li>请假原因</li>";
}
if (sDate == "")
{
ErrorMsg = ErrorMsg + "<li>日期</li>";
}
try
{
if (sNum != "")
{
if (Int64.Parse(sNum) < 0)
{
ErrorMsg = ErrorMsg + "<li>请假天数不能是负数</li>";
}
}
else
{
ErrorMsg = ErrorMsg + "<li>请假天数</li>";
}
}
catch (Exception Ex)
{
ErrorMsg = ErrorMsg + "<li><font color=red>注意：</font>请假天数必须是数字</li>";
}
string id = Request.Query["ID"];
string sql = "";
if (ErrorMsg == "")
{
sql = "update leaveRecord set Name='" + sName
+ "', Dept='" + sDept + "', Cause='" + sCause
+ "', Num=" + sNum + ", SubmitTime='" + sDate
+ "' where ID=" + id;
SqliteConnection conn = new SqliteConnection(connString);
conn.Open();
SqliteCommand cmd = new SqliteCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
else
{
await Response.Body.WriteAsync(Encoding.GetEncoding("GB2312").GetBytes(ErrorMsg));
doc.ShowPage(578, 380);
}
doc.Close();
return(Content("OK"));
}
