poll.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 _POLL
    Inherits System.Web.UI.Page
    Implements IHttpHandler, AspToAspX_Interface

    Public AspToAspX_Host_Class_Object As Object

Public n
Public k
Public voteid
Public tptype
Public titleid
Public idarr
Public rs As ADODB.Recordset
Public sql
Public poll_user
Public AspToAspX_Str
Public rstp
Public Vote_Count_Total
Public linkdb
Public ft
Public ku
Public ckiesdomain
Public conndb
Public ConnectionString
    Public ASPX_CONN As _CONN
#Region "..."
    Public Sub AspToAspX_InitIncludeFiles()
        ASPX_CONN = New _CONN()
        ASPX_CONN.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_CONN.AspToAspX_InitIncludeFiles()
    End Sub

    Public Sub AspToAspX_UnloadIncludeFiles()
        ASPX_CONN.AspToAspX_UnloadIncludeFiles()
        ASPX_CONN = 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 ( )
    n = "" '4
    voteid = Request.QueryString ( "vote" ) '5
    tptype = AspToAspX_Int ( ( Request.QueryString ( "tptype" ) ) ) '6
    titleid = AspToAspX_Int ( ( Request.QueryString ( "pollid" ) ) ) '7
    If AspToAspX_Len ( voteid ) > 1 Then '8
        idarr = AspToAspX_Split ( voteid , "|" ) '9
        If AspToAspX_CheckDBNull ( tptype ) = 1 Then '10
            rs = New ADODB.Recordset ( ) '11
            sql = "SELECT top 1 * FROM " & ft & "ftbbs_poll_ip where poll_user_ip='" & AspToAspX_GetRequestServerVariables ( "remote_addr" ) & "' and bbstitleid=" & titleid '12
            rs.Open ( sql , conn , 1 , 3 ) '13
            If rs.BOF Then '14
                rs = New ADODB.Recordset ( ) '15
                sql = "SELECT top 1 * FROM " & ft & "BBS_Poll where id=" & idarr ( 1 ) & " " '16
                rs.Open ( sql , conn , 1 , 3 ) '17
                If Not ( rs.BOF And rs.EOF ) Then '18
                    rs.Fields ( "票数" ) .Value = AspToAspX_CheckDBNull(rs.Fields ( "票数" ) .Value) + 1 '19
                    rs.Update ( ) '20
                    If AspToAspX_CheckDBNull ( getcookie ( "name" ) ) < > EmptyString.Value Then '21
                        poll_user = getcookie ( "name" ) '22
                    Else '23
                        poll_user = "过客" '24
                    End If '25
                    sql = "insert into " & ft & "ftbbs_poll_ip (bbstitleid,poll_user,poll_user_ip) values('" & titleid & "','" & poll_user & "','" & AspToAspX_GetRequestServerVariables ( "remote_addr" ) & "')" '26
                    conn.Execute ( sql ) '27
                End If '28
            End If '29
            rs.Close ( ) '30
            rs = Nothing '31
        Else '32
            rs = New ADODB.Recordset ( ) '33
            sql = "SELECT top 1 * FROM " & ft & "ftbbs_poll_ip where poll_user_ip='" & AspToAspX_GetRequestServerVariables ( "remote_addr" ) & "' and bbstitleid=" & titleid '34
            rs.Open ( sql , conn , 1 , 3 ) '35
            If rs.BOF Then '36
                For k = 1 To Val ( UBound ( idarr ) ) '37
                    sql = "update " & ft & "BBS_Poll set 票数=票数+1 where id=" & idarr ( k ) '38
                    conn.Execute ( sql ) '39
                Next '40
                If AspToAspX_CheckDBNull ( getcookie ( "name" ) ) < > EmptyString.Value Then '42
                    poll_user = getcookie ( "name" ) '43
                Else '44
                    poll_user = "过客" '45
                End If '46
                sql = "insert into " & ft & "ftbbs_poll_ip (bbstitleid,poll_user,poll_user_ip) values('" & titleid & "','" & poll_user & "','" & AspToAspX_GetRequestServerVariables ( "remote_addr" ) & "')" '48
                conn.Execute ( sql ) '49
            End If '50
        End If '51
    End If '52
    AspToAspX_Str = "select sum(票数) as total from " & ft & "BBS_Poll where pid=" & titleid '53
    rstp = conn.Execute ( AspToAspX_Str ) '54
    Vote_Count_Total = AspToAspX_CheckDBNull(rstp.Fields ( "total" ) .Value) '55
    rs = New ADODB.Recordset ( ) '56
    sql = "SELECT * FROM " & ft & "BBS_Poll where pid=" & titleid & " " '57
    rs.Open ( sql , conn , 1 , 1 ) '58
    rs.MoveNext ( ) '59
    Do While Not rs.EOF '60
        n = n & " " & AspToAspX_CheckDBNull(rs.Fields ( "票数" ) .Value) '61
        rs.MoveNext ( ) '62
    Loop '63
    closedb ( ) '64
    Response.Charset = "utf-8" '65
    Response.Write ( trim ( n ) & " " & Vote_Count_Total ) '66
    Response.Write ( vbCrLf )

        AspToAspX_UnloadIncludeFiles()
        Exit Sub
    _AspToAspX_Err:
        AspToAspX_WriteLog ("Poll_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

#End Region
End Class