<!--#include file="top.asp"-->
<%
dim rsbo,sql1,sql2,sql3,sql4,sql5,class1,class2,sheng,shi,leixing,class1name,class2name,shengname,shiname,leixingname
dim ThisPage,Pagesize,Allrecord,Allpage,tj
class1=trim(request("class1"))
class2=trim(request("class2"))
sheng=trim(request("sheng"))
shi=trim(request("shi"))
leixing=trim(request("leixing"))
set rsbo=server.createobject("adodb.recordset")
if class1<>"" then
sql1="select class1 from FOX_class1 where id="&class1&""
rsbo.open sql1,conn,1,1
class1name=rsbo("class1")
rsbo.close
'set rsbo=nothing
end if
if class2<>"" then
sql2="select class2 from FOX_class2 where id="&class2&""
rsbo.open sql2,conn,1,1
class2name=rsbo("class2")
rsbo.close
'set rsbo=nothing
end if
if sheng<>"" then
sql3="select sheng from FOX_sheng where id="&sheng&""
rsbo.open sql3,conn,1,1
shengname=rsbo("sheng")
rsbo.close
'set rsbo=nothing
end if
if shi<>"" then
sql4="select shi from FOX_shi where id="&shi&""
rsbo.open sql4,conn,1,1
shiname=rsbo("shi")
rsbo.close
'set rsbo=nothing
end if
if leixing<>"" then
sql5="select leixing from FOX_lei where id="&leixing&""
rsbo.open sql5,conn,1,1
leixingname=rsbo("leixing")
rsbo.close
'set rsbo=nothing
end if

if request("page")="" then
  ThisPage=1		
else
  ThisPage=request("page")
end if
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>信息张贴--<%=title%>--<%=web%></title>
</head>

<body>

<div align="center">
<table cellSpacing="0" cellPadding="0" width="760" border="0" id="table1">
		<tr bgColor="#d9ebe5">
			<td  height="25" bgcolor="#C0C0C0" colspan="3"><b>&nbsp;<img border="0" src="images/z1.gif" width="50" height="18"> 您的位置  
			<font color="#FFFFFF">-></font> <a class="scap1" href="index.htm"><%=title%></a>
			<font color="#FFFFFF">-></font> 信息张贴频道：</b><font color="#FFFFFF"> -></font>
			<font color="#FF0000">&nbsp; <%=class1name%>&nbsp; <%=class2name%>&nbsp; <%=shengname%>&nbsp; <%=shiname%>&nbsp; <%=leixingname%></font></td>
		</tr>
		
		<tr bgColor="#d9ebe5">
			<td  height="25" bgcolor="#FFFFFF" width="252" valign="top"><!--#include file="jingjiax.asp"--></td>
			<td  height="25" bgcolor="#FFFFFF" width="4">　</td>
			<td  height="25" bgcolor="#FFFFFF" width="504" valign="top">
<table cellSpacing="0" cellPadding="0" width="100%" border="0" id="table63">
			<tr>
				<td width="6">
				<img height="6" src="images/idxtable01.gif" width="6"></td>
				<td class="titles01" vAlign="bottom" background="images/idxtdheadbg01.gif" rowSpan="2">
				<font color="#FFFFFF">信息张贴列表</font></td>
				<td align="right" width="52" rowSpan="2">
				<img height="24" src="images/idxtbhead01.gif" width="52"></td>
				<td width="6">
				<img height="6" src="images/idxtable02.gif" width="6"></td>
			</tr>
			<tr>
				<td bgColor="#ff6c3b">
				<img height="18" src="images/_scap.gif" width="6"></td>
				<td bgColor="#ff6c3b">
				<img height="18" src="images/_scap.gif" width="6"></td>
			</tr>
		</table>
<%dim rsfoxf,sqlfoxf
tj=1
set rsfoxf=server.createobject("adodb.recordset")
 sqlfoxf="SELECT * FROM FOX_xinxi where yz=1 and"
 If class1<>"" Then sqlfoxf=sqlfoxf&" class1="&class1&" and"
 If class2<>"" Then sqlfoxf=sqlfoxf&" class2="&class2&" and"
 If sheng<>"" Then sqlfoxf=sqlfoxf&" sheng="&sheng&" and"
 If shi<>"" Then sqlfoxf=sqlfoxf&" shi="&shi&" and"
 If leixing<>"" Then sqlfoxf=sqlfoxf&" leixing="&leixing&" and"
' if right(sqlfoxf,5)="where" then sqlfoxf=left(sqlfoxf,clng(len(sqlfoxf))-5)
 if right(sqlfoxf,3)="and" then sqlfoxf=left(sqlfoxf,clng(len(sqlfoxf))-3)
 sqlfoxf=sqlfoxf&" order by fbsj desc"
 rsfoxf.Open sqlfoxf,conn,1,3
 rsfoxf.Pagesize=10
Pagesize=rsfoxf.Pagesize
Allrecord=rsfoxf.Recordcount
Allpage=rsfoxf.Pagecount
if ThisPage<1 then                           
ThisPage=1                           
end if
On Error Resume Next
rsfoxf.move (ThisPage-1)*Pagesize
if rsfoxf.eof then
response.write "暂时没有！"
else
%>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#C0C0C0" style="border-collapse: collapse" id="table169">

            <%do while not rsfoxf.eof%>
 <%dim rsq,sqlq,class1c,class2c,leixingc,shengc,shic
set rsq=server.createobject("adodb.recordset") 
sqlq = "select class1 from [FOX_class1] where id="&rsfoxf("class1")&""
rsq.open sqlq,conn,1,1
class1c=rsq("class1")
rsq.close
set rsq=nothing
set rsq=server.createobject("adodb.recordset") 
sqlq = "select class2 from [FOX_class2] where id="&rsfoxf("class2")&""
rsq.open sqlq,conn,1,1
class2c=rsq("class2")
rsq.close
set rsq=nothing
set rsq=server.createobject("adodb.recordset") 
sqlq = "select leixing from [FOX_lei] where id="&rsfoxf("leixing")&""
rsq.open sqlq,conn,1,1
leixingc=rsq("leixing")
rsq.close
set rsq=nothing
set rsq=server.createobject("adodb.recordset") 
sqlq = "select sheng from [FOX_sheng] where id="&rsfoxf("sheng")&""
rsq.open sqlq,conn,1,1
shengc=rsq("sheng")
rsq.close
set rsq=nothing
set rsq=server.createobject("adodb.recordset") 
sqlq = "select shi from [FOX_shi] where id="&rsfoxf("shi")&""
rsq.open sqlq,conn,1,1
shic=rsq("shi")
rsq.close
set rsq=nothing
%>
            <tr bgcolor="#CCCCCC">
              <td colspan="5" height="1"></td>
            </tr> 

            <tr>
              <td height="22" width="1%" class="p9t" bgcolor="#F5F5F5">
				　</td>
              <td height="22" class="p9t" bgcolor="#F5F5F5" colspan="4">
				<table border="0" width="100%" id="table171" cellspacing="0" cellpadding="0">
            <tr>
              <td height="35" colspan="2" class="p10t" bgcolor="#D9EBE5">
				<p align="center">
				&nbsp;<img border="0" src="images/dot3.gif" width="11" height="11"></td>
              <td height="35" colspan="3" class="p10t" bgcolor="#D9EBE5"><strong style="font-weight: 400"><%if rsfoxf("ts")=0 then%>[<a href="xinxiindex.asp"><font color="#008080">信息</font></a>]<%else%>[<a href="adindex.asp"><font color="#FF0000">张贴</font></a>]<%end if%>&nbsp;<font color="#CC0000">[<a href="xinxilist.asp?class1=<%=class1%>&class2=<%=class2%>&sheng=<%=sheng%>&shi=<%=shi%>&leixing=<%=rsfoxf("leixing")%>"><%=leixingc%></a>]：</font><%if rsfoxf("xinxipic")<>"0" then%>[<font color="#FF0000">图</font>]<%else%><%end if%><font color="#009933"><b><%if rsfoxf("ts")=0 then%><a href="xinxiinfo.asp?fox=<%=rsfoxf("id")%>"><%else%><a href="adinfo.asp?fox=<%=rsfoxf("id")%>"><%end if%><%=rsfoxf("company")%></a></b></font></strong>&nbsp;时间：<font color="#666666"><%=rsfoxf("fbsj")%></font></td>
            </tr>
				</table>
				</td>
            </tr>

            <tr>
              <td height="22" width="1%" class="p9t" bgcolor="#F5F5F5">
				<p align="right">
				　</td>
              <td height="22" class="p9t" bgcolor="#F5F5F5" width="15%">
				信息所属：</td>
              <td height="22" width="46%">
             <a href="xinxilist.asp?class1=<%=class1%>&class2=<%=rsfoxf("class2")%>&sheng=<%=sheng%>&shi=<%=shi%>&leixing=<%=leixing%>"><%=class2c%></a> <- <a href="xinxilist.asp?class1=<%=rsfoxf("class1")%>&class2=<%=class2%>&sheng=<%=sheng%>&shi=<%=shi%>&leixing=<%=leixing%>"><%=class1c%></a></td>
              <td height="22" width="10%">
              属地：</td>
              <td height="22" width="26%">
              　<a href="xinxilist.asp?class1=<%=class1%>&class2=<%=class2%>&sheng=<%=sheng%>&shi=<%=rsfoxf("shi")%>&leixing=<%=leixing%>"><%=shic%></a> <- <a href="xinxilist.asp?class1=<%=class1%>&class2=<%=class2%>&sheng=<%=rsfoxf("sheng")%>&shi=<%=shi%>&leixing=<%=leixing%>"><%=shengc%></a></td>
            </tr>

            <tr>
              <td height="22" width="1%" class="p9t" bgcolor="#F5F5F5">
				　</td>
              <td height="22" class="p9t" bgcolor="#F5F5F5" width="15%">
				信息内容：</td>
              <td height="22" width="84%" class="p9t" colspan="3">
				<p align="left"><%=left(rsfoxf("memo"),60)%> ...</td>
            </tr>            <%
        tj=tj+1
        if tj>=Pagesize then exit do
        rsfoxf.movenext
        loop
        %>

            </table>

				<table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#111111" style="border-collapse: collapse" id="table170">
                <tr>
                  <td height="25" width="163" class="p9t"><p align="center"> 
					<font color="#CC5200"><%=Pagesize%></font> 条/页 &nbsp;共 <font color="#CC5200"><%=Allrecord%></font> 条记录</td>
                  <td height="25" width="103" class="p9t"><p align="center">共 <font color="#CC5200"><%=Allpage%></font> 页</td>
                  <td height="25" width="78" class="p9t"><p align="center">第 <font color="#CC5200"><%=ThisPage%></font> 页</td>
                  <td height="25" width="187" class="p9t"><p align="center">
 <%
