?? qx_tree.jsp
字號:
<%@page contentType="text/html;charset=GBK"%>
<%@ page import = "com.vstsoft.std.*" %>
<%@ page import = "java.sql.*" %>
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />
<% if (jcypurview.checkLogin() == false)
{
%>
<Script Language=javascript>
alert("用戶已斷線或未正常登錄，請重新登錄!")
window.open("../index.htm","_top")
</Script>
<% return;}
String Userid = "";
Userid = jcypurview.getUserid(); //取當前公務員編號
if (jcypurview.purviewVerdict("B0500006") == false)
{
%>
<Script Language=javascript>
alert("您沒有操作此頁權限!")
window.open("../index.jsp","_top")
</Script>
<% return; } %>
<%
vststd tra = new vststd("jc");
String squery = tra.getValue(request,"query");
String suid = "";
String sucode = "";
String suname = "";
String sdm = "";
String smc = "";
String sdwdm = "";
String sdwmc = "";
String szbdm = "";
String szbmc = "";
%>
<html>
<head>
<style>
BODY {
SCROLLBAR-FACE-COLOR: #FFE6D4;
SCROLLBAR-HIGHLIGHT-COLOR: white;
SCROLLBAR-SHADOW-COLOR: white;
SCROLLBAR-3DLIGHT-COLOR: white;
SCROLLBAR-ARROW-COLOR: white;
SCROLLBAR-TRACK-COLOR: #FFE6D4;
SCROLLBAR-DARKSHADOW-COLOR: #FFE6D4
}
</style>
<link rel="stylesheet" href="../style.css" type="text/css">
<title>權限管理</title>
<script language="JavaScript" src = "js/tree.js"></script>
</head>
<body bgcolor="#EEF9FF">
<table width="100%" height="23" border="0">
<tr>
<td width="13%" height="19">
<div align="left"></div></td>
<td width="87%">
<script>
foldersTree = gFld("<b><font color=#174ca3>權限管理</font></b>", "")
aux1 = insFld(foldersTree, gFld("<b><font color=#174ca3>人員管理</font></b>", ""))
<% sun.jdbc.rowset.CachedRowSet rs_qx = tra.getResultBySelect("select dm,mc from DM_MX where dmm = '0001' order by dm ");
while(rs_qx.next())
{
sdm = rs_qx.getString(1);
if (sdm == null) sdm = "";
smc = rs_qx.getString(2);
if (smc == null) smc = "";
%>
aux2 = insFld(aux1, gFld("<font size=2 color=#174ca3><a href='qx_ry_view.jsp?key=query&zt=qx&qxdm=<%=sdm%>&dwdm=null&zbdm=null' target='tabFrame'><%=smc%></a></font>", ""));
<%
sun.jdbc.rowset.CachedRowSet rs_dw = tra.getResultBySelect("select dwdm,dwmc from jcy_dw where qx = '" + sdm + "' order by dwmc");
while(rs_dw.next())
{
sdwdm = rs_dw.getString(1);
if (sdwdm == null) sdwdm = "";
sdwmc = rs_dw.getString(2);
if (sdwmc == null) sdwmc = "";
%>
aux3 = insFld(aux2, gFld("<font size=2 color=#174ca3><a href='qx_ry_view.jsp?key=query&zt=dw&qxdm=<%=sdm%>&dwdm=<%=sdwdm%>&zbdm=null' target='tabFrame'><%=sdwmc%></a></font>", ""));
<%
sun.jdbc.rowset.CachedRowSet rs_zb = tra.getResultBySelect("select zbdm,zbmc from jcy_zb where dwdm = '"+ rs_dw.getString(1) + "' order by zbmc");
while(rs_zb.next())
{
szbdm = rs_zb.getString(1);
if (szbdm == null) szbdm = "";
szbmc = rs_zb.getString(2);
if (szbmc == null) szbmc = "";
%>
aux4 = insFld(aux3, gFld("<font size=2 color=#174ca3><a href='qx_ry_view.jsp?key=query&zt=zb&qxdm=<%=sdm%>&dwdm=<%=sdwdm%>&zbdm=<%=szbdm%>' target='tabFrame'><%=szbmc%></a></font>", ""));
<%
}
}
}%>
aux1 = insFld(foldersTree, gFld("<b><font size=2 color=#174ca3><a href='qx_js_dtab.jsp?key=query' target='tabFrame'>角色管理</a></font></b>", ""));
<% sun.jdbc.rowset.CachedRowSet rs_group = tra.getResultBySelect("select id ,name from QX_GROUP where id <> 1 order by name");
while(rs_group.next())
{%>
insDoc(aux1, gLnk(2, "<font size=2 color=#174ca3><a href='qx_js_tab.jsp?ID=<%=rs_group.getString(1)%>' target='tabFrame'><%=rs_group.getString(2)%></a></font>", ""));
<%}%>
</script>
<script>
initializeDocument()
</script>
</td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -