commentary.aspx.vb

这是用ASP.NET和SQLserver编写的购物网站的程序

Public Class _111
    Inherits System.Web.UI.Page
    Dim record As New DataSet
    Dim currentpage As Integer
    Dim showconnection As New SqlClient.SqlConnection("data source=(local);initial catalog=ECDB;user id=sa;pwd=200343")
    Dim showdataadapter As New SqlClient.SqlDataAdapter
    Dim maxpage As Integer
    Dim rowcount As Integer = 7
    Protected WithEvents Label3 As System.Web.UI.WebControls.Label
    Protected WithEvents Label4 As System.Web.UI.WebControls.Label
    Protected WithEvents Label5 As System.Web.UI.WebControls.Label
    Protected WithEvents Label6 As System.Web.UI.WebControls.Label
    Protected WithEvents LinkButton3 As System.Web.UI.WebControls.LinkButton
    Protected WithEvents LinkButton4 As System.Web.UI.WebControls.LinkButton
    Protected WithEvents LinkButton5 As System.Web.UI.WebControls.LinkButton
    Protected WithEvents LinkButton6 As System.Web.UI.WebControls.LinkButton
    Protected WithEvents Repeater1 As System.Web.UI.WebControls.Repeater
    Protected WithEvents LinkButton1 As System.Web.UI.WebControls.LinkButton
    Protected WithEvents Label7 As System.Web.UI.WebControls.Label
    Protected WithEvents Label8 As System.Web.UI.WebControls.Label
    Protected WithEvents Label9 As System.Web.UI.WebControls.Label
    Protected WithEvents Label10 As System.Web.UI.WebControls.Label
    Protected WithEvents LinkButton2 As System.Web.UI.WebControls.LinkButton
    Protected WithEvents Label11 As System.Web.UI.WebControls.Label
    Protected WithEvents ImageButton1 As System.Web.UI.WebControls.ImageButton
    Protected WithEvents HyperLink6 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents HyperLink5 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents HyperLink4 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents HyperLink3 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents HyperLink1 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents HyperLink2 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents Hyperlink7 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents Label12 As System.Web.UI.WebControls.Label
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents Label13 As System.Web.UI.WebControls.Label
    Dim rowsum As Integer
#Region " Web 窗体设计器生成的代码 "

    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents Label2 As System.Web.UI.WebControls.Label

    '注意: 以下占位符声明是 Web 窗体设计器所必需的。
    '不要删除或移动它。
    Private designerPlaceholderDeclaration As System.Object

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '在此处放置初始化页的用户代码
        If Not Page.IsPostBack Then
            If Session("userpower") = 1 Then
                Label12.Text = "欢迎" & Session("username")
                Label12.Visible = True
                Button1.Visible = True

            Else
                Label12.Visible = False
                Button1.Visible = False
            End If
            Dim showsentence As String
            showsentence = "select username,date,support,object,content from commentary order by date desc"
            showdataadapter = New SqlClient.SqlDataAdapter(showsentence, showconnection)
            record = New DataSet
            Try
                showdataadapter.Fill(record, "commentary")
                rowsum = record.Tables(0).Rows.Count
                Label8.Text = rowsum
            Catch ex As Exception
                rowsum = 0
            End Try
            If rowsum = 0 Then
                Exit Sub
            End If
            If rowsum Mod rowcount > 0 Then
                maxpage = rowsum \ rowcount + 1
            Else
                maxpage = rowsum \ rowcount
            End If
            currentpage = 1
            readpage(currentpage)
            binddata()
            Label5.Text = maxpage
            LinkButton3.Visible = False
            LinkButton4.Visible = False
            If maxpage = 1 Then
                LinkButton5.Visible = False
            Else
                LinkButton5.Visible = True
            End If
        End If
    End Sub
    Public Sub binddata()
        Repeater1.DataSource = record
        Repeater1.DataBind()
        Label2.Text = currentpage
    End Sub
    Public Sub readpage(ByVal n As Integer)
        Dim showsentence As String
        showsentence = "select username,date,support,object,content from commentary order by date desc"
        showdataadapter = New SqlClient.SqlDataAdapter(showsentence, showconnection)
        record = New DataSet
        record.Clear()
        showdataadapter.Fill(record, (n - 1) * rowcount, rowcount, "commentary")
    End Sub

    Private Sub linkButton2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton2.Click
        If Label2.Text = 1 Then
            currentpage = 1
            readpage(currentpage)
            binddata()
            LinkButton3.Visible = False
            LinkButton4.Visible = False
            LinkButton5.Visible = True
            LinkButton6.Visible = True
        ElseIf Label2.Text > 1 And Label2.Text < Label5.Text Then
            currentpage = Label2.Text
            readpage(currentpage)
            binddata()
            LinkButton3.Visible = True
            LinkButton4.Visible = True
            LinkButton5.Visible = True
            LinkButton6.Visible = True
        Else : Label2.Text = Label5.Text
            currentpage = Label5.Text
            readpage(currentpage)
            binddata()
            LinkButton3.Visible = True
            LinkButton4.Visible = True
            LinkButton5.Visible = False
            LinkButton6.Visible = False
        End If
    End Sub

    Private Sub linkButton3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton3.Click
        currentpage = 1
        readpage(currentpage)
        binddata()
        LinkButton3.Visible = False
        LinkButton4.Visible = False
        LinkButton5.Visible = True
        LinkButton6.Visible = True
    End Sub

    Private Sub linkButton4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton4.Click
        If Label2.Text > 2 Then
            LinkButton5.Visible = True
            LinkButton6.Visible = True
        Else
            LinkButton3.Visible = False
            LinkButton4.Visible = False
            LinkButton5.Visible = True
            LinkButton6.Visible = True
        End If
        currentpage = Label2.Text - 1
        readpage(currentpage)
        binddata()
    End Sub

    Private Sub linkButton5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton5.Click
        If Label2.Text < Label5.Text - 1 Then
            LinkButton3.Visible = True
            LinkButton4.Visible = True
        Else
            LinkButton3.Visible = True
            LinkButton4.Visible = True
            LinkButton5.Visible = False
            LinkButton6.Visible = False
        End If
        currentpage = Label2.Text + 1
        readpage(currentpage)
        binddata()
    End Sub

    Private Sub LinkButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton1.Click
        Response.Redirect("addcommentary.aspx")
    End Sub

    Private Sub linkButton6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton6.Click
        currentpage = Label5.Text
        readpage(currentpage)
        binddata()
        LinkButton3.Visible = True
        LinkButton4.Visible = True
        LinkButton5.Visible = False
        LinkButton6.Visible = False
    End Sub

    Private Sub Repeater1_ItemCommand(ByVal source As System.Object, ByVal e As System.Web.UI.WebControls.RepeaterCommandEventArgs) Handles Repeater1.ItemCommand
        Dim numbervalue As Integer
        numbervalue = Label8.Text - ((Label2.Text - 1) * rowcount + e.Item.ItemIndex)
        Dim updatesentence As String
        If e.CommandSource.ID = "support" Then
            updatesentence = "update commentary set support=support+1 where number='" & numbervalue & "'"
        Else
            updatesentence = "update commentary set object=object+1 where number='" & numbervalue & "'"
        End If
        Dim updatecommand As SqlClient.SqlCommand
        updatecommand = New SqlClient.SqlCommand(updatesentence, showconnection)
        showconnection.Open()
        updatecommand.ExecuteNonQuery()
        showconnection.Close()
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Session("uspower") = -1
        Label12.Visible = False
        Button1.Visible = False
    End Sub
End Class