📄 yhzqx.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%
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 selectedYhz="";
int checknum=-1;
int i=0;//计数器
java.lang.String czydm="";
java.lang.String sql="";
java.lang.String czyssyhz="";
java.sql.ResultSet rs=null;
//支持十几级以内的动态菜单
java.sql.ResultSet result[]=new java.sql.ResultSet[3];
for(i=0;i<3;i++) result[i]=null;
i=0;//计数器复位，以备后用
java.lang.String temp1="全选";
java.lang.String temp2="取消";
temp1 = new String(temp1.getBytes("gb2312"));
temp2 = new String(temp2.getBytes("gb2312"));
java.lang.String resultmenu="";
java.lang.String[] cdxbm={"","",""};
java.lang.String[] cdxmc={"","",""};
java.lang.String[] sjdm ={"","",""};
java.lang.String isFirst="1";
java.lang.String oldYhzbm="";
isFirst=((java.lang.String)(request.getParameter("isFirst"))).trim();
if(isFirst.equals("0")) oldYhzbm=((java.lang.String)(request.getParameter("yhzbm"))).trim();
int zxgs=0;
int index1=0;
int index2=0;
int index3=1;
czydm=(( java.lang.String)session.getValue("czydm")).trim();
//查询出操作员所属的用户组
if(isFirst.equals("1"))
{
sql="SELECT DBO.CZYZD.YHZBM AS YHZBM FROM DBO.CZYZD WHERE DBO.CZYZD.CZYBM='"+czydm+"'";
rs=DbBean.sqlQuery(sql);
while(rs.next())
{
if(i==0)
czyssyhz=" (DBO.YHZQXB.YHZBM='"+rs.getString("YHZBM")+"' ";
else
czyssyhz+=" OR DBO.YHZQXB.YHZBM='"+rs.getString("YHZBM")+"' ";
i++;
selectedYhz=(rs.getString("YHZBM")).trim();
}
czyssyhz+=" ) ";
rs.close();//释放资源
rs=null;
if(i!=1)
{
java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系，您现在不属于任何用户组或属于多个用户组，所以您在本系统中没有任何权限！");
throw exception;
}
}
else if(isFirst.equals("0"))
{
czyssyhz=" (DBO.YHZQXB.YHZBM='"+oldYhzbm+"') ";
selectedYhz=oldYhzbm;
}
//return;
//下面动态生成菜单
i=0;//计数器复位，以备后用
sql="SELECT DBO.CDXZD.CDXBM AS CDXBM,DBO.CDXZD.CDXMC AS CDXMC,DBO.CDXZD.ZXGS AS ZXGS FROM DBO.CDXZD WHERE DBO.CDXZD.SJDM='000' AND DBO.CDXZD.CDXBM<>'000' ORDER BY CDXBM";
result[0]=DbBean.sqlQuery(sql);
while(result[0].next())
{
cdxbm[0]=((java.lang.String)(result[0].getString("CDXBM"))).trim();
cdxmc[0]=((java.lang.String)(result[0].getString("CDXMC"))).trim();
zxgs=result[0].getInt("ZXGS");
if(zxgs==0)
{ //如果是终节点，根据操作员的岗位和该功能项的代码从岗位功能表中检查是否有此权限
checknum++;
index1++;
sql="SELECT COUNT(*) AS NUM FROM DBO.YHZQXB WHERE ((DBO.YHZQXB.CDXBM='"+cdxbm[0]+"') AND ("+czyssyhz+"))";
rs=DbBean.sqlQuery(sql);
rs.next();
if(rs.getInt("NUM")>0)
{
resultmenu+="<TR><TD align='right'><input type='checkbox' name='cdxdmtext' value='"+cdxbm[0]+"' checked></TD>";
resultmenu+="<TD align='left'>"+cdxmc[0]+"</TD></TR>";
}
else
{
resultmenu+="<TR><TD align='right'><input type='checkbox' name='cdxdmtext' value='"+cdxbm[0]+"'></TD>";
resultmenu+="<TD align='left'>"+cdxmc[0]+"</TD></TR>";
}
rs.close();//释放资源
rs=null;
}
else
{//文件夹
resultmenu+="<TR><TD align='right'><input type='hidden' name='index1' value='"+index1+"'><input type='hidden' name='index2' value='"+checknum+"'><input type='radio' name='selsss"+index2+"' value='"+temp1+"' onclick='cliSelect("+index2+","+index3+")' style='background-color: #aac4ff;'>"+temp1+" <input type='radio' name='selsss"+index2+"' value='"+temp2+"' onclick='cliCancel("+index2+","+index3+")' style='background-color: #aac4ff;'>"+temp2+"<!--input type='checkbox' name='cdxdmtext' value='"+cdxbm[0]+"' disabled--></TD>";
resultmenu+="<TD align='left'>"+cdxmc[0]+"</TD></TR>";
i=1;
index2++;
index3++;
sql="SELECT DBO.CDXZD.CDXBM AS CDXBM,DBO.CDXZD.CDXMC AS CDXMC,DBO.CDXZD.ZXGS AS ZXGS FROM DBO.CDXZD WHERE DBO.CDXZD.SJDM='"+cdxbm[0]+"' ORDER BY CDXBM";
result[1]=DbBean.sqlQuery(sql);
while(result[1].next())
{
checknum++;
index1++;
cdxbm[1]=((java.lang.String)(result[1].getString("CDXBM"))).trim();
cdxmc[1]=((java.lang.String)(result[1].getString("CDXMC"))).trim();
zxgs=result[1].getInt("ZXGS");
if(zxgs==0)
{ //各个节点之间可能不同的地方class='***Item' or '***Folder';src='';href=;
//如果是终节点，根据操作员的岗位和该功能项的代码从岗位功能表中检查是否有此权限
sql="SELECT COUNT(*) AS NUM FROM DBO.YHZQXB WHERE ((DBO.YHZQXB.CDXBM='"+cdxbm[1]+"') AND ("+czyssyhz+"))";
rs=DbBean.sqlQuery(sql);
rs.next();
if(rs.getInt("NUM")>0)
{
resultmenu+="<TR><TD align='right'><input type='checkbox' name='cdxdmtext' value='"+cdxbm[1]+"' checked></TD>";
resultmenu+="<TD align='left'> "+cdxmc[1]+"</TD></TR>";
}
else
{
resultmenu+="<TR><TD align='right'><input type='checkbox' name='cdxdmtext' value='"+cdxbm[1]+"'></TD>";
resultmenu+="<TD align='left'> "+cdxmc[1]+"</TD></TR>";
}
rs.close();//释放资源
rs=null;
}
else
{ //文件夹
resultmenu+="<TR><TD align='right'><input type='checkbox' name='cdxdmtext' value='"+cdxbm[1]+"' disabled></TD>";
resultmenu+="<TD align='left'> "+cdxmc[1]+"</TD></TR>";
i=2;
sql="SELECT DBO.CDXZD.CDXBM AS CDXBM,DBO.CDXZD.CDXMC AS CDXMC,DBO.CDXZD.ZXGS AS ZXGS FROM DBO.CDXZD WHERE DBO.CDXZD.SJDM='"+cdxbm[1]+"' ORDER BY CDXBM";
result[2]=DbBean.sqlQuery(sql);
while(result[2].next())
{ //现在金支持到这一级菜单
//如果是终节点，根据操作员的岗位和该功能项的代码从岗位功能表中检查是否有此权限
checknum++;
index1++;
cdxbm[2]=((java.lang.String)(result[2].getString("CDXBM"))).trim();
cdxmc[2]=((java.lang.String)(result[2].getString("CDXMC"))).trim();
zxgs=result[2].getInt("ZXGS");
sql="SELECT COUNT(*) AS NUM FROM DBO.YHZQXB WHERE ((DBO.YHZQXB.CDXBM='"+cdxbm[2]+"') AND ("+czyssyhz+"))";
rs=DbBean.sqlQuery(sql);
rs.next();
if(rs.getInt("NUM")>0)
{
resultmenu+="<TR><TD align='right'><input type='checkbox' name='cdxdmtext' value='"+cdxbm[2]+"' checked></TD>";
resultmenu+="<TD align='left'> "+cdxmc[2]+"</TD></TR>";
}
else
{
resultmenu+="<TR><TD align='right'><input type='checkbox' name='cdxdmtext' value='"+cdxbm[2]+"'></TD>";
resultmenu+="<TD align='left'> "+cdxmc[2]+"</TD></TR>";
}
rs.close();//释放资源
rs=null;
}
result[2].close();//释放资源
result[2]=null;
}
}
result[1].close();//释放资源
result[1]=null;
}
}
result[0].close();//释放资源
result[0]=null;
%>
<HTML>
<HEAD>
<TITLE>
用户组权限维护
</TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<SCRIPT language="JavaScript">
var actionurl="";
var checknum=<%=checknum+1%>;
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);
if (ob[lId]) ob[lId].visibility = "show";
}
if (isIE)
{
w_str = "document.all.item(\"" + lId + "\").style";ob[lId] = eval(w_str);
ob[lId].visibility = "visible";
}
}
function HideObj(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);
if (ob[lId]) ob[lId].visibility = "hide";
}
if (isIE)
{
w_str = "document.all.item(\"" + lId + "\").style";ob[lId] = eval(w_str);
ob[lId].visibility = "hidden";
}
}
function btnClick(i)
{
czform.quebtn.disabled=false;
czform.chabtn.disabled=false;
czform.newbtn.disabled=false;
czform.delbtn.disabled=false;
czform.subbtn.disabled=true;
switch(i)
{
case 1:
czform.ACT.value='1';
czform.quebtn.disabled=true;
HideObj("Lxz");
ShowObj("Lcxgx");
break;
case 2:
czform.ACT.value='2';
czform.chabtn.disabled=true;
czform.subbtn.disabled=false;
HideObj("Lxz");
ShowObj("Lcxgx");
actionurl="yhzqx_save.jsp";
czform.action=actionurl;
break;
case 3:
czform.ACT.value='3';
czform.newbtn.disabled=true;
czform.subbtn.disabled=false;
HideObj("Lcxgx");
ShowObj("Lxz");
actionurl="yhzqx_save.jsp";
document.czform.yhzmc.focus();
czform.action=actionurl;
for(i=0;i<checknum;i++) document.czform.cdxdmtext[i].checked=false;
break;
case 4:
czform.ACT.value='4';
czform.delbtn.disabled=true;
czform.subbtn.disabled=false;
HideObj("Lxz");
ShowObj("Lcxgx");
actionurl="yhzqx_save.jsp";
czform.action=actionurl;
break;
}
}
function openpop()
{
window.open('search.jsp?yhzbm='+document.czform.yhzmclist.value,'PopupWindow','menubar=no,toolbar=no,location=no,directories=no,\
status=yes,resizable=yes,scrollbars=yes,width=40,height=40,top=11200,left=11200');
}
function checkque()
{
openpop();
}
function cliSelect(var1,var2)
{
for(var h=document.czform.index1[var1].value;h+1<=document.czform.index1[var2].value;h++)
document.czform.cdxdmtext[h].checked=true;
}
function cliCancel(var1,var2)
{
for(var h=document.czform.index1[var1].value;h<document.czform.index1[var2].value;h++)
document.czform.cdxdmtext[h].checked=false;
}
</SCRIPT>
</HEAD>
<BODY>
<FORM action="yhzqx_save.jsp" method="post" name="czform" >
<DIV style="width : 400px;height : 5px;top : 0px;left : 20px;
position : absolute;
z-index : 1;
visibility : visible;" id="Lcxffdsfgx">
<H2>用户组权限维护</H2>
<INPUT type="button" name="quebtn" value="查询" onclick="btnClick(1)" disabled>
<INPUT type="button" name="chabtn" value="修改" onclick="btnClick(2)">
<INPUT type="button" name="newbtn" value="新增" onclick="btnClick(3)">
<INPUT type="button" name="delbtn" value="删除" onclick="btnClick(4)">
<INPUT type="submit" name="subbtn" value="提交" disabled>
<INPUT type="button" name="bangzhu" value="帮助" onClick="window.open('/help/2.6/2.6.1.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');">
<INPUT TYPE='hidden' NAME='ACT' VALUE='1'><BR>
<BR>
</DIV>
<DIV style="width : 400px;height : 5px;top : 90px;left : 20px;
position : absolute;
z-index : 1;
visibility : visible;" id="Lcxgx">
用户组：<SELECT name="yhzmclist" onchange="checkque()"><%=DbBean.selOption("DBO.YHZZD","YHZBM","YHZMC",selectedYhz)%></SELECT>
</DIV>
<DIV style="width : 800px;height : 5px;top : 90px;left : 20px;
position : absolute;
z-index : 1;
visibility : hidden;" id="Lxz">
用户组名称：<INPUT size="15" type="text" name="yhzmc" maxlength="20"> 用户组编码：<INPUT size="6" type="text" name="yhzbm" maxlength="6"> 备注： <INPUT size="15" type="text" name="beizhu" maxlength="30">
</DIV>
<DIV style="top : 130px;left : 20px;
position : absolute;
z-index : 1;
visibility : visible;" id="LxDDDDz">
<TABLE border="0" width="550">
<TR>
<TH>选择项</TH>
<TH >菜单项名称</TH>
</TR>
<%=resultmenu%>
</TABLE>
</DIV>
<%="<input type='hidden' name='index1' value='"+index1+"'>"%>
</FORM>
</BODY>
</HTML>
<%
}
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());
return;
}
finally
{
System.gc();
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -