📄 frmauthor.frm
字号:
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Index = 6
Left = 1785
TabIndex = 8
Top = 390
Width = 1635
End
Begin VB.CheckBox chkAuthor
Caption = "菜单管理"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Index = 5
Left = 435
TabIndex = 7
Top = 2640
Width = 1245
End
Begin VB.CheckBox chkAuthor
Caption = "酒席配置"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Index = 4
Left = 435
TabIndex = 6
Top = 2190
Width = 1245
End
Begin VB.CheckBox chkAuthor
Caption = "基本配置"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Index = 3
Left = 435
TabIndex = 5
Top = 1740
Width = 1245
End
Begin VB.CheckBox chkAuthor
Caption = "查询预订"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Index = 2
Left = 435
TabIndex = 4
Top = 1290
Width = 1245
End
Begin VB.CheckBox chkAuthor
Caption = "新增预订"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Index = 1
Left = 435
TabIndex = 3
Top = 840
Width = 1245
End
Begin VB.CheckBox chkAuthor
Caption = "查看座位"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Index = 0
Left = 435
TabIndex = 2
Top = 390
Width = 1245
End
Begin VB.CommandButton cmdCancel
Cancel = -1 'True
Caption = "关闭返回(&C)"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 420
Left = 6030
TabIndex = 1
Top = 3240
Width = 1545
End
Begin VB.CommandButton cmdSave
Caption = "保存设置(&S)"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 420
Left = 4455
TabIndex = 0
Top = 3240
Width = 1545
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "请在需要的权限上打勾,然后按保存设置按钮。"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = 615
TabIndex = 25
Top = 3330
Width = 3645
End
Begin VB.Image Image1
Height = 480
Left = 105
Picture = "frmAuthor.frx":030A
Top = 3210
Width = 480
End
Begin VB.Shape Shape1
FillColor = &H00C0FFFF&
FillStyle = 0 'Solid
Height = 360
Left = 150
Top = 3285
Width = 4200
End
Begin VB.Line Line4
BorderColor = &H00FFFFFF&
X1 = 7560
X2 = 7560
Y1 = 225
Y2 = 3150
End
Begin VB.Line Line3
BorderColor = &H00808080&
X1 = 165
X2 = 7575
Y1 = 225
Y2 = 225
End
Begin VB.Line Line2
BorderColor = &H00808080&
X1 = 165
X2 = 165
Y1 = 240
Y2 = 3165
End
Begin VB.Line Line1
BorderColor = &H00FFFFFF&
X1 = 165
X2 = 7575
Y1 = 3150
Y2 = 3150
End
End
Attribute VB_Name = "frmAuthor"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public suserID As String
Private Sub cmdCancel_Click()
Unload Me
End Sub
Private Sub cmdSave_Click()
On Error GoTo GetRR
Dim auDB As Connection
Dim auRS As Recordset
Dim auX As Integer
Set auDB = CreateObject("ADODB.Connection")
Set auRS = CreateObject("ADODB.Recordset")
auDB.Open Constr
auRS.Open "Select * from Main Where 操作员='" & suserID & "'", auDB, adOpenStatic, adLockOptimistic, adCmdText
'没有找到该操作员时
If Not (auRS.EOF And auRS.BOF) Then
For auX = 0 To 22
auRS.Fields("Author" & CStr(auX)) = chkAuthor(auX).Value
Next
auRS.Update
Else
MsgBox "不能进行权限设置工作？ " & vbCrLf & Err.Description, vbInformation
cmdSave.Enabled = False
End If
auRS.Close
Set auRS = Nothing
auDB.Close
Set auDB = Nothing
Unload Me
Exit Sub
GetRR:
MsgBox "保存操作员权限错误:" & Err.Description, vbCritical
Exit Sub
End Sub
Private Sub Form_Load()
GetFormSet Me, Screen
'给出权限
GetAuthor suserID
End Sub
Private Sub Form_Unload(Cancel As Integer)
SaveFormSet Me
End Sub
Private Sub GetAuthor(auID As String)
On Error GoTo GetRR
Dim auDB As Connection
Dim auRS As Recordset
Dim auX As Integer
Set auDB = CreateObject("ADODB.Connection")
Set auRS = CreateObject("ADODB.Recordset")
auDB.Open Constr
auRS.Open "Select * from Main Where 操作员='" & auID & "'", auDB, adOpenStatic, adLockReadOnly, adCmdText
'没有找到该操作员时
If Not (auRS.EOF And auRS.BOF) Then
For auX = 0 To 22
chkAuthor(auX).Value = auRS.Fields("Author" & CStr(auX))
Next
Else
MsgBox "不能进行权限设置工作？ ", vbInformation
cmdSave.Enabled = False
End If
auRS.Close
Set auRS = Nothing
auDB.Close
Set auDB = Nothing
Exit Sub
GetRR:
MsgBox "给出操作员权限错误:" & Err.Description, vbCritical
Exit Sub
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -