📄 list.asp
字号:
<!--#include file="../../conn/conn.asp"-->
<!--#include file="../../inc/safe.asp"-->
<%
if Request.Cookies("globalec")("globalecmaster")="" or Request.Cookies("globalec")("masterflag")="" then
response.write "<script language='javascript'>"
response.write"this.location.href='../login.asp';</SCRIPT>"
response.end
end if
if instr(Request.Cookies("globalec")("masterflag"),"113")=0 then
response.redirect "../err.asp"
response.end
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>GlobalEC 广告管理</title>
<SCRIPT LANGUAGE="JavaScript">
function delad(){
if (confirm("确定要删除这则广告么?删除后不可以再恢复哦!?")){return true;}
return false;
}
</SCRIPT>
<link href="../css/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<%
Dim pagesize,rs,sql,curpage,strcate,i
Dim id,ADID,ADViews,ADHits,ADType,ADSrc,ADLink,ADAlt,ADWidth,ADHeight,ADNote,ADStopViews,ADStopHits,ADStopDate
pagesize=5 '设置每页显示广告树目
If Request.QueryString("page")="" Then
curpage = 1
Else
curpage = cint(Request.QueryString("page"))
End If
Set rs = Server.CreateObject("ADODB.Recordset")
if Request.QueryString("action")="stop" then
sql = "SELECT * FROM [ad] where ( ADStopViews <> 0 and ADViews > ADStopViews) or ( ADStopHits <> 0 and ADHits > ADStopHits) or ( ADStopDate < getdate() ) ORDER BY id DESC"
Else
sql = "SELECT * FROM [ad] ORDER BY id DESC"
end If
rs.open sql, conn, 1, 1
'监测是否存在错误
If err.number <> 0 Then
Response.Write "出现意外错误"
Response.End
End If
If rs.bof or rs.eof Then
rs.Close
if Request.QueryString("action")="stop" Then
%>
<table width="760" height="200" border="0" align="center" cellpadding="0" cellspacing="1" class="tableBorder">
<tr>
<th height="22" colspan="2" class="tableHeaderText" align="center">广 告 列 表 管 理</th>
</tr>
<tr>
<td align="center" class="forumRow"><font color="#990000">暂时没有过期广告！</font></td>
</tr>
</table>
<br>
<!--#include file="../copy.asp" -->
<%Else%>>
<table width="760" height="200" border="0" align="center" cellpadding="0" cellspacing="1" class="tableBorder">
<tr>
<th height="22" colspan="2" class="tableHeaderText" align="center">广 告 列 表 管 理</th>
</tr>
<tr>
<td align="center" class="forumRow">暂时没有任何广告！-- <a href=add.asp>立即添加新广告</a></td>
</tr>
</table>
<br>
<!--#include file="../copy.asp" --> <%
End If
Response.End
End If
rs.pagesize = pagesize
rs.absolutepage = curpage
%>
<table width='760' height="22" border=0 align=center cellpadding=0 cellspacing=0 class="tableBorder">
<tr>
<th width="60" height="22" align="center" class="tableHeaderText"><a href="?page=<%=cstr(curpage)%>&pagesize=<%=pagesize%>"><font color="#FFFFFF">[刷新]</font></a></th>
<th width="700" height="22" align=right class="tableHeaderText">
<%If curpage = 1 Then%>
[首页] [上一页]
<%Else%>
[<a href='?page=1'>首页</a>] [<a href='?page=<%=cstr(curpage-1)%>'>上一页</a>]
<%End If
If curpage = rs.pagecount Then%>
[下一页] [尾页]
<%Else%>
[<a href='?page=<%=cstr(curpage+1)%>'>下一页</a>] [<a href='?page=<%=cstr(rs.pagecount)%>'>尾页</a>]
<%End If%> </th>
</tr>
</table>
<table width='760' border="0" align=center cellpadding=3 cellspacing=1 class="tableBorder">
<% Do While NOT rs.eof
id=rs("id")
ADID=rs("ADID")
ADViews=rs("ADViews")
ADHits=rs("ADHits")
ADType=rs("ADType")
ADSrc=rs("ADSrc")
ADLink=rs("ADLink")
ADAlt=rs("ADAlt")
ADSrc=rs("ADSrc")
ADWidth=rs("ADWidth")
ADHeight=rs("ADHeight")
ADNote=rs("ADNote")
ADStopViews=rs("ADStopViews")
ADStopHits=rs("ADStopHits")
ADStopDate=rs("ADStopDate")%>
<tr>
<td width="25%" height="25" class="forumRowHighlight">名称：<%=ADID%> <%if IsStop(ADViews,ADStopViews,ADStopHits,ADHits,ADStopDate) Then Response.Write(" <font color=red>(已过期)") End If%></td>
<td width="25%" class="forumRowHighlight">显示：<%=ADViews%></td>
<td width="25%" class="forumRowHighlight">点击：<%=ADHits%></td>
<td width="25%" class="forumRowHighlight">管理：<a href="edit.asp?id=<%=id%>">编辑</a> <a href="createjs.asp?id=<%=ADID%>">生成JS</a> <a href="del.asp?id=<%=id%>" onclick='return delad();'>删除</a></td>
</tr>
<tr>
<td width="50%" height="25" colspan=2 class="forumRow">广告类型：<%=ShowAdType(ADType,rs("ADSrc"))%></td>
<td colspan=2 width="50%" class="forumRow">显示地址：
<%If ADType<>6 Then%><a href=<%=ADSrc%> target=_blank><font color="#000000"><%=ADSrc%></a><%else%>不显示<%end if%></td>
</tr>
<tr>
<td height="25" colspan=2 class="forumRow">链接地址：<a href=<%=ADLink%> target=_blank><font color="#000000"><%=ADLink%></a></td>
<td colspan=2 class="forumRow">提示文字：<%=ADAlt%></td>
</tr>
<tr>
<td height="25" colspan=2 class="forumRow">广告规格：<%=ADWidth%>×<%=ADHeight%></td>
<td colspan=2 class="forumRow">备 注：<%=ADNote%></td>
</tr>
<%
i=i+1
rs.movenext
If i>=rs.PageSize Then Exit Do
Loop
%>
<tr align="center">
<td height="25" colspan=6 class="forumRowHighlight"> <center> 第<%=cstr(curpage)%>页 总<%=cstr(rs.pagecount)%>页 本页<%=cstr(i-1)%>条 总<%=cstr(rs.recordcount)%>条 </td>
</tr>
</table>
<br>
<!--#include file="../copy.asp" -->
<p></p>
</body>
</html>
<%
rs.close
set rs=nothing
conn.Close
set conn=nothing
'检测是否过期
function IsStop(ADViews,ADStopViews,ADStopHits,ADHits,ADStopDate)
IsStop=false
If ( ADStopViews <> 0 and ADViews > ADStopViews) Then
IsStop=true
Exit function
ElseIf ( ADStopHits <> 0 and ADHits > ADStopHits) Then
IsStop=true
Exit function
ElseIf ( DateDiff("d",Now(),ADStopDate)<1 ) Then
IsStop=true
Exit function
End If
end function
'判断广告类型
function ShowAdType(ADType,ADSrc)
Dim ADExt
ADExt="图片"
If InStr(1,ADSrc,".swf",1)>0 Then ADExt="FLASH"
Select Case ADType
Case 1
ShowAdType="普通"&ADExt
Case 2
ShowAdType="全屏浮动"&ADExt
Case 3
ShowAdType="上下浮动 - 右"&ADExt
Case 4
ShowAdType="上下浮动 - 左"&ADExt
Case 5
ShowAdType="渐隐消失"&ADExt
Case 6
ShowAdType="网页对话框"
Case 7
ShowAdType="移动透明对话框"
Case 8
ShowAdType="打开新窗口"
Case 9
ShowAdType="弹出新窗口"
Case 10
ShowAdType="对联式广告"
Case else
ShowAdType="<font color=red><b>错误!将不能正确显示</b>"
End Select
end function
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -