?? jcy_ry_view.jsp
字號:
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*,com.vstsoft.std.*" %>
<%@ page import="javax.naming.*"%>
<%@ page import="javax.sql.DataSource"%>
<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("您沒有操作此頁權限！")
window.open("../index.jsp","_top")
</Script>
<% return;
}
%>
<html>
<head>
<%vststd std = new vststd();%>
<title>公務員詳細信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<script language="JavaScript1.2" src="new.js"></script>
<link rel="stylesheet" href="../style.css" type="text/css">
<%
String uid = request.getParameter("uid");
String sdwdm = std.getValue(request, "sdwdm");
String szbdm = std.getValue(request, "szbdm");
String sql_view = null;
if (sdwdm.equals("")){
sql_view = "select ry.username, ry.sfzh, dp_sys.F_Get_mc_by_dm('0004',ry.xb), ry.usercode, DP_SYS.TO_CHN_DATE(ry.csrq,'YMD'), dp_sys.F_Get_mc_by_dm('0006',ry.mz), dp_sys.F_Get_mc_by_dm('5005',ry.whcd), ry.sxzy, dp_sys.F_Get_mc_by_dm('5004',ry.zzmm), dp_sys.F_Get_mc_by_dm('0001',ry.qx), dp_sys.F_Get_mc_by_dm('0002',ry.jddm), dp_sys.F_Get_mc_by_dm('5007',ry.sfjd), '' dwmc , '' zbmc, dp_sys.F_Get_mc_by_dm('5003',ry.ssbz), dp_sys.F_Get_mc_by_dm('5006',ry.zjlb), dp_sys.F_Get_mc_by_dm('5002',ry.zw), ry.xphm, ry.zjhm, ry.fzjg, ry.gzbm, DP_SYS.TO_CHN_DATE(ry.gzqr,'YMD'), DP_SYS.TO_CHN_DATE(ry.gzzr,'YMD'), DP_SYS.TO_CHN_DATE(ry.zxrq,'YMD'), dp_sys.F_Get_mc_by_dm('5008',ry.zxyy), ry.ryzt, ry.qx, to_char(ry.gzzr, 'yyyymmdd') from jcy_ry ry where userid = '"+uid+"'";
}
else if (szbdm.equals("")){
sql_view = "select ry.username, ry.sfzh, dp_sys.F_Get_mc_by_dm('0004',ry.xb), ry.usercode, DP_SYS.TO_CHN_DATE(ry.csrq,'YMD'), dp_sys.F_Get_mc_by_dm('0006',ry.mz), dp_sys.F_Get_mc_by_dm('5005',ry.whcd), ry.sxzy, dp_sys.F_Get_mc_by_dm('5004',ry.zzmm), dp_sys.F_Get_mc_by_dm('0001',ry.qx), dp_sys.F_Get_mc_by_dm('0002',ry.jddm), dp_sys.F_Get_mc_by_dm('5007',ry.sfjd), dw.dwmc, '', dp_sys.F_Get_mc_by_dm('5003',ry.ssbz), dp_sys.F_Get_mc_by_dm('5006',ry.zjlb), dp_sys.F_Get_mc_by_dm('5002',ry.zw), ry.xphm, ry.zjhm, ry.fzjg, ry.gzbm, DP_SYS.TO_CHN_DATE(ry.gzqr,'YMD'), DP_SYS.TO_CHN_DATE(ry.gzzr,'YMD'), DP_SYS.TO_CHN_DATE(ry.zxrq,'YMD'), dp_sys.F_Get_mc_by_dm('5008',ry.zxyy), ry.ryzt, ry.qx, to_char(ry.gzzr, 'yyyymmdd') from jcy_ry ry, jcy_dw dw where userid = '"+uid+"' and ry.dwdm = dw.dwdm";
}
else{
sql_view = "select ry.username, ry.sfzh, dp_sys.F_Get_mc_by_dm('0004',ry.xb), ry.usercode, DP_SYS.TO_CHN_DATE(ry.csrq,'YMD'), dp_sys.F_Get_mc_by_dm('0006',ry.mz), dp_sys.F_Get_mc_by_dm('5005',ry.whcd), ry.sxzy, dp_sys.F_Get_mc_by_dm('5004',ry.zzmm), dp_sys.F_Get_mc_by_dm('0001',ry.qx), dp_sys.F_Get_mc_by_dm('0002',ry.jddm), dp_sys.F_Get_mc_by_dm('5007',ry.sfjd), dw.dwmc, zb.zbmc, dp_sys.F_Get_mc_by_dm('5003',ry.ssbz), dp_sys.F_Get_mc_by_dm('5006',ry.zjlb), dp_sys.F_Get_mc_by_dm('5002',ry.zw), ry.xphm, ry.zjhm, ry.fzjg, ry.gzbm, DP_SYS.TO_CHN_DATE(ry.gzqr,'YMD'), DP_SYS.TO_CHN_DATE(ry.gzzr,'YMD'), DP_SYS.TO_CHN_DATE(ry.zxrq,'YMD'), dp_sys.F_Get_mc_by_dm('5008',ry.zxyy), ry.ryzt, ry.qx, to_char(ry.gzzr, 'yyyymmdd') from jcy_ry ry, jcy_dw dw, jcy_zb zb where userid = '"+uid+"' and ry.dwdm = dw.dwdm and ry.zbdm = zb.zbdm";
}
sun.jdbc.rowset.CachedRowSet crs = std.getResultBySelect(sql_view);
crs.next();
String username = crs.getString(1);
String sfzh = crs.getString(2);
String xb = crs.getString(3);
String usercode = crs.getString(4);
String csrq = crs.getString(5);
String year = csrq.substring(0,4);
String month= csrq.substring(5,7);
String day = csrq.substring(8);
String mz = crs.getString(6);
String whcd = crs.getString(7);
String sxzy = crs.getString(8);
String zzmm = crs.getString(9);
String qx = crs.getString(10);
String jd = crs.getString(11);
String sfjx = crs.getString(12);
String gzdw = crs.getString(13);
String sszb = crs.getString(14);
String ssbz = crs.getString(15);
String zjlb = crs.getString(16);
String zw = crs.getString(17);
String xphm = crs.getString(18);
String zjhm = crs.getString(19);
String fzjg = crs.getString(20);
String gzbm = crs.getString(21);
String gzqr = crs.getString(22);
String gzzr = crs.getString(23);
String zxrq = crs.getString(24);
String zxyy = crs.getString(25);
String ryzt = crs.getString(26);
String qxdm = crs.getString(27);
String yxrq = crs.getString(28);
username = (username != null)?username:"";
sfzh = (sfzh != null)?sfzh:"";
xb = (xb != null)?xb:"";
usercode = (usercode != null)?usercode:"";
csrq = (csrq != null)?csrq:"";
mz = (mz != null)?mz:"";
whcd = (whcd != null)?whcd:"";
sxzy = (sxzy != null)?sxzy:"";
zzmm = (zzmm != null)?zzmm:"";
qx = (!qx.equals(""))?qx:"市處";
jd = (jd != null)?jd:"";
sfjx = (sfjx != null)?sfjx:"";
gzdw = (gzdw != null)?gzdw:"";
sszb = (sszb != null)?sszb:"";
ssbz = (ssbz != null)?ssbz:"";
zjlb = (zjlb != null)?zjlb:"";
zw = (zw != null)?zw:"";
xphm = (xphm != null)?xphm:"";
zjhm = (zjhm != null)?zjhm:"";
fzjg = (fzjg != null)?fzjg:"";
gzbm = (gzbm != null)?gzbm:"";
gzqr = (gzqr != null)?gzqr:"";
gzzr = (gzzr != null)?gzzr:"";
zxrq = (zxrq != null)?zxrq:"";
zxyy = (zxyy != null)?zxyy:"";
%>
</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="" target="submitx">
<table width="750" cellspacing="1" cellpadding="0" bgcolor="#000099">
<tr>
<td>
<table align=center bordercolordark=#ffffff bordercolorlight=#666699
cellpadding=0 cellspacing=1 width=100% bgcolor="#000099">
<tr align="center" bgcolor="#EEF9FF">
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -