28,409
社区成员




<!--#include file="inc_common_sql.asp"-->
<!--#include file="UBB.asp"-->
<%
dim currentpage,page_count,Pcount
dim totalrec,endpage
if Request.QueryString("page")="" then
currentPage=1
else
currentPage=cint(Request.QueryString("page"))
end if
if login then
pagename="管理信息"
else
pagename="查看信息"
end if
call bodySkin()
sub pageContent()
showMsg()
end sub
function showMsg()
sql="select * from tv"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
rs.close
set rs=nothing
errinfo="<li>还没有任何记录。</li>"
call showError()
end if
rs.pagesize = perpage
rs.absolutepage=currentpage
page_count=0
totalrec=rs.recordcount
if not totalrec mod perpage=0 then
if currentPage > (totalrec/perpage)+1 then response.redirect "?page=" & Int((totalrec/perpage))+1
else
if currentPage > (totalrec/perpage) then response.redirect "?page=" & Int((totalrec/perpage))
end if
Response.write("<table border=1 width='97%' cellspacing=1 align=center cellpadding=3 bordercolor=#ad8c42 style=BORDER-COLLAPSE: collapse;><tr><td align=center width='25%'><b>序号</b></td><td align=center width='25%'><b>尺寸</b></td><td align=center width='25%'><b>位置</b></td><td align=center width='25%'><b>房间</b></td></tr>")
while (not rs.eof) and (not page_count = rs.pagesize)
dim x_xuhao,x_chicun,x_weizhi,x_fangjian
x_xuhao =rs("id")
x_chicun =rs("chicun")
x_weizhi = rs("weizhi")
x_fangjian = rs("fangjian")
%>
<a id="msg<%=rs("id")%>">
<tr class="title2" align="center">
<td>
<% response.write x_xuhao %>
</td>
<td>
<% response.write X_chicun %>
</td>
<td>
<% response.write X_weizhi %>
</td>
<td>
<% response.write X_fangjian %>
</td>
</tr>
<%
page_count = page_count + 1
rs.movenext
wend
%>
</table>
<%
rs.close
set rs=nothing
end function
%>