frmuserman.vb

vb2005人事管理系统源码

Public Class FrmUserMan




    Private Sub BtOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtSaveEdit.Click
        If Trim(TxtUserName.Text) = "" Then
            MsgBox("输入的用户名不能为空！", MsgBoxStyle.Exclamation, "信息框")
            Exit Sub
        End If
        If Trim(TxtRealName.Text) = "" Then
            MsgBox("输入的用户真实姓名不能为空！", MsgBoxStyle.Exclamation, "信息框")
            Exit Sub
        End If
        If Trim(TxtPassword.Text) = "" Then
            MsgBox("输入的密码不能为空！", MsgBoxStyle.Exclamation, "信息框")
            Exit Sub
        End If
        Dim TempUser As New ClsUser(TxtUserName.Text, TxtPassword.Text)
        TempUser.RealName = Trim(TxtRealName.Text)
        TempUser.ModDepartment = Trim(ComboModDempartment.Text)
        TempUser.ModEmployees = Trim(ComboModEmployees.Text)
        TempUser.ModCheckIn = Trim(ComboModCheckIn.Text)
        TempUser.ModEvaluation = Trim(ComboModEvaluation.Text)
        TempUser.ModSarlary = Trim(ComboModSalary.Text)
        TempUser.Memo = Trim(TxtMemo.Text)
        If TxtUserName.Enabled = True Then
            User.AddUser(TempUser)
            TxtUserName.Enabled = False
        Else
            User.DelUser(LBUserName.SelectedItem)
            User.AddUser(TempUser)
        End If
        FrmEditUser_Load(sender, e)
        LBUserName.SelectedIndex = 0
    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 = ClsOperation.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 = ClsOperation.DBOperate(SQLString, MSG)
        TxtUserName.Text = UserTable.Rows(0)("UserName")
        TxtRealName.Text = UserTable.Rows(0)("RealName")
        TxtPassword.Text = UserTable.Rows(0)("Password")
        TxtMemo.Text = UserTable.Rows(0)("Memo")
        ComboModDempartment.Text = UserTable.Rows(0)("ModDepartment")
        ComboModEmployees.Text = UserTable.Rows(0)("ModEmployees")
        ComboModCheckIn.Text = UserTable.Rows(0)("ModCheckIn")
        ComboModEvaluation.Text = UserTable.Rows(0)("ModEvaluation")
        ComboModSalary.Text = UserTable.Rows(0)("ModSalary")
        TxtUserName.Enabled = False
    End Sub

    Private Sub BtnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnAdd.Click
        TxtUserName.Text = ""
        TxtRealName.Text = ""
        TxtPassword.Text = ""
        TxtMemo.Text = ""
        Me.ComboModDempartment.SelectedIndex = 0
        Me.ComboModEmployees.SelectedIndex = 0
        Me.ComboModCheckIn.SelectedIndex = 0
        Me.ComboModEvaluation.SelectedIndex = 0
        Me.ComboModSalary.SelectedIndex = 0
        TxtUserName.Enabled = True
    End Sub

    Private Sub BtnDel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnDel.Click
        Dim SelectUser As String = LBUserName.SelectedItems(0).Text
        If SelectUser = "Admin" Then
            MsgBox("不能删除管理员！", MsgBoxStyle.Exclamation, "信息框")
            Exit Sub
        End If
        User.DelUser(LBUserName.SelectedItem)
        FrmEditUser_Load(sender, e)
        LBUserName.SelectedIndex = 0
    End Sub
End Class