frmaddusers.frm

人事工资管理系统应包含对员工档案、员工培训、员工调动、员工职称评定、员工奖惩的管理和工资的查询与管理等诸多模块。员工档案管理模块对员工信息进行添加、修改、删除和查询；员工培训管理模块可增加

VERSION 5.00
Object = "{3A6644DE-3402-11D9-9DE7-C33FAA87690A}#1.0#0"; "WinXPCEngine.ocx"
Begin VB.Form FrmAddUsers 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "添加用户"
   ClientHeight    =   3150
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   4590
   Icon            =   "FrmAddUsers.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   3150
   ScaleWidth      =   4590
   ShowInTaskbar   =   0   'False
   Begin VB.PictureBox PicAddUser 
      Height          =   2175
      Left            =   240
      ScaleHeight     =   2115
      ScaleWidth      =   4035
      TabIndex        =   6
      Top             =   120
      Width           =   4095
      Begin VB.ComboBox CmbPopedom 
         Height          =   300
         ItemData        =   "FrmAddUsers.frx":000C
         Left            =   1440
         List            =   "FrmAddUsers.frx":0016
         TabIndex        =   5
         Top             =   1620
         Width           =   2175
      End
      Begin VB.TextBox TxtUserName 
         Height          =   270
         Left            =   1440
         MaxLength       =   15
         TabIndex        =   2
         ToolTipText     =   "用户名称字符长度不能超过15"
         Top             =   240
         Width           =   2175
      End
      Begin VB.TextBox TxtPassWord 
         Height          =   270
         IMEMode         =   3  'DISABLE
         Left            =   1440
         MaxLength       =   10
         PasswordChar    =   "*"
         TabIndex        =   3
         ToolTipText     =   "用户密码字符长度不能超过15"
         Top             =   720
         Width           =   2175
      End
      Begin VB.TextBox TxtOkPwd 
         Height          =   270
         IMEMode         =   3  'DISABLE
         Left            =   1440
         MaxLength       =   10
         PasswordChar    =   "*"
         TabIndex        =   4
         ToolTipText     =   "用户密码字符长度不能超过15"
         Top             =   1200
         Width           =   2175
      End
      Begin VB.Label LblPopedom 
         AutoSize        =   -1  'True
         Caption         =   "用户权限："
         Height          =   180
         Left            =   240
         TabIndex        =   10
         Top             =   1680
         Width           =   900
      End
      Begin VB.Label LblUserName 
         AutoSize        =   -1  'True
         Caption         =   "用户名称："
         Height          =   180
         Left            =   240
         TabIndex        =   9
         Top             =   285
         Width           =   900
      End
      Begin VB.Label LblPassWord 
         AutoSize        =   -1  'True
         Caption         =   "用户密码："
         Height          =   180
         Left            =   240
         TabIndex        =   8
         ToolTipText     =   "用户密码字符长度不能超过15"
         Top             =   765
         Width           =   900
      End
      Begin VB.Label LblOkPwd 
         AutoSize        =   -1  'True
         Caption         =   "确认密码："
         Height          =   180
         Left            =   240
         TabIndex        =   7
         Top             =   1245
         Width           =   900
      End
   End
   Begin VB.CommandButton CmdCancel 
      Caption         =   "取消(&C)"
      Height          =   375
      Left            =   2640
      TabIndex        =   1
      Top             =   2520
      Width           =   1455
   End
   Begin VB.CommandButton CmdOK 
      Caption         =   "确认(&O)"
      Default         =   -1  'True
      Height          =   375
      Left            =   480
      TabIndex        =   0
      Top             =   2520
      Width           =   1455
   End
   Begin WinXPC_Engine.WindowsXPC WinXPAddUsers 
      Left            =   360
      Top             =   360
      _ExtentX        =   6588
      _ExtentY        =   1085
      ColorScheme     =   2
      EngineStarted   =   -1  'True
      Common_Dialog   =   0   'False
   End
End
Attribute VB_Name = "FrmAddUsers"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdcancel_Click()
Unload Me
End Sub

Private Sub cmdOK_Click()
If Trim(TxtUserName.Text) <> Empty And Trim(TxtPassWord.Text) <> Empty And Trim(TxtOkPwd.Text) <> Empty Then
    If Len(Trim(TxtUserName.Text)) <= 15 And Len(Trim(TxtPassWord.Text)) <= 15 Then
        If Trim(TxtPassWord.Text) = Trim(TxtOkPwd.Text) Then       '//验证两次输入密码是否一致
On Error GoTo ErrAddUser
            RsAddUser.AddNew     '//在记录集中添加一行新记录
            RsAddUser.Fields(0).Value = Trim(TxtUserName.Text)       '//将文本框中的内容赋给记录集
            RsAddUser.Fields(1).Value = Trim(TxtPassWord.Text)
            RsAddUser.Fields(2).Value = Trim(CmbPopedom.Text)
            RsAddUser.Update         '更新记录
            MsgBox "用户添加成功", , "添加成功"
            Unload Me
        Else
            MsgBox "两次密码不一致 ", vbExclamation + vbOKOnly, "验证错误"         '两次密码不一致时
        End If
    Else
        MsgBox "用户名与密码长度不能大于15", vbInformation + vbOKOnly, "验证错误"
    End If
Else
    MsgBox "请输入要添加的用户名及密码 ", vbInformation + vbOKOnly, "错误提示"
End If
Exit Sub
ErrAddUser:
MsgBox "用户已存在 ", vbInformation + vbOKOnly, "提示信息"
End Sub

Private Sub Form_Load()
WinXPAddUsers.InitSubClassing

Me.Left = Frmmdimain.Width / 3
Me.Top = Frmmdimain.Height / 6

CmbPopedom.ListIndex = 1
    If RsAddUser.State = adStateClosed Then
        RsAddUser.Open "管理用户", DBCON, adOpenKeyset, adLockPessimistic, adCmdTable   '打开记录集
    End If
End Sub

Private Sub Form_Unload(Cancel As Integer)
RsAddUser.Close
End Sub