?? jcy_ry_sp_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_sp_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("B0500004") == false || !curruserszqx.equals("001"))
{
%>
<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">
var G_id;
function f_radio(num)
{
G_id = num;
}
function f_check()
{
if (G_id == "" || G_id == null)
{
alert("請選擇要進行審批的人員！");
return false;
}
}
</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 qx_temp = std.getValue(request,"qx");
String qx = "";
if (qx_temp.length() >= 3)
qx = qx_temp.substring(0,3);
else qx = ""; //縣區代碼
String jddm = std.getValue(request,"jd"); //街道代碼
String ryzt = std.getValue(request,"ryzt"); //人員狀態(注銷，減少，正常，未上報，待審核，未通過)
String sbsj1= std.getValue(request,"sbsj1"); //錄入時間1
String sbsj2= std.getValue(request,"sbsj2"); //錄入時間2
sqlStr = (String)session.getAttribute("jcy_cx");
if (!sqlStr.equals("")){
sql_select = sqlStr;
ryzt = (String)session.getAttribute("jcy_ryzt");
sqlStr = "";
}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(sbsj,'YMD'), ryzt, dwdm, zbdm from jcy_ry where 1=1";
if (!username.equals(""))
sql_select = sql_select + " and username like '%"+username+"%'";
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 (ryzt.equals("05"))
sql_select = sql_select + " and sbsj between to_date('"+sbsj1+"', 'YYYY.MM.DD') and to_date('"+sbsj2+"', 'YYYY.MM.DD')";
sql_select = sql_select + " and userid <> 'admin' order by sbsj desc";
session.setAttribute("jcy_cx",sql_select);
session.setAttribute("jcy_ryzt",ryzt);
}
if (key.equals("query")){
PageList.setJndi("jc");
PageList.setPagenum(1);
PageList.setListnum(20);
PageList.setLink("jcy_ry_sp_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 sdwdm=null;
String szbdm=null;
String suserid, susername, sxb, sssbz, swhcd, szjhm, sqx, sjd, ssbsj, sryztc, sryzt;
%>
</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">
<form name="form1" method="post" action="jcy_ry_sp.jsp" onSubmit="return(f_check())">
<div id="submit">
<table align=center border=1 bordercolordark=#ffffff bordercolorlight=#666699
cellpadding=0 cellspacing=0 width="750" bgcolor="#000099">
<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="50" bgcolor=#174ca3><font color="#FFFFFF">所屬編制</font></td>
<td width="80" bgcolor=#174ca3><font color="#FFFFFF">文化程度</font></td>
<td width="150" bgcolor=#174ca3><font color="#FFFFFF">公務證件號碼</font></td>
<td width="50" 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" height="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);
ssbsj = 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:"";
ssbsj = (ssbsj != null)?ssbsj:"";
sryzt = (sryzt != null)?sryzt:"";
sdwdm = (sdwdm != null)?sdwdm:"";
szbdm = (szbdm != null)?szbdm:"";
%>
<tr align="center" bgcolor="#FFFFFF">
<td height="25" width="25"> <input type="radio" name="radio" value="<%=suserid%>" onClick="f_radio(this.value)">
</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%>">
<%=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"><%}%><%=ssbsj%> </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="ryzt" value="<%=ryzt%>">
<input type="hidden" name="sdwdm" value="<%=sdwdm%>">
<input type="hidden" name="szbdm" value="<%=szbdm%>">
<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="85%" border="0" cellspacing="0">
<tr>
<%if (ryzt.equals("05") || ryzt.equals("06")){%>
<td width="50%" height="40" align="center"> <input type="submit" name="button_sp" value="審 批" class="input">
</td>
<%}else {%>
<%}%>
</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>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -