aa_neclass.asp

台讯企业全站管理系统V2006 供下载时经过了严格的测试

crecordcount=Rs.Recordcount
Rs.Close
Set Rs=Nothing
Set Rs=server.createobject("adodb.recordset")
Sql="select * from Tx_NeClass Where Class_Id=" & Request.form("ParentID")
Rs.open Sql,Conn,1,1
IF Rs.Recordcount<>0 THEN
oClassParentPath=Rs("Class_ParentPath")
End IF
Rs.Close
Set Rs=Nothing
IF Request.form("Class_Name")="" THEN
Errorst="请输入新闻分类名称！"
founderr=True
ElseIF instr(oClassParentPath,Id) THEN
Errorst="所属分类不能是自己的下属子类！"
founderr=True
End IF
    IF founderr=True THEN
	    Call Form_Error()
    Else	
        ParentID=int(Request.form("ParentID"))
        Parent=ParentID
        Do while ParentID>0
            ParentID=Conn.Execute("Select ParentID from Tx_NeClass Where Class_Id=" & ParentID)(0)
            If ParentID>0 THEN
                Parent=ParentID & "|" & Parent
            End If
        Loop
	Set Rs=server.createobject("adodb.recordset")
        Sql="Select * From Tx_NeClass where Class_Id=" & Id
        Rs.open Sql,Conn,1,3
		Rs("ParentID")=Request.form("ParentID")
		Rs("Class_Name")=Request.form("Class_Name")
		Rs("Class_Content")=nohtml(Request.form("Class_Content"))
	    Rs("Class_ParentPath")=Parent
        Rs("Class_Flag")=Request.form("Class_Flag")
		Rs.update
		Rs.Close
		Set Rs=Nothing
        Set Rs=server.Createobject("Adodb.Recordset")
            Sql="Select * From Tx_NeClass Where Class_ParentPath like '%" & Id & "%'"
            Rs.Open Sql,Conn,1,3
            while not Rs.eof
			aParentPath=split(Rs("Class_ParentPath"),"|")
            For intTemp=0 to ubound(aParentPath)
			    IF aParentPath(intTemp)=Id THEN
					Exit For
				End IF
			    Rs("Class_ParentPath")=replace(Rs("Class_ParentPath"),aParentPath(intTemp)&"|","")
			Next
			IF Parent<>"0" THEN
			Rs("Class_ParentPath")=Parent & "|" & Rs("Class_ParentPath")
			End IF
            Rs.moveNext
            wend
        Rs.Close
		Set Rs=Nothing
		ToHistory="Aa_NeClass.asp?Action=Edit&Id=" & Id
		saveok="新闻分类：[ " & Request.form("Class_Name") & " ] 修改成功！"
	    Call Form_Saveok()
End IF
case "EditOrder"
IF not isnumeric(Request.form("ClassOrder")) THEN
Errorst="错误的参数（请输入数字）！"
founderr=True
End IF
    IF founderr=True THEN
	    Call Form_Error()
    Else	
	    NewOrder=Request.form("ClassOrder")
	    Set Rs=server.Createobject("Adodb.Recordset")
            Sql="Select * From Tx_NeClass Where Class_Id=" & Id
            Rs.open Sql,Conn,1,3
            OldOrder=Rs("Class_Order")
		    ClassName=Rs("Class_Name")
		    ClassParentID=Rs("ParentID")
	        IF NewOrder="" Then
		        Rs("Class_Order")=Rs("Class_Order")
	        Else
		        Rs("Class_Order")=NewOrder
	        End IF
		    Rs.update
		Rs.Close
		Set Rs=Nothing
	    Set Rs=server.Createobject("Adodb.Recordset")
            Sql="Select * From Tx_NeClass where ParentID=" & ClassParentID & " And Class_Order>=" & NewOrder & " and Class_Id<>" & Id & " order by Class_Order"
            Rs.open Sql,Conn,1,3
	        IF Rs.Recordcount<>0 Then
	            IF Rs("Class_Order")<NewOrder+1 Then
                    while not Rs.eof
		                Rs("Class_Order")=Rs("Class_Order")+1
	                    Rs.moveNext
                    wend
	            End IF
	        End IF
	    Rs.Close
		Set Rs=Nothing
		ToHistory="Aa_NeClass.asp?Action=Manage"
		saveok="新闻分类：[ " & ClassName & " ]，原序号为" & OldOrder & "，现序号为" & NewOrder & "！"
	    Call Form_Saveok()
End IF
case "Del"
Set Rs=server.Createobject("Adodb.Recordset")
Sql="Select * from Tx_NeClass where ParentID=" & Id
Rs.open Sql,Conn,1,1
crecordcount=Rs.Recordcount
Rs.Close
Set Rs=Nothing
IF crecordcount<>0 THEN
Errorst="您要删除的分类有下属子类，请先删除子类！"
founderr=True
End IF
    IF founderr=True THEN
	    Call Form_Error()
    Else	
        BoardName=Conn.Execute ("Select Class_Name From Tx_NeClass where Class_Id=" & Id)(0)
        Set Rs=server.Createobject("Adodb.Recordset")
        Sql="Select * from Tx_News where News_ClassId=" & Id
        Rs.open Sql,Conn,1,1
        crecordcountP=Rs.Recordcount
		    While Not Rs.eof
		        Conn.Execute "Delete From Tx_Cret Where Cret_Class=2 And Cret_ClassId=" & Rs("News_Id")
			Rs.MoveNext
			Wend
		Rs.Close
		Set Rs=Nothing
        Conn.Execute "Delete from Tx_News where News_ClassId=" & Id
        Conn.Execute "Delete from Tx_NeClass where Class_Id=" & Id
		ToHistory="Aa_NeClass.asp?Action=Manage"
		IF crecordcountP<>0 THEN
		    saveok="新闻分类[ " & BoardName & " ]已删除，并同时删除下属" & crecordcountP & "个新闻及这些新闻的评论！"
		Else
		    saveok="新闻分类[ " & BoardName & " ]删除成功！"
		End IF
	    Call Form_Saveok()
	End IF
case "Flag"
	Set Rs=server.createobject("adodb.recordset")
        Sql="Select * From Tx_NeClass where Class_Id=" & Id
        Rs.open Sql,Conn,1,3
		IF Rs("Class_Flag")=1 THEN
		    Rs("Class_Flag")=0
		saveok="新闻分类：[ " & Rs("Class_Name") & " ] 已取消审核！"
		Else
		    Rs("Inform_Flag")=1
		saveok="新闻分类：[ " & Rs("Class_Name") & " ] 已通过审核！"
		End IF
		Rs.update
		Rs.Close
		Set Rs=Nothing
		ToHistory=Request.servervariables("http_referer")
	    Call Form_Saveok()
case "Merges"
    IF Request.form("NewClassId")<>"" THEN
        Set Rs=server.Createobject("Adodb.Recordset")
        Sql="Select * From Tx_NeClass where Class_Id=" & Request.form("NewClassId")
        Rs.open Sql,Conn,1,1
            IF Rs.Recordcount<>0 THEN
                ClassParentPath=Rs("Class_ParentPath")
            End IF
        Rs.Close
        Set Rs=Nothing
        Set Rs=server.Createobject("Adodb.Recordset")
        Sql="Select * From Tx_NeClass Where ParentID=" & Request.form("NewClassId")
        Rs.open Sql,Conn,1,1
            NewClassId=Rs.Recordcount
        Rs.Close
        Set Rs=Nothing
    End IF
    IF Request.form("OldClassId")<>"" THEN
        Set Rs=server.Createobject("Adodb.Recordset")
        Sql="Select * From Tx_NeClass Where ParentID=" & Request.form("OldClassId")
        Rs.open Sql,Conn,1,1
            OldClassId=Rs.Recordcount
        Rs.Close
        Set Rs=Nothing
    End IF
    IF Request.form("OldClassId")="" THEN
        Errorst="请选择原新闻分类！"
        founderr=True
    ElseIF Request.form("NewClassId")="" THEN
        Errorst="请选择目标分类！"
        founderr=True
    ElseIF Request.form("OldClassId")=Request.form("NewClassId") THEN
        Errorst="自己怎么可能吃自己呢？"
        founderr=True
    ElseIF instr(ClassParentPath,Request.form("OldClassId")) THEN
        Errorst="不能将数据合并到子类中！"
        founderr=True
    ElseIF OldClassId<>0 THEN
        Errorst="原分类不能有下属子类！"
        founderr=True
    ElseIF NewClassId<>0 THEN
        Errorst="目标分类不能有下属子类！"
        founderr=True
    End IF	
    IF founderr=True THEN
        Call Form_Error()
    Else	
        Set Rs=server.Createobject("Adodb.Recordset")
            Sql="Select * from Tx_News where News_ClassId=" & Request.form("OldClassId")
            Rs.open Sql,Conn,1,3
            While Not Rs.Eof
                Rs("News_ClassId")=Request.form("NewClassId")
            Rs.MoveNext
            Wend
        Rs.Close
		Set Rs=Nothing
		Conn.Execute "Delete from Tx_NeClass Where Class_Id=" & Request.form("OldClassId")
		ToHistory="Aa_NeClass.asp?Action=Merges"
		saveok="数据合并成功！"
	    Call Form_Saveok()
	End IF
End Select
Call Page_Spane(5)
Call CloseConn()
Call Page_endBody()
%>