📄 qx_ry_view.jsp
字号:
<%@page contentType="text/html;charset=GBK"%>
<%@ page import = "com.vstsoft.std.*" %>
<%@ page import = "java.sql.*" %>
<%@page import = "sun.jdbc.rowset.*"%>
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />
<jsp:useBean id="PageList" class="com.vstsoft.std.PageList" scope = "session" />
<%vststd std = new vststd();%>
<% if (jcypurview.checkLogin() == false)
{
%>
<Script Language=javascript>
alert("用户已断线或未正常登录，请重新登录!")
window.open("../index.htm","_top")
</Script>
<% return;}
if (jcypurview.purviewVerdict("B0500006") == false)
{
%>
<Script Language=javascript>
alert("您没有操作此页权限!")
window.open("../index.jsp","_top")
</Script>
<% return; } %>
<%
String key = std.getValue(request, "key");
String szt = std.getValue(request,"zt");
String sid = std.getValue(request,"qxdm");
String sdwdm = std.getValue(request,"dwdm");
String szbdm = std.getValue(request,"zbdm");
String lsql = "";
String sdm = "";
if (szt.equals("qx")){
lsql = "select userid,usercode,username,(select mc from DM_MX where dmm = '0001' and dm = jcy_ry.QX),(select dwmc from jcy_dw where dwdm = jcy_ry.dwdm),(select zbmc from jcy_zb where zbdm = jcy_ry.ZBDM) from jcy_ry where RYZT = '03' and qx = '"+sid+"' order by zbdm, lrrq desc";
sdm = sid;
}else if (szt.equals("dw")){
lsql = "select userid,usercode,username,(select mc from DM_MX where dmm = '0001' and dm = jcy_ry.QX),(select dwmc from jcy_dw where dwdm = jcy_ry.dwdm),(select zbmc from jcy_zb where zbdm = jcy_ry.ZBDM) from jcy_ry where RYZT = '03' and dwdm ='"+sdwdm+"' and qx = '"+sid+"' order by zbdm, lrrq desc";
sdm = sdwdm;
}else if (szt.equals("zb")){
lsql = "select userid,usercode,username,(select mc from DM_MX where dmm = '0001' and dm = jcy_ry.QX),(select dwmc from jcy_dw where dwdm = jcy_ry.dwdm),(select zbmc from jcy_zb where zbdm = jcy_ry.ZBDM) from jcy_ry where RYZT = '03' and ZBDM = '"+ szbdm + "'order by zbdm, lrrq desc";
sdm = szbdm;
}else if (szt.equals("query")){
String squery = std.getValue(request,"query");
lsql = "select userid,usercode,username,(select mc from DM_MX where dmm = '0001' and dm = jcy_ry.QX),(select dwmc from jcy_dw where dwdm = jcy_ry.dwdm),(select zbmc from jcy_zb where zbdm = jcy_ry.ZBDM) from jcy_ry where RYZT = '03' and (usercode like '%"+ squery +"%' or username like '%"+ squery +"%') order by zbdm, lrrq desc";
}
if (key.equals("query")){
PageList.setJndi("jc");
PageList.setPagenum(1);
PageList.setListnum(10);
PageList.setLink("qx_ry_view.jsp");
PageList.setTarget("tabFrame");
PageList.setSql(lsql);
}else{
String pagen = std.getValue(request,"p");
int pagenum = Integer.parseInt(pagen);
PageList.setPagenum(pagenum);
}
sun.jdbc.rowset.CachedRowSet ryview = new CachedRowSet();
ryview = PageList.getRs();
ryview.beforeFirst();
String suserid = "";
String susercode = "";
String susername = "";
String sqxmc = "";
String sdwmc = "";
String szbmc = "";
%>
<html>
<head>
<title>公务员权限管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<link rel="stylesheet" href="../style.css" type="text/css">
<script>
//function f_err(err,jcid,spd){
// alert(err);
// if (spd == "okdel"){
// location.reload();
// parent.leftFrame.location.reload();
// }
//}
</script>
</head>
<body bgcolor="#EEF9FF" text="#000000" leftmargin="0" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td width="1"> </td>
<td width="759" align="center">
<form name="form1" method="post" action="qx_rydx_tab.jsp?ZT=<%=szt%>&ID=<%=sdm%>">
<div id="submit">
<p><font color="#FF3300" size="3"><strong><br>
<br>
<br>
<br>
<font color="#FF6600">人 员 管 理</font></strong></font></p>
<table width=96% border="1" align=center cellpadding=0 cellspacing=0 bordercolorlight=#666699 bordercolordark=#ffffff >
<tr align="center" bgcolor="#EEF9FF">
<td width="15%" height="40" bgcolor=#174ca3><font color="#FFFFFF">用户名</font></td>
<td width="15%" height="40" bgcolor=#174ca3><font color="#FFFFFF">真实姓名</font></td>
<td width="15%" height="40" bgcolor=#174ca3><font color="#FFFFFF">所在区县</font></td>
<td width="30%" height="40" bgcolor=#174ca3><font color="#FFFFFF">所在单位</font></td>
<td width="20%" height="40" bgcolor=#174ca3><font color="#FFFFFF">所在组别</font></td>
</tr>
<%while (ryview.next()){
suserid = ryview.getString(1);
susercode = ryview.getString(2);
susername = ryview.getString(3);
sqxmc = ryview.getString(4);
sdwmc = ryview.getString(5);
szbmc = ryview.getString(6);
suserid = (suserid != null)?suserid:"";
susercode = (susercode != null)?susercode:"";
susername = (susername != null)?susername:"";
sqxmc = (sqxmc != null)?sqxmc:"";
szbmc = (szbmc != null)?szbmc:"";
sdwmc = (sdwmc != null)?sdwmc:"";
%>
<tr align="center" bgcolor="#FFFFFF">
<td height="25"><font color="#105781"><a href='qx_tab.jsp?ID=<%=suserid%>' target='tabFrame'><%=susercode%> </a></font></td>
<td height="25"><font color="#105781"><%=susername%> </font></td>
<td height="25"><font color="#105781"><%=sqxmc%> </font></td>
<td height="25"><font color="#105781"><%=sdwmc%> </font></td>
<td height="25"><font color="#105781"><%=szbmc%> </font></td>
<%}%>
</table>
<table width="96%" height="42" border="0" cellspacing="0">
<tr>
<td width="672" height="40" align="center">
<div align="left"><%=PageList.getLink()%><br>
</div></td>
<td width="82" align="center"><div align="right">
<input type="submit" name="fyjs" value="赋予角色" class="input">
</div></td>
</tr>
</table>
<div align="right"> </div>
</div>
</form>
</td>
<td width="10"> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -