📄 codeadslist.asp
字号:
<% Option Explicit %>
<!--#include file="../../../Inc/Const.asp" -->
<!--#include file="../../../Inc/Cls_DB.asp" -->
<!--#include file="../../../Inc/Function.asp" -->
<%
'==============================================================================
'软件名称：风讯网站信息管理系统
'当前版本：Foosun Content Manager System v3.2Sp1
'最新更新：2006.05
'==============================================================================
'商业注册联系：028-85098980-601,602 技术支持：028-85098980-607,客户支持：608
'项目开发：028-66026180-606，QQ：655071
'产品咨询QQ：159410,655071,66252421
'技术支持:所有程序使用问题，请提问到bbs.foosun.net我们将及时回答您
'程序开发：风讯开发组 & 风讯插件开发组
'论坛支持：风讯在线论坛(http://bbs.foosun.net)
'官方网站：www.Foosun.net 演示站点：test.cooin.com
'网站建设专区：www.cooin.com
'==============================================================================
'免费版本请在新闻首页保留版权信息，并做上本站LOGO友情连接
'==============================================================================
Dim DBC,Conn
Set DBC = New DataBaseClass
Set Conn = DBC.OpenConnection()
Set DBC = Nothing
%>
<!--#include file="../../../Inc/Session.asp" -->
<!--#include file="../../../Inc/CheckPopedom.asp" -->
<%
if Not JudgePopedomTF(Session("Name"),"P060704") then Call ReturnError1()
Conn.Execute("Update FS_Ads set State=0 where State<>0 and (ClickNum>=MaxClick or ShowNum>=MaxShow or ( EndTime<>null and EndTime<="&StrSqlDate&"))")
Dim TempState,RsAdsObj,AdsSql,AdsFlag,TempAddTime,TempType,TempAdsState,Location,AdsIDTemp
AdsSql = "select * from FS_Ads where State=1"
AdsFlag = "正常广告"
TempState = Request("State")
if TempState <> "" then
if Cstr(TempState)="InGear" then
AdsSql = "select * from FS_Ads where State=1 order by Location asc"
AdsFlag = "正常广告"
elseif Cstr(TempState)="ClickMax" then
AdsSql = "select * from FS_Ads order by ClickNum desc,Location asc"
AdsFlag = "点击最高"
elseif Cstr(TempState)="ClickMin" then
AdsSql = "select * from FS_Ads order by ShowNum desc,Location asc"
AdsFlag = "显示最高"
elseif Cstr(TempState)="Abate" then
AdsSql = "select * from FS_Ads where State=0 order by Location asc"
AdsFlag = "失效广告"
elseif Cstr(TempState)="ShowAds" then
AdsSql = "select * from FS_Ads where Type=1 order by Location asc"
AdsFlag = "显示广告"
elseif Cstr(TempState)="Stop" then
AdsSql = "select * from FS_Ads where State=2 order by Location asc"
AdsFlag = "暂停广告"
elseif Cstr(TempState)="NewWindow" then
AdsSql = "select * from FS_Ads where Type=2 order by Location asc"
AdsFlag = "弹出新窗口"
elseif Cstr(TempState)="OpenWindow" then
AdsSql = "select * from FS_Ads where Type=3 order by Location asc"
AdsFlag = "打开新窗口"
elseif Cstr(TempState)="FilterAway" then
AdsSql = "select * from FS_Ads where Type=4 order by Location asc"
AdsFlag = "渐隐消失"
elseif Cstr(TempState)="DialogBox" then
AdsSql = "select * from FS_Ads where Type=5 order by Location asc"
AdsFlag = "网页对话框"
elseif Cstr(TempState)="ClarityBox" then
AdsSql = "select * from FS_Ads where Type=6 order by Location asc"
AdsFlag = "透明对话框"
elseif Cstr(TempState)="DriftBox" then
AdsSql = "select * from FS_Ads where Type=8 order by Location asc"
AdsFlag = "满屏浮动"
elseif Cstr(TempState)="LeftBottom" then
AdsSql = "select * from FS_Ads where Type=9 order by Location asc"
AdsFlag = "左下底端"
elseif Cstr(TempState)="RightBottom" then
AdsSql = "select * from FS_Ads where Type=7 order by Location asc"
AdsFlag = "右下底端"
elseif Cstr(TempState)="Couplet" then
AdsSql = "select * from FS_Ads where Type=10 order by Location asc"
AdsFlag = "对联广告"
elseif Cstr(TempState)="Cycle" then
AdsSql = "select * from FS_Ads where Type=11 or CycleTF=1 order by Location asc"
AdsFlag = "循环广告"
end if
end if
Set RsAdsObj = Server.CreateObject(G_FS_RS)
RsAdsObj.Open AdsSql,Conn,1,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>广告列表</title>
</head>
<link href="../../../CSS/FS_css.css" rel="stylesheet" type="text/css">
<script src="../../SysJS/PublicJS.js" language="JavaScript"></script>
<script language="JavaScript" src="../../SysJS/ContentMenu.js"></script>
<body topmargin="2" leftmargin="2" onclick="SelectAds();" onselectstart="return false;">
<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#999999">
<tr bgcolor="#EEEEEE">
<td height="26" colspan="5" valign="middle">
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width=35 align="center" alt="调用代码" onClick="GetCode();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">代码</td>
<td width=2 class="Gray">|</td>
<td width=35 align="center" alt="后退" onClick="top.GetEkMainObject().history.back();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">后退</td>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="5" height="2"></td>
</tr>
<tr>
<td valign="top">
<table width="100%" border="0" cellpadding="2" cellspacing="0">
<tr>
<td width="10%" height="26" class="ButtonListLeft">
<div align="center">广告位</div></td>
<td width="23%" height="26" class="ButtonList">
<div align="center">广告类型</div></td>
<td width="22%" height="26" class="ButtonList">
<div align="center">添加时间</div></td>
<td width="16%" height="26" class="ButtonList">
<div align="center">点击次数</div></td>
<td width="16%" height="26" class="ButtonList">
<div align="center">显示次数</div></td>
<td width="13%" height="26" class="ButtonList">
<div align="center">状态</div></td>
</tr>
<%
if Not RsAdsObj.Eof then
Dim page_no,page_total,record_all,PageNums
page_no=request.querystring("page_no")
if page_no<=1 or page_no="" then page_no=1
If Request.QueryString("page_no")="" then
page_no=1
end if
RsAdsObj.PageSize=20
page_total=RsAdsObj.PageCount
if (cint(page_no)>page_total) then page_no=page_total
RsAdsObj.AbsolutePage=page_no
record_all=RsAdsObj.RecordCount
Dim i
for i=1 to RsAdsObj.PageSize
if RsAdsObj.eof then exit for
select case RsAdsObj("Type")
case "1" TempType = "显示广告"
case "2" TempType = "弹出新窗口"
case "3" TempType = "打开新窗口"
case "4" TempType = "渐隐消失"
case "5" TempType = "网页对话框"
case "6" TempType = "透明对话框"
case "7" TempType = "右下底端"
case "8" TempType = "满屏浮动"
case "9" TempType = "左下底端"
case "10" TempType = "对联广告"
case "11" TempType = "循环广告"
end select
TempAddTime = year(RsAdsObj("AddTime"))&"-"&month(RsAdsObj("AddTime"))&"-"&day(RsAdsObj("AddTime"))
select case RsAdsObj("State")
case "0" TempAdsState="失效"
case "1" TempAdsState="正常"
case "2" TempAdsState="暂停"
end select
AdsIDTemp = RsAdsObj("ID")
%>
<tr>
<td><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="../../Images/Folder/folderclosed.gif"></td>
<td><span State="<%=RsAdsObj("State")%>" Location="<%=RsAdsObj("Location")%>" class="TempletItem">第<%=RsAdsObj("Location")%>位</span></td>
</tr>
</table>
</td>
<td height="25">
<div align="center"><%=TempType%></div></td>
<td><div align="center"><%=TempAddTime%></div></td>
<td><div align="center"><%=RsAdsObj("ClickNum")%></div></td>
<td><div align="center"><%=RsAdsObj("ShowNum")%></div></td>
<td><div align="center"><%=TempAdsState%></div></td>
</tr>
<%
RsAdsObj.MoveNext
next
end if
%>
</table>
</td>
</tr>
<%if page_total>1 then%>
<tr>
<td valign="middle" height="10">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr height="1">
<tr height="1">
<td width="42%" height="18"><table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
</tr>
</table> </td>
<td width="51%" height="25" valign="middle"> <div align="right">
<% = "NO.<b>"& page_no &"</b>, " %>
<% = "Totel:<b>"& page_total &"</b>, RecordCounts:<b>" & record_all &"</b> "%>
<%
if Page_Total=1 then
response.Write " <img src=../images/First1.gif border=0 alt=首页></img> "
response.Write " <img src=../images/prePage.gif border=0 alt=上一页></img> "
response.Write " <img src=../images/nextPage.gif border=0 alt=下一页></img> "
response.Write " <img src=../images/endPage.gif border=0 alt=尾页></img> "
else
if cint(Page_No)<>1 and cint(Page_No)<>Page_Total then
response.Write " <a href=?page_no=1" &"&Keywords="&Request("Keywords")&"><img src=../images/First1.gif border=0 alt=首页></img></a> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)-1) &"&Keywords="&Request("Keywords")&"><img src=../images/prePage.gif border=0 alt=上一页></img></a> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)+1) &"&Keywords="&Request("Keywords")&"><img src=../images/nextPage.gif border=0 alt=下一页></img></a> "
response.Write " <a href=?page_no="& Page_Total &"&Keywords="&Request("Keywords")&"><img src=../images/endPage.gif border=0 alt=尾页></img></a> "
elseif cint(Page_No)=1 then
response.Write " <img src=../images/First1.gif border=0 alt=首页></img></a> "
response.Write " <img src=../images/prePage.gif border=0 alt=上一页></img> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)+1) &"&Keywords="&Request("Keywords")&"><img src=../images/nextPage.gif border=0 alt=下一页></img></a> "
response.Write " <a href=?page_no="& Page_Total &"&Keywords="&Request("Keywords")&"><img src=../images/endpage.gif border=0 alt=尾页></img></a> "
else
response.Write " <a href=?page_no=1" &"&Keywords="&Request("Keywords")&"><img src=../images/First1.gif border=0 alt=首页></img> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)-1) &"&Keywords="&Request("Keywords")&"><img src=../images/prePage.gif border=0 alt=上一页></img></a> "
response.Write " <img src=../images/nextPage.gif border=0 alt=下一页></img></a> "
response.Write " <img src=../images/endpage.gif border=0 alt=尾页></img> "
end if
end if
%>
</div></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -