📄 proc_delete_cati.asp
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -