?? usermanage.asp
字號:
<%@language=vbscript codepage=936 %>
<!--#include file="Admin.asp"-->
<!--#include file="Conndb.asp"-->
<!--#include file="Inc/Function.asp"-->
<%
dim strFileName
const MaxPerPage=20
dim totalPut,CurrentPage,TotalPages
dim rs, sql
strFileName="UserManage.asp"
if request("page")<>"" then
currentPage=cint(request("page"))
else
currentPage=1
end if
Set rs=Server.CreateObject("Adodb.RecordSet")
sql="select * from [User] order by UserID desc"
rs.Open sql,conn,1,1
%>
<script language=javascript>
function ConfirmDel()
{
if(confirm("確定要刪除此用戶嗎？"))
return true;
else
return false;
}
</script>
<html>
<head>
<title>用戶管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Admin_Style.css" rel="stylesheet" type="text/css">
</head>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="862" align="center" valign="top">
<br>
<%
if rs.eof and rs.bof then
response.write "目前共有 0 個注冊用戶"
else
totalPut=rs.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showpage strFileName,totalput,MaxPerPage,true,true,"個用戶"
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"個用戶"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showpage strFileName,totalput,MaxPerPage,true,true,"個用戶"
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"個用戶"
else
currentPage=1
showpage strFileName,totalput,MaxPerPage,true,true,"個用戶"
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"個用戶"
end if
end if
end if
sub showContent
dim i
i=0
%>
<table width="741" border="0" align="center" cellpadding="0" cellspacing="2" class="border">
<tr bgcolor="#C0C0C0" class="title">
<td width="30" height="25" align="center" style="background-color: #E1F4EE"><strong> 序號</strong></td>
<td width="59" height="25" align="center" style="background-color: #E1F4EE"><strong> 用戶名</strong></td>
<td width="29" height="25" align="center" style="background-color: #E1F4EE"><strong> 性別</strong></td>
<td width="87" height="25" align="center" style="background-color: #E1F4EE"><strong>Email</strong></td>
<td width="185" height="25" align="center" style="background-color: #E1F4EE"><strong>公司名稱</strong></td>
<td width="71" height="25" align="center" style="background-color: #E1F4EE"><b>用戶級別</b></td>
<td width="49" height="25" align="center" style="background-color: #E1F4EE"><strong> 狀態</strong></td>
<td width="220" height="25" align="center" bgcolor="#E1F4EE"><strong>
操作</strong></td>
</tr>
<%do while not rs.EOF %>
<tr bgcolor="#E3E3E3" class="tdbg">
<td height="22" align="center"><%=rs("UserID")%></td>
<td align="center"><%=rs("username")%></td>
<td align="center">
<%if rs("Sex")=1 then
response.write "男"
else
response.write "女"
end if%>
</td>
<td><a href="Sendmail.asp?email=<%=rs("email")%>"><%=rs("email")%></a></td>
<td> <%=rs("Comane")%> </td>
<td align="center">
<% if rs("UserLevel")="9" then
response.write "VIP用戶"
else if rs("UserLevel")="99" then
response.write "企業用戶"
else
response.write "普通用戶"
end if
end if%> </td>
<td align="center">
<%
if rs("LockUser")=true then
response.write "已鎖定"
else
response.write "正常"
end if
%>
</td>
<td align="center"><a href="UserModify.asp?UserID=<%=rs("UserID")%>">修改</a>
<%if rs("LockUser")=False then %>
<a href="UserLock.asp?Action=Lock&UserID=<%=rs("UserID")%>">鎖定</a>
<%else%>
<a href="UserLock.asp?Action=CancelLock&UserID=<%=rs("UserID")%>">解鎖</a>
<%end if%>
刪除</td>
</tr>
<%
i=i+1
if i>=MaxPerPage then exit do
rs.movenext
loop
%>
</table>
<%
end sub
%>
</td>
</tr>
</table>
<%
rs.Close
set rs=Nothing
call CloseConn()
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -