protected void Page_Load(object sender, EventArgs e) { PageOffice.WordReader.WordDocument doc = new PageOffice.WordReader.WordDocument(); Byte[] bWord; // 读取数据区域PO_test1中的内容,保存为一个新的word文档:new1.doc PageOffice.WordReader.DataRegion dr1 = doc.OpenDataRegion("PO_test1"); bWord = dr1.FileBytes; Stream s1 = new FileStream(Server.MapPath("doc/") + "new1.doc", FileMode.Create); s1.Write(bWord, 0, bWord.Length); s1.Close(); // 读取数据区域PO_test2中的内容,保存为一个新的word文档:new2.doc PageOffice.WordReader.DataRegion dr2 = doc.OpenDataRegion("PO_test2"); bWord = dr2.FileBytes; Stream s2 = new FileStream(Server.MapPath("doc/") + "new2.doc", FileMode.Create); s2.Write(bWord, 0, bWord.Length); s2.Close(); // 读取数据区域PO_test3中的内容,保存为一个新的word文档:new3.doc PageOffice.WordReader.DataRegion dr3 = doc.OpenDataRegion("PO_test3"); bWord = dr3.FileBytes; Stream s3 = new FileStream(Server.MapPath("doc/") + "new3.doc", FileMode.Create); s3.Write(bWord, 0, bWord.Length); s3.Close(); doc.Close(); }
protected void Page_Load(object sender, EventArgs e) { PageOffice.WordReader.WordDocument wordDoc = new PageOffice.WordReader.WordDocument(); PageOffice.WordReader.DataRegion dataRegion1 = wordDoc.OpenDataRegion("PO_image"); //将提取的图片保存到服务器上,图片的名称为:a.jpg dataRegion1.OpenShape(1).SaveAsJPG(Server.MapPath("doc/a.jpg")); wordDoc.CustomSaveResult = "保存成功,文件保存到:" + Server.MapPath("doc/a.jpg"); wordDoc.Close(); }
protected void Page_Load(object sender, EventArgs e) { PageOffice.WordReader.WordDocument doc = new PageOffice.WordReader.WordDocument(); //获取提交的数值 PageOffice.WordReader.DataRegion dataUserName = doc.OpenDataRegion("PO_userName"); PageOffice.WordReader.DataRegion dataDeptName = doc.OpenDataRegion("PO_deptName"); content += "公司名称:" + doc.GetFormField("txtCompany"); content += "<br/>员工姓名:" + dataUserName.Value; content += "<br/>部门名称:" + dataDeptName.Value; doc.ShowPage(400, 300); doc.Close(); }
protected void Page_Load(object sender, EventArgs e) { PageOffice.WordReader.WordDocument doc = new PageOffice.WordReader.WordDocument(); if (Request.QueryString["userName"] != null && Request.QueryString["userName"].Equals("zhangsan")) { saveBytesToFile(doc.OpenDataRegion("PO_com1").FileBytes, Server.MapPath("doc/content1.doc")); } else { saveBytesToFile(doc.OpenDataRegion("PO_com2").FileBytes, Server.MapPath("doc/content2.doc")); } doc.Close(); }
protected void Page_Load(object sender, EventArgs e) { PageOffice.WordReader.WordDocument doc = new PageOffice.WordReader.WordDocument(); //获取提交的数值 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(); }
protected void Page_Load(object sender, EventArgs e) { string strID = Request.QueryString["ID"]; string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|demo.mdb"; OleDbConnection conn = new OleDbConnection(connString); conn.Open(); string strsql; OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; //----------- PageOffice 服务器端编程开始 -------------------// PageOffice.WordReader.WordDocument doc = new PageOffice.WordReader.WordDocument(); 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 (Int32.Parse(sNum) < 0) { ErrorMsg = ErrorMsg + "<li>请假天数不能是负数</li>"; } } else { ErrorMsg = ErrorMsg + "<li>请假天数</li>"; } } catch (Exception Ex) { ErrorMsg = ErrorMsg + "<li><font color=red>注意:</font>请假天数必须是数字</li>"; } if (ErrorMsg == "") { strsql = "update leaveRecord set Name='" + sName + "', Dept='" + sDept + "', Cause='" + sCause + "', Num=" + sNum + ", SubmitTime='" + sDate + "' where ID=" + strID; cmd.CommandText = strsql; cmd.ExecuteNonQuery(); } else { doc.ShowPage(578, 380); } doc.Close(); conn.Close(); //----------- PageOffice 服务器端编程结束 -------------------// string mScriptName = "savedata.aspx"; string mHttpUrl = "http://" + Request.ServerVariables["HTTP_HOST"] + Request.ServerVariables["SCRIPT_NAME"]; BaseUrl = mHttpUrl.Substring(0, mHttpUrl.Length - mScriptName.Length); }