?? jcy_zb_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("B0500027") == 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>
<%
//response.setHeader("Pragma","No-cache");
//response.setHeader("Cache-Control","no-cache");
//response.setDateHeader("Expires",0);
String zbmc = std.getValue(request,"zbmc"); //組別名稱
String zbdm = std.getValue(request,"zbdm"); //組別編號
String dwdm = std.getValue(request,"dwdm"); //所屬區縣
String jl = "";
String xzbdm = "";
String blrq = "";
String qx = "";
String sql_dw = "select qx from jcy_dw where dwdm = '"+dwdm+"'";
sun.jdbc.rowset.CachedRowSet dw = std.getResultBySelect(sql_dw);
dw.next();
qx = dw.getString(1);
String sql_select = "select jcy_zb.zbdm,dp_sys.f_get_mc_by_dm('0001',jcy_dw.qx),jcy_zb.zbmc,jcy_zb.zbdm,to_char(jcy_zb.blrq,'yyyy.mm.dd') from jcy_zb ,jcy_dw where jcy_zb.DWDM=jcy_dw.DWDM and jcy_dw.dwdm = '"+dwdm+"'";
if (!zbmc.equals(""))
sql_select = sql_select + " and jcy_zb.zbmc like '%"+zbmc+"%'";
if (!zbdm.equals(""))
sql_select = sql_select + " and jcy_zb.zbdm like '%"+zbdm+"%'";
sql_select = sql_select + " order by jcy_zb.blrq desc ";
sun.jdbc.rowset.CachedRowSet crs = std.getResultBySelect(sql_select);
String panduan = "select count(*) from jcy_zb ,jcy_dw where jcy_zb.DWDM=jcy_dw.DWDM and jcy_dw.qx = '"+qx+"'";
if (!zbmc.equals(""))
panduan = panduan + " and jcy_zb.zbmc like '%"+zbmc+"%'";
if (!zbdm.equals(""))
panduan = panduan + " and jcy_zb.zbdm like '%"+zbdm+"%'";
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_zb_new_modify.jsp?zt=modify&ID="+G_id+"&dwdm="+'<%=dwdm%>',"_self");
}
}
function f_del()
{
if (<%=jl%> == 0)
{
alert("沒有記錄");
return false;
}
if (G_id == "" || G_id == null)
{
alert("請選擇需要刪除的組別信息！");
return false;
}
else
{
form.action = "jcy_zb_submit.jsp?zt=del&ID="+G_id;
form.submit();
}
}
function f_back()
{
window.open("jcy_zb_select.jsp?ID="+'<%=dwdm%>',"_self");
}
function f_imager(text,ixy)
{
if (ixy == '0')
{
alert(text);
window.open("jcy_zb_select.jsp?ID="+'<%=dwdm%>'+"&zt="+text,"_self");
}
else
{
alert(text);
}
}
</script>
<title>公務員管理</title>
<link rel="stylesheet" href="../style.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<script language="JavaScript" src="new.js"></script>
</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="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="17" align="left" background="../images/caozuo01.gif"> </td>
<td background="../images/caozuo02.gif" align="center" width="962"><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="100%" 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="form" method="post" action="" target="zbview">
<table align=center border=1 bordercolordark=#ffffff bordercolorlight=#666699
cellpadding=0 cellspacing=0 width=100% bgcolor="#000099">
<tr align="center" bgcolor="#174ca3">
<td width="4%" height="40"> </td>
<td width="19%" height="16"><font color="#FFFFFF">所屬區縣</font></td>
<td width="37%" height="16"><font color="#FFFFFF">組別名稱</font></td>
<td width="15%" height="16"><font color="#FFFFFF">組別編號</font></td>
<td width="25%" height="16"><font color="#FFFFFF">登記時間</font></td>
</tr>
<%while (crs.next()){
zbdm = crs.getString(1);
qx = crs.getString(2);
zbmc = crs.getString(3);
xzbdm = crs.getString(4);
blrq = crs.getString(5);
if (zbdm == null) zbdm = "000";
if (qx == null) qx = "101";
if (zbmc == null) zbmc = "無";
if (xzbdm == null) xzbdm = "00000";
if (blrq == null) blrq = "0000-00-00";
%>
<tr align="center" bgcolor="#FFFFFF">
<td height="25"> <input type="radio" name="radiobutton" value="<%=zbdm%>" onClick="f_radio(this.value)">
</td>
<td height="18"><font color="#105781"><%=qx%></font></td>
<td height="18"><font color="#105781"><%=zbmc%></font></td>
<td height="18"><font color="#105781"><%=xzbdm%></font></td>
<td height="18"><font color="#105781"><%=blrq%></font></td>
</tr>
<%}%>
</table>
<table width="70%" border="0">
<tr>
<td width="29%" height="63" align="center" valign="middle"><input type="button" class="input" name="Submit" value="修 改" onClick="f_modify()"></td>
<td width="44%" align="center" valign="middle"><input type="button" class="input" name="Submit2" value="刪 除" onClick="f_del()"></td>
<td width="27%" align="center" valign="middle"><input type="button" class="input" name="Submit22" value="返 回" onClick="f_back()"></td>
</tr>
</table>
</form></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"><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="zbview" width="1000" height="1000" style="display:none" ></iframe>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -