📄 review.asp
字号:
<% Option Explicit %>
<!--#include file="../../../Inc/NosqlHack.asp" -->
<!--#include file="../../../Inc/Const.asp" -->
<!--#include file="../../../Inc/Cls_DB.asp" -->
<%
Dim DBC,Conn,UserConn
Set DBC = New DataBaseClass
Set Conn = DBC.OpenConnection()
DBC.ConnStr = "DBQ=" + Server.MapPath(UserDBConnectStr) + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
Set UserConn = DBC.OpenConnection()
Set DBC = Nothing
'==============================================================================
'软件名称：风讯网站信息管理系统
'当前版本：Foosun Content Manager System(FoosunCMS V3.2SP1)
'最新更新：2006.50
'==============================================================================
'Copyright (C) 2002-2004 Foosun.Net All rights reserved.
'商业注册联系：028-85098980-601,项目开发：028-85098980-606、609,客户支持：608
'产品咨询QQ：394226379,159410,125114015
'技术支持QQ：315485710,66252421
'项目开发QQ：415637671，655071
'程序开发：四川风讯科技发展有限公司(Foosun Inc.)
'Email:service@Foosun.cn
'MSN：skoolls@hotmail.com
'论坛支持：风讯在线论坛(http://bbs.foosun.net)
'官方网站：www.Foosun.cn 演示站点：test.cooin.com
'网站通系列(智能快速建站系列)：www.ewebs.cn
'==============================================================================
'免费版本请在程序首页保留版权信息，并做上本站LOGO友情连接
'风讯公司保留此程序的法律追究权利
'如需进行2次开发，必须经过风讯公司书面允许。否则将追究法律责任
'==============================================================================
%>
<!--#include file="../../../Inc/Session.asp" -->
<!--#include file="../../../Inc/CheckPopedom.asp" -->
<%
if Not JudgePopedomTF(Session("Name"),"P010509") then Call ReturnError1()
Dim OperationID
OperationID = Request("OperationID")
if Request("Action") = "Del" then
if OperationID <> "" then
OperationID = Replace(OperationID,"***",",")
UserConn.execute("Delete From FS_Review Where ID in (" & OperationID & ")")
end if
elseif Request("Action") = "Audit" then
if OperationID <> "" then
OperationID = Replace(OperationID,"***",",")
UserConn.execute("Update FS_Review Set Audit=1 Where ID in (" & OperationID & ")")
end if
elseif Request("Action") = "CancelAudit" then
if OperationID <> "" then
OperationID = Replace(OperationID,"***",",")
UserConn.execute("Update FS_Review Set Audit=0 Where ID in (" & OperationID & ")")
end if
end if
Dim NewsID,RsReviewObj,RsNewsObj,SunNumAsp,sql,isn,ShowPagesTF,DownloadID,Sqlstr
ShowPagesTF = True
If Request("NewsID")<>"" then
NewsID = Cstr(Request("NewsID"))
isn="where Types = 1 and NewsID='"&NewsID&"'"
elseif Request("DownloadID")<>"" Then
DownloadID = Cstr(Request("DownloadID"))
isn="where Types = 2 and NewsID='"&DownloadID&"'"
end if
Sql = "Select * from FS_Review "&isn&" order by id desc"
Set RsReviewObj = Server.CreateObject(G_FS_RS)
RsReviewObj.Open Sql,UserConn,1,1
SunNumAsp = RsReviewObj.RecordCount
%>
<html>
<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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加新闻到专题</title>
</head>
<body topmargin="2" leftmargin="2" onclick="SelectReview();" 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="DelReview();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">删除</td>
<td width=2 class="Gray">|</td>
<td width=35 align="center" alt="修改" onClick="EditReview();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">修改</td>
<td width=2 class="Gray">|</td>
<td width=35 align="center" alt="审核" onClick="Audit();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">审核</td>
<td width=2 class="Gray">|</td>
<td width=55 align="center" alt="取消审核" onClick="CancelAudit();" 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="" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="5" height="2"></td>
</tr>
<tr>
<td height="26" class="ButtonListLeft">
<div align="center">内容 </div></td>
<td width="8%" height="26" class="ButtonList">
<div align="center">审核</div></td>
<td width="10%" height="26" class="ButtonList">
<div align="center">发布人</div></td>
<td width="15%" height="26" class="ButtonList">
<div align="center">发布时间</div></td>
<td width="8%" height="26" class="ButtonList">
<div align="center">评论类型</div></td>
<td width="25%" height="26" class="ButtonList">
<div align="center">
所属内容
</div>
</td>
</tr>
<%
if not RsReviewObj.Bof And not RsReviewObj.Eof then
Dim page_size,page_no,page_total,record_all
page_size=20
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
RsReviewObj.PageSize=page_size
page_total=RsReviewObj.PageCount
if (cint(page_no)>page_total) then page_no=page_total
RsReviewObj.AbsolutePage=cint(page_no)
record_all=RsReviewObj.RecordCount
Dim i
for i=1 to RsReviewObj.PageSize
if RsReviewObj.eof then exit for
%>
<tr>
<td nowrap> <table border="0" cellspacing="0" cellpadding="0">
<tr height="22">
<td><img src="../../Images/Info/WordNews.gif" width="24" height="22"></td>
<td nowrap><span class="TempletItem" NewsID="<% = RsReviewObj("NewsID") %>" ReviewID="<% = RsReviewObj("ID") %>"><%=left(RsReviewObj("Content"),20)%></span></td>
</tr>
</table></td>
<td nowrap><div align="center"><% if RsReviewObj("Audit") = 1 then Response.Write("已审核") else Response.Write("<font color=""red"">未审核</fon>") %></div></td>
<td nowrap> <div align="center"><%=RsReviewObj("UserID")%></div></td>
<td nowrap> <div align="center"><%=RsReviewObj("Addtime")%></div></td>
<td nowrap> <div align="center"><%
If RsReviewObj("Types")="1" then
response.write "新闻"
ElseIf RsReviewObj("Types")="2" then
response.write "下载"
else
response.write "商品"
End If
%></div></td>
<td nowrap> <div align="center">
<%
If RsReviewObj("Types")="1" then
Set RsNewsObj = Conn.Execute("Select TiTle from FS_News where newsid='" &RsReviewObj("NewsID")&"'")
If Not RsNewsObj.eof Then
response.Write(""&left(RsNewsObj("TiTle"),10)&"")
Else
Response.Write("所属新闻已被删除")
End If
elseif RsReviewObj("Types")="2" Then
Set RsNewsObj = Conn.Execute("Select Name from FS_Download where DownLoadID='" & RsReviewObj("NewsID")&"'")
If Not RsNewsObj.eof Then
response.Write(""&left(RsNewsObj("Name"),10)&"")
Else
Response.Write("所属下载已被删除")
End If
end if
%>
</div></td>
</tr>
<%
RsReviewObj.movenext
next
RsReviewObj.close
set RsReviewObj=nothing
if page_total > 1 then
ShowPagesTF = True
else
ShowPagesTF = False
end if
else
ShowPagesTF = False
end if
if ShowPagesTF = True then
%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="26" colspan="5" class="ButtonListLeft"> <div align="right"><strong>
<%
if page_total=1 then
response.Write " <img src=../../images/FirstPage.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&Newsid="&request("Newsid")&"&Downloadid="&request("Downloadid")&"><img src=../../images/FirstPage.gif border=0 alt=首页></img></a> "
response.Write " <a href=?page_no="&cstr(cint(page_no)-1)&"&Newsid="&request("Newsid")&"&Downloadid="&request("Downloadid")&"><img src=../../images/prePage.gif border=0 alt=上一页></img></a> "
response.Write " <a href=?page_no="&cstr(cint(page_no)+1)&"&Newsid="&request("Newsid")&"&Downloadid="&request("Downloadid")&"><img src=../../images/nextPage.gif border=0 alt=下一页></img></a> "
response.Write " <a href=?page_no="& page_total &"&Newsid="&request("Newsid")&"&Downloadid="&request("Downloadid")&"><img src=../../images/endPage.gif border=0 alt=尾页></img></a> "
elseif cint(page_no)=1 then
response.Write " <img src=../../images/FirstPage.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)&"&Newsid="&request("Newsid")&"&Downloadid="&request("Downloadid")&"><img src=../../images/nextPage.gif border=0 alt=下一页></img></a> "
response.Write " <a href=?page_no="& page_total &"&Newsid="&request("Newsid")&"&Downloadid="&request("Downloadid")&"><img src=../../images/endPage.gif border=0 alt=尾页></img></a> "
else
response.Write " <a href=?page_no=1&Newsid="&request("Newsid")&"&Downloadid="&request("Downloadid")&"><img src=../../images/FirstPage.gif border=0 alt=首页></img></a> "
response.Write " <a href=?page_no="&cstr(cint(page_no)-1)&"&Newsid="&request("Newsid")&"&Downloadid="&request("Downloadid")&"><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
%>
</strong></div></td>
</tr>
<%
end If
Set Conn = Nothing
Set UserConn = Nothing
%>
</table>
</body>
</html>
<script language="JavaScript">
var NewsID='<% = NewsID %>';
var DownloadID = '<%= DownloadID%>';
var DocumentReadyTF=false;
var ListObjArray = new Array();
var ContentMenuArray=new Array();
function document.onreadystatechange()
{
if (DocumentReadyTF) return;
IntialListObjArray();
InitialContentListContentMenu();
DocumentReadyTF=true;
}
function InitialContentListContentMenu()
{
ContentMenuArray[ContentMenuArray.length]=new ContentMenuFunction("parent.EditReview();",'修改','disabled');
ContentMenuArray[ContentMenuArray.length]=new ContentMenuFunction("parent.DelReview();",'删除','disabled');
ContentMenuArray[ContentMenuArray.length]=new ContentMenuFunction('parent.Audit();','审核','disabled');
ContentMenuArray[ContentMenuArray.length]=new ContentMenuFunction('parent.CancelAudit();','取消审核','disabled');
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -