📄 admin_special_del.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
'=========================================================
' 学校机房作业管理系统 V 1.0 [创建于200812122100]
' 授权发布网站：清远ABC-http://www.qyabc.com/
' 客服QQ:418322257 E-Mail:qystu@163.com
' 注意：如想得到关于本程序免费的技术支持，
' 必须承诺使用一周后，用平邮回寄“相关文件”文件夹中的“学校机房作业管理系统调查反馈表”表格。
' 作者博客：http://www.qyabc.com/u/qin/Default.aspx
'=========================================================
%>
<!--#include file="inc/config.asp" -->
<!--#include file="Connections/master.asp" -->
<%
if(Request.QueryString("id") <> "") then contentdel__delid = Request.QueryString("id")
%>
<%
Dim contentinfo
Dim contentinfo_numRows
Set contentinfo = Server.CreateObject("ADODB.Recordset")
contentinfo.ActiveConnection = MM_master_STRING
contentinfo.Source = "SELECT teachername, teachernum FROM exercise_subject WHERE subject_id = " + Replace(contentdel__delid, "'", "''") + ""
contentinfo.CursorType = 0
contentinfo.CursorLocation = 2
contentinfo.LockType = 1
contentinfo.Open()
contentinfo_numRows = 0
%>
<% If (contentinfo.Fields.Item("teachernum").Value) <> session("QYABC_userid") Then %>
你只可以删除自己添加的专业！<a href="javascript:history.back(-1)">返回上一页</a>
<% Else %>
<%
set contentdel = Server.CreateObject("ADODB.Command")
contentdel.ActiveConnection = MM_master_STRING
contentdel.CommandText = "DELETE FROM exercise_subject WHERE subject_id =" + Replace(contentdel__delid, "'", "''") + ""
contentdel.CommandType = 1
contentdel.CommandTimeout = 0
contentdel.Prepared = true
contentdel.Execute()
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta http-equiv="refresh" content="1;URL=admin_exercise_subject_mylist.asp">
<title>已成功删除专业-<%=WebName%></title>
<link href="<%= SysCss %>" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="16%" valign="top"><table width="97%" border="0" align="center" cellpadding="5" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td> </td>
</tr>
<tr>
<td align="center"><a href="admin_class_add.asp">添加班级</a><a href="admin_news_index.asp"></a></td>
</tr>
<tr>
<td align="center"><a href="admin_class_list.asp">班级列表</a></td>
</tr>
<tr>
<td align="center"><a href="admin_special_add.asp">添加科组</a><a href="admin_news_add.asp"></a></td>
</tr>
<tr>
<td align="center"><a href="admin_special_list.asp">科组列表</a><a href="admin_news_add.asp"></a></td>
</tr>
<tr>
<td align="center"><a href="admin_news_add.asp"></a></td>
</tr>
</table></td>
<td width="84%" align="center" valign="middle">已成功删除专业!</td>
</tr>
</table>
<br />
<!--#include file="inc/bot.asp" -->
</body>
</html>
<%
contentinfo.Close()
Set contentinfo = Nothing
%>
<% End If %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -