📄 jcy_pxxx_view.jsp
字号:
<%@ page contentType="text/html; charset=GBK" errorPage="" %>
<%@ import="com.vstsoft.std.vststd" %>
<%com.vstsoft.std.vststd std=new com.vstsoft.std.vststd();%>
<%@ errorPage="errorPage.jsp" %>
<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;
}
if (jcypurview.purviewVerdict("B0500035") == false)
{
%>
<Script Language=javascript>
alert("您没有操作此页权限！")
window.open("../index.jsp","_top")
</Script>
<% return;
} %>
<%
String nowuserid = jcypurview.getUserid(); //取当前用户编号
String nowusername = jcypurview.getUserName(); //取当前用户名称
String nowuserszqx = jcypurview.getUserSzqx(); //取当前用户所在区县
String nowuserszdw = jcypurview.getUserSzdw(); //取当前用户所在单位
%>
<html>
<head>
<title>公务员管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<link rel="stylesheet" href="../style.css" type="text/css">
<%
//response.setHeader("Pragma","No-cache");
//response.setHeader("Cache-Control","no-cache");
//response.setDateHeader("Expires",0);
String pxbm = std.getValue(request,"pxbm"); //公务员培训组织部门
String pxqr = std.getValue(request,"rq"); //公务员培训时间起
String pxzr = std.getValue(request,"rqr"); //公务员培训时间止
String pxqc = std.getValue(request,"pxqc"); //公务员培训班期次
String pxnd= std.getValue(request,"pxnd"); //公务员培训年度
String sfzh= std.getValue(request,"sfzh"); //公务员身份证号
String username = std.getValue(request,"username"); //公务员姓名
String qxdm = std.getValue(request,"qxdm"); //所属区县
String userid = ""; //公务员培训序号
String pxqk = ""; //培训情况
String jl = "";
String pxxxid = ""; //培训人员编号ID
String sid = std.getValue(request,"userid");
String sdwdm = std.getValue(request,"sdwdm");
String szbdm = std.getValue(request,"szbdm");
//String sql_select = "select jcy_pxxx.pxxxid, dp_sys.f_get_mc_by_dm('0001',jcy_ry.qx), jcy_ry.username,to_char(jcy_pxxx.pxqr,'yyyy.mm.dd'),to_char(jcy_pxxx.pxzr,'yyyy.mm.dd'),dp_sys.f_get_mc_by_dm('5001',jcy_pxxx.pxbm),jcy_pxxx.pxnd,jcy_pxxx.pxqc,jcy_pxxx.pxqk from jcy_pxxx,jcy_ry where jcy_pxxx.pxbm = '"+pxbm+"' and jcy_ry.qx= '"+qxdm+"' and jcy_pxxx.userid = jcy_ry.userid and jcy_pxxx.userid = '"+sid+"'";
String sql_select = "select jcy_pxxx.pxxxid, dp_sys.f_get_mc_by_dm('0001',jcy_ry.qx), jcy_ry.username,to_char(jcy_pxxx.pxqr,'yyyy.mm.dd'),to_char(jcy_pxxx.pxzr,'yyyy.mm.dd'),dp_sys.f_get_mc_by_dm('5001',jcy_pxxx.pxbm),jcy_pxxx.pxnd,jcy_pxxx.pxqc,jcy_pxxx.pxqk from jcy_pxxx,jcy_ry where jcy_pxxx.pxbm = '"+pxbm+"' and jcy_pxxx.userid = jcy_ry.userid and jcy_pxxx.userid = '"+sid+"'";
if (!pxqr.equals(""))
sql_select = sql_select + " and jcy_pxxx.pxqr >= to_date('"+pxqr+"', 'YYYY.MM.DD')";
if (!pxzr.equals(""))
sql_select = sql_select + " and jcy_pxxx.pxzr <= to_date('"+pxzr+"', 'YYYY.MM.DD')";
if (!pxnd.equals(""))
sql_select = sql_select + " and jcy_pxxx.pxnd like '%"+pxnd+"%'";
if (!pxqc.equals(""))
sql_select = sql_select + " and jcy_pxxx.pxqc = '"+pxqc+"'";
if (!sfzh.equals(""))
sql_select = sql_select + " and jcy_ry.sfzh like '%"+sfzh+"%'";
if (!username.equals(""))
sql_select = sql_select + " and jcy_ry.username like '%"+username+"%'";
sql_select = sql_select + " order by jcy_pxxx.pxqc";
sun.jdbc.rowset.CachedRowSet crs = std.getResultBySelect(sql_select);
String panduan = "select count(*) from jcy_pxxx,jcy_ry where jcy_pxxx.pxbm = '"+pxbm+"' and jcy_pxxx.userid = jcy_ry.userid and jcy_pxxx.userid = '"+sid+"'";
if (!pxqr.equals(""))
panduan = panduan + " and jcy_pxxx.pxqr >= to_date('"+pxqr+"', 'YYYY.MM.DD')";
if (!pxzr.equals(""))
panduan = panduan + " and jcy_pxxx.pxzr <= to_date('"+pxzr+"', 'YYYY.MM.DD')";
if (!pxnd.equals(""))
panduan = panduan + " and jcy_pxxx.pxnd like '%"+pxnd+"%'";
if (!pxqc.equals(""))
panduan = panduan + " and jcy_pxxx.pxqc = '"+pxqc+"'";
if (!sfzh.equals(""))
panduan = panduan + " and jcy_ry.sfzh like '%"+sfzh+"%'";
if (!username.equals(""))
panduan = panduan + " and jcy_ry.username like '%"+username+"%'";
sun.jdbc.rowset.CachedRowSet ii = std.getResultBySelect(panduan);
ii.next();
jl = ii.getString(1);
%>
<script language=javascript>
var G_id;
function f_radio(num)
{
G_id = num;
}
function f_modify()
{
if (<%=jl%> == 0)
{
alert("没有记录");
return false;
}
if (G_id == "" || G_id == null)
{
alert("请选择需要修改的培训人员信息！");
return false;
}
else
{
window.open("jcy_pxxx_new_modify.jsp?zt=modify&ID="+G_id+"&userid="+'<%=sid%>',"_self");
}
}
function f_del()
{
if (<%=jl%> == 0)
{
alert("没有记录");
return false;
}
if (G_id == "" || G_id == null)
{
alert("请选择需要删除的培训人员信息！");
return false;
}
else
{
form.action = "jcy_pxxx_submit.jsp?zt=del&ID="+G_id;
form.submit();
}
}
function f_imager(text,ixy)
{
if (ixy == '0')
{
alert(text);
window.open("jcy_pxxx_select.jsp?zt=todel&userid="+'<%=sid%>'+"&sdwdm="+'<%=sdwdm%>'+"&szbdm="+'<%=szbdm%>',"_self");
}
else
{
alert(text);
}
}
function f_back()
{
window.open("jcy_pxxx_select.jsp?zt=back&userid="+'<%=sid%>'+"&sdwdm="+'<%=sdwdm%>'+"&szbdm="+'<%=szbdm%>',"_self");
}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tr>
<td width="252">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="16" height="84" align="left" background="../images/caozuo01.gif"> </td>
<td background="../images/caozuo02.gif" align="center" width="944"><font size="5" color="#ff0000"><b><font color="#FF6633" size="3">公务员培训信息</font></b></font><font color="#FF9933" size="3"> </font></td>
<td width="18"><img src="../images/caozuo03.gif" width="15" height="84"></td>
</tr>
</table>
<table width="100%" height="242" border="0" cellpadding="0" cellspacing="0" bgcolor="#EEF9FF">
<tr>
<td width="15" height="242" background="../images/caozuo04.gif"><img src="../images/caozuo04.gif" width="15" height="6"></td>
<td width="782" align="center">
<table width="100%" height="154" border="0" align="center">
<tr>
<td width="764"> <form name="form" method="post" action="" target="pxxxview">
<br>
<table width="95%" bordercolorlight=#666699 bordercolordark=#ffffff border="1" cellspacing="0" cellpadding="0" align="center">
<tr align="center" bgcolor="#174ca3">
<td width="0" height="40"><font color="#FFFFFF"> </font></td>
<td width="0"><font color="#FFFFFF">所属区县</font></td>
<td width="0"><font color="#FFFFFF">姓名</font></td>
<td width="0"><font color="#FFFFFF">参加培训时间(起)</font></td>
<td width="0"><font color="#FFFFFF">参加培训时间(止)</font></td>
<td width="0"><font color="#FFFFFF">组织培训部门</font></td>
<td width="0"><font color="#FFFFFF">培训年份</font></td>
<td width="0"><font color="#FFFFFF">培训班期次</font></td>
<td width="0"><font color="#FFFFFF">培训情况</font></td>
</tr>
<%while (crs.next()){
pxxxid = crs.getString(1);
qxdm = crs.getString(2);
username = crs.getString(3);
pxqr = crs.getString(4);
pxzr = crs.getString(5);
pxbm = crs.getString(6);
pxnd = crs.getString(7);
pxqc = crs.getString(8);
pxqk = crs.getString(9);
if (pxxxid == null) pxxxid = "";
if (qxdm == null) qxdm = "无";
if (username == null) username = "无";
if (pxqr == null) pxqr = "0000-00-00";
if (pxzr == null) pxzr = "0000-00-00";
if (pxbm == null) pxbm = "无";
if (pxnd == null) pxnd = "0";
if (pxqc == null) pxqc = "0";
if (pxqk == null) pxqk = "无";
%>
<tr height='25' align='center'>
<td width="26" height="25"> <input type="radio" name="radiobutton" value="<%=pxxxid%>" onClick="f_radio(this.value)">
</td>
<td width="59"><font color="#105781"><%=qxdm%></font></td>
<td width="59"><font color="#105781"><%=username%></font></td>
<td><font color="#105781"><%=pxqr%></font></td>
<td><font color="#105781"><%=pxzr%></font></td>
<td><font color="#105781"><%=pxbm%></font></td>
<td><font color="#105781"><%=pxnd%></font></td>
<td><font color="#105781"><%=pxqc%></font></td>
<td width="123"><font color="#105781"><%=pxqk%></font></td>
</tr>
<%}%>
</table>
<br>
<table width="600" border="0" align="center" bordercolorlight=#666699 bordercolordark=#ffffff>
<tr>
<td width="108" height="23"> <div align="right"></div>
<div align="center"> </div></td>
<td width="111"> <input type="button" name="Submit52" value="修 改" class="input" onClick="f_modify()"></td>
<td width="138"> <div align="center">
<input type="button" name="Submit223" value="删 除" class="input" onClick="f_del()">
</div></td>
<td width="136"> <div align="center">
<input type="button" name="Submit2222" value="返 回" class="input" onClick="f_back()">
</div></td>
<td width="85"> </td>
</tr>
</table>
</form></td>
</tr>
</table>
<br>
</td>
<td width="14" background="../images/caozuo07.gif"><img src="../images/caozuo07.gif" width="14" height="6"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="21" height="16"><img src="../images/caozuo05.gif" width="21" height="16"></td>
<td width="935" background="../images/caozuo08.gif"><img src="../images/caozuo08.gif" width="6" height="16"></td>
<td width="22"><img src="../images/caozuo09.gif" width="19" height="16"></td>
</tr>
</table>
<br>
</td>
</tr>
</table>
</td>
<td width="59">
</td>
<br>
<td width="381"><p><br>
</p>
</td>
<div align="center"></div>
<tr>
<iframe name="pxxxview" width="100" height="100" style="display:none" ></iframe>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -