smallclasskillok.asp

ASP+SQL2000+

<!--#include file="Conn.ASP"--><!--#include file=../include/config.asp-->
<%
IF not(request.cookies("KEY")="super" or request.cookies("KEY")="bigmaster" or request.cookies("KEY")="typemaster") THEN
response.redirect "index_face.asp"
response.end
END IF
delsmallclass=request.form("delsmallclass")
if delsmallclass="1" then	
dim smallclassname
SmallClassid=request("SmallClassid")
set rs=server.createobject("adodb.recordset")
sql="select * from smallclass where smallclassid="&SmallClassid
rs.open sql,conn,1,1
smallclassname=rs("smallclassname")
bigclassid=rs("bigclassid")
rs.close
set rs=nothing

button_value=trim(Request.Form("alert_button"))
if button_value="是" then
conn.execute("delete from news where smallclassid=" &smallclassid)
conn.execute("delete from smallclass where smallclassid=" &smallclassid)
conn.close
set conn=nothing
response.write "<p align=center><font color=red>恭喜您!您删除小类“"&smallclassname&"”成功!<br>"&freetime&"秒钟后返回上页!</font>"
else
response.write "<p align=center><font color=red>您没有执行删除操作！<br>"&freetime&"秒钟后返回上页!</font>"
end if
response.write "<meta http-equiv=""refresh"" content="""&freetime&";url=smallclass.asp?bigclassid="&bigclassid&""">"
else
response.write "<script>alert('您无权删除此项目！');history.go(-1);</Script>"
response.end
end if
%>