www.gusucode.com > 公寓出租网站整站源码 1.0程序 > FeedbackView.asp
<!--#include file="top.asp"-->
<tr>
<td><table width="977" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="237" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="37" valign="bottom" background="images/18.gif"><table width="50%" height="25" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><b>公寓分类</b></td>
</tr>
</table></td>
</tr>
<tr>
<td background="images/22.gif"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td style="line-height:25px;"><% call ShowSmallClass_Tree() %></td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="images/28.gif" width="237" height="10" alt="" /></td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="37" valign="bottom" background="images/18.gif"><table width="50%" height="25" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><b>公寓查询</b></td>
</tr>
</table></td>
</tr>
<tr>
<td background="images/22.gif"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" style="line-height:25px;"><% call ShowSearch(1) %></td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="images/28.gif" width="237" height="10" alt="" /></td>
</tr>
</table></td>
<td width="10" valign="top"> </td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10" valign="bottom" background="images/26.gif"><img src="images/26.gif" width="730" height="10" alt="" /></td>
</tr>
<tr>
<td background="images/23.gif"><table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><b>留言列表</b></td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="images/29.gif" width="730" height="10"></td>
</tr>
<tr>
<td><div align="center">
<table border="0" width="95%" cellpadding="0" style="border-collapse: collapse">
<tr>
<td align="left"><br>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from Feedback where Publish<>'1' order by id desc"
rs.open sql,conn,1,1
dim MaxPerPageFeedback
MaxPerPageFeedback=5
'取得页数,并判断留言输入的是否数字类型的数据，如不是将以第一页显示
dim text,checkpage
text="0123456789"
Rs.PageSize=MaxPerPageFeedback
for i=1 to len(request("page"))
checkpage=instr(1,text,mid(request("page"),i,1))
if checkpage=0 then
exit for
end if
next
If checkpage<>0 then
If NOT IsEmpty(request("page")) Then
CurrentPage=Cint(request("page"))
If CurrentPage < 1 Then CurrentPage = 1
If CurrentPage > Rs.PageCount Then CurrentPage = Rs.PageCount
Else
CurrentPage= 1
End If
If not Rs.eof Then Rs.AbsolutePage = CurrentPage end if
Else
CurrentPage=1
End if
call list
'显示帖子的子程序
Sub list()%>
<%
If rs.eof and rs.bof then
response.write "<br> 没有留言"
exit Sub
End if
%> <br>
<%
i=0
do while not rs.eof
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF" >
<tr bgcolor="#DFDFDF">
<td width="17%" height="22" align="right" bgcolor="#FF9257" >
主 题： </td>
<td colspan="5" bgcolor="#FF9257"> <%if rs("username")="管理员"then%>
[管理员公告]
<%end if%>
<%=rs("title")%></a></td>
</tr>
<tr bgcolor="#DFDFDF">
<td height="22" align="right" bgcolor="#FDDA98" > 反馈内容： </td>
<td colspan="5" align="center" bgcolor="#FDDA98" >
<table width="97%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="4"> </td>
</tr>
<tr>
<td height="40" ><%=rs("Content")%>
</td>
</tr>
<tr>
<td height="4"></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#EFEFEF">
<td height="22" align="right" bgcolor="#FDDA98" > 留言者： </td>
<td width="22%" bgcolor="#FDDA98" ><%=rs("Receiver")%>
</td>
<td width="12%" align="right" bgcolor="#FDDA98" >留言时间：</td>
<td width="17%" bgcolor="#FDDA98" ><%=rs("Time")%></td>
<td width="12%" align="right" bgcolor="#FDDA98" >回复时间：</td>
<td width="20%" bgcolor="#FDDA98" ><%=rs("Retime")%>
</td>
</tr>
<tr bgcolor="#DFDFDF">
<td height="22" align="right" bgcolor="#FDDA98" > 管理员回复： </td>
<td colspan="5" align="center" bgcolor="#FDDA98" >
<table width="97%" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td height="4"></td>
</tr>
<tr>
<td height="40" ><%if rs("ReFeedback")=""then%>
["未回复"]
<%else%>
<%=rs("ReFeedback")%>
<%end if%>
</td>
</tr>
<tr>
<td height="4"></td>
</tr>
</table></td>
</tr>
<tr valign="top" bgcolor="#F7F7F7">
<td height="12" colspan="6" ><img src="Images/Hrbackup.gif" width="96" height="10"></td>
</tr>
</table>
<%
i=i+1
if i >= MaxPerPageFeedback then exit do
rs.movenext
loop
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="right">
<%
Response.write "全部"
Response.write "共" & Cstr(Rs.RecordCount) & "条留言 "
Response.write "第" & Cstr(CurrentPage) & "/" & Cstr(rs.pagecount) & " "
If currentpage > 1 Then
response.write "<a href='FeedbackView.asp?&page="+cstr(1)+"'> 首页 </a>"
Response.write "<a href='FeedbackView.asp?page="+Cstr(currentpage-1)+"'> 上一页 </a>"
Else
Response.write " 上一页 "
End if
If currentpage < Rs.PageCount Then
Response.write "<a href='FeedbackView.asp?page="+Cstr(currentPage+1)+"'> 下一页 </a>"
Response.write "<a href='FeedbackView.asp?page="+Cstr(Rs.PageCount)+"'> 尾页 </a>"
Else
Response.write ""
Response.write " 下一页 "
End if
Response.write "转到第"
response.write"<select name='sel_page' onChange='javascript:location=this.options[this.selectedIndex].value;'>"
for i = 1 to Rs.PageCount
if i = currentpage then
response.write"<option value='FeedbackView.asp?page="&i&"&id="&id&"' selected>"&i&"</option>"
else
response.write"<option value='FeedbackView.asp?page="&i&"&id="&id&"'>"&i&"</option>"
end if
next
response.write"</select>页"
%>
</div></td>
</tr>
</table>
<%end sub%>
</TD>
</TR>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<%
rs.close
set rs=nothing
%>
</td>
</tr>
</table>
</div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<!--#include file="end.asp"-->