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);
}
