frmuserlogin.frm

一个日程管理和通讯录管理的软件

VERSION 5.00
Begin VB.Form frmUserLogin 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "用户登录"
   ClientHeight    =   1635
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   3825
   Icon            =   "frmUserLogin.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   1635
   ScaleWidth      =   3825
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  'CenterScreen
   Begin VB.CommandButton cmdCancel 
      Caption         =   "取消"
      Height          =   285
      Left            =   2152
      TabIndex        =   5
      Top             =   1170
      Width           =   960
   End
   Begin VB.CommandButton cmdOk 
      Caption         =   "登录"
      Default         =   -1  'True
      Height          =   285
      Left            =   712
      TabIndex        =   1
      Top             =   1170
      Width           =   960
   End
   Begin VB.TextBox txtPassword 
      Height          =   285
      IMEMode         =   3  'DISABLE
      Left            =   1320
      PasswordChar    =   "*"
      TabIndex        =   0
      Top             =   630
      Width           =   2040
   End
   Begin VB.ComboBox cboName 
      Height          =   300
      Left            =   1305
      TabIndex        =   2
      Text            =   "ComboName"
      Top             =   225
      Width           =   2040
   End
   Begin VB.Label Label2 
      Caption         =   "密　码："
      Height          =   240
      Left            =   465
      TabIndex        =   4
      Top             =   675
      Width           =   735
   End
   Begin VB.Label Label1 
      Caption         =   "用户名："
      Height          =   240
      Left            =   465
      TabIndex        =   3
      Top             =   315
      Width           =   780
   End
End
Attribute VB_Name = "frmUserLogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'*****************************************************
'*
'*                 用户登录
'*
'*****************************************************

Private Sub cmdCancel_Click()

    Unload frmUserLogin
    
End Sub

Private Sub cmdOK_Click()

    
    On Error GoTo ADOError
    
    '校验用户名和密码的正确性
    strQry = "select password from user where ID='" & Trim(cboName.Text) & "'"
    Set rstCustomers = GetRecordSet(cnnConnection, strQry)
    
    If rstCustomers.RecordCount = 0 Then
        MsgBox "对不起，这个用户还没有注册", vbCritical, SYSTEMCAPTION
        cboName.SetFocus
        SendKeys "{HOME}+{END}"
        Exit Sub
    End If
    
    If txtPassword <> rstCustomers!Password Then
        MsgBox "输入的密码的不正确！", vbCritical, SYSTEMCAPTION
        Exit Sub
    End If
    
    '用户登录成功，记录用户的登录时间
    strQry = "update user set lastlogintime='" & Now() & "' where ID='" & Trim(cboName.Text) & "'"
    cnnConnection.Execute (strQry)
    
    
    blnLoginFlag = True
    UserID = cboName.Text
    Unload frmUserLogin
    Exit Sub
ADOError:
    DisplayADOErrors cnnConnection
    
End Sub

Private Sub cboName_KeyDown(KeyCode As Integer, Shift As Integer)

  If KeyCode = 13 Then txtPassword.SetFocus
  
End Sub

Private Sub Form_Load()
    
    On Error GoTo ADOError
    
    '根据用户的登录时间排序将用户名载入组合框
    strQry = "select lastlogintime,ID from user order by lastlogintime DESC"
    Set rstCustomers = GetRecordSet(cnnConnection, strQry)
    
    While Not rstCustomers.EOF
            cboName.AddItem rstCustomers!ID
            rstCustomers.MoveNext
    Wend
    
    '缺省选中项为是最近登录的用户
    If rstCustomers.RecordCount <> 0 Then
        cboName.Text = cboName.List(0)
    End If
    
    Exit Sub
ADOError:
    DisplayADOErrors cnnConnection
    
End Sub


Private Sub Form_Unload(Cancel As Integer)
    
    '装载主窗体
    Load frmMain
    
End Sub

Private Sub txtPassword_KeyDown(KeyCode As Integer, Shift As Integer)

  If KeyCode = 13 Then cmdOK_Click
  
End Sub