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

    Public AspToAspX_Host_Class_Object As Object

Public username
Public titleid
Public tel
Public age
Public sex
Public job
Public edu
Public address
Public qq
Public note
Public sql
Public rs As ADODB.Recordset
Public linkdb
Public ft
Public ku
Public ckiesdomain
Public conndb
Public ConnectionString
Public infotype
    Public ASPX_CONN As _CONN
    Public ASPX_INC_HTMLENCODE2 As _INC_HTMLENCODE2
#Region "..."
    Public Sub AspToAspX_InitIncludeFiles()
        ASPX_CONN = New _CONN()
        ASPX_CONN.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_CONN.AspToAspX_InitIncludeFiles()
        ASPX_INC_HTMLENCODE2 = New _INC_HTMLENCODE2()
        ASPX_INC_HTMLENCODE2.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_INC_HTMLENCODE2.AspToAspX_InitIncludeFiles()
    End Sub

    Public Sub AspToAspX_UnloadIncludeFiles()
        ASPX_CONN.AspToAspX_UnloadIncludeFiles()
        ASPX_CONN = Nothing
        ASPX_INC_HTMLENCODE2.AspToAspX_UnloadIncludeFiles()
        ASPX_INC_HTMLENCODE2 = 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_INC_HTMLENCODE2.AspToAspX_Page_Init ( )
    Response.Charset = "utf-8" '4
    username = Checkstr ( AspToAspX_CheckIsNothing ( Request.Form ( "username" ) ) ) '5
    username = Replace ( username , "union" , "" ) '6
    username = Replace ( username , "select" , "" ) '7
    titleid = AspToAspX_CInt ( Request ( "titleid" ) ) '8
    tel = AspToAspX_CheckIsNothing ( Request.Form ( "tel" ) ) '9
    age = AspToAspX_CheckIsNothing ( Request.Form ( "age" ) ) '10
    sex = AspToAspX_CheckIsNothing ( Request.Form ( "sex" ) ) '11
    job = AspToAspX_CheckIsNothing ( Request.Form ( "job" ) ) '12
    edu = AspToAspX_CheckIsNothing ( Request.Form ( "edu" ) ) '13
    address = AspToAspX_CheckIsNothing ( Request.Form ( "address" ) ) '14
    qq = AspToAspX_CheckIsNothing ( Request.Form ( "qq" ) ) '15
    If AspToAspX_CheckDBNull ( infotype ) = EmptyString.Value Then
infotype = 0
End If
    '16
        note = htmlencode2 ( AspToAspX_CheckIsNothing ( Request.Form ( "note" ) ) ) '17
        If IsDBNull ( username ) Or IsDBNull ( tel ) Or IsDBNull ( qq ) Or IsDBNull ( age ) Or Not AspToAspX_CheckIsNumeric ( tel ) Or Not AspToAspX_CheckIsNumeric ( age ) Or Not AspToAspX_CheckIsNumeric ( qq ) Then '18
            Response.Write ( "<script language='javascript'>" ) '19
            Response.Write ( "alert('电话,年龄,QQ号必须填写而且要填数字!');" ) '20
            Response.Write ( "history.go(-1);" ) '21
            Response.Write ( "</script>" ) '22
            Response.End ( ) '23
        End If '24
        sql = "select * from " & ft & "ftbbs_bmtb where username='" & username & "' and titleid=" & titleid & " order by id desc" '25
        rs = New ADODB.Recordset ( ) '26
        rs.Open ( sql , conn , 1 , 3 ) '27
        If rs.EOF Then '28
            rs.addnew ( ) '29
            rs.Fields ( "username" ) .Value = username '30
            rs.Fields ( "titleid" ) .Value = titleid '31
            rs.Fields ( "tel" ) .Value = tel '32
            rs.Fields ( "age" ) .Value = age '33
            rs.Fields ( "sex" ) .Value = sex '34
            rs.Fields ( "job" ) .Value = job '35
            rs.Fields ( "edu" ) .Value = edu '36
            rs.Fields ( "address" ) .Value = address '37
            rs.Fields ( "qq" ) .Value = qq '38
            rs.Fields ( "mynote" ) .Value = note '40
            rs.Update ( ) '41
            rs.Close ( ) '42
            rs = Nothing '43
            Response.Write ( "<SCRIPT language=JavaScript>alert('你提交成功！');history.go(-1);</script>" ) '44
        Else '45
            Response.Write ( "<SCRIPT language=JavaScript>alert('你已提交过了请不要重复提交！');history.go(-1);</script>" ) '46
            Response.End ( ) '47
        End If '48
        closedb ( ) '49
        Response.Write ( vbCrLf )

        AspToAspX_UnloadIncludeFiles()
        Exit Sub
    _AspToAspX_Err:
        AspToAspX_WriteLog ("bm_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 htmlencode2(ByRef  AspToAspX_Str )
        Return ASPX_INC_HTMLENCODE2.htmlencode2( AspToAspX_Str )
    End Function

    Public Function unhtmlencode2(ByRef  AspToAspX_Str )
        Return ASPX_INC_HTMLENCODE2.unhtmlencode2( AspToAspX_Str )
    End Function

#End Region
End Class