📄 building_dir.asp
字号:
<!--#include file=../conn/conn1.asp -->
<% if request.cookies("okadmin")="" and request.cookies("rank")="" then
response.redirect "login.asp"
end if %>
<title>商品房</title>
<SCRIPT>
function fc(url){
var url; window.open(url,'_blank','status=no,scrollbars=yes,top=20,left=110,width=600,height=470');
}
</SCRIPT>
<script language="JavaScript">
function click(e) {
if (document.all) {
if (event.button==2||event.button==3) {
oncontextmenu='return false';
}
}
if (document.layers) {
if (e.which == 3) {
oncontextmenu='return false';
}
}
}
if (document.layers) {
document.captureEvents(Event.MOUSEDOWN);
}
document.onmousedown=click;
document.oncontextmenu = new Function("return false;")
</script>
<%
dim MaxPerPage
dim sql
dim rs
dim gstBookID
dim totalPut
dim CurrentPage
dim TotalPages
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
%>
<html>
<head>
<style type="text/css">{ }
.9size { font-family: "宋体"; font-size: 9pt; color: #000000; text-decoration: none}
.txt { font-family: "宋体"; font-size: 9pt; color: #000000; text-decoration: none; background-color: #FFFFFF}
.link { font-family: "宋体"; font-size: 9pt; color: #000000; text-decoration: underline; cursor: hand; page-break-before: auto; page-break-after: auto?, OffX=20, OffY=30, Positive=50); page-break-before: auto; page-break-after: auto}
a:hover { font-family: "宋体"; font-size: 9pt; color: #FFFFFF}
.10size { font-family: "宋体"; font-size: 8pt; color: #000000; text-decoration: none }
-->
</style>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#000000" vlink="#000000">
<center>
<div align="center">
<center>
<table width="98%" height="169" border="0" cellpadding="0" cellspacing="0" bordercolor="#111111" style="border-collapse: collapse">
<tr valign="top">
<td width="567" valign="bottom" style="border-left-style: none; border-left-width: medium">
</td>
</tr>
<tr valign="top">
<td width="100%" valign="top" style="border-left-style: none; border-left-width: medium">
<%
set rs=server.createobject("adodb.recordset")
sql= "SELECT * FROM building order by ID Desc "
rs.open sql,conn,1,1
if rs.eof and rs.bof then %> <p align="center">还没有商品房信息！</p>
<% else
rs.pagesize=20
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
%> <br>
<div align="center">
<center>
<table width="98%" height="61" bordercolor="#111111" style="border-collapse: collapse" border="1" bordercolorlight="#D1D1A5" bordercolordark="#D1D1A5" cellpadding="2">
<tr valign="bottom" class="9size">
<td width="97" height="19" valign="middle" " align="center" bgcolor="#D1D1A5">
<p align="center"><STRONG><FONT
color=#333333>区域</FONT></STRONG></td>
<td width="151" height="19" valign="middle" " align="center" bgcolor="#D1D1A5">
<p align="center"><STRONG><FONT
color=#333333>地段</FONT></STRONG></td>
<td width="97" height="19" valign="middle" " align="center" bgcolor="#D1D1A5">
<p align="center">
<STRONG><FONT color=#333333>设计用途</FONT></STRONG></td>
<td width="102" height="19" valign="middle" " align="center" bgcolor="#D1D1A5">
<p align="center">
<STRONG><FONT color=#333333>信息价</FONT></STRONG></td>
<td width="195" height="19" valign="middle" " align="center" bgcolor="#D1D1A5">
<P align="center"><STRONG>开发单位</STRONG></P></td>
<td width="93" height="19" valign="middle" " align="center" bgcolor="#D1D1A5">
<p align="center">
<strong>删 除</strong></td>
</tr>
<% i=1
do while not (rs.eof or err)%>
<tr>
<td width="97" height="16" ">
<p align="center">
<p align="center"><span style="font-size:9pt"><font color="#003399"><%= rs("qushu") %></font></span></td>
<td width="151" height="16" ">
<p align="center">
<p align="center"><span style="font-size:9pt"><a href="javascript:fc('../building_list.asp?id=<%=rs("id")%>')"><font color="#0000FF"><%= rs("name") %></font></a></span></td>
<td width="97" height="16" ">
<p align="center">
<p align="center"><span style="font-size:9pt"><font color="#003399"><%= rs("cjyt") %></font></span></td>
<td width="102" height="16" ">
<p align="center">
<p align="center"><span style="font-size:9pt">
<font color="#003399">
<%= rs("price") %></font></span></td>
<td width="195" height="16" ">
<p align="center">
<p align="center"><span style="font-size:9pt"><font color="#003399"><%= rs("who") %></font></span></td>
<td width="93" height="16" ">
<p align="center">
<p align="center"> <font color="#0000FF"><span style="font-size:9pt">
<a target="main" href="building_delete.asp?id=<%=rs("id") &"&page="¤tPage %>">
<font color="#800080">删除</font></a></span></font></td>
</tr>
<%
if i>=MaxPerPage then exit do '循环时如果到尾部则先退出，如果记录达到页最大显示数，也退出
i=i+1
rs.movenext
loop
%>
</table>
</center>
</div>
<%end sub %> <%sub showpages() %>
<table width="100%">
<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
sub showpages1()
dim n
n=totalPage
%> <form action="building_dir.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"> <div align="left"><span style="font-size:9pt">
共<font color="#FF0000"><%=totalPage%></font>页/<font color="red"><%=totalPut%></font>条商品房信息</span>
<% If currentPage <> 1 Then %>
<A href=building_dir.asp><font color="#FF6600"><span style="font-size:9pt">[首页]</span></font></A>
<A href=building_dir.asp?Page=<%= (currentPage-1) %> ><font color="#FF6600"><span style="font-size:9pt">[上一页]</span></font></A>
<% End If %>
<% If currentPage <> rs.PageCount Then %>
<A href=building_dir.asp?Page=<%= (currentPage+1) %> ><font color="#FF6600"><span style="font-size:9pt">[下一页]</span></font></A>
<A href=building_dir.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> </div></td>
</tr>
</table>
</center>
</div>
</form>
<%end sub%> </td>
</tr>
</table>
</center>
</div>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -