leaveword_view.asp

购物网站源码有需要的赶快下载机不可失

<!--#include file="top.asp"--><%usertopview%>
<%sortid=request("sortid")
tableid=request("tableid")
if sortid="" then sortid=2
if tableid="" then tableid=0

if request("action")="del" then
conn.execute("delete from SMT_leaveword where SMT_book_id=" & request("id")&" and SMT_book_ypid="&session("id"))
Response.Redirect "leaveword_view.asp?sortid="&sortid&"&tableid="&tableid&"&page="&request("page")&""
end if%>

<table width="760" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#FFFFFF">
<tr>
<td width="160" valign=top bgcolor=#efefef>
<!--==============-->
<!--#include file="left.asp"-->
<!--==============-->
</td>
<td width="600" valign=top>
<!--==============-->
<table width="500" border="0" cellspacing="0" cellpadding="0" align="center">
<tr><td height=25>您现在的位置是：管理中心 > 客户反馈</td></tr>
  <tr>
    <td>
<!--####################################-->
<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor=#6C94D1>
  <tr>
    <td height=25 bgcolor=#6C94D1>　<font color=white>信息查看</font></td>
  </tr>
  <tr>
    <td bgcolor=#ffffff height=60>
<!--======-->

<table width="98%" border="0" cellspacing="1" cellpadding="2" align=center>
<tr><td height=4></td></tr>
<%sql="select * from SMT_leaveword where SMT_book_sort="&sortid&" and SMT_book_table="&tableid&" and SMT_book_ypid="&session("id")&" order by SMT_book_id desc"
set rs=server.createobject("adodb.recordset")                     
rs.open sql,conn,1,1                     
if rs.eof and rs.bof then                     
	response.write "<tr><td height=194 colspan=5 align=center>暂无内容</td></tr>"
else  
'分页的实现 
listnum=10
Rs.pagesize=listnum
page=Request("page")
if (page-Rs.pagecount) > 0 then
page=Rs.pagecount
elseif page = "" or page < 1 then
page = 1
end if
Rs.absolutepage=page
'编号的实现
j=rs.recordcount
j=j-(page-1)*listnum%>
<%i=0
nn=request("page")
if nn="" then
n=0
else
nn=nn-1
n=listnum*nn
end if%>
<%do while not rs.eof and i<listnum
n=n+1%>
<tr><td height=20 bgcolor=#efefef style="border-bottom:1px #cccccc solid">　<%=rs("SMT_book_user")%> 发表于 <%=rs("SMT_book_date")%></td><td align=center width=50 bgcolor=#efefef style="border-bottom:1px #cccccc solid"><a href="leaveword_view.asp?id=<%=rs("SMT_book_id")%>&action=del&page=<%=request("page")%>&sortid=<%=sortid%>&tableid=<%=tableid%>">删除</a></td></tr>
<tr><td height=30 colspan=2><strong><p style="line-height:150%">　　<%=trim(rs("SMT_book_content"))%></strong></td></tr>
<tr><td colspan=2 bgcolor=#fafafa style="border-top:1px #efefef solid"><p style="line-height:150%">联系方式：<%=rs("SMT_book_contact")%></td></tr>
<tr><td colspan=2 height=1 background="../img/list_line_1.gif"></td></tr>
<%rs.movenext 
i=i+1 
j=j-1
loop%>
<tr>
<%filename="leaveword_view.asp?sortid="&sortid&"&tableid="&tableid&""%>
<td align=right colspan=2 height=20 bgcolor=#efefef>共 <%=Rs.pagecount%> 页 
      <% if page=1 then %>
      <%else%>
      <a href=<%=filename%>>|<<</a>&nbsp; 
      <a href=<%=filename%>&page=<%=page-1%>><<</a>&nbsp; 
      <a href=<%=filename%>&page=<%=page-1%>>[<%=page-1%>]</a>&nbsp;<%end if%>
<% if Rs.pagecount=1 then %>
<%else%>[<%=page%>]
<%end if%>
	  <% if Rs.pagecount-page <> 0 then %>
      <a href=<%=filename%>&page=<%=page+1%>>[<%=page+1%>]</a>&nbsp; 
      <a href=<%=filename%>&page=<%=page+1%>>>></a>&nbsp; 
      <a href=<%=filename%>&page=<%=Rs.pagecount%>>>>|</a>&nbsp; 
	  <%end if%>&nbsp;&nbsp;</td>
<%end if%></tr>
<tr><td colspan=5 height=4></td></tr>
</table>

<!--======-->
	</td>
  </tr>
</table>
<!--####################################-->
	</td>
  </tr>
<tr><td height=25></td></tr>
</table>
<!--==============-->
</td>
</tr>
</table>
<!--====== bottom ========-->
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor=#ffffff>
<tr><td height=2 bgcolor=#6C94D1></td></tr>
  <tr>
    <td align="center" height=80><%=citybottom%></td>
  </tr>
</table>
</body>
</html>