📄 systemuser_query.asp
字号:
<!--#include file="../Include/TimeOut.asp"-->
<%if session("IPno")="no" then Response.Redirect "../Messagebox/error.asp?info=您无浏览此页的权限!!"%>
<%modulecode="0203"%>
<!--#include file="../Include/ModuleUserCheck.asp"-->
<!--#include file="../Include/online.asp"-->
<%
'读取当前用户的角色
set objres=server.CreateObject ("adodb.recordset")
objres.CursorType =3
objres.CursorLocation =3
objres.LockType =2
strsql="select * from xt_vp_UserRole where 用户编码='"+session("usercode")+"'"
objres.Open strsql,strconn
%>
<html>
<head>
<title>系统用户查询</title>
<style>
.button {
BACKGROUND-COLOR:#E6F4FF; BORDER-BOTTOM: #0099FF 1px solid; BORDER-LEFT: #0099FF 1px solid; BORDER-RIGHT: #0099FF 1px solid; BORDER-TOP: #0099FF 1px solid; COLOR: #336699; width="40"; height="18" ;TEXT-ALIGN: center}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#E7F6FD" text="#000000">
<div align="left">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td bgcolor="#336699"><img src="../public/images/find.jpg" width="300" height="50">
<font color="#00FFFF"> 系统用户查询</font></td>
</tr>
</table>
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#336699" align="center">
<tr>
<td>
<table style="font-size:9pt;" width="100%" border="0" cellspacing="0" cellpadding="0">
<form name="form1" method="post" action="../system/systemUser_EditList.asp?strsql=query" >
<tr bgcolor="#CAEAFF">
<td width="14%" align="right"> </td>
<td width="2%"> </td>
<td width="33%"> </td>
<td width="14%" align="right"> </td>
<td width="2%"> </td>
<td width="35%"> </td>
</tr>
<tr bgcolor="#CAEAFF">
<td width="14%" align="right">
<div align="right">用户编码</div>
</td>
<td width="2%"> </td>
<td width="33%">
<input type="text" name="UserCode" maxlength="6">
</td>
<td width="14%" align="right">职称</td>
<td width="2%"> </td>
<td width="35%">
<select name="ZhiCheng">
<option selected> </option>
<option value="无">无</option>
<option value="正高">正高</option>
<option value="副高">副高</option>
<option value="中级">中级</option>
<option value="其它">其它</option>
</select>
</td>
</tr>
<tr bgcolor="#CAEAFF">
<td width="14%" align="right"> </td>
<td width="2%"> </td>
<td width="33%"> </td>
<td width="14%" align="right"> </td>
<td width="2%"> </td>
<td width="35%"> </td>
</tr>
<tr bgcolor="#CAEAFF">
<td width="14%" align="right">
<div align="right">用户名称</div>
</td>
<td width="2%"> </td>
<td width="33%">
<input type="text" name="UserName" maxlength="10">
</td>
<td width="14%" align="right">学历</td>
<td width="2%"> </td>
<td width="35%">
<select name="XueLi">
<option> </option>
<option value="无">无</option>
<option value="博士">博士</option>
<option value="硕士">硕士</option>
<option value="本科">本科</option>
<option value="大专">大专</option>
<option value="其它">其它</option>
</select>
</td>
</tr>
<tr bgcolor="#CAEAFF">
<td width="14%" align="right"> </td>
<td width="2%"> </td>
<td width="33%"> </td>
<td width="14%" align="right"> </td>
<td width="2%"> </td>
<td width="35%"> </td>
</tr>
<tr bgcolor="#CAEAFF">
<td width="14%" align="right">部门编码</td>
<td width="2%"> </td>
<td width="33%">
<input type="text" name="departcode">
</td>
<td width="14%" align="right">职位</td>
<td width="2%"> </td>
<td width="35%">
<input name="ZhiWei" maxlength=20>
</td>
</tr>
<tr bgcolor="#CAEAFF">
<td width="14%" align="right"> </td>
<td width="2%"> </td>
<td width="33%"> </td>
<td width="14%" align="right"> </td>
<td width="2%"> </td>
<td width="35%"> </td>
</tr>
<tr bgcolor="#CAEAFF">
<td width="14%" align="right">有效标志</td>
<td width="2%"> </td>
<td width="33%">
<select name="YouXiao">
<option> </option>
<option value="1">有效</option>
<option value="0">无效</option>
</select>
</td>
<td width="14%" align="right">性别</td>
<td width="2%"> </td>
<td width="33%">
<select name="sex">
<option> </option>
<option value="男">男</option>
<option value="女">女</option>
</select>
</td>
</tr>
<tr bgcolor="#CAEAFF">
<td width="14%" align="right"> </td>
<td width="2%"> </td>
<td width="33%"> </td>
<td width="14%" align="right"> </td>
<td width="2%"> </td>
<td width="35%"> </td>
</tr>
<tr bgcolor="#336699">
<td width="14%" height="22" bgcolor="#336699" align="right">
<div align="right">
<input type="checkbox" name="checkbox" value="checkbox">
<font color="#FF0000"> <font color="#FFFFFF">模糊查询</font></font></div>
</td>
<td width="2%" height="22"> </td>
<td width="33%" bgcolor="#336699" height="22">
<div valign="center">
<div align="right"><font color="#FFFFFF">当前角色</font>
<select name="role" >
<%for i=1 to objres.RecordCount %>
<option value="<%=objres("角色编码")%>"><%=objres("角色名称")%></option>
<%
objres.MoveNext
next
objres.close
set objres=nothing
%>
</select>
</div>
</div>
</td>
<td colspan="3" bgcolor="#336699" height="22">
<div align="right">
<input class="button" type="submit" name="Submit4" value="查询">
<input class="button" type="reset" name="Submit22" value="重填">
<% if Request.QueryString("query")="query" then %>
<input class="button" type="button" name="Submit32" value="返回"onClick="back()">
<% end if%>
</div>
</td>
</tr>
</form>
</table>
</td>
</tr>
</table>
</div>
<script language="vbscript">
function back()
history.back
end function
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -