?? usermanage.asp
字號:
<%@language=vbscript codepage=936 %>
<!--#include file="conn.asp"-->
<!--#include file="admin.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>
<!-- #include file="Inc/Head.asp" -->
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="862" align="center" valign="top"><br>
<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
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"個用戶"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"個用戶"
else
currentPage=1
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"個用戶"
end if
end if
end if
sub showContent
dim i
i=0
%>
<table width="600" border="0" cellpadding="2" cellspacing="1" class="table_southidc">
<tr>
<td class="back_southidc" height="25"><div align="center">注冊會員管理</div></td>
</tr>
<tr>
<td height="25"><div align="center">
<table width="600" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000" class="border">
<tr bgcolor="#ECF5FF" class="title">
<td width="30" height="25" align="center"><strong> 序號</strong></td>
<td width="59" height="25" align="center"><strong> 用戶名</strong></td>
<td width="29" height="25" align="center"><strong> 性別</strong></td>
<td width="87" height="25" align="center"><strong>Email</strong></td>
<td width="185" height="25" align="center"><strong>公司名稱</strong></td>
<td width="39" height="25" align="center"><strong> 狀態</strong></td>
<td width="104" height="25" align="center"><strong> 操作</strong></td>
</tr>
<%do while not rs.EOF %>
<tr class="tdbg">
<td height="22" align="center" bgcolor="#ECF5FF"><%=rs("UserID")%></td>
<td align="center" bgcolor="#ECF5FF"><%=rs("username")%></td>
<td align="center" bgcolor="#ECF5FF">
<%if rs("Sex")=1 then
response.write "男"
else
response.write "女"
end if%>
</td>
<td bgcolor="#ECF5FF"><a href="AdminMaillist.asp?Email=<%=rs("email")%>"><%=rs("email")%></a></td>
<td bgcolor="#ECF5FF"> <%=rs("CompanyName")%> </td>
<td align="center" bgcolor="#ECF5FF">
<%
if rs("LockUser")=true then
response.write "已鎖定"
else
response.write "正常"
end if
%>
</td>
<td align="center" bgcolor="#ECF5FF"><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%>
<a href="UserDel.asp?UserID=<%=rs("UserID")%>" onClick="return ConfirmDel();">刪除</a></td>
</tr>
<%
i=i+1
if i>=MaxPerPage then exit do
rs.movenext
loop
%>
</table>
</div></td>
</tr>
</table>
<%
end sub
%> </td>
</tr>
</table>
<!-- #include file="Inc/Foot.asp" -->
<%
rs.Close
set rs=Nothing
call CloseConn()
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -