userlist.asp

一个非常优秀的自动建站程序

<!--#include file="top.asp"-->
<script language=Javascript>
<!--
function DelId(i){
	if (confirm("确定要删除用户的帐号吗?\n注：此操作是不可逆！")==1){
		window.location="UserDelId.asp?ID="+i
		}
		}
//-->
</script>
<table width="100%"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td align=center><form name="form1" method="post" action="?">
      输入用户名：
          <input name="usrid" type="text" id="usrid">
          <input type="submit" name="Submit" value="搜索" style="font-size: 9pt; COLOR: #ffffff; height:20px;background-color:#568ac2;" onMouseOver ="this.style.backgroundColor='#77A3D2'" onMouseOut ="this.style.backgroundColor='#568ac2'">
    </form></td>
  </tr>
</table>
<%
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from [Agent_User] where UserID like '%"&request("usrid")&"%' ORDER BY ID DESC"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
	response.write "<!--没有内容-->"
	response.end()
   else
	RowCount=PageNum
	    Tmp=IsNumeric(Request("PageNo"))
	    if (Tmp=False) then
		PageNo=1
	    else
		PageNo=Request("PageNo")
	    end if
	TSum=INT(rs.RECORDCOUNT/RowCount*-1)*-1
	if PageNo="" or PageNo=0 then
		PageNo=1
	else
		PageNo=PageNo+1
		PageNo=PageNo-1
	end if
	if CINT(PageNo)>1 then
		if CINT(PageNo)>CINT(TSum) then
			PageNo=1
		end if
	end if	
	if PageNo<0 then
		PageNo=1
	End if
	RS.PageSize=RowCount
	RS.AbsolutePage=PageNo
	RECORDCOUNT=rs.RECORDCOUNT
%>

<table width="100%" align="center" bgcolor="#cccccc" border="0" cellpadding="5" cellspacing="1">
  <tr bgcolor="#ffffff">
    <td width=30 align=center>编号</td>
    <td width=80 align=center>登录名</td>
    <td width=60 align=center>会员等级</td>
    <td width=60 align=center>真实姓名</td>
    <td width=50 align=center>账户金额</td>
    <td width=60 align=center>注册日期</td>
    <td width=60 align=center>最后登录</td>
    <td align=center>备注</td>
    <td align=center colspan="3">操作</td>
  </tr>
<%DO WHILE NOT rs.EOF AND RowCount>0%>
  <tr bgcolor="#FFFFFF">
    <td align=center><%=rs("Id")%></td>
    <td align=center><%=rs("UserId")%></td>
    <td align=center><%=GradeText(rs("Grade"))%></td>
    <td align=center><%=rs("Name")%></td>
    <td align=center><%=rs("Money")%> 元</td>
    <td align=center><%=rs("Createdate")%></td>
    <td align=center><%=rs("ExpDate")%></td>
    <td><%=rs("Other")%></td>
    <td align=center><a href="UserEdit.asp?ID=<%=rs("ID")%>">资料</a></td>
    <td align=center><a href="MoneyList.asp?usrid=<%=rs("UserId")%>">交易记录</a></td>
    <td align=center><a href="Javascript:DelId(<%=rs("id")%>)">删除</a></td>
  </tr>
<%
	RowCount = RowCount - 1
	rs.MoveNext
	Loop
	rs.close
	set rs = nothing
   end if%>
</table>
<br>
<table width="100%" align="center" bgcolor="#cccccc" border="0" cellpadding="5" cellspacing="1">
  <tr bgcolor="#FFFFFF">
    <td align=center>
<table width=100% border="0" cellpadding="0" cellspacing="0">
<tr>
<td width=30%>
共有信息 <%=RECORDCOUNT%> 条 当前第 <%=PageNo%>/<%=TSum%> 页
</td>
<td align=center width=40%>
<a href="UserAdd.asp">添加会员</a>
</td>
<td align=right width=30%>
<%=PageList%>
</td>
</tr>
</table>
    </td>
  </tr>
<%if TSum>3 then%>
  <tr bgcolor="#FFFFFF">
    <td align=center>
<%for i=1 to TSum%>
<a href="?PageNo=<%=i%>">第<%=i%>页</a>
<%next%>
    </td>
  </tr>
<%end if%>
</table>
<%Function PageList()
if TSum>1 then
  if PageNo=1 then
    NextPage=PageNo+1
    response.write"首页 上一页 <a href='?PageNo="&NextPage&"'>下一页</a> <a href='?PageNo="&TSum&"'>尾页</a>"
  end if
  if PageNo=TSum then
    PrwePage=PageNo-1
    response.write "<a href='?PageNo=1'>首页</a> <a href='?PageNo="&PrwePage&"'>上一页</a> 下一页 尾页"
  end if
  if PageNo>1 and TSum>PageNo then
    NextPage=PageNo+1
    PrwePage=PageNo-1
    response.write "<a href='?PageNo=1'>首页</a> <a href='?PageNo="&PrwePage&"'>上一页</a> <a href='?PageNo="&NextPage&"'>下一页</a> <a href='?PageNo="&TSum&"'>尾页</a>"
  end if
else
  response.write "首页 上一页 下一页 尾页"
end if
End Function%>

    </td>
  </tr>
</table>

</TD></TR></TABLE>
<!--#include file="foot.asp"-->