del.asp

来自「一个比较完整的企业erp系统」· ASP 代码 · 共 29 行

<!--#include file="../config2.asp"-->
<!--#include file="../inc/check_login.asp"-->
<!--#include file="../inc/functions.asp"-->
<%
Application_ID = 3000305	'本功能编号，含义请查看编码表
if not CheckAuth(Session("Employee_ID"),Application_ID)	then	'验证权限
	Server.Transfer "../err/un_authorized.htm"
	response.end
end if
%>
<!--**************身份验证部分****************-->
<%
Contract_ID = request("Contract_ID")
if not IsNot(Contract_ID,"n") then
	response.write "合同编号丢失或不正确"
	response.end
end if

Set conn = Server.CreateObject("ADODB.Connection")
conn.open connstr
sql = "delete from Contracts where Contract_ID = " & Contract_ID
'sql = "update Contracts set Available = 0 where Contract_ID = " & Contract_ID
conn.execute(sql)
set conn = nothing
%>
合同已经删除！
<script language="JavaScript" type="text/javascript">
	parent.main.location.reload();
</script>