📄 dir_need.asp
字号:
value=上城区>上城区</OPTION><OPTION
value=下城区>下城区</OPTION><OPTION
value=成义区>成义区</OPTION><OPTION
value=宏软区>宏软区</OPTION><OPTION
value=萧山区>萧山区</OPTION><OPTION
value=江干区>江干区</OPTION></SELECT> </TD></TR>
<TR>
<TD class=12 height=23 width=44><FONT
color=#ffffff> </FONT><FONT
color=#000000>面积：</FONT></TD>
<TD class=12 height=23 width=111><SPAN class=9size><SPAN
id=fps4 style="FONT-SIZE: 9pt"><SELECT class=form
name=txtMianj> <OPTION selected value=%>---不
限---</OPTION> <OPTION value=A>50平方以下</OPTION> <OPTION
value=B>50-70平方</OPTION> <OPTION
value=C>70-90平方</OPTION> <OPTION
value=D>90-110平方</OPTION> <OPTION
value=E>110-150平方</OPTION> <OPTION
value=F>150平方以上</OPTION></SELECT></SPAN></SPAN> </TD></TR>
<TR>
<TD class=12 height=27 width=44><FONT
color=#ffffff> </FONT><SPAN class=9size><SPAN
style="FONT-SIZE: 9pt"><SPAN
id=fps3>租金：</SPAN></SPAN></SPAN></TD>
<TD class=12 height=27 width=111><SPAN id=fps5
style="FONT-SIZE: 9pt"><SELECT class=form name=txtJiag>
<OPTION selected value=%>---不 限---</OPTION> <OPTION
value=A>1-3百/月</OPTION> <OPTION
value=B>3-5百/月</OPTION> <OPTION
value=C>5-7百/月</OPTION> <OPTION
value=D>7百-1千/月</OPTION> <OPTION
value=E>1千以上/月</OPTION></SELECT></SPAN> </TD></TR>
<TR>
<TD class=12 height=27 width=44><FONT
color=#ffffff> </FONT><FONT
color=#000000>时间：</FONT></TD>
<TD class=12 height=27 width=111><SPAN class=9size><SPAN
id=fps6 style="FONT-SIZE: 9pt"><SELECT class=form
name=txtsj> <OPTION selected value=3600>---不
限---</OPTION> <OPTION value=7>七天内信息</OPTION> <OPTION
value=15>半月内信息</OPTION> <OPTION
value=30>一月内信息</OPTION> <OPTION
value=90>三月内信息</OPTION></SELECT></SPAN></SPAN> </TD></TR>
<TR>
<TD align=middle colSpan=2 height=9 width=155><INPUT name=Submit type=submit value=搜索> <INPUT name=Submit2 type=reset value=重置>
</TD></TR></TBODY></TABLE></TD></TR></FORM>
<TR>
<TD height=15
width="100%"></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width=167>
<TBODY>
<TR>
<TD>
<IMG height=37 src="images/old_left3.jpg"
width=167></TD></TR></TBODY></TABLE><LINK
href="file:///D|/ASP/house/images/realty.css" rel=stylesheet
type=text/css></TD>
<TD align=middle bgColor=#ffffff height=489 vAlign=top>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="96%">
<TBODY>
<TR>
<TD>
<TABLE border=0 borderColor=#111111 cellPadding=0 cellSpacing=0
id=AutoNumber4 style="BORDER-COLLAPSE: collapse" width="100%">
<TBODY>
<TR>
<TD background=images/lv5-5.jpg height=25 vAlign=top
width=554><B><FONT color=#000080><SPAN
style="FONT-SIZE: 10.5pt"> 求购求租信息</SPAN></FONT></B></TD></TR>
<TR>
<TD bgColor=#e4e4cb height=6 style="BORDER-LEFT: medium none"
vAlign=bottom width=567>
<TABLE border=0 borderColor=#111111 cellPadding=0
cellSpacing=0 style="BORDER-COLLAPSE: collapse" width="98%">
<TBODY>
<TR>
<TD align=right>
<%
set rs=server.createobject("adodb.recordset")
sql= "SELECT * FROM need order by ZID Desc "
rs.open sql,conn,1,1
if rs.eof and rs.bof then %>
<p align="center"><font color="#FF0000">还没有求购求租信息！</font></p>
<% else
rs.pagesize=25
totalPut=rs.recordcount '记录总数
totalPage=rs.pagecount
MaxPerPage=rs.pagesize
if currentpage<1 then
currentpage=1
end if
if currentpage>totalPage then
currentpage=totalPage
end if
if currentPage=1 then
showpages
showContent
showpages1
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark '移动到开始显示的记录位置
showpages
showContent
showpages1
else
end if
end if
rs.close
end if
set rs=nothing
conn.close
set conn=nothing
sub showContent
dim i,j
%></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD style="BORDER-LEFT: medium none" vAlign=top width=567>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber6">
<tr>
<td valign="top" style="border-left-style: none; border-left-width: medium">
<table width="100%" bordercolor="#C0C0C0" style="border-collapse: collapse" border="1">
<tr bgcolor="#00CCFF" class="9size" valign="bottom">
<td width="43" bgcolor="#C6C68C" style="border-style: solid; border-width: 1"> <p align="center">类 别</td>
<td width="54" bgcolor="#C6C68C" style="border-style: solid; border-width: 1"> <div align="center">需求区域</div></td>
<td width="181" bgcolor="#C6C68C" style="border-style: solid; border-width: 1"> <div align="center">需求地段</div></td>
<td width="57" bgcolor="#C6C68C" style="border-style: solid; border-width: 1"> <div align="center"><font size="2"><span class="9size">
需求面积</span></font></div></td>
<td width="74" bgcolor="#C6C68C" style="border-style: solid; border-width: 1"> <div align="center"> 价 格</div></td>
<td width="41" bgcolor="#C6C68C" style="border-style: solid; border-width: 1"> <p align="center">有效期</td>
<td width="65" bgcolor="#C6C68C" style="border-style: solid; border-width: 1"> <div align="center">登记时间</div></td>
<td width="58" bgcolor="#C6C68C" style="border-style: solid; border-width: 1"> <div align="center">
详情</div></td>
</tr>
<% i=1
do while not (rs.eof or err)%>
<tr bgcolor="<%If (i Mod 2) Then%>#EAEAEA<%Else%>#FFFFFF<%End If%>">
<td width="43" align="center" style="border-style: solid; border-width: 1"> <span style="font-size:9pt">
<%=(rs.Fields.Item("qiu").Value)%></span> </td>
<td width="54" style="border-style: solid; border-width: 1">
<div align="center"><span style="font-size:9pt"><%=(rs.Fields.Item("Diduan").Value)%></span></div></td>
<td width="181" style="border-style: solid; border-width: 1">
<div align="center"><span style="font-size:9pt"><%=(rs.Fields.Item("Xiaoqm").Value)%></span></div></td>
<td width="57" style="border-style: solid; border-width: 1">
<div align="center"><span style="font-size:9pt"><%=(rs.Fields.Item("Mianj").Value)%></span><span style="font-size: 9pt"></font>M<sup>2</sup></span></div></td>
<td width="74" style="border-style: solid; border-width: 1">
<div align="center"><span style="font-size:9pt"><%=(rs.Fields.Item("Jiag").Value)%><% If (rs.Fields.Item("qiu").Value="求购") Then
response.Write("万元")
else
response.Write("元/月")
end if %>
</span></div></td>
<td width="41" align="center" style="border-style: solid; border-width: 1"> <span style="font-size:9pt">
<%=(rs.Fields.Item("D").Value)%>天</span></td>
<td width="65" style="border-style: solid; border-width: 1">
<div align="center"><span style="font-size:9pt"><%=(rs.Fields.Item("Dat").Value)%></span></div></td>
<td width="58" style="border-style: solid; border-width: 1">
<div align="center"><a target="_blank" onClick="return newpage(this.href);" href="list_need.asp?zid=<%= rs.Fields.Item("zid").Value %>&typeto=need" ><span style="font-size:9pt"><font color="#0033FF">详情</font></span></a></div></td>
</tr>
<%
if i>=MaxPerPage then exit do '循环时如果到尾部则先退出，如果记录达到页最大显示数，也退出
i=i+1
rs.movenext
loop
%>
</table>
<%end sub %> <%sub showpages() %> <table width="98%">
<tr>
<td align="right"><div align="left"><span style="font-size:9pt">共<font color="#FF0000"><%=totalPage%></font>页/<font color="red"><%=totalPut%></font>条求购求租信息</span></div></td>
</tr>
</table>
<%
end sub
sub showpages1()
dim n
n=totalPage
%> <form action="dir_need.asp" method="GET" align="right">
<div align="center">
<center>
<table width="108%" height="30" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" height="30" bgcolor="#E4E4CB">
<p align="center"><span style="font-size:9pt">
共<font color="#FF0000"><%=totalPage%></font>页/<font color="red"><%=totalPut%></font>条求购求租信息</span>
<% If currentPage <> 1 Then %>
<A href=dir_need.asp><font color="#FF6600"><span style="font-size:9pt">[首页]</span></font></A>
<A href=dir_need.asp?Page=<%= (currentPage-1) %> ><font color="#FF6600"><span style="font-size:9pt">[上一页]</span></font></A>
<% End If %>
<% If currentPage <> rs.PageCount Then %>
<A href=dir_need.asp?Page=<%= (currentPage+1) %> ><font color="#FF6600"><span style="font-size:9pt">[下一页]</span></font></A>
<A href=dir_need.asp?Page=<%= totalPage %>><font color="#FF6600"><span style="font-size:9pt">[尾页]</span></font></A>
<% End If %>
<span style="font-size:9pt">第<font color="#FF0000"><%=currentPage%></font>页/共<font color="#FF0000"><%=totalPage%></font>页
<% response.write " 转到：<select name='page' size=1 class=smallselsect style='font-family: 宋体; font-size: 9pt;'>"
for i=1 to n
response.write "<option value="& i
if currentpage=i then
response.write " selected"
end if
response.write ">"& i &"</option>"
next
response.write "</select>"
response.write " <input class=buttonface type='submit' value='go' style='font-family: 宋体; font-size: 9pt;'>"
%>
</span> </td>
</tr>
</table>
</center>
</div>
</form>
<%end sub%>
</td>
</tr>
<tr>
<td width="100%"> </td>
</tr>
</table>
<CENTER>
</FORM></CENTER></TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD align=right>
<IMG height=67 src="images/old_mimg.jpg"
width=551></TD></TR></TBODY></TABLE></TD>
<TD bgColor=#f2f6db></TR></TBODY></TABLE>
<TR>
<TD bgColor=#edf4c1 width=0>
<P> </P></TR></TABLE>
</body>
</html>
<!--#include file="inc/bottom.asp"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -