?'****************************************************************************
'人人為我，我為人人
'枕善居漢化收藏整理
'發(fā)布日期：2007/07/23
'描    述：網(wǎng)吧計(jì)費(fèi)管理系統(tǒng)客戶端/服務(wù)器端
'網(wǎng)    站：http://www.Mndsoft.com/  (VB6源碼博客)
'網(wǎng)    站：http://www.VbDnet.com/   (VB.NET源碼博客,主要基于.NET2005)
'e-mail  ：Mndsoft@163.com
'e-mail  ：Mndsoft@126.com
'OICQ    ：88382850
'          如果您有新的好的代碼別忘記給枕善居哦!
'****************************************************************************
Public Class FrmEditSuperUser




    Private Sub BtOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtOK.Click
        If Trim(TxtRealName.Text) = "" Then
            MsgBox("輸入的用戶真實(shí)姓名不能為空！", MsgBoxStyle.Exclamation, "信息框")
            Exit Sub
        End If
        If Trim(TxtPassword.Text) = "" Then
            MsgBox("輸入的密碼不能為空！", MsgBoxStyle.Exclamation, "信息框")
            Exit Sub
        End If
        NewSuperUser.DelUser(LBUserName.SelectedItem)
        Dim TempUser As New ClsSuperUser(LBUserName.SelectedItem, TxtPassword.Text)
        TempUser.RealName = Trim(TxtRealName.Text)
        TempUser.ModUser = Trim(ComboModUser.Text)
        TempUser.ModComputer = Trim(ComboModComputer.Text)
        TempUser.Memo = Trim(TxtMemo.Text)
        NewSuperUser.AddUser(TempUser)
    End Sub

    Private Sub FrmEditUser_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        LBUserName.Items.Clear()
        'SQL查詢語(yǔ)句
        Dim SQLString As String = "SELECT * FROM tbSuperUser"
        Dim UserTable As DataTable = ClsDBOperation.DBOperate(SQLString)
        Dim UserRow As DataRow
        For Each UserRow In UserTable.Rows
            LBUserName.Items.Add(UserRow("UserName"))
        Next
    End Sub

    Private Sub BtCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtCancel.Click
        Me.Close()
    End Sub

    Private Sub LBUserName_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LBUserName.SelectedIndexChanged
        Dim SQLString As String = "SELECT * FROM tbSuperUser WHERE UserName='" & LBUserName.SelectedItem & "'"
        Dim UserTable As DataTable = ClsDBOperation.DBOperate(SQLString)
        TxtRealName.Text = UserTable.Rows(0)("RealName")
        TxtPassword.Text = UserTable.Rows(0)("Password")
        TxtMemo.Text = UserTable.Rows(0)("Memo")
        ComboModUser.Text = UserTable.Rows(0)("ModUser")
        ComboModComputer.Text = UserTable.Rows(0)("ModComputer")
    End Sub
End Class