<!--#include file="../conn.asp"-->
<!-- #include file="../admin/check_master.asp" -->
<!--#include file="../inc/publicfun.asp" -->
<link rel="stylesheet" href="../css/xmwuye.css">
<% 
dim sql,seachstr,login_sort
dim rs
seachstr=request.Form("seachstr")
tyname1="seachstr"
tyvalue1=seachstr
tyname2="kind"
tyvalue2=request("kind")
if seachstr<>"" then
   sql="select * from ftbbs_bmtb where "&request("kind")&" like '%"&seachstr&"%' order by id desc"
else
   sql="select * from ftbbs_bmtb order by id desc"
end if
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,3,1
%>
<body leftmargin="0" topmargin="5">
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
  <form name="form1" method="post" action="">
      <tr bgcolor="#d6dff7"> 
        <td height="30" align="right" bgcolor="#f4f4f4"><div align="center">搜索用户： 
            <input name="seachstr" type="text" id="seachstr" size="20">
            <select name="kind">
              <option value="username" >用户名</option>
              <option value="tel">电话</option>
            </select>
            <input type="submit" name="Submit" value=" 搜 索 ">
        </div></td>
      </tr>
    </form>
  </table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
      <td width="100%">  
      <table width="100%" border="0" cellpadding="0" cellspacing="1" bordercolorlight="#000000" bordercolordark="#FFFFFF" bgcolor="#666666">
        <tr bgcolor="#f4f4f4" height=22> 
          <td width="3%" height="25" align="center"><strong>ID号</strong></td>
          <td width="8%" align="center"><strong>用户名</strong></td>
          <td width="8%" align="center"><strong>电话</strong></td>
          <td width="5%" align="center"><strong>性别</strong></td>
          <td width="4%" align="center"><strong>年龄</strong></td>
          <td width="8%" align="center"><strong>职业</strong></td>
          <td width="7%" align="center"><strong>学历</strong></td>
          <td width="10%" align="center"><strong>来自</strong></td>
          <td width="6%" align="center"><strong>QQ号</strong></td>
          <td width="9%" align="center"><strong>备注</strong></td>
          <td width="9%" align="center"><strong>报名时间</strong></td>
          <td width="5%" align="center"><strong>标志</strong></td>
          <td width="5%" align="center"><strong>修改</strong></td>
          <td width="5%" align="center"><strong>删除</strong></td>
        </tr>
<%
if not rs.eof then
wzrep =30
wzpage = clng(request.querystring("page"))
if len(wzpage) = 0 or wzpage = 0 then wzpage = 1
rs.PageSize=wzrep
rs.AbsolutePage=wzpage
wzpagecount=rs.PageCount
wzcount=rs.RecordCount
for i = 0 to wzrep-1
  if rs.eof then exit for
%>
        <tr bgcolor="#FFFFFF"> 
          <td  height=22 align="center"><FONT COLOR="blue"><%=rs("id")%></font></td>
          <td align="center"><%=rs("username")%></td>
          <td align="center"><%=rs("tel")%></td>
          <td align="center"><%=rs("sex")%></td>
          <td align="center"><%=rs("age")%></td>
          <td align="center"><%=rs("job")%></td>
          <td align="center"><%=rs("edu")%></td >
          <td align="center"><%=rs("address")%></td>
          <td align="center"><%=rs("qq")%></td>
          <td align="center"><%=rs("note")%></td>
          <td align="center"><%=rs("indate")%></td>
          <td align="center"> 
            <%if rs("flag")=1 then%>
            <a href="ftbbsdel.asp?id=<%=rs("id")%>&tb=ftbbs_bmtb&flag=0"><font color=red>隐</font></a> 
            <%else%>
            <a href="ftbbsdel.asp?id=<%=rs("id")%>&tb=ftbbs_bmtb&flag=1">显</a> 
            <%end if%>
          </td>
          <td align="center"> 
            <%if instr(session("admin_qs"),2)>0 then%>
            <a href="bmuser_edit.asp?id=<%=rs("id")%>">修改</a> 
            <%end if%>
          </td>
          <td align="center"> 
            <%if instr(session("admin_qs"),3)>0 then%>
            <a href="ftbbsdel.asp?id=<%=rs("id")%>&tb=ftbbs_bmtb&flag=3">删除</a> 
            <%end if%>
          </td>
        </tr>
        <%
 rs.movenext
 next
rs.close
set rs=nothing
%>
        <tr bgcolor="#f4f4f4" height=22> 
          <td height="25" colspan="17" align="right">&nbsp;共<font color=red><%= wzcount%></font>个用户<font color=red><%= wzrep%></font>/页 
            共<font color=red><%= wzpagecount%></font>页 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<%= FtbbsPage(wzpagecount,tyname1,tyvalue1,tyname2,tyvalue2)%>&nbsp;</td>
        </tr>
<%else%>
        <tr bgcolor="#f4f4f4" height=22> 
          <td height="25" colspan="17" align="middle">记录为空</td>
        </tr>
<%end if%>
      </table>
</td>
  </tr>
</table>
</body>
</html>
<%closedb%>
