📄 viewgbook.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="session3.asp"-->
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table cellpadding="3" cellspacing="1" border="0" width="100%" class="tableBorder" align=center>
<tr>
<th class="tableHeaderText" height=25 colspan=2>查看反馈信息</th>
</tr>
<tr>
<td class="forumRowHighlight" colspan=2> <div align="right">选择查看类型
<select name="select" onChange="var jmpURL=this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}" ><base target=Right>
<option selected>选择信息类型</option>
<option value="viewgbook.asp?lx=0" >查看所有类型</option>
<option value="viewgbook.asp?lx=1" >普通留言</option>
<option value="viewgbook.asp?lx=5" >产品投诉</option>
<option value="viewgbook.asp?lx=6" >服务投诉</option>
<option value="viewgbook.asp?lx=2" >对网站的意见</option>
<option value="viewgbook.asp?lx=3" >对公司的建议</option>
</select>
</div></td>
</tr>
<tr>
<td width="89%" class="forumRowHighlight">
<%sub leixing()
select case rs("feedbackleixing")
case "1"
response.write "简单的留言"
case "2"
response.write "对网站的意见"
case "3"
response.write "对公司的建议"
case "4"
response.write "具有合作意向"
case "5"
response.write "产品投诉"
case "6"
response.write "服务投诉"
end select
end sub
%>
<%'开始分页
Const MaxPerPage=5
dim totalPut
dim CurrentPage
dim TotalPages
dim j
dim sql
if Not isempty(request("page")) then
currentPage=Cint(request("page"))
else
currentPage=1
end if
dim lx
lx=request.QueryString("lx")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from wq_feedback order by feedbackdate desc",conn,1,1
if err.number<>0 then
response.write "数据库中无数据"
end if
if rs.eof And rs.bof then
Response.Write "<p align='center' class='contents'> 对不起，暂时还没有任何信息！</p>"
else
totalPut=rs.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showContent
showpage totalput,MaxPerPage,"viewgbook.asp"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showContent
showpage totalput,MaxPerPage,"viewgbook.asp"
else
currentPage=1
showContent
showpage totalput,MaxPerPage,"viewgbook.asp"
end if
end if
end if
sub showContent
dim i
i=0
%>
<%do while not rs.eof%>
<%response.write "发表类型：<font color=red>"
call leixing()
response.write "</font> 用户：<font color=red>"&trim(rs("feedbackusername"))&"</font> 邮箱:<a href=mailto:"&trim(rs("feedbackemail"))&" title=此用户访问IP地址是："&trim(rs("feedbackip"))&">"&trim(rs("feedbackemail"))&"</a> 所在地："&trim(rs("feedbacklaizi"))&" 电话："&trim(rs("feedbacktel"))%> </td>
<td width="11%" class="forumRowHighlight"> <div align="center"><a href="delfeedback.asp?id=<%=rs("feedbackid")%>" onClick="return confirm('您确定删除吗？')">删
除</a></div></td>
</tr>
<tr>
<td class="forumRowHighlight" colspan=2> <div align="center"><strong><%=trim(rs("feedbacksubject"))%></strong></div></td>
</tr>
<tr>
<td class="forumRowHighlight" colspan=2><%=trim(rs("feedbackcontent"))%><br> <div align=right><%="发表时间："&rs("feedbackdate")%></div></td>
</tr>
<tr>
<td class="forumRowHighlight" colspan=2><div align="center">
<%i=i+1
if i>=MaxPerPage then Exit Do
rs.movenext
loop
rs.close
set rs=nothing%>
<%
End Sub
Function showpage(totalnumber,maxperpage,filename)
Dim n
If totalnumber Mod maxperpage=0 Then
n= totalnumber \ maxperpage
Else
n= totalnumber \ maxperpage+1
End If
Response.Write "<form method=Post action="&filename&"?lx="&lx&">"
Response.Write "<p align='center' class='contents'> "
If CurrentPage<2 Then
Response.Write "<font class='contents'>首页 上一页</font> "
Else
Response.Write "<a href="&filename&"?page=1&lx="&lx&" class='contents'>首页</a> "
Response.Write "<a href="&filename&"?page="&CurrentPage-1&"&lx="&lx&" class='contents'>上一页</a> "
End If
If n-currentpage<1 Then
Response.Write "<font class='contents'>下一页 尾页</font>"
Else
Response.Write "<a href="&filename&"?page="&(CurrentPage+1)&"&lx="&lx&"&class='contents'>"
Response.Write "下一页</a> <a href="&filename&"?page="&n&"&lx="&lx&"&class='contents'>尾页</a>"
End If
Response.Write "<font class='contents'> 页次：</font><font class='contents'>"&CurrentPage&"</font><font class='contents'>/"&n&"页</font> "
Response.Write "<font class='contents'> 共有"&totalnumber&"条信息 "
Response.Write "<font class='contents'>转到：</font><input type='text' name='page' size=2 maxlength=10 class=smallInput value="¤tpage&">"
Response.Write " <input type='submit' class='button' value='GO' name='cndok'></form>"
End Function
%>
</div></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -