frmedituser.vb

Visual Basic 2005数据库通用模块开发与系统移植 物业管理信息系统

Public Class FrmEditUser




    Private Sub BtOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtOK.Click
        If Trim(TxtRealName.Text) = "" Then
            MsgBox("输入的用户真实姓名不能为空！", MsgBoxStyle.Exclamation, "信息框")
            Exit Sub
        End If
        If Trim(TxtPassword.Text) = "" Then
            MsgBox("输入的密码不能为空！", MsgBoxStyle.Exclamation, "信息框")
            Exit Sub
        End If
        User.DelUser(LBUserName.SelectedItem)
        Dim TempUser As New DBUser(LBUserName.SelectedItem, TxtPassword.Text)
        TempUser.RealName = Trim(TxtRealName.Text)
        TempUser.ModHouse = Trim(ComboModHouse.Text)
        TempUser.ModFee = Trim(ComboModFee.Text)
        TempUser.ModRepair = Trim(ComboModRepair.Text)
        TempUser.Memo = Trim(TxtMemo.Text)
        User.AddUser(TempUser)
    End Sub

    Private Sub FrmEditUser_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        LBUserName.Items.Clear()
        Dim SQLString As String = "SELECT * FROM tbUser"
        'SQL查询语句
        Dim MSG As String
        Dim UserTable As DataTable = DBOperation.DBOperate(SQLString, MSG)
        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 tbUser WHERE UserName='" & LBUserName.SelectedItem & "'"
        Dim MSG As String
        Dim UserTable As DataTable = DBOperation.DBOperate(SQLString, MSG)
        TxtRealName.Text = UserTable.Rows(0)("RealName")
        TxtPassword.Text = UserTable.Rows(0)("Password")
        TxtMemo.Text = UserTable.Rows(0)("Memo")
        ComboModHouse.Text = UserTable.Rows(0)("ModHouse")
        ComboModFee.Text = UserTable.Rows(0)("ModFee")
        ComboModRepair.Text = UserTable.Rows(0)("ModRepair")
    End Sub

End Class