📄 jglist_o618.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%
//根据2002年06月15日，（星期天）与杨虎的讨论，机构显示的条件是：操作员
//所在机构一定显示，其他的只显示内设部门，和本级部门（非内设部门）
//本级部门,一级，二级，下级机构
/*************************************************************
*类型说明：手工信息录入主页面
*************************************************************/
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<%@page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<%
if((session.getValueNames()).length==0)
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/sysmang/loginagain.html';");
out.println("</SCRIPT>");
return;
}
java.lang.String sql="";
java.sql.ResultSet rs=null;
java.lang.String czyJgbm="";
java.lang.String dqJgbm="";
java.lang.String dqJgjb="";
java.lang.String czyJgjb="";
int iDqJgjb=0;
int iCzyJgjb=0;
java.lang.String sjJgbm="000";
java.lang.String isTop="1";
java.lang.String strJgbm="";
java.lang.String strJgmc="";
java.lang.String strJgjb="";
java.lang.String type="";
java.lang.String toTop="";
java.lang.String toDown="";
java.lang.String isFirst="";
java.lang.String resultTable="";
java.lang.String isHave="1";
try
{
isFirst=(( java.lang.String)request.getParameter("isFirst")).trim();
czyJgbm=((java.lang.String)request.getParameter("czyJgbm")).trim();
if(isFirst.equals("1"))//外部调用调用;
{
dqJgbm=czyJgbm;
isTop="1";
toTop="disabled";
//sql="SELECT JGBM,JGMC,JGJB,SJJGBM FROM JGZD WHERE ((JGBM='"+dqJgbm+"') AND ( substring(JGBZ,1,1) <> '1' ) AND (JGJB<30))";
sql="SELECT JGBM,JGMC,JGJB,SJJGBM FROM JGZD WHERE (JGBM='"+dqJgbm+"')";
}
else if(isFirst.equals("0"))
{//选择下属机构;
type=((java.lang.String)request.getParameter("type")).trim();
dqJgbm=((java.lang.String)request.getParameter("dqJgbm")).trim();
dqJgjb=((java.lang.String)request.getParameter("dqJgjb")).trim();
czyJgjb=((java.lang.String)request.getParameter("czyJgjb")).trim();
iDqJgjb=Integer.parseInt(dqJgjb);
iCzyJgjb=Integer.parseInt(czyJgjb);
if(type.equals("0"))
{//下级机构列表
//sql="SELECT JGBM,JGMC,JGJB,SJJGBM FROM JGZD WHERE ((SJJGBM='"+dqJgbm+"') AND ( substring(JGBZ,1,1) <> '1' ) AND (JGJB<30))";
//sql="SELECT JGBM,JGMC,JGJB,SJJGBM FROM JGZD WHERE ((SJJGBM='"+dqJgbm+"') AND ( substring(JGBZ,1,1) <> '0' ) AND (JGJB<30))";
sql="SELECT JGBM,JGMC,JGJB,SJJGBM FROM JGZD WHERE ((SJJGBM='"+dqJgbm+"') AND ( substring(JGBZ,1,1) <> '0' ))";
toTop="";
}
else if(type.equals("1"))
{//上级机构列表
sjJgbm=((java.lang.String)request.getParameter("sjJgbm")).trim();
if(iCzyJgjb-iDqJgjb>10)
{
//sql="SELECT JGBM,JGMC,JGJB,SJJGBM FROM JGZD WHERE ((SJJGBM=(SELECT SJJGBM FROM JGZD WHERE ((JGBM='"+sjJgbm+"') AND (JGJB<30)))) AND ( substring(JGBZ,1,1) <> '1' ) AND (JGJB<30))";
//sql="SELECT JGBM,JGMC,JGJB,SJJGBM FROM JGZD WHERE ((SJJGBM=(SELECT SJJGBM FROM JGZD WHERE ((JGBM='"+sjJgbm+"') AND (JGJB<30)))) AND ( substring(JGBZ,1,1) <> '0' ) AND (JGJB<30))";
sql="SELECT JGBM,JGMC,JGJB,SJJGBM FROM JGZD WHERE ((SJJGBM=(SELECT SJJGBM FROM JGZD WHERE ((JGBM='"+sjJgbm+"') AND (JGJB<30)))) AND ( substring(JGBZ,1,1) <> '0' ))";
}
else
{
//sql="SELECT JGBM,JGMC,JGJB,SJJGBM FROM JGZD WHERE ((JGBM='"+sjJgbm+"') AND ( substring(JGBZ,1,1) <> '1' ) AND (JGJB<30))";
sql="SELECT JGBM,JGMC,JGJB,SJJGBM FROM JGZD WHERE ((JGBM='"+sjJgbm+"'))";
}
}
else
{
java.sql.SQLException exception = new java.sql.SQLException("错误调用本模块本模块！");
throw exception;
}
//判断是否到了顶级
}
rs=DbBean.sqlQuery(sql);
if(isFirst.equals("1"))
{
if(rs.next())
{
strJgbm=(rs.getString("JGBM")).trim();
strJgmc=(rs.getString("JGMC")).trim();
strJgjb=(rs.getString("JGJB")).trim();
czyJgjb=strJgjb;
dqJgjb=strJgjb;
if(dqJgjb.equals("20")) toDown="disabled";
//resultTable="<TR><TD style='text-decoration : underline;cursor : pointer;' width='81' onclick=\"setSelect('"+strJgbm+"','"+strJgmc+"')\">"+strJgbm+"</TD><TD style='text-decoration : underline;cursor : pointer;' width='117' onclick=\"setSelect('"+strJgbm+"','"+strJgmc+"')\">"+strJgmc+"</TD><TD><INPUT type='button' name='jbdown' value='下级' onclick=\"doDown('"+strJgbm+"','"+strJgjb+"')\" "+toDown+"></TD></TR>";
resultTable="<TR><TD style='cursor : pointer;' onclick=\"setSelect('"+strJgbm+"','"+strJgmc+"')\">"+strJgbm+"</TD><TD style='cursor : pointer;' onclick=\"setSelect('"+strJgbm+"','"+strJgmc+"')\">"+strJgmc+"</TD><TD><INPUT type='button' name='jbdown' value='下级' onclick=\"doDown('"+strJgbm+"','"+strJgjb+"')\" "+toDown+"></TD></TR>";
rs.close();
rs=null;
}
else
{
rs.close();
rs=null;
java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系，您没有此项权限！");
throw exception;
}
}
else
{
isHave="0";
while(rs.next())
{
isHave="1";
strJgbm=(rs.getString("JGBM")).trim();
strJgmc=(rs.getString("JGMC")).trim();
strJgjb=(rs.getString("JGJB")).trim();
sjJgbm=(rs.getString("SJJGBM")).trim();
dqJgjb=strJgjb;
dqJgbm=strJgbm;
if(dqJgjb.equals("20")) toDown="disabled";
//resultTable+="<TR><TD style='text-decoration : underline;cursor : pointer;' width='81' onclick=\"setSelect('"+strJgbm+"','"+strJgmc+"')\">"+strJgbm+"</TD><TD style='text-decoration : underline;cursor : pointer;' width='117' onclick=\"setSelect('"+strJgbm+"','"+strJgmc+"')\">"+strJgmc+"</TD><TD><INPUT type='button' name='jbdown' value='下级' onclick=\"doDown('"+strJgbm+"','"+strJgjb+"')\" "+toDown+"></TD></TR>";
resultTable+="<TR><TD style='cursor : pointer;' onclick=\"setSelect('"+strJgbm+"','"+strJgmc+"')\">"+strJgbm+"</TD><TD style='cursor : pointer;' onclick=\"setSelect('"+strJgbm+"','"+strJgmc+"')\">"+strJgmc+"</TD><TD><INPUT type='button' name='jbdown' value='下级' onclick=\"doDown('"+strJgbm+"','"+strJgjb+"')\" "+toDown+"></TD></TR>";
}
rs.close();
rs=null;
}
if(isFirst.equals("0"))
{
//判断是否到了顶级;
if(dqJgbm.equals(czyJgbm)||dqJgjb.equals(czyJgjb))
{
isTop="1";//已经到了顶级;
toTop="disabled";
}
else
{
isTop="0";
toTop="";
}
}
%>
<HTML>
<HEAD>
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<META http-equiv="Content-Style-Type" content="text/css">
<TITLE>机构查询</TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<SCRIPT language="JavaScript">
function setSelect(strTbh,strTbhmc)
{
with(opener.document.czform)
{
NTBH.value = strTbh;
NTBHMC.value = strTbhmc;
}
window.close();
}
function doDown(dqJgbm,dqJgjb)
{
self.location="jglist.jsp?isFirst=0&czyJgbm=<%=czyJgbm%>&czyJgjb=<%=czyJgjb%>&type=0&dqJgbm="+dqJgbm+"&dqJgjb="+dqJgjb;
}
function doUp(dqJgbm,dqJgjb,sjJgbm)
{
self.location="jglist.jsp?isFirst=0&czyJgbm=<%=czyJgbm%>&czyJgjb=<%=czyJgjb%>&type=1&dqJgbm="+dqJgbm+"&dqJgjb="+dqJgjb+"&sjJgbm="+sjJgbm;
}
</SCRIPT>
</HEAD>
<BODY bgcolor="#FFFFFF" >
<%
if(isHave.equals("1"))
{
%>
<INPUT type="button" name="jbup" value="上级机构" onclick="doUp('<%=dqJgbm%>','<%=dqJgjb%>','<%=sjJgbm%>')" <%=toTop%>>
<br><br>
<TABLE border="1" width="504">
<TBODY >
<TR>
<TH width="81">机构编码</TH>
<TH width="153">机构名称</TH>
<TH width="81">机构级别跳转</TH>
</TR>
<%=resultTable%>
</TBODY>
</TABLE>
<%
}
else if(isHave.equals("0"))
{
%>
<br>
没有符合条件的机构，请点击返回按钮返回上一页面！
<br><br>
<CENTER>
<INPUT type="button" name="jbup" value="返回" onclick="history.back()">
</CENTER>
<br>
<%
}
%>
</BODY>
</HTML>
<%
System.gc();
} catch( Throwable e) {
DbBean.clear();
if(((e.getMessage())).equals("ResultSet is closed"))
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/blank.html';");
out.println("</SCRIPT>");
}
else if(e.getMessage()==null)
{
out.println("服务已经重启，您闲置的时间太长或系统调用错误，请重新登入试一下！<br>如果再出现这种情况请与系统维护员联系！");
}
else out.println(e.getMessage());
System.gc();
return;
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -