📄 addlabelsave.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%option explicit%>
<!--#include file="../../../Conn.asp"-->
<!--#include file="../../../SysCls/KS_CommonCls.asp"-->
<!--#include file="../../Inc/Session.asp"-->
<%
'===================================================================================================================
'软件名称:科汛网站管理系统
'当前版本:科汛网站管理系统 V2.2 SP2 Free
'Copyright (C) 2006-2008 Kesion.Com All rights reserved.
'产品咨询QQ:9537636,41904294
'技术支持QQ:111394,54004407
'程序版权:科汛网络
'程序开发:科汛网络开发组(总策划:林文仲)
'E-Mail :kesioncms@hotmail.com webmaster@kesion.com
'官方网站:http://www.kesion.com
'演示站点:http://test.kesion.com
'郑重声明:
' ①、免费版本请在程序首页保留版权信息,并做上本站LOGO友情连接,商业版本无此要求;
' ②、任何个人或组织不得在授权允许的情况下删除、修改、拷贝本软件及其他副本上一切关于版权的信息;
' ③、科汛网络保留此软件的法律追究权利
'===================================================================================================================
Dim KSCls
Set KSCls = New AddLabelSave
KSCls.Execute()
Set KSCls = Nothing
Class AddLabelSave
Private KSCMS
Private Sub Class_Initialize()
Set KSCMS=New CommonCls
End Sub
Private Sub Class_Terminate()
Call KSCMS.CloseConn()
Set KSCMS=Nothing
End Sub
'主体部分
Public Sub Execute()
Response.Write ("<body bgcolor=#EAF0F5 scroll=no>")
Dim TempClassList, InstallDir, CurrPath, FolderID, LabelContent
Dim LabelID, LabelRS, SQLStr, LabelName, Descript, ParentID, Action, RSCheck, FileUrl, LabelFlag
FileUrl = Request("FileUrl") '便于添加完毕后返回
Set LabelRS = Server.CreateObject("Adodb.RecordSet")
If FolderID = "" Then FolderID = "0"
Select Case Trim(Request.Form("Action"))
Case "Add"
ParentID = Request.Form("ParentID")
LabelName = Replace(Replace(Trim(Request.Form("LabelName")), """", ""), "'", "")
Descript = Replace(Trim(Request.Form("Descript")), "'", "")
LabelContent = Trim(Request.Form("LabelContent"))
LabelFlag = Request.Form("LabelFlag")
If LabelFlag = "" Then LabelFlag = 0
If LabelName = "" Then
Call KSCMS.AlertHistory("标签名称不能为空!", -1)
Set KSCMS = Nothing
Response.End
End If
If LabelContent = "" Then
Call KSCMS.AlertHistory("标签内容不能为空!", -1)
Set KSCMS = Nothing
Response.End
End If
LabelName = "{LB_" & LabelName & "}"
LabelRS.Open "Select LabelName From [KS_Label] Where LabelName='" & LabelName & "'", Conn, 1, 1
If Not LabelRS.EOF Then
Response.Write ("<script>alert('标签名称已经存在!');location.href='" & FileUrl & "?Action=Add&FolderID=" & ParentID & "';</script>")
LabelRS.Close
Conn.Close
Set LabelRS = Nothing
Set Conn = Nothing
Set KSCMS = Nothing
Response.End
Else
LabelRS.Close
LabelRS.Open "Select * From [KS_Label] Where (ID is Null)", Conn, 1, 3
LabelRS.AddNew
Do While True
'生成ID 年+10位随机
LabelID = Year(Now()) & KSCMS.MakeRandom(10)
Set RSCheck = Conn.Execute("Select ID from [KS_Label] Where ID='" & LabelID & "'")
If RSCheck.EOF And RSCheck.BOF Then
RSCheck.Close
Set RSCheck = Nothing
Exit Do
End If
Loop
LabelRS("ID") = LabelID
LabelRS("LabelName") = LabelName
LabelRS("Description") = Descript
LabelRS("LabelContent") = LabelContent
LabelRS("LabelFlag") = LabelFlag
LabelRS("FolderID") = ParentID
LabelRS("AddDate") = Now
LabelRS("LabelType") = 0 '指定为系统函数标签
LabelRS("OrderID") = 1
LabelRS.Update
Response.Write ("<script>if (confirm('成功提示:\n\n添加标签成功,继续添加标签吗?')){location.href='" & FileUrl & "?Action=Add&FolderID=" & ParentID & "';}else{window.close();}</script>")
End If
Case "Edit"
LabelID = Trim(Request.Form("LabelID"))
ParentID = Request.Form("ParentID")
LabelName = Replace(Replace(Trim(Request.Form("LabelName")), """", ""), "'", "")
Descript = Replace(Trim(Request.Form("Descript")), "'", "")
LabelContent = Trim(Request.Form("LabelContent"))
LabelFlag = Request.Form("LabelFlag")
If LabelFlag = "" Then LabelFlag = 0
If LabelName = "" Then
Call KSCMS.AlertHistory("标签名称不能为空!", -1)
Set KSCMS = Nothing
Response.End
End If
If LabelContent = "" Then
Call KSCMS.AlertHistory("标签内容不能为空!", -1)
Set KSCMS = Nothing
Response.End
End If
LabelName = "{LB_" & LabelName & "}"
LabelRS.Open "Select LabelName From [KS_Label] Where ID <>'" & LabelID & "' AND LabelName='" & LabelName & "'", Conn, 1, 1
If Not LabelRS.EOF Then
Response.Write ("<script>alert('标签名称已经存在!');location.href='" & FileUrl & "?LabelID=" & LabelID & "';</script>")
LabelRS.Close
Conn.Close
Set LabelRS = Nothing
Set Conn = Nothing
Set KSCMS = Nothing
Response.End
Else
LabelRS.Close
LabelRS.Open "Select * From [KS_Label] Where ID='" & LabelID & "'", Conn, 1, 3
LabelRS("LabelName") = LabelName
LabelRS("Description") = Descript
LabelRS("LabelContent") = LabelContent
LabelRS("LabelFlag") = LabelFlag
LabelRS("FolderID") = ParentID
LabelRS("AddDate") = Now
LabelRS.Update
Response.Write ("<script>alert('成功提示:\n\n标签修改成功!');window.close();</script>")
End If
End Select
End Sub
End Class
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -