📄 userlist.asp
字号:
<%option explicit%>
<!-- #include virtual="include/DataEnvi.asp" -->
<!-- #include virtual="include/String.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>用户</title>
<base target="_self">
<style>
<!--
td { font-size: 12px }
.td0 {cursor:hand}
.td1 {cursor:hand;background-color: #D3D9E7; color: #000000; border: 1 solid #35356A}
.td2 {cursor:hand;background-color: #6174A7; color: #FFFFFF; border: 1 solid #35356A}
-->
</style>
</head>
<body bgcolor="#FFFFFF" leftmargin="2" rightmargin="0" background="../../Images/Menu/bg.gif">
<table border="0" cellpadding="3" cellspacing="0" width=100%>
<tr>
<td width=10%></td>
<td width=90%></td>
</tr>
<%
Dim ObjDB,ObjRS,StrSQL
Set ObjDB = Server.CreateObject("Adodb.Connection")
OpenDB ObjDB
Dim IsShowAll
IsShowAll = True
If Request.QueryString("ID") = "2" Then IsShowAll = False
If IsShowAll Then
StrSQL = "Select * From v_OA_MSN_Account Order By State Desc,LastLoginTime Desc"
Else
StrSQL = "Select * From v_OA_MSN_Account Where AccountID In (Select AccountID From t_OA_SYS_Department_Account Where DepID In (Select DepID From t_OA_SYS_Department_Account Where AccountID = " & Session("AccountID") & ")) Order By State Desc,LastLoginTime Desc"
End If
Set ObjRS = ObjDB.Execute(StrSQL)
While Not ObjRS.Eof
%>
<tr>
<td><img src="../../Images/OA/MSN/<%If ObJRS("Gender")=2 Then Response.Write "g" Else Response.Write "b"%><%=ObjRS("State")%>.gif"></td>
<td onclick="parent.SendMsg(<%=ObjRS("AccountID")%>,'<%=Server.HTMLEncode ( ObjRS("TrueName") )%>')" onmouseover="this.className='td1'" onmouseout="this.className='td0'" onmousedown="this.className='td2'"><%=Server.HTMLEncode(ObjRS("TrueName"))%></td>
</tr>
<%
ObjRS.MoveNext
Wend
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -