⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 feedbacklist.asp

📁 管理登录system 管理员:admin 密码:admin888 数据库链接文件: conn.asp 内容数据库前台链接文件 systemconn.asp 内容数据库后台链接文件 sy
💻 ASP
字号:
<!--#include file="SiteInfo.asp"-->
<%
'☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆
'★                                                                  ★
'☆                万博中小企业网站管理系统(NWEB)                    ☆
'★                                                                  ★
'☆  版权所有 Nweb.cn                                                ☆
'★                                                                  ★
'☆  程序制作 万博工作室                                             ☆
'★           Add:四川省彭州市西大街228号/611930                     ★
'☆           Tel:028-88079088  Fax:83708850                         ☆
'★           E-m:duolaimi-123@163.com                               ★
'☆           Q Q:59309100                                           ☆
'★                                                                  ★
'☆  相关网址 [产品介绍]http://www.Nweb.cn                           ☆
'★           [支持论坛]http://www.Nweb.cn/bbs                       ★
'☆                                                                  ☆
'★  演示网址 http://www.Nweb.cn                                     ★
'☆                                                                  ☆
'★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★
%>
<HTML>
<HEAD>
<TITLE>首页-留言反馈|<%=SiteName%></TITLE>
<META http-equiv="Content-Type" content="text/html; charset=gb2312">
<META NAME="copyright" CONTENT="Copyright 2004-2005 - NWEB.CN-STUDIO-多来米">
<META NAME="Author" CONTENT="万博网络技术工作室,www.Nweb.cn">
<META NAME="Robots" CONTENT="all">
<META NAME="Keywords" CONTENT="<%=Keywords%>">
<META NAME="Description" CONTENT="<%=Description%>">
<link href="Images/CSS.css" type=text/css rel=stylesheet>
</HEAD>
<BODY >
<!--#include file="Top.asp" -->
<table width="868" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="190" height="96" valign="top" bgcolor="#F2F2F2" ><!--#include file="LeftNav.asp" -->
        <!--#include file="FeedbackLeft.asp" --></td>
    <td width="5"></td>
    <td width="673" valign="top" class="Index-Center"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <!--DWLayoutTable-->
      <tr>
        <td height="180" colspan="2" bgcolor="#FFFFFF"><img src="Images/Banner_01.jpg" alt="万博中小企业网站系统" width="499" height="180"></td>
        <td width="172" align="right" bgcolor="#FFFFFF"><img src="Images/Banner_02.jpg" alt="万博中小企业网站系统" width="171" height="180"></td>
      </tr>
      <tr>
        <td width="93" height="5" bgcolor="#FFFFFF"></td>
        <td width="408" bgcolor="#FFFFFF"></td>
        <td bgcolor="#FFFFFF"></td>
      </tr>
      <tr>
        <td height="30" align="right" bgcolor="#F2F2F2"><strong><font color="#1c529b"><img src="Images/Arrow-locality.gif" width="14" height="12" align="absmiddle"> 当前位置:</font></strong></td>
        <td colspan="2" bgcolor="#F2F2F2" class="locality"><a href="index.asp">首 页</a> &gt;&gt; <a href="FeedbackList.asp">留言反馈</a> &gt;&gt; 信息列表</td>
      </tr>
      <tr>
        <td height="5" align="center" bgcolor="#FFFFFF"></td>
        <td colspan="2" align="center" bgcolor="#FFFFFF"></td>
      </tr>
    </table>
        <table width="100%" border="0" cellpadding="0" cellspacing="0" >
          <tr>
            <td height="12">&nbsp;</td>
            <td></td>
            <td></td>
          </tr>
          <tr>
            <td width="20" height="30">&nbsp;</td>
            <td align="center"><%
dim i,intPage,page,pre,last,filepath
set rsp = server.createobject("adodb.recordset")
productsSQL="select * from Feedback where outpub=true ORDER BY id DESC" 
'rsp.open productsSQL,conn,1,1

rsp.PageSize =5  '这里设定每页显示的记录数
rsp.CursorLocation = 3
rsp.Open productsSQL,conn,0,2,1  '这里执行你查询SQL并获得结果记录集
pre = true
last = true
page = trim(Request.QueryString("page"))
if len(page) = 0 then
    intpage = 1
    pre = false
else
    if cint(page) =< 1 then
       intpage = 1
       pre = false
    else
        if cint(page)>=rsp.PageCount then
           intpage = rsp.PageCount
           last = false
        else
           intpage = cint(page)
        end if
    end if
end if
if not rsp.eof then   rsp.AbsolutePage = intpage
if rsp.bof then Response.write"暂无相关信息!"

for i=1 to rsp.PageSize
if rsp.EOF or rsp.BOF then exit for
%>
              <table width="100%"  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF" >
                <tr bgcolor="#DFDFDF">
                  <td width="17%" height="22" align="right" bgcolor="#DFDFDF" class="News-05"> 主 题: </td>
                  <td colspan="5" bgcolor="#DFDFDF" class="News-05" >&nbsp;&nbsp;<font color="#990000"><%=rsp("title")%></font></td>
                </tr>
                <tr bgcolor="#DFDFDF">
                  <td height="22" align="right" bgcolor="#DFDFDF" class="News-05"> 反馈内容: </td>
                  <td colspan="5" align="center" bgcolor="#DFDFDF" class="News-05"><table width="97%"  border="0" cellpadding="0" cellspacing="0" class="ABOUT_01">
                      <tr>
                        <td height="4"></td>
                      </tr>
                      <tr>
                        <td height="40" class="News-05"><% if rsp("ss")=true then
				      if session("My_Login")="My_Login_Succeed" and session("Uname")<>"" then
                         set rsU=Server.CreateObject("Adodb.Recordset")
                         sql = "select * from UserInfo where Uname='"&session("Uname")&"'" 
                         rsU.open sql,conn,1,1
						 if rsU.recordcount>0 then
						   Uid=rsU("id")
                           rsU.close
                           set rsU=nothing 
						 end if     
	                       if rsp("Uid")=Uid then
					          comtont=rsp("comtont")
					          response.write ""&comtont&""
						   else 
						   
				   	        response.write "******** 悄悄话不可查看" 
						   end if
					  else
				   	     response.write "******** 悄悄话不可查看"  
					  end if
					else
					  comtont=rsp("comtont")
					  response.write ""&comtont&""

				   end if   %></td>
                      </tr>
                      <tr>
                        <td height="4"></td>
                      </tr>
                  </table></td>
                </tr>
                <tr bgcolor="#DFDFDF">
                  <td height="22" align="right" bgcolor="#DFDFDF" class="News-05"> 留言者: </td>
                  <td width="22%" bgcolor="#DFDFDF" class="News-05">&nbsp;&nbsp;<%=rsp("linkman")%>
                      <% if rsp("Uid")=0 then
			          response.write "<font color='#ff6600'>&nbsp;&nbsp;非会员</font>"
                   else
				   	  response.write "<font color='#ff6600'>&nbsp;&nbsp;会员</font>"
				   end if   %>                  </td>
                  <td width="12%" align="right" bgcolor="#DFDFDF" class="News-05">留言时间:</td>
                  <td width="17%" bgcolor="#DFDFDF" class="News-05">&nbsp;<%=rsp("addtime")%></td>
                  <td width="12%" align="right" bgcolor="#DFDFDF" class="News-05">回复时间:</td>
                  <td width="20%" bgcolor="#DFDFDF" class="News-05">&nbsp;
                      <% if rsp("re")="NoRe" then
				 			       response.write "未回复"
								   else
								   ret=rsp("retime")
				 			       response.write ""&ret&""
								   end if%></td>
                </tr>
                <tr bgcolor="#DFDFDF">
                  <td height="22" align="right" bgcolor="#DFDFDF" class="News-05"> 管理员回复: </td>
                  <td colspan="5" align="center" bgcolor="#DFDFDF" class="News-05"><table width="97%"  border="0" cellpadding="0" cellspacing="0" class="ABOUT_01">
                      <tr>
                        <td height="4"></td>
                      </tr>
                      <tr>
                        <td height="40" class="News-05"><%if rsp("re")="NoRe" then
				    response.write "未回复"
				  else
                    if rsp("ss")=true then
				      if session("My_Login")="My_Login_Succeed" and session("Uname")<>"" then
                         set rsU=Server.CreateObject("Adodb.Recordset")
                         sql = "select * from UserInfo where Uname='"&Su&"'" 
                         rsU.open sql,conn,1,1
						 if rsU.recordcount>0 then
						   Uid=rsU("id")
                           rsU.close
                           set rsU=nothing 
						 end if     
	                       if rsp("Uid")=Uid then
					          Re=rsp("Re")
					          response.write ""&Re&""
						   else 
						   
				   	        response.write "悄悄话回复,留言者本人登录后才能查看" 
						   end if
					  else
				   	     response.write "悄悄话回复,留言者本人登录后才能查看"  
					  end if
					else
					  Re=rsp("Re")
					  response.write ""&Re&""

				   end if 
				 end if
				%></td>
                      </tr>
                      <tr>
                        <td height="4"></td>
                      </tr>
                  </table></td>
                </tr>
                <tr valign="top" bgcolor="#F7F7F7">
                  <td height="12" colspan="6" class="News-05"><img src="images/Feedback_Center_01.gif" width="96" height="10"></td>
                </tr>
              </table>
            <%
rsp.movenext
next
%></td>
            <td width="20"></td>
          </tr>
          <tr>
            <td height="40">&nbsp;</td>
            <td valign="bottom"><table width="100%" border="0" align="center"  class='Pagination'>
                <tr valign="middle">
                  <%if rsp.pagecount>0 then%>
                  <td  height="20" align="center">当前页<%=intpage%>/<%=rsp.PageCount%>&nbsp;&nbsp;&nbsp;&nbsp;
                      <%else%>
                  <td  height="20" align="center">当前页0/0&nbsp;&nbsp;&nbsp;&nbsp;
                      <%end if%>
                    共有<%=rsp.recordcount%>条信息 每页<%=rsp.PageSize%>条&nbsp;&nbsp;&nbsp;&nbsp;<a href="FeedbackList.asp?page=1">首页</a>&nbsp;|
                    <%if pre then%><a href="FeedbackList.asp?page=<%=intpage -1%>">上页</a>&nbsp;|
                    <%end if%>
                    <%if last then%><a href="FeedbackList.asp?page=<%=intpage +1%>">下页</a>&nbsp;|
                    <%end if%><a href="FeedbackList.asp?page=<%=rsp.PageCount%>">尾页</a>&nbsp;|&nbsp;转到第
                    <select name="select" onChange="javascript:location=this.options[this.selectedIndex].value;">
                      <%
       for i = 1 to rsp.PageCount
       if i = intpage then%>
                      <option value="FeedbackList.asp?page=<%=i%>"selected><%=i%></option>
                      <%else%>
                      <option value="FeedbackList.asp?page=<%=i%>"><%=i%></option>
                      <%
       end if
        next
        %>
                    </select>
                    页</td>
                </tr>
            </table></td>
            <td></td>
          </tr>

          <tr>
            <td height="30">&nbsp;</td>
            <td></td>
            <td></td>
          </tr>
      </table></td>
  </tr>
</table>
<!--#include file="Bot.asp" -->
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -