<!--#include file="geditop.asp"-->
<%function HTMLEncode(fString)
if not isnull(fString) then
    fString = replace(fString, ">", "&gt;")
    fString = replace(fString, "<", "&lt;")
    fString = Replace(fString, CHR(32), "&nbsp;")
    fString = Replace(fString, CHR(9), "&nbsp;")
    fString = Replace(fString, CHR(34), "&quot;")
    fString = Replace(fString, CHR(39), "&#39;")
    fString = Replace(fString, CHR(13), "")
    fString = Replace(fString, CHR(10) & CHR(10), "</P><P> ")
    fString = Replace(fString, CHR(10), "<BR> ")
    HTMLEncode = fString
end if
end function
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 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 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="930" border="0" id="table1">
		<tr>
			<td  height="25" colspan="4" class="tdtop"><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="224" valign="top"><!--#include file="jingjiax.asp"--></td>
			<td  height="25" bgcolor="#FFFFFF" width="46" valign="top" align="center">
			<img border="0" src="<%=css%>bgfox6.jpg"></td>
			<td  height="25" bgcolor="#FFFFFF" width="10" valign="top">
　</td>
			<td  height="25" bgcolor="#FFFFFF" width="656" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0" class="table2">
	<tr>
		<td><table cellSpacing="0" cellPadding="0" width="100%" border="0" id="table63">
			<tr>
				<td height="24" class="tdbg2">
				&nbsp;魅力名片列表</td>
			</tr>
			</table>
<%dim rsfoxf,sqlfoxf
tj=1
set rsfoxf=server.createobject("adodb.recordset")
 sqlfoxf="SELECT * FROM FOX_mp where yz=1 and"
 If sheng<>"" Then sqlfoxf=sqlfoxf&" sheng="&sheng&" and"
 If shi<>"" Then sqlfoxf=sqlfoxf&" shi="&shi&" 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" height="105">

            <%do while not rsfoxf.eof%>
 <%dim rsq,sqlq,class1c,class2c,leixingc,shengc,shic
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="30" colspan="2" class="p10t" bgcolor="#D9EBE5">
				<p align="center">
				&nbsp;<img border="0" src="images/dot3.gif" width="11" height="11"></td>
              <td height="30" colspan="3" class="p10t" bgcolor="#D9EBE5">公司名称：<strong style="font-weight: 400"><a href="mpinfo.asp?fox=<%=rsfoxf("id")%>"><%=rsfoxf("company")%></a></b></font></strong>&nbsp;&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="69" class="p9t" bgcolor="#F5F5F5" width="15%" rowspan="3" background="images/mp1.gif" align="center">
				　<DIV style="FILTER: shadow(color=#6495ED, strength=40); WIDTH: 100px"><FONT face=楷体 color=#9932cc size=4><B>
<CENTER><a href="mpinfo.asp?fox=<%=rsfoxf("id")%>"><%=rsfoxf("lxrname")%></a></CENTER>
<CENTER></B>　</CENTER></FONT></DIV></DIV></td>
              <td height="22" class="p9t" bgcolor="#F5F5F5" width="15%">
				名片所属：</td>
              <td height="22" width="69%" colspan="2">
             <a href="mpindex.asp?class1=<%=class1%>&class2=<%=class2%>&sheng=<%=sheng%>&shi=<%=rsfoxf("shi")%>&leixing=<%=leixing%>"><%=shic%></a> <- <a href="mpindex.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="69%" class="p9t" colspan="2">
				　<%=rsfoxf("dizhi")%></td>
            </tr>            

            <tr>
              <td height="25" width="1%" class="p9t" bgcolor="#F5F5F5">
				　</td>
              <td height="25" class="p9t" bgcolor="#F5F5F5" width="15%">
				联系方式：</td>
              <td height="25" width="49%" class="p9t">
				<p align="left"> <font color="#FF0000"><%=left(rsfoxf("usertel"),12)%></font></td>
              <td height="25" width="20%" class="p9t">
				<img border="0" src="images/how_icon2.gif" width="33" height="21"><a href="mpinfo.asp?fox=<%=rsfoxf("id")%>">名片查看</a></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>
 </td>
		</tr>
		
</table>
</div>

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