option explicit
response.buffer=true
Const PurviewLevel=2
Const CheckChannelID=2
Const PurviewLevel_Article=3
%>
<!--#include file="inc/conn.asp"-->
<!--#include file="inc/config.asp"-->
<!--#include file="Admin_ChkPurview.asp"-->
<!--#include file="inc/ubbcode.asp"-->
<!--#include file="inc/function.asp"-->
<!--#include file="inc/admin_code_article.asp"-->
<%
dim strFileName,FileName
const MaxPerPage=20
dim totalPut,CurrentPage,TotalPages
dim i,j
dim keyword,strField
dim sql,rsArticleList
dim ClassID
dim PurviewChecked
dim strAdmin,arrAdmin
dim tClass,ClassName,RootID,ParentID,Depth,ParentPath,Child,ChildID,tID,tChild,ClassMaster
dim SkinID,LayoutID,BrowsePurview,AddPurview
dim ManageType
ManageType=trim(request("ManageType"))
PurviewChecked=false
FileName="Admin_ArticleManage.asp"
ClassID=Trim(request("ClassID"))
keyword=trim(request("keyword"))
if keyword<>"" then
keyword=ReplaceBadChar(keyword)
end if
strField=trim(request("Field"))
if ClassID="" then
ClassID=0
if strField="" and AdminPurview=2 and AdminPurview_Article=3 and ManageType<>"MyArticle" then
set tClass=conn.execute("select ClassName,RootID,ParentID,Depth,ParentPath,Child,ClassMaster,ClassID From ArticleClass where ClassMaster like '%" & AdminName & "%'")
do while not tClass.eof
if CheckClassMaster(tClass(6),AdminName)=true then
ClassName=tClass(0)
RootID=tClass(1)
ParentID=tClass(2)
Depth=tClass(3)
ParentPath=tClass(4)
Child=tClass(5)
ClassMaster=tClass(6)
ClassID=tClass(7)
PurviewChecked=True
exit do
end if
tClass.movenext
loop
end if
else
ClassID=CLng(ClassID)
end if
if ClassID>0 and PurviewChecked=False then
set tClass=conn.execute("select ClassName,RootID,ParentID,Depth,ParentPath,Child,ClassMaster From ArticleClass where ClassID=" & ClassID)
if tClass.bof and tClass.eof then
founderr=True
ErrMsg=ErrMsg & "<br><li>找不到指定的栏目</li>"
Call WriteErrMsg()
response.end
else
ClassName=tClass(0)
RootID=tClass(1)
ParentID=tClass(2)
Depth=tClass(3)
ParentPath=tClass(4)
Child=tClass(5)
ClassMaster=tClass(6)
PurviewChecked=CheckClassMaster(tClass(6),AdminName)
if PurviewChecked=False and ParentID>0 then
set tClass=conn.execute("select ClassMaster from ArticleClass where ClassID in (" & ParentPath & ")")
do while not tClass.eof
PurviewChecked=CheckClassMaster(tClass(0),AdminName)
if PurviewChecked=True then exit do
tClass.movenext
loop
end if
end if
end if
if request("page")<>"" then
currentPage=cint(request("page"))
else
currentPage=1
end if
if ManageType="MyArticle" then
FileName=FileName & "?ManageType=" & ManageType
strFileName=FileName & "&ClassID=" & ClassID & "&strField=" & strField & "&keyword=" & keyword
else
strFileName=FileName & "?ClassID=" & ClassID & "&strField=" & strField & "&keyword=" & keyword
end if
%>
<html>
<head>
<title>文章管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<link rel="stylesheet" type="text/css" href="Admin_Style.css">
<SCRIPT language=javascript>
function unselectall()
{
if(document.myform.chkAll.checked){
document.myform.chkAll.checked = document.myform.chkAll.checked&0;
}
}
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.Name != "chkAll"&&e.disabled==false)
e.checked = form.chkAll.checked;
}
}
function ConfirmDel()
{
if(document.myform.Action.value=="Del")
{
document.myform.action="Admin_ArticleDel.asp";
if(confirm("确定要删除选中的文章吗?本操作将把选中的文章移到回收站中。必要时您可从回收站中恢复!"))
return true;
else
return false;
}
else
{
document.myform.action="Admin_ArticleMove.asp";
if(document.myform.TargetClassID.value=="")
{
alert("不能将文章移动到含有子栏目的栏目或外部栏目中!");
return false;
}
if(confirm("确定要将选中的文章移动到指定的栏目吗?"))
return true;
else
return false;
}
}
</head>
<body leftmargin="2" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border">
<tr class="topbg">
<td height="22" colspan="2" align="center"><strong>文 章 管 理</strong></td>
</tr>
<tr class="tdbg">
<td width="70" height="30" ><strong>管理导航:</strong></td>
<td><a href="Admin_ArticleManage.asp">文章管理首页</a> | <a href="Admin_ArticleAdd1.asp">添加文章(简洁模式)</a> | <a href="Admin_ArticleAdd2.asp">添加文章(高级模式)</a> | <a href="Admin_ArticleCheck.asp">审核文章</a>
<%if AdminPurview=1 or AdminPurview_Article<=2 then %>| <a href="Admin_ArticleManageSpecial.asp">专题文章管理</a><%end if%>
<%if AdminPurview=1 or AdminPurview_Article=1 then %>| <a href="Admin_ArticleRecyclebin.asp">文章回收站管理</a>
| <a href="Admin_ArticleComment.asp">文章评论管理</a><%end if%>
</td>
</tr>
</table>
<br>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border">
<tr class="title">
<td height="22"><%call Admin_ShowRootClass()%></td>
</tr>
</table>
<br>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="22"><%call Admin_ShowPath("文章管理")%></td>
<td width="200" height="22" align="right">
<select name='JumpClass' id="JumpClass" onchange="if(this.options[this.selectedIndex].value!=''){location='<%=FileName & "?ClassID="%>'+this.options[this.selectedIndex].value;}">
<option value='' selected>跳转栏目至…</option>
<%call Admin_ShowClass_Option(2,0)%>
</select>
</td>
</tr>
</table>
<%
sql="select A.ArticleID,A.ClassID,C.ClassName,A.Title,A.Key,A.Author,A.CopyFrom,A.UpdateTime,A.Editor,"
sql=sql & "A.Hits,A.OnTop,A.Hot,A.Elite,A.Passed,A.IncludePic,A.Stars,A.PaginationType,A.ReadLevel,A.ReadPoint from Article A"
sql=sql & " inner join ArticleClass C on A.ClassID=C.ClassID where A.Deleted=False"
if ClassID>0 then
if Child>0 then
ChildID=""
set tClass=conn.execute("select ClassID from ArticleClass where ParentID=" & ClassID & " or ParentPath like '" & ParentPath & "," & ClassID & ",%'")
do while not tClass.eof
if ChildID="" then
ChildID=tClass(0)
else
ChildID=ChildID & "," & tClass(0)
end if
tClass.movenext
loop
sql=sql & " and A.ClassID in (" & ChildID & ")"
else
sql=sql & " and A.ClassID=" & ClassID
end if
end if
sql=sql & " and A.Editor='" & AdminName & "' "
else
if keyword<>"" then
select case strField
case "Title"
sql=sql & " and A.Title like '%" & keyword & "%' "
case "Content"
sql=sql & " and A.Content like '%" & keyword & "%' "
case "Author"
sql=sql & " and A.Author like '%" & keyword & "%' "
case "Editor"
sql=sql & " and A.Editor like '%" & keyword & "%' "
case else
sql=sql & " and A.Title like '%" & keyword & "%' "
end select
end if
end if
sql=sql & " order by A.ArticleID desc"
rsArticleList.open sql,conn,1,1
if rsArticleList.eof and rsArticleList.bof then
totalPut=0
if Child=0 then
response.write "<p align='center'><br>没有任何文章!<br></p>"
else
response.write "<p align='center'><br>此栏目的下一级子栏目中没有任何文章!<br></p>"
end if
else
totalPut=rsArticleList.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"篇文章"
else
if (currentPage-1)*MaxPerPage<totalPut then
rsArticleList.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rsArticleList.bookmark
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"篇文章"
else
currentPage=1
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"篇文章"
end if
end if
end if
rsArticleList.close
set rsArticleList=nothing
sub showContent
dim ArticleNum
ArticleNum=0
%>
<table width='100%' border="0" cellpadding="0" cellspacing="0"><tr>
<form name="myform" method="Post" action="Admin_ArticleDel.asp" onsubmit="return ConfirmDel();">
<td><table class="border" border="0" cellspacing="1" width="100%" cellpadding="0">
<tr class="title" height="22">
<td height="22" width="30" align="center"><strong>选中</strong></td>
<td width="25" align="center" height="22"><strong>ID</strong></td>
<td align="center" ><strong>文章标题</strong></td>
<td width="60" align="center" ><strong>录入</strong></td>
<td width="40" align="center" ><strong>点击数</strong></td>
<td width="60" align="center" ><strong>文章属性</strong></td>
<td width="40" align="center" ><strong>已审核</strong></td>
<td width="180" align="center" ><strong>操作</strong></td>
</tr>
<%do while not rsArticleList.eof%>
<tr class="tdbg" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#BFDFFF'">
<td width="30" align="center"><input name='ArticleID' type='checkbox' onclick="unselectall()" id="ArticleID" value='<%=cstr(rsArticleList("articleID"))%>'></td>
<td width="25" align="center"><%=rsArticleList("articleid")%></td>
<td> <%
if rsArticleList("ClassID")<>ClassID then
response.write "<a href='" & FileName & "?ClassID=" & rsArticleList("ClassID") & "'>[" & rsArticleList("ClassName") & "]</a> "
end if
if rsArticleList("IncludePic")=true then
response.write "<font color=blue>[图文]</font>"
end if
response.write "<a href='Admin_ArticleShow.asp?ArticleID=" & rsArticleList("articleid") & "'"
response.write " title='标 题:" & rsArticleList("Title") & vbcrlf & "作 者:" & rsArticleList("Author") & vbcrlf & "转 贴 自:" & rsArticleList("CopyFrom") & vbcrlf & "更新时间:" & rsArticleList("UpdateTime") & vbcrlf
response.write "点 击 数:" & rsArticleList("Hits") & vbcrlf & "关 键 字:" & mid(rsArticleList("Key"),2,len(rsArticleList("Key"))-2) & vbcrlf & "推荐等级:"
if rsArticleList("Stars")=0 then
response.write "无"
else
response.write string(rsArticleList("Stars"),"★")
end if
response.write vbcrlf & "分页方式:"
if rsArticleList("PaginationType")=0 then
response.write "不分页"
elseif rsArticleList("PaginationType")=1 then
response.write "自动分页"
elseif rsArticleList("PaginationType")=2 then
response.write "手动分页"
end if
response.write vbcrlf & "阅读等级:"
if rsArticleList("ReadLevel")=9999 then
response.write "游客"
elseif rsArticleList("ReadLevel")=999 then
response.write "注册用户"
elseif rsArticleList("ReadLevel")=99 then
response.write "收费用户"
elseif rsArticleList("ReadLevel")=9 then
response.write "VIP用户"
elseif rsArticleList("ReadLevel")=5 then
response.write "管理员"
end if
response.write vbcrlf & "阅读点数:" & rsArticleList("ReadPoint")
response.write "'>" & rsArticleList("title") & "</a>"
%></td>
<td width="60" align="center"><%
response.write "<a href='" & FileName & "?field=Editor&keyword=" & rsArticleList("Editor") & "' title='点击将查看此用户录入的所有文章'>" & rsArticleList("Editor") & "</a>"
%></td>
<td width="40" align="center"><%= rsArticleList("Hits") %></td>
<td width="60" align="center"> <%
if rsArticleList("OnTop")=true then
response.Write "<font color=blue>顶</font> "
else
response.write " "
end if
if rsArticleList("Hits")>=HitsOfHot then
response.write "<font color=red>热</a> "
else
response.write " "
end if
if rsArticleList("Elite")=true then
response.write "<font color=green>荐</a>"
else
response.write " "
end if
%> </td>
<td width="40" align="center"> <%
if rsArticleList("Passed")=true then
response.write "是"
else
response.write "否"
end if%></td>
<td width="180" align="center"> <%
if AdminPurview=1 or AdminPurview_Article<=2 or PurviewChecked=true or AdminName=rsArticleList("Editor") then
response.write "<a href='Admin_ArticleModify.asp?ArticleID=" & rsArticleList("articleid") &"'>修改</a> "
response.write "<a href='Admin_ArticleDel.asp?ArticleID=" & rsArticleList("ArticleID") & "&Action=Del' onclick='return ConfirmDel();'>删除</a> "
end if
if AdminPurview=1 or AdminPurview_Article<=2 then
response.write "<a href='Admin_ArticleMove.asp?ArticleID=" & rsArticleList("ArticleID") & "'>移动</a> "
end if
if AdminPurview=1 or AdminPurview_Article<=2 or PurviewChecked=true then
if rsArticleList("OnTop")=False then
response.write "<a href='Admin_ArticleProperty.asp?ArticleID=" & rsArticleList("ArticleID") & "&Action=SetOnTop'>固顶</a> "
else
response.write "<a href='Admin_ArticleProperty.asp?ArticleID=" & rsArticleList("ArticleID") & "&Action=CancelOnTop'>解固</a> "
end if
if rsArticleList("Elite")=False then
response.write "<a href='Admin_ArticleProperty.asp?ArticleID=" & rsArticleList("ArticleID") & "&Action=SetElite'>设为推荐</a>"
else
response.write "<a href='Admin_ArticleProperty.asp?ArticleID=" & rsArticleList("ArticleID") & "&Action=CancelElite'>取消推荐</a>"
end if
end if
%></td>
</tr>
<%
ArticleNum=ArticleNum+1
if ArticleNum>=MaxPerPage then exit do
rsArticleList.movenext
loop
%>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="250" height="30"><input name="chkAll" type="checkbox" id="chkAll" onclick=CheckAll(this.form) value="checkbox">
选中本页显示的所有文章 </td>
<td><input name="submit" type='submit' value='删除选定的文章' onClick="document.myform.Action.value='Del'" <%if PurviewChecked=False and AdminPurview=2 and AdminPurview_Article>=3 then response.write "disabled"%>>
<input name="Action" type="hidden" id="Action" value="Del">
<%
if AdminPurview=1 or AdminPurview_Article<=2 then
%>
<input type="submit" name="Submit" value="将选定的文章移动到" onClick="document.myform.Action.value='MoveToClass'">
<select name="TargetClassID"><%call Admin_ShowClass_Option(3,ClassID)%></select>
<%end if%>
</td>
</tr>
</table>
</td>
</form></tr></table>
<%
end sub
%>
<br>
<table width="100%" height="5" border="0" cellpadding="0" cellspacing="0"><tr><td></td></tr></table>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class='border'>
<tr height="20" class='tdbg'>
<td width='150' align="right">【<%response.write "<a href='" & strFileName & "'>" & ClassName & "</a>"%>】子栏目导航:</td>
<td><%call Admin_ShowChild()%></td></tr>
</table>
<%
end if
%>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="border">
<tr class="tdbg">
<td width="80" align="right"><strong>文章搜索:</strong></td>
<td>
<%call Admin_ShowSearchForm(FileName,2)%>
</td>
</tr>
</table>
</body>
</html>
[此贴子已经被作者于2006-5-25 10:45:50编辑过]