📄 sysuser.asp
字号:
<!--#Include file="../Common/Inc_DatConn.asp"-->
<!--#Include file="Common/Inc_Config.asp"-->
<!--#Include file="Common/Inc_Function.asp"-->
<%
'┌─ 风云ASP在线 ────────────────────────┐
'│ │
'│ 作者：赵振波. http://www.fyasp.com │
'│ │
'│ Q Q：176189168 │
'│ │
'│ Email：fy96@163.com │
'│ │
'│ 程序定做，系统开发，网站制作，提供高质量的网络产品、技术和服务！│
'│ │
'│【版权声明】 │
'│ │
'│ 本程序版权归坐看风云所有，未经授权擅自修改、复制或散布本程序│
'│ │
'│的部分或全部，将承受严厉的民事和刑事处罚，对已知的违反者将给予法 │
'│ │
'│律范围内的全面制裁。对非法使用此程序所造成的一切后果本人概不负责!│
'│ │
'└─────────────────── http://www.fyasp.com ──┘
%>
<%if IsTimeOut(Session("strAccount"),Session("strPassWord")) then Response.Redirect "index.asp"%>
<html>
<head>
<title><% = strSiteName%> - 网站后台管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="Common/Site.css" type="text/css">
<script language="javascript">
function CreateUser() {
popupWin = window.open('Oper.asp?Oper=AddUser','','width=300,height=150,scrollbars=no')
}
function EditUser(ID) {
popupWin = window.open('Oper.asp?Oper=EditUser&ID='+ ID,'','width=300,height=150,scrollbars=no')
}
function LockUser(ID) {
popupWin = window.open('Oper.asp?Oper=LockUser&ID='+ ID,'','width=300,height=150,scrollbars=no')
}
function UnLockUser(ID) {
popupWin = window.open('Oper.asp?Oper=UnLockUser&ID='+ ID,'','width=300,height=150,scrollbars=no')
}
function DelUser(ID) {
popupWin = window.open('Oper.asp?Oper=DelUser&ID='+ ID,'','width=300,height=150,scrollbars=no')
}
</script>
</head>
<body leftMargin="0" topMargin="2">
<!--#Include file="Common/inc_Top.asp"-->
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="105" valign="top" style="border-left: 1px solid rgb(0,0,0); border-right: 1px solid rgb(0,0,0)" class="bottom"><br>
<!--#Include file="Common/Inc_Button.asp"-->
</td>
<td valign="top" style="border-right: 1px solid rgb(0,0,0)" align="center">
<table width="96%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="50">当前位置：<a href="Main.asp">管理首页</a> -> 用户管理</td>
</tr>
</table>
<table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="50%" height="25">
<input onclick="Javascript:CreateUser()" type="button" value="新 增" name="button1" class="button">
</td>
<form method="post" action="SysUser.asp" name="Form1">
<td width="50%" align="right">用户名：<input type="text" name="KeyWord" size="15" value="<%= Request("KeyWord")%>" class="face"> <input type="submit" name="submit" value="搜" class="button"></td>
</form>
</tr>
</table>
<table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="100%" class="booktable">
<table border="0" width="100%" cellspacing="1" cellpadding="0">
<tr>
<td width="10%" height="30" class="bottom" align="center">编 号</td>
<td width="20%" height="30" class="bottom" align="center">用户名</td>
<td width="10%" height="30" class="bottom" align="center">状 态</td>
<td width="15%" height="30" class="bottom" align="center">用户身份</td>
<td width="25%" height="30" class="bottom" align="center">添加时间</td>
<td width="20%" height="30" class="bottom" align="center">操 作</td>
</tr>
<%
Dim rdsSysUser '/通告的数据库对象及SQL语句/
Dim sqlSysUser
Dim rdsTotalRec
Dim strKeyWord '/关键字/
Dim intPage '/当前页/
Dim intTotalRec '/所有记录/
Dim intUserCot '/通告条数/
Dim intUserCount '/通告条数/
Dim n,p,ii '/定义一些临时变量/
Dim strState
strKeyWord = Request("KeyWord")
intPage = Trim(Request("Page"))
if intPage = "" then
intPage = 1
else
intPage = Clng(intPage)
end if
intUserCot = 10
set rdsSysUser = Server.CreateObject("ADODB.Recordset")
if strKeyWord <> "" then
set rdsTotalRec = Conn.Execute("Select Count(UserKey) From Sys_Account Where Account like '%"& strKeyWord &"%'")
intTotalRec = rdsTotalRec(0)
sqlSysUser = "Select * From Sys_Account Where Account like '%"& strKeyWord &"%' Order By UserKey Desc"
else
set rdsTotalRec = Conn.Execute("Select Count(UserKey) From Sys_Account")
intTotalRec = rdsTotalRec(0)
sqlSysUser = "Select * From Sys_Account Order By UserKey Desc"
end if
rdsSysUser.Open sqlSysUser,Conn,1,1
if not rdsSysUser.EOF then
if intTotalRec mod intUserCot = 0 then
n = intTotalRec \ intUserCot
else
n = intTotalRec \ intUserCot + 1
end if
rdsSysUser.MoveFirst
if intPage > n then intPage = n
if intPage < 1 then intPage = 1
rdsSysUser.Move (intPage - 1) * intUserCot
do while not rdsSysUser.EOF and intUserCount < Clng(intUserCot)
intUserCount = intUserCount + 1
if rdsSysUser("State") = 0 then
strState = "活动"
strOperState = "<a href=""javascript:LockUser("& rdsSysUser("UserKey") &")""><img border=""0"" src="""& strImageUrl &"Lock.gif"" alt=""关闭用户""></a>"
else
strState = "<font color=""red"">关闭</font>"
strOperState = "<a href=""javascript:UnLockUser("& rdsSysUser("UserKey") &")""><img border=""0"" src="""& strImageUrl &"UnLock.gif"" alt=""开启用户""></a>"
end if
%>
<tr>
<td height="25" align="center" class="banma1"><%= rdsSysUser("UserKey")%></td>
<td height="25" align="center" class="banma2"><%= rdsSysUser("Account")%></td>
<td height="25" align="center" class="banma1"><%= strState%></td>
<td height="25" align="center" class="banma2"><%if rdsSysUser("UserLevel") = 1 then Response.Write "普通用户" else Response.Write "管 理 员" end if%></td>
<td height="25" align="center" class="banma1"><%= FormatTime(rdsSysUser("CreateTime"),6)%></td>
<td height="25" align="center" class="banma2"><%= strOperState%> <a href="javascript:EditUser(<%= rdsSysUser("UserKey")%>)"><img border="0" src="<%= strImageUrl%>/Edit.gif" alt="编辑用户"></a> <%if Session("strAccount") = rdsSysUser("Account") then%><img border="0" src="<%= strImageUrl%>Del.gif" alt="删除用户"><%else%><a href="javascript:DelUser(<%= rdsSysUser("UserKey")%>)"><img border="0" src="<%= strImageUrl%>Del.gif" alt="删除用户"></a><%end if%></td>
</tr>
<%
rdsSysUser.MoveNext
loop
else
Response.Write "<tr><td width=""100%"" height=""25"" colspan=""6"" class=""banma1""> <font color=""#FF0000"">没有管理用户信息...</font></td></tr>"
end if
rdsSysUser.Close
set rdsSysUser = nothing
if intPage - 1 mod 10 = 0 then
p = (intPage - 1) \ 10
else
p = (intPage - 1) \ 10
end if
%>
</table>
</td>
</tr>
</table>
<table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
<form method="post" action="SysUser.asp" id="form2" name="form2">
<input type="hidden" name="KeyWord" value="<%= strKeyWord%>">
<tr>
<td width="30%" height="30" valign="middle">页次：<b><%= intPage %></b>/<b><%= n %></b>页 每页<b><%= intUserCot %></b>条 共<b><%= intTotalRec %></b>条</td>
<td width="70%" height="30" valign="middle"><div align="right">分页：
<%
if intPage = 1 then
Response.Write "<font face=webdings>9</font> "
else
Response.Write "<a href='?Page=1&KeyWord="& strKeyWord &"' title=首页><font face=webdings>9</font></a> "
end if
if p * 10 > 0 then Response.Write "<a href='?Page="&Cstr(p*10)&"&KeyWord="& strKeyWord &"' title=上十页><font face=webdings>7</font></a> "
Response.Write "<b>"
for ii = p * 10 + 1 to P * 10 + 10
if ii = intPage then
Response.Write "<font color=""#FF0000"">"+Cstr(ii)+"</font> "
else
Response.Write "<a href='?Page="&Cstr(ii)&"&KeyWord="& strKeyWord &"'>"+Cstr(ii)+"</a> "
end if
if ii = n then exit for
next
Response.Write "</b>"
if ii < n then Response.Write "<a href='?Page="&Cstr(ii)&"&KeyWord="& strKeyWord &"' title=下十页><font face=webdings>8</font></a> "
if intPage=n then
Response.Write "<font face=webdings>:</font> "
else
Response.Write "<a href='?Page="&Cstr(n)&"&KeyWord="& strKeyWord &"' title=尾页><font face=webdings>:</font></a> "
end if
%>
转到：<input type="text" name="Page" size="2" maxlength="10" value="<%= intPage %>" class="face"> <input type="submit" value="Go" name="submit" class="button">
</div></td>
</tr>
</form>
</table>
<br>
</td>
</tr>
</table>
<!--#Include file="Common/Inc_Bottom.asp"-->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -