proc_delete_cati.asp

来自「一个软件工程的软件质量web跟踪管理系统」· ASP 代码 · 共 62 行

ASP
62
字号
<%@ Language=VBScript %>
<%Response.Expires=0
Response.Buffer = False
%>
<HTML>
<HEAD>
<META name="VI60_DefaultClientScript" Content="VBScript">

<META NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
</HEAD>
<BODY>

</BODY>
</HTML>
<Script Language=Javascript>
<!--
returnValue = "";
-->
</Script>
<%
On Error Resume Next
cDrugCatiID = Trim(Request.QueryString("DrugCatiID"))
cDrugCatiID = Mid(cDrugCatiID,2,Len(cDrugCatiID) - 1)

Set Conn = session("AdoConnectObj")
MySql = "Select ISNULL(REPLACE(fchrFatherID, '-', '_'), '') as UpID From Project1_CaseTree Where (REPLACE(REPLACE(REPLACE(fchrTreeNodeID , '}', ''), '{', ''), '-', '_')= '"+cDrugCatiID+"')"
Response.write MySQL
Set Rs = Conn.Execute(MySql)
cUpID = Trim(Rs("UpID"))
Set Rs = Nothing

MySql = "Delete from Project1_CaseTree Where (REPLACE(REPLACE(REPLACE(fchrTreeNodeID , '}', ''), '{', ''), '-', '_')= '"+cDrugCatiID+"')"

Conn.BeginTrans
Conn.Execute(MySql)
	
If Err.description = "缺少对象" Or Err.description = "" Then
	Conn.CommitTrans
%>
<Script Language=Javascript>
<!--
	returnValue = returnValue + "Delete <%=cDrugCatiID%>" + " " + "<%=cUpID%> |";
-->
</Script>
<%
Else
	Conn.RollbackTrans
	cTemp = Replace(Err.description,chr(13),"\n")
	%>
	<Script Language=Javascript>
		returnValue = "Cancel";
		alert("操作失败,原因为:"+"<%=cTemp%>"+" 请联系系统管理员");
	</Script>
	<%
End If
%>

<Script Language=Javascript>
<!--
	window.close();
-->
</Script>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?