📄 zddefinput.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<%! String sql,bbbm,bbmc,bbbz; ResultSet RS; int i,j,maxbbbm,num=1; %>
<%
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<META http-equiv="Content-Type" content="text/html; charset=GB2312">
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<META http-equiv="Content-Style-Type" content="text/css">
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<TITLE>固定报表定义</TITLE>
</HEAD>
<BODY onload="hideit()">
<P><BR></P>
<p align='center'><B><FONT size="+2" color="#ff0000">报表定义</FONT></B><BR>
<FORM method="GET" action="2201fenfa.jsp" name="form1">
<CENTER>
<TABLE align='center' border="0" width="602">
<TBODY>
<TR>
<TD align='center' height='20' colspan="3"><p align="left"> 选择已存在的报表并确认进行修改或按“增加”按钮定义新报表</TD>
</TR>
<TR>
<TD align='center' width='55' height='20'>序 号</TD>
<TD align='center' width='490' height='20'>报 表 名 称</TD>
<TD align='center' width='55' height='20'>选 择</TD>
</TR>
<%
sql = "SELECT * FROM DBO.BBZD";
RS = DbBean.sqlQuery(sql);
i = 1;
while( RS.next() )
{
bbbm = RS.getString("BBBM");
bbmc = RS.getString("BBMC").trim();
bbbz = RS.getString("BBBZ");
out.println(" <TR>");
out.println(" <TD align='center' width='55' height='20'>" + i + "</TD>");
out.println(" <TD align='left' width='490' height='20' onclick=\"Setbbbm(" + bbbm + ",'" + bbmc + "'," + bbbz + "," + i + ")\">" + bbmc + "</TD>");
out.println(" <TD align='center' width='55' height='20'><p align='center'><INPUT type='radio' name='R" + i + "' onclick=\"Setbbbm(" + bbbm + ",'" + bbmc + "'," + bbbz + "," + i + ")\"></p></TD>");
out.println(" </TR>");
i = i + 1;
}
RS.close();
%>
</TBODY>
</TABLE>
</CENTER>
<SCRIPT language="JavaScript">
var oldradio = 0;
function Setbbbm(bbbm,bbmc,bbbz,curradio)
{
if ( oldradio != 0 )
{
form1['R' + oldradio].checked = false;
}
form1['R' + curradio].checked = true;
oldradio = curradio;
form1.T_bbbm.value = bbbm;
form1.T_bbmc.value = bbmc;
form1.T_bbbz.value = bbbz;
form1.T_tjzl.value = "update";
document.all.input1.style.display = "none";
}
function PageSubmit()
{
form1.T_bbbz.value = form1.T_bbbz1.value + "" + form1.T_bbbz2.value;
document.form1.submit();
}
function Add()
{
input1.style.display = "inline";
form1.T_tjzl.value = "add";
form1.T_bbmc.value = "";
form1.T_bbmc.focus();
form1.T_bbbz1.value = "0";
form1.T_bbbz2.value = "0";
if ( oldradio != 0 )
{
form1['R' + oldradio].checked = false;
}
}
function hideit()
{
document.all.input1.style.display = "none";
form1.T_bbbz.value = "00";
aaa = 1 + <%=bbbm%>;
form1.T_bbbm.value = aaa;
}
</SCRIPT>
<BR>
<CENTER>
<div id=input1>
<TABLE border="0">
<TBODY>
<TR>
<TD align='center' width="78">报表名称:</TD>
<TD width="233"><INPUT size="36" type="text" name="T_bbmc"></TD>
<TD align='center' width="80">报表类型:</TD>
<TD width="165">
<SELECT name="S_bbbz1" onchange="form1.T_bbbz1.value = this.value;">
<OPTION value="0">省行</OPTION>
<OPTION value="1" selected>二级行</OPTION>
<OPTION value="2" selected>基层行</OPTION>
</SELECT> <SELECT name="S_bbbz2" onchange="form1.T_bbbz2.value = this.value;">
<OPTION value="0">列公式不同</OPTION>
<OPTION value="1" selected>列公式相同</OPTION>
<OPTION value="2" selected>两种都有</OPTION>
</SELECT>
</TD>
</TR>
</TBODY>
</TABLE>
</div>
</CENTER>
<INPUT size="3" type="hidden" name="T_bbbm">
<INPUT size="3" type="hidden" name="T_bbbz">
<INPUT size="3" type="hidden" name="T_bbbz1">
<INPUT size="3" type="hidden" name="T_bbbz2">
<INPUT size="3" type="hidden" name="T_addNo">
<INPUT size="3" type="hidden" name="T_tjzl">
<INPUT size="3" type="hidden" name="T_Butt">
<BR>
<CENTER>
<INPUT type="button" name="B_add" value="增加" onclick="Add()">
<INPUT type="button" name="B_submit" value="确认" onclick="PageSubmit()">
</CENTER>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -