📄 usermanage.asp

📁 企事业单位网站管理系统防止数据库数据非法备份
💻 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>&nbsp; 
            <%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%>
            &nbsp;删除</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 + -