<%@language=vbscript codepage=936 %>
<%
option explicit
response.buffer=true
Const PurviewLevel=2
Const CheckChannelID=2
Const PurviewLevel_Article=2
%>
<%
dim strFileName,FileName
const MaxPerPage=20
dim totalPut,CurrentPage,TotalPages
dim i,j
dim keyword,strField
dim sql,rsArticleList
dim ClassID,SpecialID,SpecialName
FileName="Admin_ArticleManageSpecial.asp"
ClassID=Trim(request("ClassID"))
SpecialID=trim(request("SpecialID"))
keyword=trim(request("keyword"))
if keyword<>"" then
keyword=ReplaceBadChar(keyword)
end if
strField=trim(request("Field"))
if ClassID="" then
ClassID=0
else
ClassID=CLng(ClassID)
end if
if SpecialID="" then
SpecialID=0
else
SpecialID=Clng(SpecialID)
end if
strFileName=FileName & "?SpecialID=" & SpecialID & "&ClassID=" & ClassID & "&strField=" & strField & "&keyword=" & keyword
if request("page")<>"" then
currentPage=cint(request("page"))
else
currentPage=1
end if
dim rsSpecial,sqlSpecial
sqlSpecial="select * from Special"
set rsSpecial=server.CreateObject("adodb.recordset")
rsSpecial.open sqlSpecial,conn,1,1
sql="select Article.ArticleID,Article.SpecialID,Special.SpecialName,Article.Title,Article.Key,Article.Author,Article.CopyFrom,Article.UpdateTime,Article.Editor,"
sql=sql & "Article.Hits,Article.OnTop,Article.Hot,Article.Elite,Article.Passed,Article.IncludePic,Article.Stars,Article.PaginationType,Article.ReadLevel,Article.ReadPoint from article"
sql=sql & " left join Special on Article.SpecialID=Special.SpecialID where Article.Deleted=False "
if SpecialID>0 then
sql=sql & " and Article.SpecialID=" & SpecialID
end if
if ClassID>0 then
sql=sql & " and Article.ClassID=" & ClassID
end if
if strField<>"" then
if keyword<>"" then
select case strField
case "Title"
sql=sql & " and Title like '%" & keyword & "%' "
case "Content"
sql=sql & " and Content like '%" & keyword & "%' "
case "Author"
sql=sql & " and Author like '%" & keyword & "%' "
case "Editor"
sql=sql & " and Editor like '%" & keyword & "%' "
case else
sql=sql & " and Title like '%" & keyword & "%' "
end select
end if
end if
sql=sql & " order by Article.articleid desc"
Set rsArticleList= Server.CreateObject("ADODB.Recordset")
rsArticleList.open sql,conn,1,1
%>
专题文章管理
专 题 文 章 管 理
专题列表：
<%
if rsSpecial.bof and rsSpecial.eof then
response.write "没有任何专题"
else
response.write "
"
i=1
do while not rsSpecial.eof
if rsSpecial("SpecialID")=SpecialID then
SpecialName=rsSpecial("SpecialName")
response.write "
"
end if
i=i+1
if i mod 10 =0 then
response.write "
"
end if
rsSpecial.movenext
loop
response.write "
"
end if
%>
您现在的位置：专题文章管理 >> <%
if SpecialID=0 then
response.write "所有文章"
else
response.write SpecialName
end if
%>
<%
if rsArticleList.eof and rsArticleList.bof then
totalPut=0
if SpecialID=0 then
response.write "
没有任何文章！
"
else
response.write "
此专题中没有任何文章！
"
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
<%
end sub
%>
文章搜索：
<%call Admin_ShowSearchForm(FileName,2)%>
<%
rsSpecial.close
set rsSpecial=nothing
call CloseConn()
%>