info_delete.aspx.vb

本程序修改自飞天BBS 7.0 将原来的ASP语法迁移为ASP.NET并封装成DLL ASP.NET相对ASP有更快的执行效率以及更高的并发访问量 基于ASP.NET的DLL可以运行在支持ASP

' ***************************************************
' *        本程序由AspToAspX风火轮0.99转换生成      *
' *        http://Www.AspToAspX.Cn                  *
' *        Q Q :  139227536                         *
' *        QQ群:  17152722                          *
' *        MSN :  [e-mail]        *
' *        EMail  [e-mail]              *
' ***************************************************
Imports Microsoft.VisualBasic
Imports System.Web
Imports System.Math
Imports System.Web.SessionState


Public Class _BBSADMIN_INFO_DELETE
    Inherits System.Web.UI.Page
    Implements IHttpHandler, AspToAspX_Interface

    Public AspToAspX_Host_Class_Object As Object

Public sql
Public rs As ADODB.Recordset
Public i
Public return_url
Public ptuser
Public AspToAspX_Str
Public id
Public BoardID_1
Public BoardID_2
Public rep
Public deleted
Public htmfilename
Public pagenum
Public htm_ext
Public postget
Public k
Public page
Public htmarray
Public FiLePaTh
Public fnarr
Public fso
Public rsd
Public renum
Public sql0
Public rs0
Public oldpicFile
Public mypicFile
Public linkdb
Public ft
Public ku
Public ckiesdomain
Public conndb
Public ConnectionString
    Public ASPX_CONN As _CONN
    Public ASPX_ADMIN_CHECK_MASTER As _ADMIN_CHECK_MASTER
    Public ASPX_ADMIN_CHECK_ADMIN_QS As _ADMIN_CHECK_ADMIN_QS
    Public ASPX_ADMIN_DHFUN As _ADMIN_DHFUN
#Region "..."
    Public Sub AspToAspX_InitIncludeFiles()
        ASPX_CONN = New _CONN()
        ASPX_CONN.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_CONN.AspToAspX_InitIncludeFiles()
        ASPX_ADMIN_CHECK_MASTER = New _ADMIN_CHECK_MASTER()
        ASPX_ADMIN_CHECK_MASTER.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_ADMIN_CHECK_MASTER.AspToAspX_InitIncludeFiles()
        ASPX_ADMIN_CHECK_ADMIN_QS = New _ADMIN_CHECK_ADMIN_QS()
        ASPX_ADMIN_CHECK_ADMIN_QS.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_ADMIN_CHECK_ADMIN_QS.AspToAspX_InitIncludeFiles()
        ASPX_ADMIN_DHFUN = New _ADMIN_DHFUN()
        ASPX_ADMIN_DHFUN.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_ADMIN_DHFUN.AspToAspX_InitIncludeFiles()
    End Sub

    Public Sub AspToAspX_UnloadIncludeFiles()
        ASPX_CONN.AspToAspX_UnloadIncludeFiles()
        ASPX_CONN = Nothing
        ASPX_ADMIN_CHECK_MASTER.AspToAspX_UnloadIncludeFiles()
        ASPX_ADMIN_CHECK_MASTER = Nothing
        ASPX_ADMIN_CHECK_ADMIN_QS.AspToAspX_UnloadIncludeFiles()
        ASPX_ADMIN_CHECK_ADMIN_QS = Nothing
        ASPX_ADMIN_DHFUN.AspToAspX_UnloadIncludeFiles()
        ASPX_ADMIN_DHFUN = Nothing
    End Sub

#End Region
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
        AspToAspXGlobal.Application = Application
        AspToAspXGlobal.Server = Server
        AspToAspXGlobal.Response = Response
        AspToAspXGlobal.Request = Request
        AspToAspXGlobal.Session = Session
        AspToAspX_Host_Class_Object = Me
        AspToAspX_InitIncludeFiles()
        AspToAspX_Page_Init()
        End Sub
    Public Sub AspToAspX_Page_Init()
    On Error GoTo _AspToAspX_Err
    ASPX_CONN.AspToAspX_Page_Init ( )
    ASPX_ADMIN_CHECK_MASTER.AspToAspX_Page_Init ( )
    ASPX_ADMIN_CHECK_ADMIN_QS.AspToAspX_Page_Init ( )
    ASPX_ADMIN_DHFUN.AspToAspX_Page_Init ( )
    return_url = Request.QueryString ( "return_url" ) '8
    If AspToAspX_CheckDBNull ( return_url ) = EmptyString.Value Then '9
        return_url = "title_manage.aspx" '10
    End If '11
    ptuser = Request ( "ptuser" ) '12
    AspToAspX_Str = "select id,BoardID_1,BoardID_2,rep,deleted,htmfilename from " & ft & "bbstitle Where id=" & Request ( "id" ) '13
    rs = New ADODB.Recordset ( ) '14
    rs.Open ( AspToAspX_Str , conn , 1 , 1 ) '15
    id = AspToAspX_CheckDBNull(rs.Fields ( "id" ) .Value) '16
    BoardID_1 = AspToAspX_CheckDBNull(rs.Fields ( "BoardID_1" ) .Value) '17
    BoardID_2 = AspToAspX_CheckDBNull(rs.Fields ( "BoardID_2" ) .Value) '18
    rep = AspToAspX_CheckDBNull(rs.Fields ( "rep" ) .Value) '19
    deleted = AspToAspX_CheckDBNull(rs.Fields ( "deleted" ) .Value) '20
    htmfilename = AspToAspX_CheckDBNull(rs.Fields ( "htmfilename" ) .Value) '21
    FTBBS_HTML_MB ( ft ) '22
    pagenum = Application ( "FTBBSMB" ) ( 6 , 0 ) '23
    htm_ext = Application ( "FTBBSMB" ) ( 32 , 0 ) '24
    postget = Application ( "FTBBSMB" ) ( 48 , 0 ) '25
    k = rep / pagenum '26
    If AspToAspX_Int ( k ) = k And AspToAspX_Int ( k ) < > 0 Then '27
        page = k '28
    Else '29
        page = AspToAspX_Int ( k ) + 1 '30
    End If '31
    If AspToAspX_CheckDBNull ( htmfilename ) = EmptyString.Value Or IsDBNull ( htmfilename ) Then '32
        Response.Write ( "" ) '33
    Else '34
        htmarray = AspToAspX_Split ( htmfilename , "/" ) '35
        For i = 1 To Val ( page ) '36
            If AspToAspX_CheckDBNull ( i ) = 1 Then '37
                FiLePaTh = Server.MapPath ( "../" & htmfilename ) '38
            Else '39
                fnarr = AspToAspX_Split ( htmarray ( 1 ) , "." ) '40
                FiLePaTh = Server.MapPath ( "../" & htmarray ( 0 ) & "/" & fnarr ( 0 ) & "_" & i & htm_ext ) '41
            End If '42
            fso = New Scripting.FileSystemObject ( ) '43
            If AspToAspX_CheckDBNull ( fso.FileExists ( FiLePaTh ) ) = True Then '44
                fso.DeleteFile ( FiLePaTh ) '45
            End If '46
            fso = Nothing '47
        Next '48
    End If '49
    rsd = conn.Execute ( "select count(id) as kkk from " & ft & "bbsmenu where pid=" & Request ( "id" ) ) '50
    renum = AspToAspX_CheckDBNull(rsd.Fields ( "kkk" ) .Value) '51
    sql = "delete from " & ft & "bbstitle where id=" & Request ( "id" ) '52
    conn.Execute ( sql ) '53
    sql = "delete from " & ft & "bbsmenu where pid=" & Request ( "id" ) '54
    conn.Execute ( sql ) '55
    sql = "update " & ft & "BBS_Cate set BBS_Cate_Topic=BBS_Cate_Topic-1 where BBS_Cate_ID='" & BoardID_1 & "'" '56
    conn.Execute ( sql ) '57
    sql = "update " & ft & "BBS_Cate set BBS_Cate_Topic=BBS_Cate_Topic-1 where BBS_Cate_ID='" & BoardID_2 & "'" '58
    conn.Execute ( sql ) '59
    sql = "update " & ft & "BBS_Cate set BBS_Cate_Reply=BBS_Cate_Reply-" & renum & " where BBS_Cate_ID='" & BoardID_1 & "'" '60
    conn.Execute ( sql ) '61
    sql = "update " & ft & "BBS_Cate set BBS_Cate_Reply=BBS_Cate_Reply-" & renum & " where BBS_Cate_ID='" & BoardID_2 & "'" '62
    conn.Execute ( sql ) '63
    If AspToAspX_CheckDBNull ( deleted ) = 0 Then '64
        sql = "update " & ft & "clubuser set jingyuan=jingyuan-" & postget & ",postnum=postnum-1 where postnum>0 and clubuser_name='" & ptuser & "'" '65
    Else '66
        sql = "update " & ft & "clubuser set postnum=postnum-1 where postnum>0 and clubuser_name='" & ptuser & "'" '67
    End If '68
    conn.Execute ( sql ) '69
    sql0 = "select * from " & ft & "ftbbs_upload where upload_htm='" & htmfilename & "'" '71
    rs0 = New ADODB.Recordset ( ) '72
    rs0.Open ( sql0 , conn , 1 , 1 ) '73
    If Not rs0.EOF Then '74
        oldpicFile = "../" & AspToAspX_CheckDBNull(rs0.Fields ( "upload_pic" ) .Value) '75
        mypicFile = Server.MapPath ( oldpicFile ) '76
        fso = New Scripting.FileSystemObject ( ) '77
        If AspToAspX_CheckDBNull ( fso.FileExists ( mypicFile ) ) = True Then '78
            fso.DeleteFile ( mypicFile ) '79
        End If '80
        fso = Nothing '81
        sql = "delete from " & ft & "ftbbs_upload where upload_htm='" & htmfilename & "'" '82
        conn.Execute ( sql ) '83
    End If '84
    default_listbbsad ( ft ) '85
    conn.Close ( ) '86
    conn = Nothing '87
    If AspToAspX_CheckDBNull ( Request ( "bbs_img" ) ) < > EmptyString.Value Then '89
        mypicFile = "../" & htmarray ( 0 ) & "/" & Request ( "bbs_img" ) '91
        mypicFile = Server.MapPath ( mypicFile ) '92
        fso = New Scripting.FileSystemObject ( ) '93
        If AspToAspX_CheckDBNull ( fso.FileExists ( mypicFile ) ) = True Then '94
            fso.DeleteFile ( mypicFile ) '95
        End If '96
        fso = Nothing '97
    End If '98
    AspToAspX_Response_Redirect ( return_url ) '99
    Response.Write ( vbCrLf )

        AspToAspX_UnloadIncludeFiles()
        Exit Sub
    _AspToAspX_Err:
        AspToAspX_WriteLog ("info_delete_aspx Page_Init:" & Err.Description)
        Resume Next
        End Sub
#Region "..."
    Public Property conn
        Get
            conn = ASPX_CONN.conn
        End Get
        Set(ByVal value)
            ASPX_CONN.conn = value
        End Set
    End Property
    Public Property qs
        Get
            qs = ASPX_CONN.qs
        End Get
        Set(ByVal value)
            ASPX_CONN.qs = value
        End Set
    End Property
    Public Property errc
        Get
            errc = ASPX_CONN.errc
        End Get
        Set(ByVal value)
            ASPX_CONN.errc = value
        End Set
    End Property
    Public Property iii
        Get
            iii = ASPX_CONN.iii
        End Get
        Set(ByVal value)
            ASPX_CONN.iii = value
        End Set
    End Property
    Public Property nothis
        Get
            nothis = ASPX_CONN.nothis
        End Get
        Set(ByVal value)
            ASPX_CONN.nothis = value
        End Set
    End Property
    Public Sub makeftbbstree(ByRef  ft )
        ASPX_CONN.makeftbbstree( ft )
    End Sub

    Public Sub CloseDb
        ASPX_CONN.CloseDb
    End Sub

    Public Sub SaveToFile( ByVal strBody,ByVal File )
        ASPX_CONN.ASPX_ADOSTREAM.SaveToFile( strBody, File )
    End Sub

    Public Function Checkstr(ByRef  AspToAspX_Str )
        Return ASPX_CONN.Checkstr( AspToAspX_Str )
    End Function

    Public Function CheckCharStr(ByRef  usernamepsw,ByRef flag )
        Return ASPX_CONN.CheckCharStr( usernamepsw,flag )
    End Function

    Public Function ftbbs_msg(ByRef  msg,ByRef reurl )
        Return ASPX_CONN.ftbbs_msg( msg,reurl )
    End Function

    Public Function login_msg(ByRef  msg,ByRef reurl )
        Return ASPX_CONN.login_msg( msg,reurl )
    End Function

    Public Function FTBBS_HTML_MB(ByRef  ft )
        Return ASPX_CONN.FTBBS_HTML_MB( ft )
    End Function

    Public Function FTBBS_BZ_NAME(ByRef  BoardID_1,ByRef ft )
        Return ASPX_CONN.FTBBS_BZ_NAME( BoardID_1,ft )
    End Function

    Public Function FTBBS_BZ_NAME2(ByRef  BoardID_1,ByRef BoardID_2,ByRef ft )
        Return ASPX_CONN.FTBBS_BZ_NAME2( BoardID_1,BoardID_2,ft )
    End Function

    Public Function makefilename(ByRef  fname )
        Return ASPX_CONN.makefilename( fname )
    End Function

    Public Function GetExtendName(ByRef  FileName )
        Return ASPX_CONN.GetExtendName( FileName )
    End Function

    Public Function IsObjInstalled(ByRef  strClassString )
        Return ASPX_CONN.IsObjInstalled( strClassString )
    End Function

    Public Function ChkMapPath( ByVal strPath )
        Return ASPX_CONN.ChkMapPath( strPath )
    End Function

    Public Function userlogin(ByRef  ft )
        Return ASPX_CONN.userlogin( ft )
    End Function

    Public Function headhtml
        Return ASPX_CONN.headhtml
    End Function

    Public Function GetOpInfo(ByRef  AspToAspX_Str,ByRef Flag )
        Return ASPX_CONN.GetOpInfo( AspToAspX_Str,Flag )
    End Function

    Public Function getcode
        Return ASPX_CONN.getcode
    End Function

    Public Function codepass
        Return ASPX_CONN.codepass
    End Function

    Public Function Ftbbs_Time
        Return ASPX_CONN.Ftbbs_Time
    End Function

    Public Function ft_home(ByRef  defaulthome )
        Return ASPX_CONN.ft_home( defaulthome )
    End Function

    Public Function chkpost
        Return ASPX_CONN.chkpost
    End Function

    Public Function CodeCookie(ByRef  AspToAspX_Str )
        Return ASPX_CONN.CodeCookie( AspToAspX_Str )
    End Function

    Public Function DecodeCookie(ByRef  AspToAspX_Str )
        Return ASPX_CONN.DecodeCookie( AspToAspX_Str )
    End Function

    Public Function setcookie(ByRef  cookexpires,ByRef cookdomain,ByRef cookneme,ByRef cookvalue )
        Return ASPX_CONN.setcookie( cookexpires,cookdomain,cookneme,cookvalue )
    End Function

    Public Function getcookie(ByRef  ckname )
        Return ASPX_CONN.getcookie( ckname )
    End Function

    Public Function clearcookie(ByRef  cookdomain,ByRef cookneme )
        Return ASPX_CONN.clearcookie( cookdomain,cookneme )
    End Function

    Public Function LoadFile( ByVal File )
        Return ASPX_CONN.ASPX_ADOSTREAM.LoadFile( File )
    End Function

    Public Function adminlogin(ByRef  ft )
        Return ASPX_ADMIN_CHECK_MASTER.adminlogin( ft )
    End Function

    Public Function maketodh(ByRef  ft )
        Return ASPX_ADMIN_DHFUN.maketodh( ft )
    End Function

    Public Function bbsad(ByRef  ft )
        Return ASPX_ADMIN_DHFUN.bbsad( ft )
    End Function

    Public Function listad(ByRef  ft )
        Return ASPX_ADMIN_DHFUN.listad( ft )
    End Function

    Public Function default_listbbsad(ByRef  ft )
        Return ASPX_ADMIN_DHFUN.default_listbbsad( ft )
    End Function

    Public Function default_listad(ByRef  ft )
        Return ASPX_ADMIN_DHFUN.default_listad( ft )
    End Function

    Public Function sitead(ByRef  ft )
        Return ASPX_ADMIN_DHFUN.sitead( ft )
    End Function

    Public Function htmtop(ByRef  ft )
        Return ASPX_ADMIN_DHFUN.htmtop( ft )
    End Function

    Public Function ftbbshomead(ByRef  ft )
        Return ASPX_ADMIN_DHFUN.ftbbshomead( ft )
    End Function

    Public Function postad(ByRef  ft )
        Return ASPX_ADMIN_DHFUN.postad( ft )
    End Function

    Public Function indexad(ByRef  ft )
        Return ASPX_ADMIN_DHFUN.indexad( ft )
    End Function

#End Region
End Class