c重新登录.frm

用vb实现学校自动排课

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.Form C重新登录 
   Caption         =   "登录"
   ClientHeight    =   3345
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5820
   LinkTopic       =   "Form1"
   ScaleHeight     =   3345
   ScaleWidth      =   5820
   StartUpPosition =   3  'Windows Default
   Begin VB.Frame Frame2 
      Height          =   45
      Left            =   0
      TabIndex        =   3
      Top             =   600
      Width           =   5760
   End
   Begin VB.CommandButton cmdCancel 
      BackColor       =   &H00C0C0C0&
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   400
      Left            =   4560
      Picture         =   "C重新登录.frx":0000
      Style           =   1  'Graphical
      TabIndex        =   2
      Top             =   2880
      Width           =   1095
   End
   Begin VB.CommandButton CmdOk 
      BackColor       =   &H00C0C0C0&
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   400
      Left            =   3360
      MaskColor       =   &H00FF8080&
      Picture         =   "C重新登录.frx":19BA
      Style           =   1  'Graphical
      TabIndex        =   1
      Top             =   2880
      UseMaskColor    =   -1  'True
      Width           =   1095
   End
   Begin VB.TextBox txtPassword 
      Appearance      =   0  'Flat
      BackColor       =   &H0080FFFF&
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   390
      IMEMode         =   3  'DISABLE
      Left            =   840
      MaxLength       =   6
      PasswordChar    =   "*"
      TabIndex        =   0
      Top             =   2925
      Width           =   1485
   End
   Begin MSComctlLib.ListView ListView1 
      Height          =   2085
      Left            =   0
      TabIndex        =   4
      Top             =   720
      Width           =   5715
      _ExtentX        =   10081
      _ExtentY        =   3678
      LabelWrap       =   -1  'True
      HideSelection   =   -1  'True
      _Version        =   393217
      Icons           =   "ImageList1"
      ForeColor       =   -2147483640
      BackColor       =   -2147483643
      BorderStyle     =   1
      Appearance      =   1
      NumItems        =   0
   End
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   0
      Top             =   0
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   32
      ImageHeight     =   32
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   2
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "C重新登录.frx":32FD
            Key             =   ""
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "C重新登录.frx":3BD9
            Key             =   ""
         EndProperty
      EndProperty
   End
   Begin VB.Label Label1 
      BackStyle       =   0  'Transparent
      Caption         =   "排课系统"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   15.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00FF0000&
      Height          =   390
      Left            =   1920
      TabIndex        =   8
      Top             =   120
      Width           =   2055
   End
   Begin VB.Label Label3 
      Caption         =   "密码："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   120
      TabIndex        =   7
      Top             =   3000
      Width           =   735
   End
   Begin VB.Label Label4 
      BackStyle       =   0  'Transparent
      Caption         =   "密码："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000FF&
      Height          =   255
      Left            =   120
      TabIndex        =   6
      Top             =   3000
      Width           =   735
   End
   Begin VB.Label Label8 
      Caption         =   "(小于10位)"
      ForeColor       =   &H000000FF&
      Height          =   255
      Index           =   1
      Left            =   2400
      TabIndex        =   5
      Top             =   3000
      Width           =   855
   End
End
Attribute VB_Name = "C重新登录"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim SQL As String
Dim msg As String
Dim rs As ADODB.Recordset
Private Sub Form_Load()
    Dim rst As ADODB.Recordset
    Dim key As String           '保存用户ID
    Dim usertype                '保存用户类别
    Dim list As ListItem
    '添加用户列表
    SQL = " select * from 用户信息表 order by 用户ID"
    Set rst = SelectSQL(SQL, msg)
    If rst.RecordCount = 0 Then
        MsgBox ("请先创建用户信息！")
        CmdOK.Enabled = False
        Exit Sub
    Else
        '向ListView中添加数据
        rst.MoveFirst
        Do Until rst.EOF
            key = rst.Fields("用户ID") & rst.Fields("用户名称")
            usertype = Trim(rst.Fields("用户类别"))
            If usertype = "管理人员" Then
                '当时管理人员时，用图像2
                Set list = ListView1.ListItems.Add(, , key, 2)
            Else
                Set list = ListView1.ListItems.Add(, , key, 1)
            End If
            rst.MoveNext
        Loop
        rst.Close
    End If
End Sub
Private Sub ListView1_Click()
'取出当前用户ID操作
    If ListView1.ListItems.count > 0 Then
        UserID = Left(Trim(ListView1.SelectedItem), 6)              '取出当前用户ID
    End If
End Sub
Private Sub CmdOK_Click()
'确定操作
    Dim password As String
    '判断用户是否存在
    SQL = " select * from 用户信息表 where 用户ID='" & UserID & "'"
    Set rs = SelectSQL(SQL, msg)
    If rs.RecordCount > 0 Then
        password = Trim(rs.Fields("密码"))              '取出该用户的密码
    Else
        MsgBox ("数据库操作错误！")
        Exit Sub
    End If
    '判断密码是否正确
    If password = Trim(txtPassword.Text) Then
        User_Type = Trim(rs.Fields("用户类别"))
        LoginSucceeded = True
        排课系统.Show
        Call 排课系统.SetRight
        Unload Me
    Else
        MsgBox ("密码错误！")
        txtPassword.SetFocus
        txtPassword.SelStart = 0
        txtPassword.SelLength = Len(txtPassword.Text)
        LoginSucceeded = False
    End If
End Sub
Private Sub cmdCancel_Click()
'退出操作
    '设置全局变量为 false
    '提示失败的登录
    LoginSucceeded = False
    Unload Me
End Sub
Private Sub Form_Unload(Cancel As Integer)
    LoginSucceeded = False
    Unload Me
End Sub