?? syh.asp
字號:
<!--#include file="conn.asp"-->
<!--#include file="adminset.asp"-->
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('網絡超時或您還沒有登陸！');window.location.href='login.asp';</script>"
response.End
end if
if session("flag")>2 then
response.Write "<div align=center><font size=80 color=red><b>您沒有此項目管理權限！</b></font></div>"
response.End
end if
if qx12<>1 then
response.Write "<div align=center><font size=80 color=red><b>您沒有此項目管理權限！</b></font></div>"
response.End
end if
action=request.QueryString("action")
if action="del" then
id=request.QueryString("id")
if id="" then
response.write "<script LANGUAGE='javascript'>alert('參數錯誤，請返回！');history.go(-1);</script>"
response.End
else
conn.execute "delete from shop_yh where id="&id
response.write "<script LANGUAGE='javascript'>alert('成功退訂，請返回！');history.go(-1);</script>"
response.End
end if
else
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.style1 {
color: #000000;
font-weight: bold;
}
-->
</style></head>
<body><div align="center">
<table width="100%" border="0" cellpadding="0" cellspacing="0" background="images/right_top2.gif">
<tr>
<td width="1%"> </td>
<td width="99%"><table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="30%" style="font-size:14px;color:#ffffff"> <span class="style1">商友會信息管理</span></td>
<td width="70%" align="right"> </td>
</tr>
</table></td>
</tr>
</table>
<%set rs=server.createobject("adodb.recordset")
rs.open "select * from shop_yh order by id asc",conn,1,1
if rs.recordcount=0 then
%>
<table width="100%" border="0" cellspacing="0" cellpadding="5" align="center">
<tr>
<td align=center>暫無商友會，請添加!</td>
</tr>
</table>
<%
else
rs.PageSize =30 '每頁記錄條數
iCount=rs.RecordCount '記錄總數
iPageSize=rs.PageSize
maxpage=rs.PageCount
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif page>maxpage then
page=maxpage
end if
rs.AbsolutePage=Page
if page=maxpage then
x=iCount-(maxpage-1)*iPageSize
else
x=iPageSize
end if
%>
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#9DB2D4">
<tr bgcolor="#C7D3E6">
<td height="22" bgcolor="#C7D3E6" >
<div align="center"> 商友會 </div>
<div align="center"></div>
<div align="center"></div></td>
<td bgcolor="#C7D3E6" ><div align="center">用戶</div></td>
<td >
<div align="center">回復</div></td>
<td bgcolor="#C7D3E6" >
<div align="center">建立時間</div></td>
<td >
<div align="center"></div>
<div align="center">操作</div></td>
</tr>
<%
For i=1 To x
%>
<tr bgcolor="#F0F3F8">
<td height=23 align=left bgcolor="#F0F3F8"> <strong><a href=../list.asp?id=<%=rs("shopid")%>><%=rs("shopname")%></a></strong> <a href=../listpl.asp?id=<%=rs("shopid")%>>查看評論</a>
<div align="center"> </div>
<div align="center"></div></td>
<td height=23 align=left bgcolor="#F0F3F8"><div align="center"><%=rs("username")%></div></td>
<td align=left>
<div align="center"><%=rs("hot")%></div></td>
<td align=left>
<div align="center"><%=year(rs("adddate"))&"."&month(rs("adddate"))&"."&day(rs("adddate"))%></div></td>
<td align=center>
<div align="center"><a href="?action=del&id=<%=rs("id")%>">退訂</a></div></td>
</tr>
<%
rs.movenext
next
%>
</table>
<p align="right">
<%if page=1 then %>
上一頁
<%else%>
<a href="?page=<%=page-1%>">上一頁</a>
<%end if%>
<%if i=30 and not rs.eof then %>
<a href="?page=<%=page+1%>">下一頁</a>
<%else%>
下一頁
<%end if%>
</div>
<div align="center">
<center>
<%rs.close
conn.close%>
</center>
</div> <br>
<!--#include file="copyright.asp"-->
<%end if%><%end if%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -