?? jcy_dw_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("B0500007") == 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">
<jsp:useBean id="PageList" class="com.vstsoft.std.PageList" scope = "session" />
<%
//response.setHeader("Pragma","No-cache");
//response.setHeader("Cache-Control","no-cache");
//response.setDateHeader("Expires",0);
String csqx = std.getValue(request,"csqx"); //所屬區縣
String dwzt = std.getValue(request,"dwzt"); //單位狀態
String key = std.getValue(request,"key");
String dwdm = "";
String dwmc = "";
String ssqx = "";
String szdz = "";
String lxdh = "";
String jl = "";
String sql_select = "";
String panduan = "";
String dwzt1="";
if(dwzt.equals("03"))
{
dwzt1="and (yxbz = '02' or yxbz='01') ";
}else{
dwzt1="and yxbz = '"+dwzt+"'";
}
if (csqx.equals("")){
sql_select = "select dwdm,dwmc,dm_mx.mc,szdz,lxdh,yxbz from jcy_dw,dm_mx where dm_mx.dmm = '0001'and dm_mx.dm= jcy_dw.QX "+dwzt1+" order by qx";
panduan = "select count(*) from jcy_dw,dm_mx where dm_mx.dmm ='0001' and dm_mx.dm= jcy_dw.QX "+dwzt1+" ";
}
else {
sql_select = "select dwdm,dwmc,dm_mx.mc,szdz,lxdh,yxbz from jcy_dw,dm_mx where dm_mx.dmm = '0001'and dm_mx.dm= jcy_dw.QX and dm_mx.dm = '"+csqx+"' "+dwzt1+" order by qx";
panduan = "select count(*) from jcy_dw,dm_mx where dm_mx.dmm ='0001' and dm_mx.dm= jcy_dw.QX and dm_mx.dm = '"+csqx+"' "+dwzt1+" ";
}
//out.print(sql_select+","+panduan);
if (key.equals("query")){
PageList.setJndi("jc");
PageList.setPagenum(1);
PageList.setListnum(20);
PageList.setLink("jcy_dw_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 sun.jdbc.rowset.CachedRowSet();
crs = PageList.getRs();
crs.beforeFirst();
/*
sun.jdbc.rowset.CachedRowSet ii = std.getResultBySelect(panduan);
ii.next();
jl = ii.getString(1);
*/
%>
<script>
var G_id;
function f_radio(num)
{
G_id = num;
}
function f_modify()
{
if (G_id == "" || G_id == null)
{
alert("請選擇需要修改的單位！");
return false;
}
else
{
window.open("jcy_dw_new_modify.jsp?zt=modify&ID="+G_id+"&csqx="+'<%=csqx%>'+"&dwzt="+'<%=dwzt%>',"_self");
}
}
function f_del()
{
if (G_id == "" || G_id == null)
{
alert("請選擇需要減少的單位！");
return false;
}
else
{
form.action ="jcy_dw_submit.jsp?zt=del&ID="+G_id;
form.submit();
}
}
function f_ret()
{
if (G_id == "" || G_id == null)
{
alert("請選擇需要恢復的單位！");
return false;
}
else
{
form.action = "jcy_dw_submit.jsp?zt=ret&ID="+G_id;
form.submit();
}
}
function f_jc()
{
if (G_id == "" || G_id == null)
{
alert("請選擇需要修改獎懲情況的單位！");
return false;
}
else
{
window.open("jcy_dwjc_view_jl.jsp?zt=jc&ID="+G_id,"_self");
}
}
function f_back()
{
window.open("jcy_dw_select.jsp","_self");
}
function zb_new()
{
if (G_id == "" || G_id == null)
{
alert("請選擇需要修改組別管理的單位！");
return false;
}
else
{
window.open("jcy_zb_select.jsp?zt=zb&ID="+G_id,"_self");
}
}
function f_imager(text,ixy)
{
if (ixy == '0')
{
alert(text);
window.open("jcy_dw_select.jsp?zt="+text,"_self");
}
else
{
alert(text);
}
}
function f_back()
{
window.open("jcy_dw_select.jsp","_self");
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<link rel="stylesheet" href="../style.css" type="text/css">
</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="946"><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="dwview">
<table align=center border=1 bordercolordark=#ffffff bordercolorlight=#666699
cellpadding=0 cellspacing=0 width=95%>
<tr align="center" bgcolor="#174ca3">
<td width="59" height="40"> </td>
<td width="177" height="16"> <div align="center"><font color="#FFFFFF">單位名稱</font></div></td>
<td width="139" height="16"> <div align="center"><font color="#FFFFFF">所屬區縣</font></div></td>
<td width="179" height="16"> <div align="center"><font color="#FFFFFF">所在地址</font></div></td>
<td width="179" height="16"> <div align="center"><font color="#FFFFFF">聯系電話</font></div></td>
</tr>
<%while (crs.next()){
dwdm = crs.getString(1);
dwmc = crs.getString(2);
ssqx = crs.getString(3);
szdz = crs.getString(4);
lxdh = crs.getString(5);
dwzt = crs.getString(6);
if (dwdm == null) dwdm = "";
if (dwmc == null) dwmc = "";
if (ssqx == null) ssqx = "";
if (szdz == null) szdz = "";
if (lxdh == null) lxdh = "";
%>
<tr align="center" bgcolor="#FFFFFF">
<td height="25" width="59"> <input id = "aa" type="radio" name="radiobutton" value="<%=dwdm%>" onClick="f_radio(this.value)">
</td>
<td height="18" width="177"><font color="#105781"><%=dwmc%> </font></td>
<td height="18" width="139"><font color="#105781"><%=ssqx%> </font></td>
<td height="18" width="179"><font color="#105781"><%=szdz%> </font></td>
<td height="18" width="179"><font color="#105781"><%=lxdh%> </font></td>
</tr>
<%}%>
</table>
<table align=center border=0 cellpadding=2 cellspacing=0 width="95%" bgcolor="#FFF8CC">
<tbody>
<tr>
<td height=10 width=30> </td>
<td height=10 width=670> <%=PageList.getLink()%></td>
</tr>
</tbody>
</table>
<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr align="center">
<td width="16%" height="63" valign="middle">
<%if (nowuserszqx.equals("001")) {%>
<input type="button" class="input" name="modify" value="修 改" onClick="f_modify()">
<%} else {%>
<input type="button" class="input" name="modify" value="修 改" onClick="f_modify()" disabled>
<%}%>
</td>
<td width="17%">
<%if (dwzt.equals("02")) {%>
<input type="button" name="del" class="input" value="減 少" onClick="f_del()" disabled>
<%} else if (nowuserszqx.equals("001")) {%>
<input type="button" name="del" class="input" value="減 少" onClick="f_del()" >
<%} else {%>
<input type="button" name="del" class="input" value="減 少" onClick="f_del()" disabled>
<%}%>
</td>
<td width="18%">
<%if (dwzt.equals("01")) {%>
<input type="button" name="jshf" class="input" value="減少恢復" onClick="f_ret()" disabled>
<%} else if (nowuserszqx.equals("001")) {%>
<input type="button" name="jshf" class="input" value="減少恢復" onClick="f_ret()">
<%} else {%>
<input type="button" name="jshf" class="input" value="減少恢復" onClick="f_ret()" disabled>
<%}%>
</td>
<td width="17%"> <input type="button" name="jcqk" class="input" value="獎懲情況" onClick="f_jc()" >
</td>
<td width="17%">
<input type="button" name="zbgl" class="input" value="組別管理" onClick= "zb_new()")>
</td>
<td width="15%"><input type="button" name="jlqk2" class="input" 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="dwview" width="100" height="100" style="display:none" ></iframe>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -