frmlogin.frm

驾驶员考试系统界面不错在98下运行C/S模式

VERSION 5.00
Begin VB.Form frmLogin 
   AutoRedraw      =   -1  'True
   BackColor       =   &H00FFFFFF&
   BorderStyle     =   0  'None
   Caption         =   "Login screen"
   ClientHeight    =   3345
   ClientLeft      =   0
   ClientTop       =   0
   ClientWidth     =   7380
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Picture         =   "frmLogin.frx":0000
   ScaleHeight     =   3345
   ScaleWidth      =   7380
   StartUpPosition =   2  '屏幕中心
   Begin Project1.FCombo Combo1 
      Height          =   300
      Left            =   3375
      TabIndex        =   7
      Top             =   1350
      Width           =   1560
      _ExtentX        =   2752
      _ExtentY        =   529
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "新宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      EnabledText     =   0   'False
      ListIndex       =   -1
   End
   Begin VB.TextBox Text2 
      BorderStyle     =   0  'None
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   9.75
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   210
      IMEMode         =   3  'DISABLE
      Left            =   5520
      PasswordChar    =   "*"
      TabIndex        =   2
      ToolTipText     =   "Press Enter to login"
      Top             =   1400
      Width           =   1335
   End
   Begin VB.Label Label7 
      BackStyle       =   0  'Transparent
      Caption         =   "太原凌启电子科技有限公司"
      BeginProperty Font 
         Name            =   "楷体_GB2312"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   195
      Left            =   600
      TabIndex        =   6
      Top             =   2520
      Width           =   2175
   End
   Begin VB.Label Label6 
      BackColor       =   &H008CBDDE&
      Caption         =   "系统登录"
      Height          =   255
      Left            =   1170
      TabIndex        =   5
      Top             =   315
      Width           =   915
   End
   Begin VB.Label Label5 
      BackColor       =   &H0084CEF7&
      Caption         =   " 取消"
      Height          =   195
      Left            =   1185
      TabIndex        =   4
      Top             =   1830
      Width           =   615
   End
   Begin VB.Label Label3 
      BackColor       =   &H0084CEF7&
      Caption         =   "登录"
      Height          =   300
      Left            =   1260
      TabIndex        =   3
      Top             =   1215
      Width           =   540
   End
   Begin VB.Image imgTitlebar 
      Height          =   915
      Left            =   340
      Picture         =   "frmLogin.frx":3C89
      Top             =   120
      Width           =   2370
   End
   Begin VB.Image imgCancel 
      Height          =   615
      Left            =   910
      Picture         =   "frmLogin.frx":472F
      Top             =   1660
      Width           =   1095
   End
   Begin VB.Image imgLogin 
      Height          =   675
      Left            =   880
      Picture         =   "frmLogin.frx":4D02
      Top             =   940
      Width           =   1125
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "密 码："
      Height          =   255
      Left            =   5400
      TabIndex        =   1
      Top             =   1080
      Width           =   975
   End
   Begin VB.Label Label1 
      BackStyle       =   0  'Transparent
      Caption         =   "用户名："
      Height          =   255
      Left            =   3360
      TabIndex        =   0
      Top             =   1080
      Width           =   735
   End
End
Attribute VB_Name = "frmLogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Load()
    DoTransparency Me, vbRed
    Set Res = New ADODB.Recordset
    Sstr = "select name from kg"
    Res.Open Sstr, Conn
    Do Until Res.EOF
        If Res!Name <> "admin" Then Combo1.AddItem Res!Name
        Res.MoveNext
    Loop
    i = 1
End Sub

Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Label3.ForeColor = vbBlack
    Label5.ForeColor = vbBlack
    Label7.ForeColor = vbBlack
End Sub

Private Sub imgCancel_Click()
    Unload Me
    Frmmainload = False
    End
End Sub

Private Sub imgCancel_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Label5.ForeColor = vbWhite
End Sub

Private Sub imgLogin_Click()
        CheckIfValid
End Sub

Private Sub imgLogin_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Label3.ForeColor = vbWhite
End Sub

Private Sub Label3_Click()
     CheckIfValid
End Sub

Private Sub Label5_Click()
    Unload Me
    Frmmainload = False
    End
End Sub

Private Sub Label7_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
     Label7.ForeColor = vbWhite
End Sub

Private Sub Text1_KeyDown(KeyCode As Integer, Shift As Integer)
    If KeyCode = 13 Then Text2.SetFocus
End Sub

Private Sub Text2_KeyDown(KeyCode As Integer, Shift As Integer)
    If KeyCode = 13 Then
        CheckIfValid
    Else
        Exit Sub
    End If
End Sub

Private Sub CheckIfValid()
    Set Res = New ADODB.Recordset
    Sstr = "select * from kg where name= '" & Combo1.Text & "' and password='" & Text2.Text & "'"
    Res.Open Sstr, Conn
    If Res.EOF Then
        i = i + 1
        If i > 3 Then
            If Frmmainload = True Then
                MsgBox "多次登陆错误，更改失败", vbOKOnly + vbExclamation, "非法用户"
                Unload Me
            Else
                MsgBox "多次登陆错误，系统关闭", vbOKOnly + vbCritical, "非法登陆"
                End
            End If
        Else
            MsgBox "请输入正确的登陆信息！", vbOKOnly + vbInformation, "登陆错误"
        End If
    Else
        Unload Me
        frmMain.Show
    End If
End Sub