📄 manger.frm
字号:
VERSION 5.00
Begin VB.Form manger
BackColor = &H0080C0FF&
Caption = "操作员管理"
ClientHeight = 4710
ClientLeft = 2895
ClientTop = 1815
ClientWidth = 6375
ControlBox = 0 'False
LinkTopic = "Form1"
ScaleHeight = 4710
ScaleWidth = 6375
Begin VB.ComboBox Combo1
Height = 300
ItemData = "manger.frx":0000
Left = 2520
List = "manger.frx":000A
TabIndex = 2
Top = 2400
Width = 2055
End
Begin VB.TextBox txtselect
Appearance = 0 'Flat
Height = 270
Index = 0
Left = 1680
TabIndex = 9
Top = 360
Width = 1695
End
Begin VB.ComboBox comsel
Height = 300
Index = 0
ItemData = "manger.frx":0026
Left = 3600
List = "manger.frx":002D
TabIndex = 8
Text = "名字"
Top = 360
Width = 1215
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
Height = 270
Index = 3
Left = 2520
TabIndex = 3
Top = 3000
Width = 2055
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
Height = 270
IMEMode = 3 'DISABLE
Index = 1
Left = 2520
PasswordChar = "*"
TabIndex = 1
Top = 1800
Width = 2055
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
Height = 270
Index = 0
Left = 2520
TabIndex = 0
Top = 1200
Width = 2055
End
Begin VB.Label qd
BackStyle = 0 'Transparent
Caption = " 确定"
Height = 495
Left = 2760
MouseIcon = "manger.frx":0037
MousePointer = 99 'Custom
TabIndex = 12
Top = 4080
Width = 1455
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = " 返回"
Height = 540
Left = 4560
MouseIcon = "manger.frx":0341
MousePointer = 99 'Custom
TabIndex = 11
Top = 4080
Width = 1380
End
Begin VB.Image Image2
Height = 195
Index = 1
Left = 4680
MouseIcon = "manger.frx":064B
MousePointer = 99 'Custom
Picture = "manger.frx":0955
Top = 4080
Width = 195
End
Begin VB.Image Image1
Height = 450
Index = 1
Left = 4440
MouseIcon = "manger.frx":09D0
MousePointer = 99 'Custom
Picture = "manger.frx":0CDA
Stretch = -1 'True
Top = 3960
Width = 1395
End
Begin VB.Label Labinfo
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "查询信息："
Height = 180
Index = 1
Left = 720
TabIndex = 10
Top = 405
Width = 900
End
Begin VB.Image search
Height = 300
Index = 0
Left = 4920
MouseIcon = "manger.frx":110D
MousePointer = 99 'Custom
Picture = "manger.frx":1417
Top = 360
Width = 780
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "解屏密码："
Height = 180
Index = 3
Left = 1320
TabIndex = 7
Top = 3000
Width = 900
End
Begin VB.Image Image2
Height = 195
Index = 0
Left = 3000
MouseIcon = "manger.frx":1642
MousePointer = 99 'Custom
Picture = "manger.frx":194C
Top = 4080
Width = 195
End
Begin VB.Image Image1
Height = 450
Index = 0
Left = 2760
MouseIcon = "manger.frx":19C7
MousePointer = 99 'Custom
Picture = "manger.frx":1CD1
Stretch = -1 'True
Top = 3960
Width = 1395
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "管理员级别："
Height = 180
Index = 2
Left = 1200
TabIndex = 6
Top = 2400
Width = 1080
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "管理员密码："
Height = 180
Index = 1
Left = 1200
TabIndex = 5
Top = 1800
Width = 1080
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "管理员姓名："
Height = 180
Index = 0
Left = 1200
TabIndex = 4
Top = 1200
Width = 1080
End
Begin VB.Shape Shape1
BorderColor = &H0080FFFF&
BorderWidth = 5
Height = 4695
Left = 0
Top = 0
Width = 6375
End
End
Attribute VB_Name = "manger"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim yn As New yn '定义yn为yn类
Option Explicit
Private Sub Form_Load()
Select Case msg
Case Is = "添加管理员"
Me.qd.Caption = " 添加" '标题赋为
Me.txtselect(0).Locked = True '设置为不可写
Me.txtselect(0).BackColor = &H80000004 '设置背景
Me.comsel(0).BackColor = &H80000004
Me.comsel(0).Locked = True
Case Is = "修改管理员"
Me.qd.Caption = " 修改"
Me.txtselect(0).Locked = False
Me.txtselect(0).BackColor = vbWhite
Me.comsel(0).BackColor = vbWhite
Me.comsel(0).Locked = False
Case Is = "删除管理员"
Me.qd.Caption = " 删除"
Me.txtselect(0).Locked = False
Me.txtselect(0).BackColor = vbWhite
Me.comsel(0).BackColor = vbWhite
Me.comsel(0).Locked = False
Me.Text1(0).BackColor = &H80000004
Me.Text1(1).BackColor = &H80000004
Me.Text1(3).BackColor = &H80000004
Me.Combo1.BackColor = &H80000004
Case Is = "管理员查询"
Me.txtselect(0).Locked = False
Me.txtselect(0).BackColor = vbWhite
Me.comsel(0).BackColor = vbWhite
Me.comsel(0).Locked = False
Me.Text1(0).BackColor = &H80000004
Me.Text1(1).BackColor = &H80000004
Me.Text1(3).BackColor = &H80000004
Me.Combo1.BackColor = &H80000004
Me.Image1(0).Visible = False '设置不可见
Me.Image2(0).Visible = False
Me.qd.Visible = False
End Select
End Sub
Private Sub Label2_Click()
Unload Me '御下窗体
End Sub
Private Sub qd_Click()
Select Case msg
Case Is = "添加管理员"
If Me.Text1(0).Text <> "" And Me.Text1(1).Text <> "" And Me.Combo1.Text <> "" And Me.Text1(3).Text <> "" Then
Call yn.opendb("select * from 管理员 where 名字='" & Me.Text1(0).Text & "'") '查询条件在数据库中
If yn.myrec.EOF Then
Call yn.myrec.AddNew ' 添加
yn.myrec.Fields("名字") = Me.Text1(0).Text
yn.myrec.Fields("密码") = Me.Text1(1).Text
yn.myrec.Fields("级别") = Me.Combo1.Text
yn.myrec.Fields("解屏密码") = Me.Text1(3).Text
Call yn.myrec.Update '更新
Call yn.closedb '关闭
MsgBox "添加成功！！！", vbInformation
Me.Text1(0).Text = ""
Me.Text1(1).Text = ""
Me.Combo1.Text = ""
Me.Text1(3).Text = ""
Else
MsgBox "已经有此管理员！！！", vbInformation
Call yn.closedb
End If
Else
MsgBox "请输入完整！！！", vbInformation
End If
Case Is = "修改管理员"
Call yn.opendb("select * from 管理员 where 名字='" & Me.txtselect(0).Text & "'")
If Not yn.myrec.EOF Then
yn.myrec.Fields("名字") = Me.Text1(0).Text
yn.myrec.Fields("密码") = Me.Text1(1).Text
yn.myrec.Fields("级别") = Me.Combo1.Text
yn.myrec.Fields("解屏密码") = Me.Text1(3).Text
Call yn.myrec.Update
Call yn.closedb
MsgBox "修改成功！！！", vbInformation
End If
Case Is = "删除管理员"
Call yn.opendb("select * from 管理员 where 名字='" & Me.txtselect(0).Text & "'")
If Not yn.myrec.EOF Then
Me.Text1(0).Text = yn.myrec.Fields("名字")
Me.Text1(1).Text = yn.myrec.Fields("密码")
Me.Combo1.Text = yn.myrec.Fields("级别")
Me.Text1(3).Text = yn.myrec.Fields("解屏密码")
Call yn.myrec.Delete '删除
Call yn.myrec.Update '更新
Call yn.closedb '关闭
MsgBox "删除成功！！！", vbInformation
Me.Text1(0).Text = ""
Me.Text1(1).Text = ""
Me.Combo1.Text = ""
Me.Text1(3).Text = ""
End If
End Select
End Sub
Private Sub search_Click(Index As Integer)
Call yn.opendb("select * from 管理员 where 名字='" & Me.txtselect(0).Text & "'")
If Not yn.myrec.EOF Then
Me.Text1(0).Text = yn.myrec.Fields("名字")
Me.Text1(1).Text = yn.myrec.Fields("密码")
Me.Combo1.Text = yn.myrec.Fields("级别")
Me.Text1(3).Text = yn.myrec.Fields("解屏密码")
Call yn.closedb
Else
MsgBox "没有此管理员！！！", vbInformation
Call yn.closedb
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -