<%=GetQueryString("WindowName")%>
<%
'从这开始读数据
strSQL="Select * From web_guestbook1 Where mn_id=" & strCurrMenu & " Order By id Desc"
rs.open strSQL,conn,1,1
'分页显示初始化
page=GetVariable("page")
if page="" then
page=1
else
page=Cint(page)
end if
Section=GetVariable("section")
if Section="" then
Section=1
else
Section=Cint(Section)
end if
'变量赋值
intPageSize=15 '每页显示记录数
intSectionSize=5 '多少页为一段,像GOOGLE一样
PrevSectionText="7" '上一段的链接文字
NextSectionText="8" '下一段的链接文字
PrevPageText="3" '上页的链接文字
NextPageText="4" '下页的链接文字
strPageUrl="?mnid=" & GetVariable("mnid") & "&WindowName=" & GetQueryString("WindowName")
rs.pagesize=intPageSize
intCount=rs.RecordCount
intPageCount=rs.pagecount
intSectionCount=(intPageCount - 1) \ intSectionSize + 1
if intCount>0 then
rs.AbsolutePage=page
end if
%>
留言板管理
<%
'循环输出
for i=1 to intPageSize
if rs.eof then exit for
if i mod 2=0 then
strColor="#eeeeee"
else
strColor="#f9f9f9"
end if
%>
姓 名:
<%=trim(rs("g_Name"))%>
<%if isDW<>"none" then%>
单 位:
<%=trim(rs("g_dw"))%>
<%End if%>
<%if isEmail<>"none" then%>
电子邮件:
<%=trim(rs("g_email"))%>
<%End if%>
<%if isAdrr<>"none" And isAdrr<>"Null" then%>
地 址:
<%=trim(rs("g_addr"))%>
<%End if%>
<%if isTel<>"none" then%>
电 话:
<%=trim(rs("g_tel"))%>
<%End if%>
<%if isOICQ<>"none" And isOICQ<>"Null" then%>
共有<%=intCount%>记录,分<%=intPageCount%>页,当前页<%=Page%>,每页显示<%=intPageSize%>条记录
<%
'计算每一段的开始页
intStarPage=(Section-2) * intSectionSize + 1
'前一段
if Section<=1 then
response.Write(PrevSectionText & " ")
else
response.Write("" & PrevSectionText & " ")
end if
'显示页码列表
response.Write("第")
intStarPage=(Section-1) * intSectionSize + 1
for p=intStarPage to intStarPage + intSectionSize - 1
if p > intPageCount then exit for
if p=page then
response.Write("[" & p & "] ")
else
response.Write("[" & p & "] ")
end if
next
response.Write("页")
'后一段
intStarPage=(Section) * intSectionSize + 1
if Section>=intSectionCount then
response.Write(" " & NextSectionText)
else
response.Write(" " & NextSectionText & " ")
end if
%>