📄 jgzd.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%
/*************************************************************
*调用时需要参数isFirst=1:从菜单直接调用时为'1'，从页面中调用时为'0';
*************************************************************/
/*2002-04-09: -LFY-
1.把显示列表中的上级机构名称删除，增加上级机构编码列表;
2.增加机构回溯的功能(回到上级);
*************/
%>
<%
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;
}
try
{
java.lang.String sql="";
java.sql.ResultSet rs=null;
java.lang.String selectedJgbm="";
java.lang.String baseJgbm="";
java.lang.String isTop="";
int checknum=0;
int i=0;//计数器
int iorder=0; //显示列表的序号
java.lang.String czydm=(( java.lang.String)session.getValue("czydm")).trim();
java.lang.String isFirst=(( java.lang.String)request.getParameter("isFirst")).trim();
java.lang.String strJgbm="";
java.lang.String strJgmc="";
java.lang.String strJgjb="";
java.lang.String strSjjgbm=""; //上级机构编码；
java.lang.String strSjjgmc=""; //上级机构名称；
java.lang.String strZrzxbm="";
java.lang.String strJgbz=""; //机构标志；
java.lang.String selectedJgjb=""; //选择机构的机构级别;
java.lang.String resulttable="";
java.lang.String delResulttable="";
//把机构级别从代码转换为汉字；
//00：省行; 10：二级行; 21：县支行; 22：办事处; 31：分理处; 32：储蓄所
java.lang.String jgjbdm[]={"00", "10", "20", "30"}; //机构级别代码;
java.lang.String jgjbmc[]={"省行", "二级分行", "基层行", "基层机构"}; //机构级别名称；
//机构标志第二位：基层行机构类别
java.lang.String bzdmsecond[]={"0", "1"};
java.lang.String bzmcsecond[]={"县支行", "办事处"};
//机构标志第二位：基层营业机构类别
java.lang.String bzdmsecond2[]={"0", "1"};
java.lang.String bzmcsecond2[]={"储蓄所", "分理处"};
//机构标志第一位：0：非内设部门，1：内设部门
java.lang.String bzdmfirst[]={"0", "1", "2"};
java.lang.String bzmcfirst[]={"非内设部门", "内设部门", "本级"};
//查询出操作员所属的机构
sql="SELECT DBO.CZYZD.JGBM AS JGBM FROM DBO.CZYZD WHERE DBO.CZYZD.CZYBM='"+czydm+"'";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
i=1;
baseJgbm=(rs.getString("JGBM")).trim();
}
else
{
rs.close();
rs=null;
java.sql.SQLException exception = new java.sql.SQLException("您现在不属于任何机构或所属机构不唯一，请与系统维护员联系！");
throw exception;
}
rs.close();//释放资源
rs=null;
//得到机构列表的选择机构selectedJgbm;
if(isFirst.equals("1")) //从菜单直接调用;
{
selectedJgbm=baseJgbm;
}
else if(isFirst.equals("0")) //选择下属机构;
{
selectedJgbm=((java.lang.String)request.getParameter("jgbmlist")).trim();
}
else //isFirst=='2'：回到上级机构;
{
selectedJgbm=(( java.lang.String)request.getParameter("jgbmlist")).trim();
sql="SELECT DBO.JGZD.SJJGBM AS SJJGBM FROM DBO.JGZD WHERE DBO.JGZD.JGBM='"+selectedJgbm+"'";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
selectedJgbm=(rs.getString("SJJGBM")).trim();
}
else
{
java.sql.SQLException exception = new java.sql.SQLException("当前机构已经没有上级机构了！");
throw exception;
}
rs.close();//释放资源
rs=null;
}
//得到选择机构selectedJgbm的机构级别，为了增加机构时的选择而用；
sql="SELECT DBO.JGZD.JGJB AS JGJB FROM DBO.JGZD WHERE DBO.JGZD.JGBM='"+selectedJgbm+"'";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
selectedJgjb=(rs.getString("JGJB")).trim();
}
else
{
java.sql.SQLException exception = new java.sql.SQLException("当前机构已经没有上级机构了！");
throw exception;
}
//判断是否到了顶级;
if(baseJgbm.equals(selectedJgbm))
isTop="1"; //已经到了顶级;
else
isTop="0";
i=0;//计数器复位，以备后用
//下面查询出所选机构的所有下属机构信息
sql="SELECT DBO.JGZD.JGBM, DBO.JGZD.JGMC, DBO.JGZD.JGJB, DBO.JGZD.SJJGBM, DBO.JGZD.ZRZXBM, DBO.JGZD.JGBZ FROM DBO.JGZD WHERE DBO.JGZD.JGBM='"+selectedJgbm+"' OR DBO.JGZD.SJJGBM='" + selectedJgbm + "' ORDER BY JGBM";
rs=DbBean.sqlQuery(sql);
while(rs.next())
{
checknum++;
iorder++;
resulttable+="<TR>";
delResulttable+="<TR>";
strJgbm=((java.lang.String)(rs.getString("JGBM"))).trim();
strJgmc=((java.lang.String)(rs.getString("JGMC"))).trim();
strJgjb=((java.lang.String)(rs.getString("JGJB"))).trim();
strSjjgbm=((java.lang.String)(rs.getString("SJJGBM"))).trim();
strZrzxbm=((java.lang.String)(rs.getString("ZRZXBM"))).trim();
strJgbz=((java.lang.String)(rs.getString("JGBZ")));
//strJgbz=((java.lang.String)(rs.getString("JGBZ"))).trim();
//显示列表////////////////////////
resulttable+="<TD><INPUT size='3' type='text' name='OXH' value='"+ iorder +"' readonly></TD>";
resulttable+="<TD><INPUT size='9' type='text' name='OJGBM' value='"+strJgbm+"' readonly></TD>";
resulttable+="<TD><INPUT size='20' type='text' maxlength='50' name='OJGMC' value='"+strJgmc+"'></TD>";
resulttable+="<TD><INPUT size='8' type='text' maxlength='4' name='OZRZXBM' value='"+strZrzxbm+"'></TD>";
//机构级别名称，下拉框显示
resulttable+="<TD><SELECT name='OJGJB'>" + DbBean.selOptionS(jgjbdm, jgjbmc, strJgjb) +"</SELECT></TD>";
//机构类别转换
if(strJgjb.equals("20")) //基层行
{
resulttable+="<TD><SELECT name='OJGBZSECOND'>" + DbBean.selOptionS(bzdmsecond, bzmcsecond, strJgbz.substring(1,2)) + "</SELECT></TD>";
}
else if(strJgjb.equals("30")) //基层营业机构
{
resulttable+="<TD><SELECT name='OJGBZSECOND'>" + DbBean.selOptionS(bzdmsecond2, bzmcsecond2, strJgbz.substring(1,2)) + "</SELECT></TD>";
}
else //二级行 或 省行
{
resulttable+="<TD><INPUT size='1' type='hidden' name='OJGBZSECOND' value=''></TD>";
}
//机构属性
resulttable+="<TD><SELECT name='OJGBZFIRST'>" + DbBean.selOptionS(bzdmfirst, bzmcfirst, strJgbz.substring(0,1)) + "</SELECT></TD>";
resulttable+="<TD><INPUT size='9' type='text' maxlength='9' name='OSJJGBM' value='"+strSjjgbm + "'>";
//删除情况下的显示列表//////////////////
delResulttable+="<TD align='right'><INPUT type='checkbox' name='DJGBMCHECK' value='" + strJgbm + "'></TD>";
delResulttable+="<TD><INPUT size='3' type='text' name='DXH' value='"+ iorder +"' readonly></TD>";
delResulttable+="<TD><INPUT size='9' type='text' name='DJGBM' value='"+strJgbm+"' readonly></TD>";
delResulttable+="<TD><INPUT size='20' type='text' maxlength='50' name='DJGMC' value='"+strJgmc+"'></TD>";
delResulttable+="<TD><INPUT size='8' type='text' maxlength='4' name='DZRZXBM' value='"+strZrzxbm+"'></TD>";
//机构级别名称，下拉框显示
delResulttable+="<TD><SELECT name='DJGJB'>" + DbBean.selOptionS(jgjbdm, jgjbmc, strJgjb)+"</SELECT></TD>";
if(strJgjb.equals("20")) //基层行
{
delResulttable+="<TD><SELECT name='DJGBZSECOND'>" + DbBean.selOptionS(bzdmsecond, bzmcsecond, strJgbz.substring(1,2)) + "</SELECT></TD>";
}
else if(strJgjb.equals("30")) //基层营业机构
{
delResulttable+="<TD><SELECT name='OJGBZSECOND'>" + DbBean.selOptionS(bzdmsecond2, bzmcsecond2, strJgbz.substring(1,2)) + "</SELECT></TD>";
}
else //二级行 或 省行
{
delResulttable+="<TD><INPUT size='1' type='hidden' name='DJGBZSECOND' value=''></TD>";
}
//机构属性转换
delResulttable+="<TD><SELECT name='DJGBZFIRST'>" + DbBean.selOptionS(bzdmfirst, bzmcfirst, strJgbz.substring(0,1)) + "</SELECT></TD>";
delResulttable+="<TD><INPUT size='9' type='text' maxlength='9' name='DSJJGBM' value='" + strSjjgbm + "'>";
resulttable+="</TR>";
delResulttable+="</TR>";
}
if(checknum==0)
{
resulttable+="<TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>";
delResulttable+="<TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>";
}
rs.close();//释放资源
rs=null;
%>
<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<TITLE>
机构字典维护
</TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<SCRIPT language="JavaScript">
var jgjb='<%=selectedJgjb%>';
var actionurl="";
var checknum=<%=checknum%>;
function FindObj(doc, lId)
{
for (var i=0; i < doc.layers.length; i++)
{
var w_str = "doc.layers[i].document." + lId;
var obj;obj=new Array;
obj[lId] = eval(w_str);
if (!obj[lId]) obj[lId] = FindObj(doc.layers[i], lId);
if (obj[lId]) return obj[lId];
}
return null;
}
function ShowObj(lId)
{
var ob;ob=new Array;
var appVer=parseInt(navigator.appVersion);
var isNC=(document.layers && (appVer >= 4));
var isIE=(document.all && (appVer >= 4));
if (isNC)
{
w_str = "document." + lId;ob[lId] = eval(w_str);
if (!ob[lId]) ob[lId] = FindObj(document, lId);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -