admin_bbs_delannounce.asp

WAP网上购物系统源程序,,有兴趣的朋友,一起研究一下..交流经眼

<!--#include file=INC/skin.asp-->

<%
Dim const_txl_HomeUrl
const_txl_HomeUrl = ""
%>
<!--#include file=admin_login_check.asp-->
<%
opendatabase
txl_SiteHead const_txlname&"- 管理员"
BBSSET
closedatabase
web_end
Response.End()
Function BBSSET
%>
<table width="779" border="0" align="center" cellspacing="8">
  <tr><td>  <b> Wap影音论坛==添加版面</b>||<b><a href="admin_bbs_board.asp">版面管理</a></b>
	</td></tr><tr><td>
<%
If Request("confirm") <> "true" Then
		DisplayBBSSet
		Exit Function
Elseif Request("confirm") = "true" then
		Delannounce(Request.QueryString("boardid"))
End If
%>
</td></tr>
</table>
<br>


<%

End Function



Function DisplayBBSSet
%>
		
<table width="100%" border=0 align="center" cellpadding=5 cellspacing=1 bgcolor=#cccccc class=TBone>
  <tr bgcolor=#f7f7f7> 
    <td colspan="2">此操作不可逆，确认要该专区的<font color="#FF0000">所有帖子</font>吗？<br>
      如果此版面帖子过多，删除将是一个漫长的过程，强烈建议暂停Wap影音后再作删除<br>
      操作． 如果执行超时，可以刷新来重新继续删除操作． <br>
      <br><br><b>
      <strong><font color="#FF0000">确认信息： 真的要删除编号为<%=Request.QueryString("boardid")%>论坛帖子吗？</font></strong><br>
      <br>
      <input type=button value="不能删啊" onclick="javascript:history.go(-1);">
		<input type=button value="当然删除" onclick="javascript:document.location.href='admin_bbs_delannounce.asp?boardid=<%=Request.QueryString("boardid")%>&confirm=true';"></td>
  </tr>
</table>
<%

End Function

Function Delannounce(id)
	Dim boardid,sql,total,rs
	boardid=id
	sql="select count(*) from announce where boardid="&boardid
	set rs=conn.execute (sql)
	total=rs(0)
	rs.close
	set rs=nothing
	sql="delete from announce where boardid="&boardid
	
	conn.execute (sql)
	Response.Write("<font color=green><b>&nbsp;&nbsp;编号为"&boardid&"的论坛帖子已经全部删除成功，所影响的记录数为<font color=red>"&total&"</font>!</b></font>")

End Function
%>