if ThisPage<2 then     
response.write "<font color=""#808080"">首页</font>&nbsp;"
response.write "<font color=""#808080"">上一页</font>&nbsp;"     
else     
response.write "<a href=?page=1&class1="&class1&"&class2="&class2&"&sheng="&sheng&"&shi="&shi&"&leixing="&leixing&">首页</a>&nbsp;"
response.write "<a href=?page="&ThisPage-1&"&class1="&class1&"&class2="&class2&"&sheng="&sheng&"&shi="&shi&"&leixing="&leixing&">上一页</a>&nbsp;"     
end if
if Allpage-ThisPage<1 then     
response.write "<font color=""#808080"">下一页</font>&nbsp;"
response.write "<font color=""#808080"">尾页</font>&nbsp;"  
else     
response.write "<a href=?page="&(ThisPage+1)&"&class1="&class1&"&class2="&class2&"&sheng="&sheng&"&shi="&shi&"&leixing="&leixing&">下一页</a>&nbsp;"   
response.write "<a href=?page="&Allpage&"&class1="&class1&"&class2="&class2&"&sheng="&sheng&"&shi="&shi&"&leixing="&leixing&">尾页</a>&nbsp;"     
end if
%>  
                    </td>
                </tr>
              </table>


 <%end if
 rsfoxf.close
 set rsfoxf=nothing%>  
 </td>
		</tr>
		
</table>
</div>

</body>
<!--#include file="bottom.asp"--></body></html>