📄 transact_update.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.ijipin.tool.*" %>
<%@ page import="com.ijipin.database.*" %>
<%@ page import="com.ijipin.property.*" %>
<%@ include file="/userinfor.jsp" %>
<%@ include file="/share/page/page_request.jsp"%>
<%@ page import="com.ijipin.oa.document.*" %>
<%
////////////////////////////列表页面所必须有的公共变量
final String strSkin = "../../" + userInfor_session.getPFLJ(); //皮肤路径
final String strLevel = Draft.strLevel; //本页所在的层次
final String strLink = Draft.strLink_update; //本页的地址
final String strLink_action = "transact_control.jsp";
final String strLink_back = "transact_list.jsp";
int iModuleID= Draft.iModuleID;
//设置查询参数
String sTable = "";
String sField = "";
String sCondition = "";
int iSpace = Message.SPACE; //空格的宽度
String sWidth = Message.WIDTH; //第一个td的百分比宽度
//新建一个连接
DataConn dataConn = new DataConn();
Statement stmt = null;
ResultSet rs = null;
DataList dataList = null;
//是否可以写，如果为false，必须要取消所有的按牛
boolean canWrite = true;
if (strACTION.equals("VIEW")) {
canWrite = false;
}
ResultSet result=null;
String mHttpUrlName=request.getRequestURI();
String mScriptName=request.getServletPath();
String mServerName="OfficeServer.jsp";
String mClientName="iWebOffice2003.ocx#version=1,0,0,0";
String mServerUrl="http://"+strServer_session+":"+strPort_session + rootPath_session + "/oa/document/" + mServerName;
String mClientUrl="http://"+strServer_session+":"+strPort_session + rootPath_session + "/oa/document/" + mClientName;
String mBLID = Convert.toZeroStr(request.getParameter("BLID"));
String mWZID = Convert.toZeroStr(request.getParameter("WZID"));
//System.out.println("mWZID="+mWZID);
//System.out.println("ACTION="+strACTION);
String mTemplate = Convert.toSpaceStr(request.getParameter("TEMPLATE")); //模板recordid
String mRecordID = "";
String mFileType = ".doc";
String mEditType = "2";
String mUserName = userInfor_session.getYGXM() + "[" + userInfor_session.getBMMC() + "]";
String mFileName = "";
String mDescript = "";
// 0 显示 1 起草
if (strACTION.equals("VIEW")) {
mEditType = "0";
}
%>
<%
try {
stmt = dataConn.getConnection().createStatement();
dataList = new DataList(stmt);
////////取出来
if (!strACTION.equals("ADD")) {
rs = dataList.getResultSet("OA_FWWZ", "WZNR,WZDX,RECORDID", "WZID="+mWZID + "");
if (rs.next()) {
mRecordID = Convert.toSpaceStr(rs.getString("RECORDID"));
}
}
if (mRecordID.equals("")) {
//取得唯一值(mRecordID)
java.util.Date dt=new java.util.Date();
long lg=dt.getTime();
Long ld=new Long(lg);
//初始化值
mRecordID = ld.toString();
mFileName=mRecordID + mFileType;
mDescript = "";
} else { //已经存在就不用取模伴了
mTemplate = "";
}
String str_value = ""; //临时变量，放字段的值
String str_field = ""; //字段的名称
String str_type = ""; //字段类型
String key_field = ""; //关键字
String key_value = "0"; //关键字的值
int iFieldCount = 0; //字段数量
%>
<html>
<head>
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
<META HTTP-EQUIV="Expires" CONTENT="0">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=Message.COMPANY_NAME%></title>
<link href="<%=strSkin%>css.css" rel="stylesheet" type="text/css">
</head>
<script language=javascript>
function StatusMsg(mString){
StatusBar.innerText=mString;
}
function Load(){
try{
form.WebOffice.WebUrl="<%=mServerUrl%>";
form.WebOffice.RecordID="<%=mRecordID%>";
form.WebOffice.Template="<%=mTemplate%>";
form.WebOffice.FileName="<%=mFileName%>";
form.WebOffice.FileType="<%=mFileType%>";
form.WebOffice.EditType="<%=mEditType%>";
form.WebOffice.UserName="<%=mUserName%>";
form.WebOffice.WebOpen(); //打开该文档
StatusMsg(form.WebOffice.Status);
}catch(e){
}
}
function UnLoad(){
try{
if (!form.WebOffice.WebClose()){
StatusMsg(form.WebOffice.Status);
}else{
StatusMsg("关闭文档...");
}
}catch(e){}
}
//作用：保存文档
function SaveDocument(){
if (!form.WebOffice.WebSave()){
StatusMsg(form.WebOffice.Status);
return false;
}else{
StatusMsg(form.WebOffice.Status);
return true;
}
}
function ShowRevision(mObject){
var mFlag=mObject.value;
if (mFlag=="显示痕迹"){
mObject.value="隐藏痕迹";
form.WebOffice.WebShow(true);
StatusMsg("显示痕迹...");
}else{
mObject.value="显示痕迹";
form.WebOffice.WebShow(false);
StatusMsg("隐藏痕迹...");
}
}
</script>
</head>
<%@ include file="/share/property/update_property.jsp" %>
<% if (hasEditor) {%>
<script language = "vbscript">
sub LoadContent
window_onresize
dim surl
surl="http://<%=strServer_session%>:<%=strPort_session%><%=rootPath_session%>/share/editor/load.jsp?key=<%=key_value%>&module=<%=iModuleID%>"
tbContentElement.LoadURL(sURL)
end sub
</script>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="vbscript:LoadContent">
<% } else {%>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="javascript:Load();" onunload="javascript:UnLoad();">
<% } %>
<% iModuleID = 12;%>
<%@ include file="/share/page/bar_top.jsp"%>
<% iModuleID = 11;%>
<!-- 工具条上 2004-04-28 -->
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<form name="formBar1" method="post" action="<%=strLink_action%>">
<tr class="toptr2">
<td>
<table width="100%" border=0 cellpadding=3 cellspacing=1 >
<tr>
<% if (canWrite) {%>
<td width="5%"><input type="button" name="btn1" value="" class="buttonSend" onClick="javaScript:FunSend();"></td>
<td width="5%"><input type="button" name="btn2" value="否决" class="sbttn" onClick="javaScript:FunReject();"></td>
<td width="5%"><input type="button" name="btn3" value="办结" class="sbttn" onClick="javaScript:FunFinish();"></td>
<!-- <td width="5%"><input type="button" name="btn4" value="退回" class="sbttn" onClick="javaScript:FunUntread();"></td> -->
<td width="5%"><input type="button" name="btn5" value="" class="buttonSave" onClick="javaScript:FunSave();"></td>
<td width="5%"><input type="button" name="btn6" value="" class="buttonReset" onClick="javaScript:FunReset(form);"></td>
<% } %>
<td width="3%"><input type="button" name="btn3" value="" class="buttonBack" onClick="javaScript:FunBack(formPage);"></td>
<td width="87%"> </td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<!-- 数据区 2004-04-28 -->
<table border="0" cellspacing="0" cellpadding="0" width="100%" align="center">
<form name="form" method="post" action="<%=strLink_action%>" onsubmit="javaScript:return check_validate(this);" ENCTYPE="multipart/form-data">
<%@ include file="/share/page/page_hidden.jsp" %>
<!--隐藏的-->
<input type="hidden" name="RECORDID" value="<%=mRecordID%>">
<input type="hidden" name="ISSEND" value="0">
<input type="hidden" name="BLID" value="<%=mBLID%>">
<%
iterField = field.getList().iterator();
iFieldCount = 0;
while (iterField != null && iterField.hasNext()) {
fieldInfor = (FieldInfor)iterField.next();
if (fieldInfor.getZDGZ() != null) {
str_value = valueRule.getValue(fieldInfor.getZDGZ());
}
if (!value_str[iFieldCount].equals("")) {
str_value = value_str[iFieldCount];
}
if ( 2 == fieldInfor.getZDBJ()) {
if (5 != fieldInfor.getZDBJKJ()) {
%>
<input type="hidden" name="<%=fieldInfor.getZDMC()%>" value="<%=str_value%>">
<%
} else {
%>
<input type="hidden" name="<%=fieldInfor.getZDMC()%>">
<%
}
}
iFieldCount ++;
}
%>
<%
iFieldCount = 0;
iterField = field.getList().iterator();
while (iterField != null && iterField.hasNext()) {
fieldInfor = (FieldInfor)iterField.next();
if (fieldInfor.getZDGZ() != null) {
str_value = valueRule.getValue(fieldInfor.getZDGZ());
}
if (!value_str[iFieldCount].equals("")) {
str_value = value_str[iFieldCount];
}
iFieldCount ++;
//////列表
if ( 2 == fieldInfor.getZDBJ() || 3 == fieldInfor.getZDBJ()) {
continue;
}
%>
<tr>
<td width="<%=sWidth%>" align="right" valign="top"><%=fieldInfor.getZDSM()%></td><td width="<%=iSpace%>"> </td>
<td>
<%
if ( 0 == fieldInfor.getZDBJKJ()) {
%>
<input type="text" class="tex3" name="<%=fieldInfor.getZDMC()%>" value="<%=str_value%>" <%if(!canWrite) {%>readonly<%}%>
<% if (fieldInfor.getZDLX().equals("nvarchar")) {%> maxlength="<%=fieldInfor.getZDCD()%>" <%}%> >
<%
continue;
}
if ( 1 == fieldInfor.getZDBJKJ()) {
%>
<textarea rows="5" class="drpdwn2" name="<%=fieldInfor.getZDMC()%>" <%if(!canWrite) {%>readonly<%}%>><%=str_value%></textarea>
<%
continue;
}
//KEN 补充数据词典近来
if ( 2 == fieldInfor.getZDBJKJ() || 4 == fieldInfor.getZDBJKJ()) {
/////////找关联
selectTable = fieldInfor.getZDGLBM();
selectField = fieldInfor.getZDGLZD();
selectName = fieldInfor.getZDGLMC();
if (!canWrite) { ///不可以写，就要把唯一的一个显示出来
relateCond = selectField + "=" + str_value;
}
//数据词典
Iterator iterDataValue = null;
com.ijipin.dictionary.DataValueInfor dvInfor = null;
if (selectTable.trim().equals("")) {
int iCDID = fieldInfor.getZDSJCD();
com.ijipin.dictionary.DataValue dv = new com.ijipin.dictionary.DataValue(iCDID, dataConn);
iterDataValue = dv.getList("1=1").iterator();
rs = null;
}
else { //关联
rs = dataList.getResultSet(selectTable, selectField + "," + selectName, relateCond);
iterDataValue = null;
}
if (2 == fieldInfor.getZDBJKJ()) { ///////////下拉列表
%>
<select class="search" name="<%=fieldInfor.getZDMC()%>" <%if (!canWrite) {%>disabled<%}%> style="width:300">
<%
//////////////选择的放进iterList
while ( rs != null && rs.next()) {
selectValue = Convert.toUnicode(rs.getString(1));
%>
<option value="<%=selectValue%>" <%if (selectValue.equals(str_value)) {%>selected<%}%>><%=Convert.toUnicode(rs.getString(2))%></option>
<%
}
while (iterDataValue != null && iterDataValue.hasNext()) {
dvInfor = (com.ijipin.dictionary.DataValueInfor)iterDataValue.next();
selectValue = dvInfor.getJLMC(); //如果是下拉列表，使用数据词典时类型必须是nvarchar,取的是词典的名称
%>
<option value="<%=selectValue%>" <%if (selectValue.equals(str_value)) {%>selected<%}%>><%=dvInfor.getJLMC()%></option>
<%
}
%>
</select>
<%
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -