📄 old_old.asp
字号:
<%
old4=request("old4")
if old4="地级市" then
%>
<script language=javascript>
history.back()
alert("请先选择站点！")
</script>
<%
Response.End
end if
%>
<!--#include file="head.asp"-->
<!--#include file="diao.asp"-->
<TABLE width=760 border=0 align=center cellPadding=0 cellSpacing=0 bgcolor="#FFFFFF" class=bk>
<TBODY>
<TR>
<TD vAlign=top align=middle width=150
background=images/index_00.gif
height=500>
<!--#include file="left.asp"-->
<br> </TD>
<TD vAlign=top align=middle height=300 rowSpan=12>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=middle> <table width="100%" border="0" cellpadding="0" cellspacing="0" background="images/sj_dhtp.jpg" >
<tr>
<td width="4%"><img src="images/sj_dh.jpg" width="29" height="28"></td>
<td width="71%"> </td>
<td width="25%"> </td>
</tr>
</table></TD>
</TR>
<TR>
<TD align=left valign="top">
<% old2=request("old1")
old1=request("old2")
if old1="s_" then
e1="出售"
else
e1="出租"
end if
if old2="zhu_zai" then
e2="住宅"
else if old2="xie_zi" then
e2="写字楼"
else if old2="shang_pu" then
e2="商铺"
else
e2="厂房"
end if
end if
end if
e3=trim(request("old3"))
citye=e3
if citye="任意区县" then
citye="任意区县"
end if
response.Write "<div align=center><b>" &old4&" - "&citye&"<br>二手房 — "&e2&" — "&e1&"信息</div></b><br>"
%>
</div><!-- #include file="lwconn.asp" -->
<% table=old1&old2
info_type=trim(request("info_type"))
company=trim(request("company"))
if info_type="1" and company="1" then
%>
<script language=javascript>
history.back()
alert("请选择中介名称！")
</script>
<%
Response.End
end if
set rs=server.createobject("adodb.recordset")
sql="select * from "&table&" where 1=1 "
if info_type="2" then
sql=sql&" and info_type='2' "
else if info_type="1" then
sql=sql&" and info_type='1' and company='"&company&"' "
else
sql= sql&" "
end if
end if
if e3="任意区县" then '任意区县
sql =sql & " and area2='"&old4&"' "
else
sql =sql & " and area3='"&e3&"' "
end if
sql=sql& " order by id desc "
rs.open sql,conn,1,1
if rs.eof or rs.bof then
response.Write("<br><div align=center>数据库中暂无任何记录！</div>")
else%>
<TABLE style="BORDER-COLLAPSE: collapse"
borderColor=#dedede cellSpacing=0 cellPadding=4
width="98%" align=center border=0>
<TR vAlign=bottom bgColor=#00ccff>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"
bgColor=#99ccff><div align="center"> 物业名称 </div></TD>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"
bgColor=#99ccff>地段</TD>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"
bgColor=#99ccff> 物业类型</TD>
<% if table="s_zhu_zai" then %>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"
bgColor=#99ccff>楼层</TD>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"
bgColor=#99ccff> 户型</TD>
<% end if%>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"
bgColor=#99ccff>面 积<br>(平方米)</TD>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"
bgColor=#99ccff> <%
if old1="s_" then
response.write "总 价<br>(万元)"
else
response.write "租 金<br>(元／月)"
end if
%></TD>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"
bgColor=#99ccff>信息类别 </TD>
</TR>
<%if request.querystring("page")="" then
curpage = 1
else
curpage = cint(request.querystring("page"))
end if
'================================修改2处：显示的记录数===============
rs.pagesize=15 '每页显示15条新闻
rs.absolutepage = curpage
pagecount=curpage
n=1
do while not rs.eof%>
<TR bgColor=#f8f8f8>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"
align=middle><a href="old_show.asp?id=<%=rs("id")%>&old1=<%=old1%>&old2=<%=old2%>"><font color="#CC3300"><%=rs("name2")%></font></a></TD>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid">
<%
add=rs("address")
if len(add)>10 then
add=left(rs("address"),10)&"..."
end if
response.write add
%></TD>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><%=rs("ttype")%></TD>
<% if table="s_zhu_zai" then %>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><%=rs("floor")%>/<%=rs("total_floor")%></TD>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><%=rs("room_type")%></TD>
<% end if%>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><%=rs("mian_ji")%></TD>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><%
if old1="s_" then
response.write rs("total_price")
else
response.write rs("price")
end if
%></TD>
<TD
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><%if rs("info_type")="1" then
response.write "中介"
else
response.write "非中介"
end if%></TD>
</TR>
<%rs.movenext
n=n+1
if n>rs.pagesize then exit do
loop
%>
</table>
<% response.Write("<br><div align=center> ")
filename="?old1="&old2&"&old2="&old1&"&old3="&e3&"&old4="&old4&"&info_type="&info_type&"&company="&company&"&"
if PageCount=1 then
response.write "<font color='#000064'>首页 上页</font> "
else
response.write "<a href="&filename&"page=1><font color='0000BE'>首页</font></a> "
response.write "<a href="&filename&"page="&(pagecount-1)&"><font color='0000BE'>上页</font></a> "
end if
if rs.PageCount-pagecount<1 then
response.write "<font color='#000064'>下页 尾页</font>"
else
response.write "<a href="&filename&"page="&(pagecount+1)&"><font color='0000BE'>下页</font></a> "
response.write "<a href="&filename&"page="&rs.PageCount&"><font color='0000BE'>尾页</font></a>"
end if
response.write "<font color='000064'> 页次:<font color=blue>"&pagecount&"</font>/"&rs.PageCount&"页</font></div><br> "
'end end*********************
end if
rs.close
set rs=nothing
%>
</TD>
</TR>
</TBODY>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=middle vAlign=top> <IMG
height=3
src="images/index_li2.gif"></TD>
</TR>
</TBODY>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR></TR>
</TBODY>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR></TR>
</TBODY>
</TABLE>
</TD>
</TR>
<TR></TR>
<TR></TR>
<TR></TR>
<TR>
</TR>
</TBODY>
</TABLE>
<!--#include file="footer.asp"-->
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -