userlist.asp

重庆二手网

<!--#include file=conn.asp-->
<!--#include file=cookies.asp-->
<meta http-equiv="Content-Language" content="zh-cn">
<link rel="stylesheet" type="text/css" href="../1.CSS">
<script>
function loadThreadFollow(t_id,b_id){
	var targetImg =eval("document.all.followImg" + t_id);
	var targetDiv =eval("document.all.follow" + t_id);
	
	if ("object"==typeof(targetImg)){
		if (targetDiv.style.display!='block'){
			targetDiv.style.display="block";
			
		}else{
			targetDiv.style.display="none";
		}
	}
}
</script>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#8C8C8C" width="100%" height="30">
<%dim ptotale
'总页数
x=trim(request.querystring("page1"))
if x<>"" then
page2=cint(x)
else
page2=1
end if

dim rs,sql,k
k=1
dim y,name,stype,endtime,startime,paixu,ydesc,mydesc,timetype
name=trim(request("name"))
stype=trim(request("stype"))
startime=trim(request("startime"))
endtime=trim(request("endtime"))
paixu=request("paixu")
timetype=trim(request("timetype"))
if stype="" then
   stype="name"
end if

set rs = Server.CreateObject("ADODB.RecordSet")
if startime="" or endtime="" then
   sql="select id,username,name,zcdata,dlcs,jf,hb,a,b,c,d from [user] where "&stype&" like '%"&name&"%' order by id desc"
   else
   startime=cdate(startime)
   endtime=cdate(endtime)
   sql="select id,username,name,zcdata,dlcs,jf,hb,a,b,c,d from [user] where "&stype&" like '%"&name&"%' and "&timetype&"<='"&endtime&"' and '"&startime&"'<="&timetype&" order by id desc"
end if
rs.open sql,conn,3,3

dim rec,page1,page2
dim x,typeid
dim mpage
mpage=60
'每页12条记录
rs.pagesize=mpage
rs.absolutepage=page2
ptotale=rs.pagecount


'dim rs,sql,k
'set rs = Server.CreateObject("ADODB.RecordSet")
'sql="select id,username,name,zcdata,dlcs,jf,hb,a,b,c,d from [user] order by id desc" 
'rs.open sql,conn,1,1
if rs.eof then
response.write "<li>还没有用户数据！"
response.end
end if
k=1
%>
  
  <tr>
    <td width="100%" height="30" colspan="14">　</td>
  </tr>
  <tr>
    <td width="100%" height="30" colspan="14">　</td>
  </tr>
  <tr>
    <td width="4%" height="30">
    <p align="center">编号</td>
    <td width="12%" height="30">
    <p align="center">姓名</td>
    <td width="11%" height="30">
    <p align="center">登陆帐号</td>
    <td width="7%" height="30">
    <p align="center">登陆次数</td>
    <td width="7%" height="30">
    <p align="center">积分</td>
    <td width="7%" height="30">
    <p align="center">货币</td>
    <td width="9%" height="30">
    <p align="center">最后登陆</td>
    <td width="4%" height="30" bgcolor="#666666">
    <p align="center"><font color="#FFFFFF">道具</font></td>
    <td width="5%" height="30" align="center">
    颜色</td>
    <td width="4%" height="30" align="center">
    置顶</td>
    <td width="5%" height="30" align="center">
    图片</td>
    <td width="5%" height="30" align="center">
    验证</td>
    <td width="8%" height="30" align="center">
    操作</td>
    <td width="7%" height="30" align="center">
    选择</td>
  </tr>
  <%
  dim id
  do while not rs.eof and k<mpage+1
  id=rs("id")
  %>
  <tr>
    <td width="4%" height="25">
    <p align="center"><%=k%></td>
    <td width="12%" height="25">
    <p align="center"><%=rs("name")%></td>
    <td width="11%" height="25">
    <p align="center"><%=rs("username")%></td>
    <td width="7%" height="25">
    <p align="center"><%=rs("dlcs")%></td>
    <td width="7%" height="25">
    <p align="center"><%=rs("jf")%></td>
    <td width="7%" height="25">
    <p align="center"><%=rs("hb")%></td>
    <td width="9%" height="25">
    <p align="center"><%=datevalue(rs("zcdata"))%></td>
    <td width="4%" height="25">
    <p align="center">
                    <img border="0" src="img/r3.gif"></td>
    <td width="5%" height="25" align="center">
    <%=rs("a")%></td>
    <td width="4%" height="25" align="center">
    <%=rs("b")%></td>
    <td width="5%" height="25" align="center">
    <%=rs("c")%></td>
    <td width="5%" height="25" align="center">
    <%=rs("d")%></td>
    <td width="8%" height="25" align="center">
    <font color="#FF0000">
    <span id="followImg<%=k%>" style="CURSOR: hand" onclick="loadThreadFollow(<%=k%>,5)">
    面版</span></font></td>
    <td width="7%" height="25" align="center">
    <input type="checkbox" name="C1" value="ON"></td>
  </tr>
  <tr style="display:none" id="follow<%=k%>">
    <td width="95%" height="25" colspan="14">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="100%">
      <tr>
        <td width="10%" bgcolor="#C5C1BE">　</td>
        <td width="10%" bgcolor="#C5C1BE"><font color="#666666"><a href="#" ONCLICK="window.open('user_editzj.asp?id=<%=id%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=489,height=330,left=300,top=100')">修改资料</a></font></td>
        <td width="10%" bgcolor="#C5C1BE"><font color="#666666">查看全部</font></td>
        <td width="10%" bgcolor="#C5C1BE"><font color="#666666"><a href="#" ONCLICK="window.open('user_editpass.asp?id=<%=id%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=180,height=35,left=300,top=100')">修改密码</a></font></td>
        <td width="10%" bgcolor="#C5C1BE"><font color="#666666"><a href="#" ONCLICK="window.open('user_edithb.asp?id=<%=id%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=180,height=35,left=300,top=100')">修改货币</a></font></td>
        <td width="10%" bgcolor="#C5C1BE"><font color="#666666"><a href="#" ONCLICK="window.open('user_editdj.asp?id=<%=id%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=200,height=150,left=300,top=100')">修改道具</a></font></td>
        <td width="10%" bgcolor="#C5C1BE"><font color="#666666"><a href="#" ONCLICK="window.open('user_editmail.asp?id=<%=id%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=355,height=328,left=300,top=100')">发送邮件</a></font></td>
        <td width="10%" bgcolor="#C5C1BE"><font color="#666666">直接删除</font></td>
        <td width="10%" bgcolor="#C5C1BE"><font color="#666666">信息管理</font></td>
        <td width="10%" bgcolor="#C5C1BE">　</td>
      </tr>
    </table>
    </td>
  </tr>
    <%
    k=k+1
    rs.movenext
	loop

//总页数
x=trim(request.querystring("page1"))

if x<>"" then
page2=cint(x)

else
page2=1
end if
rs.pagesize=mpage
rs.absolutepage=page2
ptotale=rs.pagecount
	%>
  <tr>
    <td width="100%" height="30" colspan="14">　</td>
  </tr>
</table>

<table width="820" border="1" cellpadding="0" cellspacing="0" align="center">
  <tr> 
    <td bgcolor="#C0C0C0" width="762" color="ffffff" bordercolor="#000000">
      <%
if page2= 1 then
response.write "前页"
else
y=page2-1
response.write "<a href='userlist.asp?page1="&y&"&name="&name&"&stype="&stype&"&endtime="&endtime&"&startime="&startime&"&paixu="&paixu&"&ydesc="&mydesc&"&timetype="&timetype&"' class='p'>前一页</a>"
end if
response.write "  "
if page2=ptotale then
response.write "下页"
else
y=page2+1
response.write "<a class=p  href=userlist.asp?page1="&y&"&name="&name&"&stype="&stype&"&endtime="&endtime&"&startime="&startime&"&paixu="&paixu&"&ydesc="&mydesc&"&timetype="&timetype&">下一页</a>"
end if
response.write "&nbsp;&nbsp;&nbsp;"
response.write page2
response.write "/"
response.write ptotale

%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;符合条件的记录数：<%=rs.recordcount%>
    </td>
     
  </tr><form method="get" action="userlist.asp">
  <tr> 
    <td bgcolor="#C0C0C0" width="100%" color="ffffff" bordercolor="#000000">
      <select name="stype" class=an style="width: 76; height: 16" size="1">
                <option value="name">姓名</option>
                <option value="username">帐号</option>
                <option value="email">邮件</option>
                <option value="dianhua">电话</option>
                <option value="dizhi">地址</option>
                
                </select><input type="text" name="name" size="12" class=an style="width: 66; height: 16"><input type="hidden" name="paixu" size="10" class=an value=<%=paixu%>><input type="hidden" name="ydesc" size="10" class=an value=<%=mydesc%>><select name="timetype" class=an style="width: 76; height: 16" size="1">
                <option value="zcdata">注册时间</option>
                </select><input type="text" name="startime" size="10" class=an style="width: 52; height: 16">--&gt;<input type="text" name="endtime" size="10" class=an style="width: 57; height: 16">跳转页数：<input type="text" name="page1" size="12" class=an style="width: 24; height: 15">每页记录数：<input type="text" name="mypage" size="12" class=an style="width: 24; height: 15">&nbsp;  
      <input type="submit" name="submit" value="确定" class=an>
    </td>
  </tr></form> 
</table>


<%	rs.close
    set rs=nothing
    closedb
%>