?? main_mima.frm
字號:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Begin VB.Form main_mima
BackColor = &H80000016&
BorderStyle = 0 'None
Caption = "餐飲管理系統(tǒng) 版本：V1.0"
ClientHeight = 3390
ClientLeft = 0
ClientTop = -105
ClientWidth = 5310
Icon = "main_mima.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3390
ScaleWidth = 5310
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin VB.TextBox Text2
Enabled = 0 'False
Height = 315
Left = 3360
TabIndex = 9
Top = 1410
Width = 1605
End
Begin VB.TextBox Text1
BackColor = &H80000014&
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 315
IMEMode = 3 'DISABLE
Left = 3360
MaxLength = 6
PasswordChar = "*"
TabIndex = 7
Top = 2040
Width = 1605
End
Begin VB.CommandButton Comyes
BackColor = &H00C0C0C0&
Caption = "確定"
BeginProperty Font
Name = "宋體"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 2520
MaskColor = &H00FF8080&
Picture = "main_mima.frx":0E42
TabIndex = 6
Top = 2715
UseMaskColor = -1 'True
Width = 1110
End
Begin VB.CommandButton Comend
BackColor = &H00C0C0C0&
Caption = "退出"
BeginProperty Font
Name = "宋體"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 3765
Picture = "main_mima.frx":2785
TabIndex = 5
Top = 2715
Width = 1110
End
Begin VB.Frame Frame1
Caption = "Frame1"
Height = 1035
Left = -1725
TabIndex = 0
Top = 1260
Visible = 0 'False
Width = 1965
Begin VB.TextBox Textime
Height = 270
Left = 180
TabIndex = 1
Top = 645
Width = 1230
End
Begin MSAdodcLib.Adodc Adodc1
Height = 330
Left = 105
Top = 195
Width = 1530
_ExtentX = 2699
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 1
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TLCYGLXT.mdb;Persist Security Info=False"
OLEDBString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TLCYGLXT.mdb;Persist Security Info=False"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "select * from 權(quán)限信息表"
Caption = "Adodc1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
End
Begin MSComctlLib.ImageList ImageList1
Left = 60
Top = 480
_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 = "main_mima.frx":413F
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "main_mima.frx":4A1B
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.ListView ListView1
Height = 2445
Left = 240
TabIndex = 4
Top = 720
Width = 2115
_ExtentX = 3731
_ExtentY = 4313
MultiSelect = -1 'True
LabelWrap = -1 'True
HideSelection = -1 'True
_Version = 393217
Icons = "ImageList1"
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 0
NumItems = 0
End
Begin VB.Label Label4
BackStyle = 0 'Transparent
Height = 255
Left = 3360
TabIndex = 12
Top = 960
Width = 1575
End
Begin VB.Label Label3
BackStyle = 0 'Transparent
Caption = "級 別："
Height = 255
Left = 2520
TabIndex = 11
Top = 960
Width = 735
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "用戶名："
Height = 255
Left = 2520
TabIndex = 10
Top = 1440
Width = 975
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "密 碼： "
Height = 300
Left = 2520
TabIndex = 8
Top = 2115
Width = 975
End
Begin VB.Image Image1
Height = 3375
Left = 0
Picture = "main_mima.frx":52F7
Stretch = -1 'True
Top = 0
Width = 5295
End
Begin VB.Label czyjb
BackStyle = 0 'Transparent
Height = 195
Left = 3900
TabIndex = 3
Top = 2880
Width = 2040
End
Begin VB.Label czy
BackStyle = 0 'Transparent
Height = 195
Left = 900
TabIndex = 2
Top = 2880
Width = 2040
End
End
Attribute VB_Name = "main_mima"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim itmX As ListItem
Dim TIM, A As Integer '定義整型變量
Dim myval, key, list As String '定義字符串變量
Private Sub Form_Activate()
Adodc1.RecordSource = "select * from 權(quán)限信息表 "
Adodc1.Refresh
If Adodc1.Recordset.RecordCount = 0 Then
MsgBox ("您還沒有設(shè)置操作員密碼和權(quán)限，請?jiān)O(shè)置操作員密碼和權(quán)限!")
Load frm_main
frm_main.Show
Unload Me
Else
ListView1.SetFocus
frm_main.qtgl.Enabled = False
frm_main.ktgl.Enabled = False
frm_main.mdgl.Enabled = False
frm_main.rjzfx.Enabled = False
frm_main.rjsgl.Enabled = False
frm_main.htgl.Enabled = False
frm_main.czgl.Enabled = False
frm_main.ysyf.Enabled = False
frm_main.xtcs.Enabled = False
frm_main.xtgl.Enabled = False
frm_main.Toolbar1.Buttons(1).Enabled = False
frm_main.Toolbar1.Buttons(3).Enabled = False
frm_main.Toolbar1.Buttons(5).Enabled = False
frm_main.Toolbar1.Buttons(7).Enabled = False
frm_main.Toolbar1.Buttons(9).Enabled = False
frm_main.Toolbar1.Buttons(11).Enabled = False
frm_main.Toolbar1.Buttons(13).Enabled = False
'添加操作員列表
Adodc1.Recordset.MoveFirst
czy.Caption = Trim(Adodc1.Recordset.Fields("操作員姓名"))
czyjb.Caption = Trim(Adodc1.Recordset.Fields("員工級別"))
Do While Adodc1.Recordset.EOF = False
key = Trim(Adodc1.Recordset.Fields("操作員姓名"))
Set itmX = ListView1.ListItems.Add(, , key, 1)
Adodc1.Recordset.MoveNext
Loop
End If
End Sub
Private Sub Form_Unload(Cancel As Integer)
frm_main.Enabled = True
End Sub
Private Sub ListView1_Click()
If ListView1.ListItems.Count > 0 Then
list = ListView1.SelectedItem
'查詢操作員信息
Adodc1.RecordSource = "select * from 權(quán)限信息表 where 操作員姓名='" + list + "'"
Adodc1.Refresh
If Adodc1.Recordset.RecordCount > 0 Then
Text2.text = Trim(Adodc1.Recordset.Fields("操作員姓名"))
Label4.Caption = Trim(Adodc1.Recordset.Fields("員工級別"))
End If
End If
End Sub
Private Sub Text1_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyReturn Then Comyes.SetFocus '按回車鍵Comyes獲得焦點(diǎn)
End Sub
Private Sub comyes_Click()
Dim MESSAGE As String
Textime.text = TIM
Adodc1.RecordSource = "select * from 權(quán)限信息表 where 操作員姓名 = '" + Trim(Text2.text) + "'"
Adodc1.Refresh
'判斷操作員及密碼
If Text2.text <> "" And Text1.text = Trim(Adodc1.Recordset.Fields("密碼")) Then
Load frm_main
frm_main.Show
'設(shè)置操作員權(quán)限
If Trim(Adodc1.Recordset.Fields("權(quán)限")) = "A" Then
frm_main.qtgl.Enabled = True
frm_main.ktgl.Enabled = True
frm_main.mdgl.Enabled = True
frm_main.rjzfx.Enabled = True
frm_main.rjsgl.Enabled = True
frm_main.htgl.Enabled = True
frm_main.czgl.Enabled = True
frm_main.ysyf.Enabled = True
frm_main.xtcs.Enabled = True
frm_main.xtgl.Enabled = True
frm_main.Toolbar1.Buttons(1).Enabled = True
frm_main.Toolbar1.Buttons(3).Enabled = True
frm_main.Toolbar1.Buttons(5).Enabled = True
frm_main.Toolbar1.Buttons(7).Enabled = True
frm_main.Toolbar1.Buttons(9).Enabled = True
frm_main.Toolbar1.Buttons(11).Enabled = True
frm_main.Toolbar1.Buttons(13).Enabled = True
End If
If Trim(Adodc1.Recordset.Fields("權(quán)限")) = "B" Then
frm_main.qtgl.Enabled = True
frm_main.ktgl.Enabled = True
frm_main.mdgl.Enabled = True
frm_main.rjzfx.Enabled = True
frm_main.rjsgl.Enabled = True
frm_main.htgl.Enabled = True
frm_main.czgl.Enabled = True
frm_main.ysyf.Enabled = True
frm_main.xtcs.Enabled = True
frm_main.Toolbar1.Buttons(1).Enabled = True
frm_main.Toolbar1.Buttons(3).Enabled = True
frm_main.Toolbar1.Buttons(5).Enabled = True
frm_main.Toolbar1.Buttons(7).Enabled = True
frm_main.Toolbar1.Buttons(9).Enabled = True
frm_main.Toolbar1.Buttons(11).Enabled = True
End If
If InStr(Trim(Adodc1.Recordset.Fields("權(quán)限")), "K") > 0 Then
frm_main.qtgl.Enabled = True
frm_main.ktgl.Enabled = True
frm_main.Toolbar1.Buttons(5).Enabled = True
End If
If InStr(Trim(Adodc1.Recordset.Fields("權(quán)限")), "S") > 0 Then
frm_main.qtgl.Enabled = True
frm_main.mdgl.Enabled = True
frm_main.Toolbar1.Buttons(7).Enabled = True
End If
If InStr(Trim(Adodc1.Recordset.Fields("權(quán)限")), "R") > 0 Then
frm_main.qtgl.Enabled = True
frm_main.rjsgl.Enabled = True
frm_main.Toolbar1.Buttons(1).Enabled = True
End If
If InStr(Trim(Adodc1.Recordset.Fields("權(quán)限")), "J") > 0 Then
frm_main.qtgl.Enabled = True
frm_main.rjzfx.Enabled = True
frm_main.Toolbar1.Buttons(3).Enabled = True
End If
If InStr(Trim(Adodc1.Recordset.Fields("權(quán)限")), "Q") > 0 Then
frm_main.qtgl.Enabled = True
frm_main.ktgl.Enabled = True
frm_main.mdgl.Enabled = True
frm_main.rjzfx.Enabled = True
frm_main.rjsgl.Enabled = True
frm_main.Toolbar1.Buttons(1).Enabled = True
frm_main.Toolbar1.Buttons(3).Enabled = True
frm_main.Toolbar1.Buttons(5).Enabled = True
frm_main.Toolbar1.Buttons(7).Enabled = True
End If
If InStr(Trim(Adodc1.Recordset.Fields("權(quán)限")), "H") > 0 Then
frm_main.htgl.Enabled = True
frm_main.xtcs.Enabled = True
End If
If InStr(Trim(Adodc1.Recordset.Fields("權(quán)限")), "C") > 0 Then
frm_main.czgl.Enabled = True
frm_main.Toolbar1.Buttons(9).Enabled = True
End If
If InStr(Trim(Adodc1.Recordset.Fields("權(quán)限")), "Y") > 0 Then
frm_main.ysyf.Enabled = True
frm_main.Toolbar1.Buttons(11).Enabled = True
End If
frm_main.St1.Panels(3).text = Text2.text
Unload Me
Else
If TIM = 3 Then
MESSAGE = MsgBox("密碼輸入錯誤,請向系統(tǒng)管理員查詢!", 0, "")
If MESSAGE = vbOK Then End
End If
If Text2.text = "" Then
MsgBox ("請選擇操作員!")
ListView1.SetFocus
Else
If Text1.text <> Adodc1.Recordset.Fields("密碼") Then
MsgBox ("密碼錯誤,請重新輸入密碼!")
TIM = TIM + 1
Text1.SetFocus
End If
End If
End If
End Sub
Private Sub comend_Click()
End
End Sub
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -