protected void Page_Load(object sender, EventArgs e)
{
DocID = Request.QueryString["ID"];
strSql = "select * from word where ID = " + DocID;
DataSet ds = new DataSet();
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
OleDbDataAdapter command = new OleDbDataAdapter(strSql.ToString(), connection);
command.Fill(ds, "ds");
connection.Close();
}
DataTable dt = new DataTable();
dt = ds.Tables[0];
if ("文员清稿" == dt.Rows[0]["Status"].ToString())
{
Literal_Subject.Text = dt.Rows[0]["Subject"].ToString(); //文件名称
Literal_Lc.Text = dt.Rows[0]["Status"].ToString(); //当前文件的流程
Literal_Lz.Text = "正式发文"; //流转
}
else
{
Literal_Lc.Text = "已流转到“" + dt.Rows[0]["Status"].ToString() + "”，当前是“核稿模式”打开文件的效果。";
}
string fileName = dt.Rows[0]["FileName"].ToString();
PageOfficeCtrl1.CustomMenuCaption = "自定义菜单";
PageOfficeCtrl1.AddCustomMenuItem("显示痕迹", "ShowRevisions", true);
PageOfficeCtrl1.AddCustomMenuItem("隐藏痕迹", "HiddenRevisions", true);
PageOfficeCtrl1.AddCustomMenuItem("-", "", false);
PageOfficeCtrl1.AddCustomMenuItem("显示标题", "ShowTitle", true);
PageOfficeCtrl1.AddCustomMenuItem("-", "", false);
PageOfficeCtrl1.AddCustomMenuItem("领导签批", "InsertHandSign", true);
PageOfficeCtrl1.AddCustomMenuItem("插入印章", "InsertSeal", true);
PageOfficeCtrl1.AddCustomMenuItem("接受所有修订", "AcceptAllRevisions", true);
PageOfficeCtrl1.AddCustomMenuItem("-", "", false);
PageOfficeCtrl1.AddCustomMenuItem("分层显示手写批注", "ShowHandDrawDispBar", true);
PageOfficeCtrl1.AddCustomToolButton("保存", "Save", 1);
PageOfficeCtrl1.AddCustomToolButton("另存为Html", "SaveAsHtml", 0);
PageOfficeCtrl1.AddCustomToolButton("显示/隐藏痕迹", "Show_HidRevisions", 5);
PageOfficeCtrl1.AddCustomToolButton("插入印章/签名", "InsertSeal", 2);
PageOfficeCtrl1.AddCustomToolButton("领导签批", "InsertHandSign", 3);
PageOfficeCtrl1.AddCustomToolButton("接受所有修订", "AcceptAllRevisions", 5);
PageOfficeCtrl1.AddCustomToolButton("分层显示手写批注", "ShowHandDrawDispBar", 7);
PageOfficeCtrl1.AddCustomToolButton("全屏/还原", "IsFullScreen", 4);
PageOfficeCtrl1.ServerPage = "pageoffice/server.aspx";
PageOfficeCtrl1.SaveFilePage = "savedoc.aspx";
PageOfficeCtrl1.WebOpen(Server.MapPath("doc/") + fileName, PageOffice.OpenModeType.docAdmin, "张佚名");
}
protected void PageOfficeCtrl1_Load(object sender, EventArgs e)
{
string fileName = "OrderForm.xls";
//添加自定义菜单
PageOfficeCtrl1.AddCustomToolButton("打印", "Print", 6);
PageOfficeCtrl1.AddCustomToolButton("打印预览", "PrintPreView", 7);
PageOfficeCtrl1.AddCustomToolButton("页面设置", "SetPage", 3);
PageOfficeCtrl1.AddCustomMenuItem("|", "", true);
PageOfficeCtrl1.AddCustomToolButton("另存到本机", "StoreAs", 1);
PageOfficeCtrl1.AddCustomMenuItem("|", "", true);
PageOfficeCtrl1.AddCustomToolButton("全屏/还原", "SetScreen", 4);
PageOfficeCtrl1.ServerPage = "pageoffice/server.aspx";
PageOfficeCtrl1.WebOpen(Server.MapPath("doc/") + fileName, PageOffice.OpenModeType.xlsReadOnly, "admin");
}
protected void Page_Load(object sender, EventArgs e)
{
string strID = Request.QueryString["id"].ToString();
sID = strID;
//Create the command and the connection
string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|demo.mdb";
string sql = "select * from excel where ID=" + strID;
OleDbConnection conn = new OleDbConnection(connString);
OleDbCommand cmd = new OleDbCommand(sql, conn);
conn.Open();
cmd.CommandType = CommandType.Text;
OleDbDataReader Reader = cmd.ExecuteReader();
string docFile = "";
string docSubject = "";
if (Reader.Read())
{
docFile = Reader["FileName"].ToString();
docSubject = Reader["Subject"].ToString();
}
Reader.Close();
conn.Close();
PageOfficeCtrl1.ServerPage = "pageoffice/server.aspx";
PageOfficeCtrl1.SaveFilePage = "SaveFile.aspx";
PageOfficeCtrl1.CustomMenuCaption = "自定义菜单(&N)";
PageOfficeCtrl1.AddCustomMenuItem("显示标题(&T)", "CustomMenuItem1_Click()", true);
PageOfficeCtrl1.AddCustomMenuItem("-", "", false);
PageOfficeCtrl1.AddCustomMenuItem("领导圈阅(&D)", "CustomMenuItem2_Click()", true);
PageOfficeCtrl1.AddCustomToolButton("保存", "CustomToolBar_Save()", 1);
PageOfficeCtrl1.AddCustomToolButton("另存为...", "CustomToolBar_SaveAs()", 1);
PageOfficeCtrl1.AddCustomToolButton("另存为Html", "CustomToolBar_SaveAsHtml()", 1);
PageOfficeCtrl1.AddCustomToolButton("插入印章", "CustomToolBar_InsertSeal()", 2);
PageOfficeCtrl1.AddCustomToolButton("领导圈阅", "CustomToolBar_HandDraw()", 3);
PageOfficeCtrl1.AddCustomToolButton("全屏/还原", "CustomToolBar_FullScreen()", 4);
PageOfficeCtrl1.BorderStyle = PageOffice.BorderStyleType.BorderThin;
//Response.Write(Server.MapPath("doc/") + docFile);
PageOfficeCtrl1.WebOpen(Server.MapPath("doc/") + docFile, PageOffice.OpenModeType.xlsNormalEdit, "张佚名");
}
protected void Page_Load(object sender, EventArgs e)
{
DocID = Request.QueryString["ID"];
userName = Request.QueryString["user"].ToString();
strSql = "select * from word where ID = " + DocID;
DataSet ds = new DataSet();
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
OleDbDataAdapter command = new OleDbDataAdapter(strSql.ToString(), connection);
command.Fill(ds, "ds");
connection.Close();
}
DataTable dt = new DataTable();
dt = ds.Tables[0];
Literal_Subject.Text = dt.Rows[0]["Subject"].ToString();//文件名称
if ("李四批阅" == dt.Rows[0]["Status"].ToString() && "李四" == userName ||
"张三批阅" == dt.Rows[0]["Status"].ToString() && "张三" == userName)
{
Literal_Lc.Text = dt.Rows[0]["Status"].ToString();//当前文件的流程
if ("张三" == userName)
{
Literal_Lz.Text = "李四批阅";
}
if ("李四" == userName)
{
Literal_Lz.Text = "文员清稿";
}
}
else
{
Literal_Lc.Text = "已流转到“" + dt.Rows[0]["Status"].ToString() + "”，当前是“强制留痕模式”打开文件的效果。";
}
string fileName = dt.Rows[0]["FileName"].ToString();
string fileSubject = dt.Rows[0]["Subject"].ToString();
PageOfficeCtrl1.Caption = fileSubject;
PageOfficeCtrl1.CustomMenuCaption = "自定义菜单";
PageOfficeCtrl1.AddCustomMenuItem("显示痕迹", "ShowRevisions", false);
PageOfficeCtrl1.AddCustomMenuItem("隐藏痕迹", "HiddenRevisions", false);
PageOfficeCtrl1.AddCustomMenuItem("-", "", false);
PageOfficeCtrl1.AddCustomMenuItem("显示标题", "ShowTitle", true);
PageOfficeCtrl1.AddCustomMenuItem("-", "", false);
PageOfficeCtrl1.AddCustomMenuItem("领导圈阅", "StartHandDraw", true);
PageOfficeCtrl1.AddCustomMenuItem("插入印章", "InsertSeal", false);
PageOfficeCtrl1.AddCustomMenuItem("-", "", false);
PageOfficeCtrl1.AddCustomMenuItem("分层显示手写批注", "ShowHandDrawDispBar", true);
PageOfficeCtrl1.AddCustomToolButton("保存", "Save", 1);
PageOfficeCtrl1.AddCustomToolButton("显示痕迹", "ShowRevisions", 5);
PageOfficeCtrl1.AddCustomToolButton("隐藏痕迹", "HiddenRevisions", 5);
PageOfficeCtrl1.AddCustomToolButton("列举所有痕迹", "jsGetAllRevisions", 0);
PageOfficeCtrl1.AddCustomToolButton("领导圈阅", "StartHandDraw", 3);
PageOfficeCtrl1.AddCustomToolButton("插入键盘批注", "StartRemark", 3);
PageOfficeCtrl1.AddCustomToolButton("分层显示手写批注", "ShowHandDrawDispBar", 7);
PageOfficeCtrl1.AddCustomToolButton("全屏/还原", "IsFullScreen", 4);
PageOfficeCtrl1.ServerPage = "pageoffice/server.aspx";
PageOfficeCtrl1.SaveFilePage = "savedoc.aspx";
PageOfficeCtrl1.WebOpen(Server.MapPath("doc/") + fileName, PageOffice.OpenModeType.docRevisionOnly, userName);
}
