?? 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 + -