📄 dir.asp
字号:
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
%>
<table width="551" height="66" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#808080" bordercolordark="#808080" style="border-collapse: collapse">
<tr bgcolor="#99CC00" class="9size" valign="bottom">
<td width="13%" style="border-style: solid; border-width: 1" height="16">
<div align="center"> 编 号 </div></td>
<td width="14%" style="border-style: solid; border-width: 1" height="16">
<div align="center"><span style="font-size: 9pt">
所属区域</span></div></td>
<td width="13%" style="border-style: solid; border-width: 1" height="16">
<div align="center"> <span style="font-size: 9pt"> 地 点</span></div></td>
<td width="11%" style="border-style: solid; border-width: 1" height="16">
<div align="center"><span style="font-size: 9pt"> 套 型</span> </div></td>
<td width="8%" style="border-style: solid; border-width: 1" height="16">
<p align="center"> 楼层</td>
<td width="13%" style="border-style: solid; border-width: 1" height="16">
<div align="center"> <span style="font-size: 9pt"> 面积(M<sup>2</sup>)</span></div></td>
<td width="21%" style="border-style: solid; border-width: 1" height="16">
<div align="center"> <span style="font-size: 9pt">
<% If typeto="sale" Then
response.Write("价格")
else
response.Write("租金")
end if %>
</span> </div></td>
<td width="7%" style="border-style: solid; border-width:0" height="16">
<div align="center"> 管理</div></td>
</tr>
<% i=1
do while not (rs.eof or err)%>
<tr bgcolor="<%If (i Mod 2) Then%>#f2f6db<%Else%>#FFfFFF<%End If%>">
<td width="13%" height="44" style="border-style: solid; border-width: 0">
<div align="center">
<p align="center"><font color="green"> <span style="font-size:9pt">
<% If rs("num")="" Then %>
<%=rs("zid")%>
<% Else %>
<%= rs("num") %>
<% End If %>
</span> </font></div></td>
<td width="14%" 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="13%" style="border-style: solid; border-width: 1"> <div align="left"><span style="font-size:9pt">
<a target="_blank" onClick="return newpage(this.href);" href="../list.asp?zid=<%= rs.Fields.Item("zid").Value %>&typeto=<%= typeto %>"><font color="#000080"><%=(rs.Fields.Item("Xiaoqm").Value)%></font></a></span></div></td>
<td width="11%" style="border-style: solid; border-width: 1" align="center">
<span style="font-size:9pt"> <%=(rs.Fields.Item("Taox").Value)%></span></td>
<td width="8%" style="border-style: solid; border-width: 1" align="center">
<p align="center"><span style="font-size:9pt"><%=(rs.Fields.Item("Lc").Value)%></span></td>
<td width="13%" style="border-style: solid; border-width: 1"> <div align="center"><span style="font-size:9pt"><%=(rs.Fields.Item("Mianj").Value)%></span></div></td>
<td width="21%" style="border-style: solid; border-width: 1"> <div align="center"><span style="font-size:9pt"><%=(rs.Fields.Item("Jiag").Value)%><%=(rs.Fields.Item("fangshi").Value)%></span></div></td>
<td width="7%" style="border-style: solid; border-width: 1"> <div align="center">
<a href="list.asp?zid=<%= rs.Fields.Item("zid").Value %>&typeto=<%= typeto %>">
<font color="#0000FF"> </font></a><font color="#0000FF"><a href="delete.asp?<%= "zid=" & rs.Fields.Item("zid").Value &"&typeto="&typeto&"&page="¤tPage %>">
<font color="#0000FF">删除</font></a></font></div></td>
</tr>
<%
if i>=MaxPerPage then exit do '循环时如果到尾部则先退出，如果记录达到页最大显示数，也退出
i=i+1
rs.movenext
loop
%>
</table>
<p>
<%end sub %>
<%sub showpages() %>
<table width="98%" cellspacing="0" border="0" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0">
<tr>
<td align="right"><div align="right"><span style="font-size:9pt">
符合条件的房源共<font color="#FF0000"><%=totalPage%></font>页/<font color="red"><%=totalPut%></font>条</span></div></td>
</tr>
</table>
<%
end sub
dim n
n=totalPage
%>
<center>
<table width="108%" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td width="100%" bgcolor="#99CC00">
<div align="center">
<form action="dir.asp" method="GET" align="right">
<span style="font-size:9pt"> 共<font color="#FF0000"><%=totalPage%></font>页/<font color="red"><%=totalPut%></font>条房源</span>
<% If currentPage <> 1 Then %>
<A href=dir.asp?type=<%= request("type") %>><font color="#FF6600"><span style="font-size:9pt">
[首页]</span></font></A> <A href=dir.asp?type=<%= request("type") %>&Page=<%= (currentPage-1) %> ><font color="#FF6600"><span style="font-size:9pt">
[上一页]</span></font></A>
<% End If %>
<% If currentPage <> rs.PageCount Then %>
<A href=dir.asp?type=<%= request("type") %>&Page=<%= (currentPage+1) %> ><font color="#FF6600"><span style="font-size:9pt">
[下一页]</span></font></A> <A href=dir.asp?type=<%= request("type") %>&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 type='hidden' name='type' value="&typeto&">"
response.write " <input class=buttonface type='submit' value='go' style='font-family: 宋体; font-size: 9pt;'>"
%>
</span>
</form>
</div></td>
</tr>
</table>
</center>
<p> </TD>
</tr>
<tr>
<td height="6" width="567" style="border-left-style: none; border-left-width: medium" valign="bottom">
<%
set rs=server.createobject("adodb.recordset")
sql= "SELECT zid,Num,Diduan, Fangx, Taox, Mianj, M, Lc,Jiag, J, Xiaoqm, Tele, Content,Dat,fangshi,dj, "& typeto &".Dat FROM "& typeto &" where uid='"&uid&"'order by dat Desc "
rs.open sql,conn,1,1
if rs.eof and rs.bof then
end if %>
</TR></TBODY></TABLE><MAP
name=Map><AREA shape=RECT coords=66,65,147,87
href='javascript:pass("myziliao.asp")'><AREA shape=RECT coords=26,109,82,131
href="manage.asp"><AREA shape=RECT
coords=122,112,178,131 href="logout.asp"></MAP>
<META http-equiv=Content-Language content=zh-cn>
<STYLE type=text/css>.font12 {
FONT-SIZE: 12px; LINE-HEIGHT: 15px
}
</STYLE>
</BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -