?? c登錄.frm
字號:
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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -