admin_trash.asp

网站 QCNEWS后台管理程序,风格流行功能强大

<!--#include file="admin_head.asp"-->
<br><br>
<%
Select case Request("method")
	Case 1
		Call Delarticle()
	Case 2
		Call DelAll()
	Case 3
		Call ResumeArticle()
	Case 4 
		Call ResumeAll()
End Select

	'-----修改每页显示个数 Start--------
	const MaxPerPage=10
	'-----修改每页显示个数 End  --------
   	dim totalPut
   	dim CurrentPage
	if not isempty(request("page")) then
      		currentPage=cint(request("page"))
   	else
      		currentPage=1
   	end if
%>
<table width="95%" border="1" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#ECEEE4" bordercolordark="#CCCABC">
  <tr> 
    <td colspan="7" align="center" height="30" background="image/tablebg.gif"><b>文 章 回 收 管 理</b> </td>
  </tr>
  <tr align="center"> 
    <td height="25">ID</td>
    <td>操作</td>
    <td>所属大栏目</td>
    <td>文章标题</td>
    <td>录入员</td>
    <td>录入时间</td>
  </tr>
  <tr> 
    <td height="25" colspan="6">
	<%
	set rs=server.createobject("adodb.recordset")
	Sql = "Select Unid,Nclassid,title,author,Intime,pic,Audit from article_info where flag = 1 order by Unid desc"
	rs.open sql,conn,1,1
 	if rs.eof and rs.bof then
		Response.Write "<center><font color=red>回收站中还没有被删除的文章。</font></center>"
	else
		totalPut=rs.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
           		showpage totalput,MaxPerPage,"admin_trash.asp"
            		showContent
            		showpage totalput,MaxPerPage,"admin_trash.asp"
       		else
          		if (currentPage-1)*MaxPerPage<totalPut then
            			rs.move  (currentPage-1)*MaxPerPage
            			dim bookmark
            			bookmark=rs.bookmark
           			showpage totalput,MaxPerPage,"admin_trash.asp"
            			showContent
             			showpage totalput,MaxPerPage,"admin_trash.asp"
        		else
	        		currentPage=1
           			showpage totalput,MaxPerPage,"admin_trash.asp"
           			showContent
           			showpage totalput,MaxPerPage,"admin_trash.asp"
	      		end if
	   		end if
		rs.close
		set rs = nothing	
   	end if 
	sub showContent
	dim i 
	   	i=0
	%>
	</td>
  </tr>
  <form action="" name="form1" method="post">
  <%do while not rs.eof%>
  <tr> 
    <td height="25" align="center"><%=rs(0)%></td>
    <td height="25" align="center"><input type="checkbox" name="newsid" value="<%=rs(0)%>"></td>
    <td height="25" align="center"><%=Qcdn.Classlist(rs(1))%></td>
    <td height="25"><a href="admin_newsedit.asp?Unid=<%=rs(0)%>"><%=Qcdn.HTMLcode(rs(2))%></a> <%
	if rs(5) = 1 then	
		response.write "<img src=image/img.gif valign=absbottom>"
	end if
	if rs(6) = 1 then
		response.write("&nbsp;<img src=image/lock.gif valign=absbottom alt='未审核的文章'>")
	end if
	%></td>
    <td height="25" align="center"><%=rs(3)%></td>
    <td height="25" align="center"><%=rs(4)%></td>
  </tr>
  <%
  i=i+1
	      if i>=MaxPerPage then exit do
  rs.movenext
  loop
  %>
  <tr> 
    <td height="25" colspan="6">管理操作：全部选择 
      <input type="checkbox" name="chkall" onClick="javascript:CheckAll(this.form)"> 
      <input onClick="{if(confirm('文章将彻底被删除\n\n你确认吗?')){this.document.form1.submit();return true;}return false;};document.form1.method.value='1'" type=submit value=删除 name=action class="tbutton">&nbsp;
	  <input type="submit" name="Submit" value="清除全部" onClick="{if(confirm('回收站中的文章将全部删除\n\n你确认吗?')){this.document.form1.method.value='2';this.document.form1.submit();return true;}return false;}" class="tbutton">
	  <input type="button" name="Submit1" value="取消删除" onClick="{if(confirm('你确认执行此操作吗?')){this.document.form1.method.value='3';this.document.form1.submit();return true;}return false;}" class="tbutton">
	  <input type="submit" name="Submit2" value="全部取消删除" onClick="{if(confirm('你确认执行此操作吗?')){this.document.form1.method.value='4';this.document.form1.submit();return true;}return false;}" class="tbutton">
	  <input type="hidden" name="method" value="1"></td>
  </tr>
  </form>
  <tr> 
    <td height="25" colspan="6">
	<%
   end sub 

	function showpage(totalnumber,maxperpage,filename)
  	dim n

  	if totalnumber mod maxperpage=0 then
     		n= totalnumber \ maxperpage
  	else
     		n= totalnumber \ maxperpage+1
  	end if
  	response.write "<table cellspacing=1 width='100%' border=0 colspan='4' ><form method=Post action="""&filename&"""><tr><td align=right> "
  	if CurrentPage<2 then
    		response.write "共<b><font color=red>"&totalnumber&"</font></b>篇文章&nbsp;首页 上一页&nbsp;"
  	else
    		response.write "共<b><font color=red>"&totalnumber&"</font></b>篇文章&nbsp;<a href="&filename&"?page=1>首页</a>&nbsp;"
    		response.write "<a href="&filename&"?page="&CurrentPage-1&">上一页</a>&nbsp;"
  	end if

  	if n-currentpage<1 then
    		response.write "下一页 尾页"
  	else
    		response.write "<a href="&filename&"?page="&(CurrentPage+1)&">"
    		response.write "下一页</a> <a href="&filename&"?page="&n&">尾页</a>"
  	end if
   	response.write "&nbsp;页次：<strong><font color=red>"&CurrentPage&"</font>/"&n&"</strong>页 "
    	response.write "&nbsp;<b>"&maxperpage&"</b>位用户/页 "
%>
      转到： 
      <select name='page' size='1' style="font-size: 9pt" onChange='javascript:submit()'>
        <%for i = 1 to n%>
        <option value='<%=i%>' <%if CurrentPage=cint(i) then%> selected <%end if%>>第<%=i%>页</option>
        <%next%>
      </select> <%   
	response.write "</td></tr></FORM></table>"
end function

Sub Delarticle()
	if Request("newsid") = "" then
		Errmsg = "<li>请勾选你要删除的文章。"
		call Qcdn.Err_List(errmsg,1)
		Response.end
	end if
	newsid = Request("newsid")
	sql = "Delete from article_info where Unid in ("& newsid &")"
	conn.execute(sql)
	Response.Write("<script>alert(""文章彻底删除成功"");location.href=""admin_trash.asp"";</script>")
	Response.End()
End Sub
Sub DelAll()
	sql = "Delete from article_info where flag = 1"
	conn.execute(sql)
	Response.write "<script>alert(""回收站中的文章已全部删除。"");location.href=""admin_trash.asp"";</script>"
	Response.end
End Sub
Sub ResumeArticle()
	if Request("newsid") = "" then
		Errmsg = "<li>请勾选你要删除的文章。"
		FoundErr = true
	else
		newsid = Request("newsid")
	end if
	if FoundErr then
		call Qcdn.Err_List(errmsg,1)
		Response.end
	end if
	sql = "update article_info set flag = 0 where Unid in ("& newsid &")"
	conn.execute(sql)
	Response.write "<script>alert(""选中的文件已经从回收站中恢复了。"");location.href=""admin_trash.asp"";</script>"
	Response.end
End Sub
Sub ResumeAll()
	sql = "update article_info set flag = 0 where flag = 1"
	conn.execute(sql)
	Response.write "<script>alert(""回收站中的文章已全部恢复。"");location.href=""admin_trash.asp"";</script>"
	Response.end
End Sub
%>
	</td>
  </tr>
</table>
<!--#include file="admin_copy.asp"-->