📄 templateedit.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.io.*,java.text.*,java.util.*,java.sql.*,javax.servlet.*,javax.servlet.http.*,DBstep.iDBManager2000.*" %>
<%
ResultSet result=null;
String mDescript="";
String mFileName="";
String mHttpUrlName=request.getRequestURI();
String mScriptName=request.getServletPath();
String mServerName="OfficeServer.jsp";
String mClientName="WebEditor.ocx#version=4,4,0,0";
String mServerUrl="http://"+request.getServerName()+":"+request.getServerPort()+mHttpUrlName.substring(0,mHttpUrlName.lastIndexOf(mScriptName))+"/"+mServerName;
String mClientUrl="http://"+request.getServerName()+":"+request.getServerPort()+mHttpUrlName.substring(0,mHttpUrlName.lastIndexOf(mScriptName))+"/"+mClientName;
String mRecordID=request.getParameter("RecordID");
String mFileType=request.getParameter("FileType");
String mEditType="1";
String mUserName="Administrator";
//取得模式
if ( mEditType==null)
{
mEditType="2"; // 2 起草
}
//取得类型
if ( mFileType==null)
{
mFileType=".doc"; // 默认为.doc文档
}
//取得用户名
if (mUserName==null)
{
mUserName="帝龙科技";
}
//取得模板
if ( mRecordID==null)
{
mRecordID=""; // 默认没有模板
}
//打开数据库
DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000();
if (DbaObj.OpenConnection())
{
String mSql="Select * From Template_File Where RecordID='"+ mRecordID + "'";
try
{
result=DbaObj.ExecuteQuery(mSql);
if (result.next())
{
mRecordID=result.getString("RecordID");
mFileName=result.getString("FileName");
mFileType=result.getString("FileType");
mDescript=result.getString("Descript");
}
else
{
//取得唯一值(mRecordID)
java.util.Date dt=new java.util.Date();
long lg=dt.getTime();
Long ld=new Long(lg);
//初始化值
mRecordID=ld.toString();
mFileName="公文模版"+mFileType;
mFileType=mFileType;
mDescript="发文公文模版";
}
result.close();
}
catch(Exception e)
{
System.out.println(e.toString());
}
DbaObj.CloseConnection() ;
}
%>
<html>
<head>
<title>WebEditor</title>
<link rel='stylesheet' type='text/css' href='../test.css'>
<script language=javascript>
//系统变量
var vFileName=""; //打开的文件名
var vObject=null; //打开的对象
var gFileName=""; //文件名
var gObject=null; //对象
var gOpened=false; //是否被打开
var gUserName=""; //系统用户
</script>
<script language="JScript" for=WebOffice event="OnDocumentOpened(vFileName,vObject)">
OnDocumentOpened(vFileName,vObject); //打开文件事件
</script>
<script language="JScript" for=WebOffice event="OnDocumentClosed()">
OnDocumentClosed(); //关闭文件事件
</script>
<script language=javascript>
//打开文档，根据用户权限（EditType），进行初始化设置
function OnDocumentOpened(vFileName,vObject)
{
var mProtect,mTools,mTrack,mPrint,mShow;
gFileName=vFileName; //取得全局文件名
gObject=vObject; //取得全局对象
//设置痕迹和保护状态
if (webform.WebOffice.EditType=="0"){
mProtect=true;
mTools=false;
mTrack=false;
mPrint=false;
mShow=true;
}else if(webform.WebOffice.EditType=="1"){
mProtect=false;
mTools=false;
mTrack=false;
mPrint=false;
mShow=false;
}else if(webform.WebOffice.EditType=="2"){
mProtect=false;
mTools=false;
mTrack=true;
mPrint=true;
mShow=true;
}else if(webform.WebOffice.EditType=="3"){
mProtect=false;
mTools=true;
mTrack=true;
mPrint=true;
mShow=true;
}
if (webform.WebOffice.FileType==".doc"){
gObject.TrackRevisions=mTrack;
gObject.PrintRevisions=mPrint;
gObject.ShowRevisions=mShow;
if (mProtect){
gObject.Protect(2);
}
if (gUserName == "") {
//保存原来的用户
gUserName=gObject.Application.UserName;
//设置系统当前用户
gObject.Application.UserName=webform.WebOffice.UserName;
}
}
if (webform.WebOffice.FileType==".xls"){
if (mShow){
if (mTrack){
gObject.Application.DisplayCommentIndicator = 1;
}
}else{
gObject.Application.DisplayCommentIndicator = 0;
}
if (mProtect){
for (var mIndex=1;mIndex<=gObject.Application.ActiveWorkbook.Sheets.Count;mIndex++){
var mSheet=gObject.Application.ActiveWorkbook.Sheets(mIndex);
mSheet.Protect("", true, true, true);
}
}
if (gUserName == "") {
//保存原来的用户
gUserName=gObject.Application.UserName;
//设置系统当前用户
gObject.Application.UserName=webform.WebOffice.UserName;
}
}
//打开成功
gOpened = true;
}
function OnDocumentClosed()
{
//关闭成功
gOpened = false;
}
//显示系统状态信息
function StatusMsg(mString){
StatusBar.innerText=mString;
}
//页面装入事件
function Load(){
try{
webform.WebOffice.LoadTemplate();
if (webform.WebOffice.Error!=""){
//如果还没有成功，则根据扩展名创建新文档
if (webform.WebOffice.FileType==".doc"){
webform.WebOffice.CreateNew("Word.Document");
}else if(webform.WebOffice.FileType==".xls"){
webform.WebOffice.CreateNew("Excel.Sheet");
}else if(webform.WebOffice.FileType==".ppt"){
webform.WebOffice.CreateNew("PowerPoint.Show");
}else{
webform.WebOffice.CreateNew("");
}
}
}catch(e){
}
//显示状态信息
StatusMsg(webform.WebOffice.Status);
}
//页面退出事件
function UnLoad(){
try{
//关闭OCX控件
webform.WebOffice.Close();
}catch(e){}
}
//调入文档
function LoadDocument(){
StatusMsg("正在打开文档...");
webform.WebOffice.LoadTemplate();
StatusMsg(webform.WebOffice.Status);
}
//保存文档
function SaveDocument(){
//判断状态
if (webform.WebOffice.EditType=="0"){
alert("你在查看状态，不能保存!");
return false;
}
//保存文档
webform.WebOffice.SaveTemplate();
//如果没有错误
if (webform.WebOffice.Error!=""){
StatusMsg(webform.WebOffice.Status);
return false;
}else{
StatusMsg(webform.WebOffice.Status);
return true;
}
}
</script>
</head>
<body bgcolor="#ffffff" onload="Load()" onunload="UnLoad()"> <!--引导和退出iWebOffice-->
<form name="webform" method="post" action="TemplateSave.jsp" onsubmit="return SaveDocument();"> <!--保存iWebOffice后提交表单信息-->
<input type="hidden" name="RecordID" value="<%=mRecordID%>">
<table border=0 cellspacing='0' cellpadding='0' width=100% height=100% align=center class=TBStyle>
<tr>
<td align="right" class="TDTitleStyle" width=64>模版名</td>
<td class="TDStyle"><input type="text" name="FileName" value="<%=mFileName%>" class="IptStyle" ></td>
</tr>
<tr>
<td align=right class="TDTitleStyle" width=64>说明</td>
<td class="TDStyle"><input type="text" name="Descript" value="<%=mDescript%>" class="IptStyle" ></td>
</tr>
<tr>
<!--td align=right valign=top class="TDTitleStyle" width=64>内容</td-->
<td align=right valign=top class="TDTitleStyle" width=64 height=90% >
<input type=button value="打印文档" onclick="WebOpenPrint()">
<input type=button value="定义标签" onclick="WebOpenBookMarks()">
<input type=button value="填充模版" onclick="LoadBookmarks()">
<input type=button value="重调文档" onclick="LoadDocument()">
<input type=button value="打开文件" onclick="WebOpenLocal()">
<input type=button value="保存文件" onclick="WebSaveLocal()">
</td>
<td class="TDStyle" height=90%>
<table border=0 cellspacing='0' cellpadding='0' width='100%' height='100%' >
<tr>
<td bgcolor="menu">
<!--调用iWebOffice，注意版本号，可用于升级-->
<OBJECT id="WebOffice" width="100%" height="100%" classid="clsid:33739A7E-2004-4D1C-88D5-D50B18F7C347" codebase="<%=mClientUrl%>">
<param name="BorderStyle" value="1">
<param name="Menubar" value="1">
<param name="Toolbars" value="1">
<param name="Caption" value="20040520">
<param name="WebUrl" value="<%=mServerUrl%>">
<param name="RecordID" value="">
<param name="Template" value="<%=mRecordID%>">
<param name="FileName" value="<%=mFileName%>">
<param name="FileType" value="<%=mFileType%>">
<param name="EditType" value="<%=mEditType%>">
<param name="UserName" value="<%=mUserName%>">
</OBJECT>
</td>
</tr>
<tr>
<td bgcolor=menu height='20'>
<div id=StatusBar>状态栏</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
<input type=submit value=" 保存 ">
<input type=reset value=" 清除 ">
<input type=button value=" 返回 " onclick="history.back()"> 注意：只有选择《保存》后，所做的操作才有效！
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -