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

    Public AspToAspX_Host_Class_Object As Object

Public i
Public userid
Public blogtypeid
Public NewsDate
Public myarray
Public yy
Public mm
Public dd
Public idstr
Public sql
Public rs As ADODB.Recordset
Public wzrep
Public wzpage
Public wzpagecount
Public wzcount
Public linkdb
Public ft
Public ku
Public ckiesdomain
Public conndb
Public ConnectionString
Public username
Public userimg
Public homepagetitle
Public cssfile
Public bokeer
Public blog_mid
Public blogheadimg
Public clubuser_id
Public rs8
Public CurrentDate
Public PreviousMonthDate
Public NextMonthDate
Public bgnum
Public ym
Public j
Public CurrentWeekDay
Public LinkText
    Public ASPX_CONN As _CONN
    Public ASPX_INC_PUBLICFUN As _INC_PUBLICFUN
    Public ASPX_INC_UBBCODE As _INC_UBBCODE
    Public ASPX_MEMBERINFO As _MEMBERINFO
    Public ASPX_USERNAV As _USERNAV
    Public ASPX_BOKERHEAD As _BOKERHEAD
    Public ASPX_RBLOG As _RBLOG
    Public ASPX_TAIL As _TAIL
#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_PUBLICFUN = New _INC_PUBLICFUN()
        ASPX_INC_PUBLICFUN.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_INC_PUBLICFUN.AspToAspX_InitIncludeFiles()
        ASPX_INC_UBBCODE = New _INC_UBBCODE()
        ASPX_INC_UBBCODE.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_INC_UBBCODE.AspToAspX_InitIncludeFiles()
        ASPX_MEMBERINFO = New _MEMBERINFO()
        ASPX_MEMBERINFO.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_MEMBERINFO.AspToAspX_InitIncludeFiles()
        ASPX_USERNAV = New _USERNAV()
        ASPX_USERNAV.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_USERNAV.AspToAspX_InitIncludeFiles()
        ASPX_BOKERHEAD = New _BOKERHEAD()
        ASPX_BOKERHEAD.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_BOKERHEAD.AspToAspX_InitIncludeFiles()
        ASPX_RBLOG = New _RBLOG()
        ASPX_RBLOG.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_RBLOG.AspToAspX_InitIncludeFiles()
        ASPX_TAIL = New _TAIL()
        ASPX_TAIL.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_TAIL.AspToAspX_InitIncludeFiles()
    End Sub

    Public Sub AspToAspX_UnloadIncludeFiles()
        ASPX_CONN.AspToAspX_UnloadIncludeFiles()
        ASPX_CONN = Nothing
        ASPX_INC_PUBLICFUN.AspToAspX_UnloadIncludeFiles()
        ASPX_INC_PUBLICFUN = Nothing
        ASPX_INC_UBBCODE.AspToAspX_UnloadIncludeFiles()
        ASPX_INC_UBBCODE = Nothing
        ASPX_MEMBERINFO.AspToAspX_UnloadIncludeFiles()
        ASPX_MEMBERINFO = Nothing
        ASPX_USERNAV.AspToAspX_UnloadIncludeFiles()
        ASPX_USERNAV = Nothing
        ASPX_BOKERHEAD.AspToAspX_UnloadIncludeFiles()
        ASPX_BOKERHEAD = Nothing
        ASPX_RBLOG.AspToAspX_UnloadIncludeFiles()
        ASPX_RBLOG = Nothing
        ASPX_TAIL.AspToAspX_UnloadIncludeFiles()
        ASPX_TAIL = 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_PUBLICFUN.AspToAspX_Page_Init ( )
    ASPX_INC_UBBCODE.AspToAspX_Page_Init ( )
    userid = AspToAspX_CInt ( ( Request.QueryString ( "userid" ) ) ) '5
    Response.Write ( vbCrLf )
    ASPX_MEMBERINFO.AspToAspX_Page_Init ( )
    blogtypeid = Request.QueryString ( "blogtypeid" ) '9
    NewsDate = Checkstr ( Request ( "NewsDate" ) ) '10
    If AspToAspX_CheckDBNull ( NewsDate ) < > EmptyString.Value Then '11
        myarray = AspToAspX_Split ( NewsDate , "-" , - 1 , 1 ) '12
        yy = myarray ( 0 ) '13
        mm = myarray ( 1 ) '14
        dd = myarray ( 2 ) '15
    End If '16
    If AspToAspX_CheckDBNull ( blogtypeid ) < > EmptyString.Value Then '17
        idstr = "and " & ft & "ftblog.blogtypeid=" & AspToAspX_Int ( blogtypeid ) '18
    Else '19
        idstr = "" '20
    End If '21
    Response.Write ( vbCrLf )
    Response.Write ( "<html><head><meta http-equiv=content-type content=""text/html; charset=utf-8"">" & Chr ( 13 ) ) '23
    Response.Write ( "</head>" & Chr ( 13 ) ) '24
    Response.Write ( "<body>" & Chr ( 13 ) ) '25
    Response.Write ( "<center>" & Chr ( 13 ) ) '26
    Response.Write ( "<title>" ) '27
    Response.Write ( username ) '27
    Response.Write ( "的日志</title>" & Chr ( 13 ) ) '27
    Response.Write ( "<link rel=""stylesheet"" type=""text/css"" href=""" ) '28
    Response.Write ( cssfile ) '28
    Response.Write ( """>" & Chr ( 13 ) ) '28
    ASPX_USERNAV.AspToAspX_Page_Init ( )
    ASPX_BOKERHEAD.AspToAspX_Page_Init ( )
    Response.Write ( "<div class=""stage"">" & Chr ( 13 ) ) '31
    Response.Write ( "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"" id=""layout"">" & Chr ( 13 ) ) '32
    Response.Write ( "<tr>" & Chr ( 13 ) ) '33
    Response.Write ( "<td valign=""top"" class=""c2t1"">" & Chr ( 13 ) ) '34
    Response.Write ( "<div id=""mod_bloglist"" class=""mod"" rel=""drag"">" & Chr ( 13 ) ) '35
    Response.Write ( "" & Chr ( 9 ) & "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"" class=""modth"">" & Chr ( 13 ) ) '36
    Response.Write ( "" & Chr ( 9 ) & "<tr><td class=""modtl"" width=""7"">&nbsp;</td>" & Chr ( 13 ) ) '37
    Response.Write ( "" & Chr ( 9 ) & "<td class=""modtc"" nowrap><div class=""modhead""><span class=""modtit"">文章列表</span></div></td>" & Chr ( 13 ) ) '38
    Response.Write ( "" & Chr ( 9 ) & "<td class=""modtc"" nowrap align=""right""></td>" & Chr ( 13 ) ) '39
    Response.Write ( "" & Chr ( 9 ) & "<td class=""modtr"" width=""7"">&nbsp;</td>" & Chr ( 13 ) ) '40
    Response.Write ( "" & Chr ( 9 ) & "</tr></table>" & Chr ( 13 ) ) '41
    Response.Write ( "<div id=""m_blog"" class=""modbox"">" & Chr ( 13 ) ) '42
    If AspToAspX_CheckDBNull ( NewsDate ) < > EmptyString.Value Then '44
        sql = "select " & ft & "ftblog.id," & ft & "ftblog.blogtitle," & ft & "ftblog.blogtypeid," & ft & "ftblog_type.blogtype," & ft & "ftblog.blogcontent," & ft & "ftblog.writedate," & ft & "ftblog.blogplnum," & ft & "ftblog.hits from " & ft & "ftblog," & ft & "ftblog_type where year(" & ft & "ftblog.writedate)='" & yy & "' and month(" & ft & "ftblog.writedate)='" & mm & "' and day(" & ft & "ftblog.writedate)='" & dd & "' and " & ft & "ftblog.blogtypeid=" & ft & "ftblog_type.id and " & ft & "ftblog.sign=0 and " & ft & "ftblog_type.blogphoto=0 and " & ft & "ftblog.userid=" & userid & " " & idstr & " order by " & ft & "ftblog.id desc" '45
    Else '46
        sql = "select " & ft & "ftblog.id," & ft & "ftblog.blogtitle," & ft & "ftblog.blogtypeid," & ft & "ftblog_type.blogtype," & ft & "ftblog.blogcontent," & ft & "ftblog.writedate," & ft & "ftblog.blogplnum," & ft & "ftblog.hits from " & ft & "ftblog," & ft & "ftblog_type where " & ft & "ftblog.blogtypeid=" & ft & "ftblog_type.id and " & ft & "ftblog.sign=0 and " & ft & "ftblog_type.blogphoto=0 and " & ft & "ftblog.userid=" & userid & " " & idstr & " order by " & ft & "ftblog.id desc" '47
    End If '48
    rs = New ADODB.Recordset ( ) '49
    rs.Open ( sql , conn , 3 , 1 ) '50
    If Not rs.EOF Then '51
        wzrep = 8 '52
        wzpage = AspToAspX_CInt ( ( Request.QueryString ( "page" ) ) ) '53
    If AspToAspX_Len ( wzpage ) = 0 Or AspToAspX_CheckDBNull ( wzpage ) = 0 Then
wzpage = 1
End If
    '54
        rs.PageSize = wzrep '55
        rs.AbsolutePage = wzpage '56
        wzpagecount = rs.PageCount '57
        wzcount = rs.RecordCount '58
        For i = 0 To Val ( wzrep ) - 1 '59
        If rs.EOF Then
Exit For
End If
    '60
            Response.Write ( vbCrLf )
            Response.Write ( "" & Chr ( 9 ) & "<div class=""line"">&nbsp;</div>" & Chr ( 13 ) ) '62
            Response.Write ( "" & Chr ( 9 ) & "<div class=""tit""><a href=""myblog.aspx?id=" ) '63
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "id" ) .Value) ) '63
            Response.Write ( "&userid=" ) '63
            Response.Write ( userid ) '63
            Response.Write ( "&blogtypeid=" ) '63
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "blogtypeid" ) .Value) ) '63
            Response.Write ( """>" ) '63
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "blogtitle" ) .Value) ) '63
            Response.Write ( "</a></div>" & Chr ( 13 ) ) '63
            Response.Write ( "" & Chr ( 9 ) & "<div class=""date"">" ) '64
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "writedate" ) .Value) ) '64
            Response.Write ( "</div>" & Chr ( 13 ) ) '64
            Response.Write ( "" & Chr ( 9 ) & "" ) '65
            Response.Write ( left ( nohtml ( AspToAspX_CheckDBNull(rs.Fields ( "blogcontent" ) .Value) ) , 200 ) ) '65
        If AspToAspX_Len ( nohtml ( AspToAspX_CheckDBNull(rs.Fields ( "blogcontent" ) .Value) ) ) > 200 Then
Response.Write ( "......" )
End If
    '65
        Response.Write ( vbCrLf )
            Response.Write ( "    <div class=""opt""><a href=""boker.aspx?blogtypeid=" ) '66
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "blogtypeid" ) .Value) ) '66
            Response.Write ( "&userid=" ) '66
            Response.Write ( userid ) '66
            Response.Write ( """ title=""查看该分类中所有文章"">类别：" ) '66
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "blogtype" ) .Value) ) '66
            Response.Write ( "</a> | <a href=""myblog.aspx?id=" ) '66
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "id" ) .Value) ) '66
            Response.Write ( "&blogtypeid=" ) '66
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "blogtypeid" ) .Value) ) '66
            Response.Write ( "&userid=" ) '66
            Response.Write ( userid ) '66
            Response.Write ( "#comment"" title=""查看该文章的所有评论"">评论(" ) '66
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "blogplnum" ) .Value) ) '66
            Response.Write ( ")</a> | <a href=""myblog.aspx?id=" ) '66
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "id" ) .Value) ) '66
            Response.Write ( "&blogtypeid=" ) '66
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "blogtypeid" ) .Value) ) '66
            Response.Write ( "&userid=" ) '66
            Response.Write ( userid ) '66
            Response.Write ( """ title=""浏览全文"">浏览(" ) '66
            Response.Write ( AspToAspX_CheckDBNull(rs.Fields ( "hits" ) .Value) ) '66
            Response.Write ( ")</a></div>" & Chr ( 13 ) ) '66
            rs.MoveNext ( ) '68
        Next '69
        rs.Close ( ) '70
        rs = Nothing '71
        Response.Write ( vbCrLf )
        Response.Write ( "<div class=""line"">&nbsp;</div>" & Chr ( 13 ) ) '73
        Response.Write ( "<div class=""ftblog"">" ) '74
        Response.Write ( pagination ( wzpagecount , userid ) ) '74
        Response.Write ( "</div>" & Chr ( 13 ) ) '74
    Else '75
    Response.Write ( vbCrLf )
        Response.Write ( "<div class=""date"">数据为空</div>" & Chr ( 13 ) ) '76
    End If '77
    Response.Write ( vbCrLf )
    Response.Write ( "</div>" & Chr ( 13 ) ) '78
    Response.Write ( "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"" height=""8"">" & Chr ( 13 ) ) '79
    Response.Write ( "<tr><td class=""modbl"" width=""7"">&nbsp;</td>" & Chr ( 13 ) ) '80
    Response.Write ( "<td class=""modbc"">&nbsp;</td>" & Chr ( 13 ) ) '81
    Response.Write ( "<td class=""modbr"" width=""7"">&nbsp;</td>" & Chr ( 13 ) ) '82
    Response.Write ( "</tr></table>" & Chr ( 13 ) ) '83
    Response.Write ( "</div>" & Chr ( 13 ) ) '84
    Response.Write ( "</td>" & Chr ( 13 ) ) '85
    Response.Write ( "<td class=""c2t2"">&nbsp;</td>" & Chr ( 13 ) ) '86