?? qx_tab.jsp
字號:
<%@page contentType="text/html;charset=GBK"%>
<%@ page import = "com.vstsoft.std.*" %>
<%@ page import = "java.sql.*" %>
<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;}
String Userid = "";
Userid = jcypurview.getUserid(); //取當前公務員編號
if (jcypurview.purviewVerdict("B0500006") == false)
{
%>
<Script Language=javascript>
alert("您沒有操作此頁權限!")
window.open("../index.jsp","_top")
</Script>
<% return; } %>
<%
vststd tra = new vststd("jc");
String user_id = "";
String qxa = "";
String qxb = "";
String susercode = "";
String susername = "";
String sxb = "";
String ssfzh = "";
String sqx = "";
String sdwmc = "";
String szbmc = "";
String sryzt = "";
user_id = tra.getValue(request,"ID");
if (!user_id.equals("")){
sun.jdbc.rowset.CachedRowSet rs = tra.getResultBySelect("select r.usercode,r.username,decode(r.xb,'01','男','02','女'),r.sfzh,dp_sys.F_Get_mc_by_dm('0001',r.qx),(select dwmc from jcy_dw where dwdm = r.DWDM),(select zbmc from jcy_zb where zbdm = r.zbdm), dp_sys.F_Get_mc_by_dm('5009',r.ryzt) from jcy_ry r where r.userid = '"+user_id+"'");
if (rs.next() == true)
{
susercode = rs.getString(1);
if (susercode == null)susercode = "";
susername = rs.getString(2);
if (susername == null)susername = "";
sxb = rs.getString(3);
if (sxb == null) sxb = "";
ssfzh = rs.getString(4);
if (ssfzh == null) ssfzh = "";
sqx = rs.getString(5);
if (sqx == null) sqx = "";
sdwmc = rs.getString(6);
if (sdwmc == null) sdwmc = "";
szbmc = rs.getString(7);
if (szbmc == null) szbmc = "";
sryzt = rs.getString(8);
if (sryzt == null) sryzt = "";
qxa = "select a.id,a.name from qx_group a,(select gid from qx_user_group where userid = '"+ user_id +"') b where a.id = b.gid(+) and a.id <> 1 and b.gid is null order by a.NAME";
qxb = "select id,name from qx_group where id in (select gid from qx_user_group where userid = '"+ user_id +"') and id <> 1 order by name";
}
}else
{
qxa = "select id,name from qx_group where id = '0'";
qxb = "select id,name from qx_group where id = '0'";
}
%>
<html>
<head>
<title></title>
<STYLE type=text/css>
<!--
.sec2
{BORDER-RIGHT: gray 1px solid; BORDER-TOP: #ffffff 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: #ffffff 1px solid; CURSOR: hand; COLOR: #000000; BACKGROUND-COLOR: #E0ECFA}
.sec1
{BORDER-RIGHT: gray 1px solid; BORDER-TOP: #ffffff 1px solid; BORDER-LEFT: #ffffff 1px solid; CURSOR: hand; COLOR: #000000; BORDER-BOTTOM: #ffffff 1px solid; BACKGROUND-COLOR: #E0ECFA}
.main_tab
{BORDER-RIGHT: gray 1px solid; BORDER-LEFT: #ffffff 1px solid; COLOR: #000000; BORDER-BOTTOM: gray 1px solid; BACKGROUND-COLOR: #E0ECFA}
-->
</STYLE>
<Script>
<!--
function secBoard(n)
{
for(i=0;i<secTable.cells.length;i++)
secTable.cells[i].className="sec1";
secTable.cells[n].className="sec2";
for(i=0;i<mainTable.tBodies.length;i++)
mainTable.tBodies[i].style.display="none";
mainTable.tBodies[n].style.display="block";
}
-->
</Script>
<script language="JavaScript" src = "js/listbox.js"></script>
<script>
function f_err(err,jcid,spd)
{
alert(err);
if (err == "保存成功!")history.back();
}
function f_a(f,s)
{
var stext = "";
var count=0;
for(i=0;i<s.options.length; i++)
{
{
stext += "&s" + count + "=" + s.options[i].value;
count++;
}
}
f.action="qx_submit.jsp?zt=ry&user=<%=user_id%>&count=" + count + stext;
f.submit();
}
</script>
<link rel="stylesheet" href="../style.css" type="text/css">
</head>
<Body bgcolor="#EEF9FF">
<table width="61%" height="441">
<tr>
<td width="22%" height="18"> </td>
<td width="78%"> </td>
</tr>
<tr>
<td> </td>
<td><Table width="254" height="32" border=0 cellPadding=0 cellSpacing=0 id=secTable>
<TR align=middle>
<!--For Begin-->
<TD width="140" bgcolor="#00CCFF" class=sec2 onClick="secBoard(0)">
<font size="2"><font color="#000000"><br>
</font></font><font color="#000000"><font color="#105781">人員信息維護</font></font><font size="2">
</font> </TD>
<TD class=sec1 onClick="secBoard(1)" width="140"> <font size="2"><br>
</font><font color="#105781">人員角色維護</font><font size="2"> </font>
</TD>
<!--For End-->
</TR>
</Table>
<table class=main_tab id=mainTable cellspacing=0 cellpadding=0 border=0 width="422" height="258">
<!--For Begin-->
<tbody style="DISPLAY: block">
<tr>
<td valign=top> <table width="100%" align="center" height="197" border="0">
<tr>
<td height="34" align="center"> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td width="21%" height="29"><div align="right"><font color="#105781">用戶名:</font></div></td>
<td width="24%"><font color="#105781">
<input name="user" type="text" size="14" height="15" readonly="" value="<%=susercode%>">
</font></td>
<td width="20%"><div align="right"><font color="#105781">真實姓名:</font></div></td>
<td width="35%"><font color="#105781">
<input name="name" type="text" size="14" height="15" readonly="" value="<%=susername%>">
</font></td>
</tr>
<tr>
<td height="20" align="center"> <div align="right"><font color="#105781">性別:</font></div></td>
<td><font color="#105781">
<input name="xb" type="text" size="14" height="15" readonly="" value="<%=sxb%>">
</font></td>
<td><div align="right"><font color="#105781">身份證號:</font></div></td>
<td><font color="#105781">
<input name="sfzh" type="text" size="14" height="15" readonly="" value="<%=ssfzh%>">
</font></td>
</tr>
<tr>
<td height="30" align="center"> <div align="right"> <font color="#105781">區縣:
</font></div></td>
<td height="30" colspan="3" align="center"> <div align="left"><font color="#105781">
<input name="qx" type="text" size="42" height="15" readonly="" value="<%=sqx%>">
</font></div></td>
</tr>
<tr>
<td height="25" align="center"> <div align="right"></div>
<div align="right"><font color="#105781">單位: </font></div></td>
<td height="25" colspan="3" align="center"> <div align="left"><font color="#105781">
<input name="dw" type="text" size="42" height="15" readonly="" value="<%=sdwmc%>" >
</font></div></td>
</tr>
<tr>
<td height="45" align="center"><div align="right"><font color="#105781">組別:</font></div></td>
<td><font color="#105781">
<input name="zb" type="text" size="14" height="15" readonly="" value="<%=szbmc%>">
</font></td>
<td><div align="right"><font color="#105781">人員狀態:</font></div></td>
<td><font color="#105781">
<input name="ryzt" type="text" size="14" height="15" readonly="" value="<%=sryzt%>">
</font></td>
</tr>
</table></td>
</tr>
</tbody>
<tbody style="DISPLAY: none">
<tr>
<td valign=top> <form name="form1" method="post" action="" target="userwh">
<table width="50%" border="0" align="center" height="90%" cellpadding="0" cellspacing="1">
<tr>
<td width="40%"><div align="right">
<div align="center"><br>
<select name="selectA" size="11" style="WIDTH: 180px" multiple onChange="MM_findObj('p1').src = '../images/arrowRight.gif'">
<%String aaa = tra.popListWithSelect(qxa,"name");%>
<%=aaa%>
</select>
</div>
</div></td>
<td width="20%"> <div align="center"> <img name=p1 src="../images/arrowRight_disabled.gif" width="24" height="24" onClick="f_add(selectA,selectB);this.src='../images/arrowRight_disabled.gif'">
<BR>
<img name=p2 src="../images/arrowLeft_disabled.gif" width="24" height="24" onClick="f_add(selectB,selectA);this.src='../images/arrowLeft_disabled.gif'">
<BR>
</div></td>
<td width="40%"><div align="left">
<div align="center"><br>
<select name="selectB" size="11" style="WIDTH: 180px" multiple onChange="MM_findObj('p2').src = '../images/arrowLeft.gif'">
<%String bbb = tra.popListWithSelect( qxb ,"name");%>
<%=bbb%>
</select>
</div>
</div></td>
</tr>
<tr>
<td><font color="#105781">多選：按住Shift選擇</font></td>
<td> </td>
<td> <div align="right">
<input type="button" name="Submit" value="保 存" onClick="f_a(form1,selectB)" class="input">
</div></td>
</tr>
</table>
</form></td>
</tr>
</tbody>
</table>
<div align="center"></div></td>
</tr>
</table>
<div align="center"></div>
<p> </p>
<p> </p>
<iframe name= "userwh" width="1" height="1" style="display:none" ></iframe>
</Body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -