📄 jcy_ry_cx_view.jsp
字号:
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*,com.vstsoft.std.*" %>
<%@ page import = "sun.jdbc.rowset.*"%>
<%
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires", 0);
%>
<%session.setAttribute("jcy_link","jcy_ry_cx_view.jsp");%>
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />
<%
String currusercode = jcypurview.getUsercode(); //取当前用户usercode
String curruserid = jcypurview.getUserid(); //取当前用户编号
String currusername = jcypurview.getUserName(); //取当前用户名称
String curruserszqx = jcypurview.getUserSzqx(); //取当前用户所在区县
String curruserszdw = jcypurview.getUserSzdw(); //取当前用户所在单位
//检测用户是否登录
if (jcypurview.checkLogin() == false)
{
%>
<Script Language=javascript>
alert("用户已断线或未正常登录，请重新登录！")
window.open("../index.htm","_top")
</Script>
<%
return;}
%>
<%
//检测用户是否有操作权限
if (!(jcypurview.purviewVerdict("B0500001") || jcypurview.purviewVerdict("B0500002") || jcypurview.purviewVerdict("B0500003") || jcypurview.purviewVerdict("B0500009") || jcypurview.purviewVerdict("B0500010") || jcypurview.purviewVerdict("B0500035") || jcypurview.purviewVerdict("B0500036") || jcypurview.purviewVerdict("B0500037") || jcypurview.purviewVerdict("B0500038") || jcypurview.purviewVerdict("B0500043")))
{
%>
<Script Language=javascript>
alert("您没有操作此页权限！")
history.go(-1);
</Script>
<% return;
}
%>
<html>
<head>
<%vststd std = new vststd();%>
<title>公务员管理（查询结果）</title>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<link rel="stylesheet" href="../style.css" type="text/css">
<script language="JavaScript">
function f_err(err, zt)
{
if (err == "ok")
{
alert("上报成功！");
history.back();
return;
}
alert(err);
}
</script>
<jsp:useBean id="PageList" class="com.vstsoft.std.PageList" scope = "session" />
<%
String sqlStr = "";
String sql_select = "";
String key = std.getValue(request, "key");
String username = std.getValue(request,"name"); //姓名
String sfzh = std.getValue(request,"cardid"); //身份证号
String xb = std.getValue(request,"xb"); //性别(1 男 2 女)
String year = std.getValue(request,"year");
String month= std.getValue(request,"month");
String day = std.getValue(request,"day");
String csrq = year+"."+month+"."+day; //出生年月
String ssbz = std.getValue(request,"ssbz"); //所属编制(代码)
String whcd = std.getValue(request,"whcd"); //文化程度(代码)
String gzqr = std.getValue(request,"startdate"); //从事执法检查起时间
String qx = std.getValue(request,"qx"); //县区代码
String jddm = std.getValue(request,"jd"); //街道代码
String zjhm = std.getValue(request,"zjhm"); //公务证件号码
String ryzt = std.getValue(request,"ryzt"); //人员状态(注销，减少，正常，未上报，待审核，未通过)
String lrsj1= std.getValue(request,"lrsj1"); //录入时间1
String lrsj2= std.getValue(request,"lrsj2"); //录入时间2
sqlStr = (String)session.getAttribute("jcy_cx");
if (!sqlStr.equals("")){
sql_select = sqlStr;
ryzt = (String)session.getAttribute("jcy_ryzt");
}else {
sql_select = "select userid, dp_sys.F_Get_mc_by_dm('5009',ryzt), username, dp_sys.F_Get_mc_by_dm('0004',xb), dp_sys.F_Get_mc_by_dm('5003',ssbz), dp_sys.F_Get_mc_by_dm('5005',whcd), zjhm, dp_sys.F_Get_mc_by_dm('0001',qx), dp_sys.F_Get_mc_by_dm('0002',jddm), DP_SYS.TO_CHN_DATE(lrrq,'YMD'), ryzt, dwdm, zbdm from jcy_ry where 1=1";
if (!username.equals(""))
sql_select = sql_select + " and username like '%"+username+"%'";
if (!sfzh.equals(""))
sql_select = sql_select + " and sfzh like '%"+sfzh+"%'";
if (!xb.equals(""))
sql_select = sql_select + " and xb = '"+xb+"'";
if (year.length() == 4)
sql_select = sql_select + " and csrq = to_date('"+csrq+"', 'YYYY.MM.DD')";
if (!ssbz.equals(""))
sql_select = sql_select + " and ssbz = '"+ssbz+"'";
if (!whcd.equals(""))
sql_select = sql_select + " and whcd = '"+whcd+"'";
if (!gzqr.equals(""))
sql_select = sql_select + " and gzqr >= to_date('"+gzqr+"', 'YYYY.MM.DD')";
if (!zjhm.equals(""))
sql_select = sql_select + " and zjhm like '%"+zjhm+"%'";
if (!lrsj1.equals(""))
sql_select = sql_select + " and lrrq between to_date('"+lrsj1+"', 'YYYY.MM.DD') and to_date('"+lrsj2+"', 'YYYY.MM.DD')";
//如果当前用户为市处公务员，则可以查询到所有区县、街道的所有状态的公务员
if (curruserszqx.equals("001")){
if (!qx.equals(""))
sql_select = sql_select + " and qx = '"+qx+"'";
if (!jddm.equals(""))
sql_select = sql_select + " and jddm = '"+jddm+"'";
if (!ryzt.equals(""))
sql_select = sql_select + " and ryzt = '"+ryzt+"'";
}
//如果当前用户为区县公务员，则只能查询到本区的公务员（各区正常状态的公务员也可查询到）
if (!curruserszqx.equals("001")){
if (ryzt.equals("01") || ryzt.equals("02") || ryzt.equals("04") || ryzt.equals("05") || ryzt.equals("06")){
sql_select = sql_select + " and ryzt = '"+ryzt+"' and qx = '"+curruserszqx+"'";
if (!jddm.equals(""))
sql_select = sql_select + " and jddm = '"+jddm+"'";
}
else if (ryzt.equals("03")){
if (!qx.equals(""))
sql_select = sql_select + " and qx = '"+qx+"'";
if (!jddm.equals(""))
sql_select = sql_select + " and jddm = '"+jddm+"'";
sql_select = sql_select + " and ryzt = '03'";
}
else if (ryzt.equals("")){
sql_select = sql_select + " and qx = '"+curruserszqx+"'";
}
}
sql_select = sql_select + " and userid <> 'admin' order by lrrq desc";
session.setAttribute("jcy_cx",sql_select);
session.setAttribute("jcy_ryzt",ryzt);
}
// out.print(sql_select);
if (key.equals("query")){
PageList.setJndi("jc");
PageList.setPagenum(1);
PageList.setListnum(20);
PageList.setLink("jcy_ry_cx_view.jsp");
PageList.setTarget("mainFrame");
PageList.setSql(sql_select);
}else{
String pagen = std.getValue(request,"p");
int pagenum = Integer.parseInt(pagen);
PageList.setPagenum(pagenum);
}
sun.jdbc.rowset.CachedRowSet crs = new CachedRowSet();
crs = PageList.getRs();
crs.beforeFirst();
String suserid, sryztc, susername, sxb, sssbz, swhcd, szjhm, sqx, sjd, slrrq, sryzt, sdwdm, szbdm;
%>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"> <br>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="14" align="left" background="../images/caozuo01.gif"> </td>
<td background=".././images/caozuo02.gif" align="center" width="771"><b><font color="#FF6600" size="3">公务员管理（查询结果）</font></b></td>
<td width="15"><img src=".././images/caozuo03.gif" width="15" height="84"></td>
</tr>
</table>
<table width="800" border="0" cellspacing="0" cellpadding="0" bgcolor="#EEF9FF">
<tr>
<td width="15" background=".././images/caozuo04.gif"><img src=".././images/caozuo04.gif" width="15" height="6"></td>
<td align="center"> <font color="#CCCCCC"> </font>
<form name="form1" method="post" action="jcy_ry_submit.jsp" target="submitx">
<div id="submit">
<table align=center border="1" bordercolordark=#ffffff bordercolorlight=#666699
cellpadding=0 cellspacing=0 width="750">
<tr align="center" bgcolor="#EEF9FF">
<td width="25" height="40" bgcolor=#174ca3><font color="#FFFFFF">多选</font></td>
<td width="100" bgcolor=#174ca3><font color="#FFFFFF">姓名</font></td>
<td width="30" bgcolor=#174ca3><font color="#FFFFFF">性别</font></td>
<td width="60" bgcolor=#174ca3><font color="#FFFFFF">所属编制</font></td>
<td width="80" bgcolor=#174ca3><font color="#FFFFFF">文化程度</font></td>
<td width="130" bgcolor=#174ca3><font color="#FFFFFF">公务证件号码</font></td>
<td width="60" bgcolor=#174ca3><font color="#FFFFFF">所属区县</font></td>
<td width="120" bgcolor=#174ca3><font color="#FFFFFF">所在街道</font></td>
<td width="110" bgcolor=#174ca3><font color="#FFFFFF">录入时间</font></td>
<td width="40" bgcolor=#174ca3><font color="#FFFFFF">公务员状态</font></td>
</tr>
<%while (crs.next()){
suserid = crs.getString(1);
sryztc= crs.getString(2);
susername = crs.getString(3);
sxb = crs.getString(4);
sssbz = crs.getString(5);
swhcd = crs.getString(6);
szjhm = crs.getString(7);
sqx = crs.getString(8);
sjd = crs.getString(9);
slrrq = crs.getString(10);
sryzt = crs.getString(11);
sdwdm = crs.getString(12);
szbdm = crs.getString(13);
suserid = (suserid != null)?suserid:"";
sryztc = (sryztc != null)?sryztc:"";
susername = (susername != null)?susername:"";
sxb = (sxb != null)?sxb:"";
sssbz = (sssbz != null)?sssbz:"";
swhcd = (swhcd != null)?swhcd:"";
szjhm = (szjhm != null)?szjhm:"";
sqx = (sqx != null)?sqx:"";
sjd = (sjd != null)?sjd:"";
slrrq = (slrrq != null)?slrrq:"";
sryzt = (sryzt != null)?sryzt:"";
sdwdm = (sdwdm != null)?sdwdm:"";
szbdm = (szbdm != null)?szbdm:"";
%>
<tr align="center" bgcolor="#FFFFFF">
<td height="25" width="25">
<font size="-1"><input type="checkbox" name="checkbox_userid" value="<%=suserid%>"></font></td>
<td height="25" width="100">
<%if (sryzt.equals("02")) {%>
<font color="#CCCCCC">
<%} else {%>
<font color="#174ca3"><%}%>
<a href="jcy_ry_view.jsp?uid=<%=suserid%>&sdwdm=<%=sdwdm%>&szbdm=<%=szbdm%>">
<%=susername%>
</a></font></td>
<td height="25" width="30"><%if (!sryzt.equals("02")) {%><font color="#105781"><%} else {%><font color="#CCCCCC"><%}%><%=sxb%> </font></td>
<td height="25" width="50"><%if (!sryzt.equals("02")) {%><font color="#105781"><%} else {%><font color="#CCCCCC"><%}%><%=sssbz%> </font></td>
<td height="25" width="80"><%if (!sryzt.equals("02")) {%><font color="#105781"><%} else {%><font color="#CCCCCC"><%}%><%=swhcd%> </font></td>
<td height="25" width="150"><%if (!sryzt.equals("02")) {%><font color="#105781"><%} else {%><font color="#CCCCCC"><%}%><%=szjhm%> </font></td>
<td height="25" width="50"><%if (!sryzt.equals("02")) {%><font color="#105781"><%} else {%><font color="#CCCCCC"><%}%><%=sqx%> </font></td>
<td height="25" width="120"><%if (!sryzt.equals("02")) {%><font color="#105781"><%} else {%><font color="#CCCCCC"><%}%><%=sjd%> </font></td>
<td height="25" width="110"><%if (!sryzt.equals("02")) {%><font color="#105781"><%} else {%><font color="#CCCCCC"><%}%><%=slrrq%> </font></td>
<td height="25" width="50"><%if (!sryzt.equals("02")) {%><font color="#105781"><%} else {%><font color="#CCCCCC"><%}%><%=sryztc%> </font></td>
</tr>
<%}%>
</table>
<input type="hidden" name="dz" value="sb">
<input type="hidden" name="uid" value="">
<table align=center border=0 cellpadding=2 cellspacing=0 width="750" bgcolor="#FFF8CC">
<tbody>
<tr>
<td height=10 width=30> </td>
<td height=10 width=670> <%=PageList.getLink()%></td>
</tr>
</tbody>
</table>
<table width="750" border="0" cellspacing="0">
<tr>
<%if (ryzt.equals("04")){%>
<td height="40" align="center"> <input type="submit" name="button_sb" value="上 报" class="input">
</td>
<%}else {%>
<%}%>
<td><div align="center">
<input type="button" name="Submit72" value="返 回" class="input" onClick="window.location.href('jcy_ry_cx_select.jsp')">
</div></td>
</tr>
</table>
</div>
</form>
</td>
<td width="14" background="../images/caozuo07.gif"><img src=".././images/caozuo07.gif" width="14" height="6"></td>
</tr>
</table>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="21"><img src=".././images/caozuo05.gif" width="21" height="16"></td>
<td background=".././images/caozuo08.gif"><img src=".././images/caozuo08.gif" width="6" height="16"></td>
<td width="19"><img src=".././images/caozuo09.gif" width="19" height="16"></td>
</tr>
</table>
<br>
</td>
</tr>
</table>
<iframe name="submitx" width="1000" height="600" style="display:none"></iframe>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -