📄 frm_group_user.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "MSDATGRD.OCX"
Begin VB.Form Frm_Group_User
BorderStyle = 1 'Fixed Single
Caption = "部门及用户管理"
ClientHeight = 5205
ClientLeft = 2295
ClientTop = 3450
ClientWidth = 8595
Icon = "Frm_Group_User.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 5205
ScaleWidth = 8595
Begin MSDataGridLib.DataGrid DataGrd_Group_User
Height = 4935
Left = 2640
TabIndex = 1
Top = 120
Width = 5775
_ExtentX = 10186
_ExtentY = 8705
_Version = 393216
AllowUpdate = 0 'False
AllowArrows = -1 'True
BackColor = 16777215
ForeColor = 0
HeadLines = 1
RowHeight = 15
RowDividerStyle = 0
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ColumnCount = 2
BeginProperty Column00
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
Locked = -1 'True
BeginProperty Column00
EndProperty
BeginProperty Column01
EndProperty
EndProperty
End
Begin MSComctlLib.ImageList ImageList1
Left = 1200
Top = 2160
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 3
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Group_User.frx":0CCA
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Group_User.frx":0FE4
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Group_User.frx":1436
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.TreeView Tvw_Group_User
Height = 4935
Left = 120
TabIndex = 0
Top = 120
Width = 2415
_ExtentX = 4260
_ExtentY = 8705
_Version = 393217
LineStyle = 1
Style = 7
ImageList = "ImageList1"
Appearance = 1
End
Begin VB.Menu Meu_Add
Caption = "添加(&A)"
End
Begin VB.Menu Meu_Edit
Caption = "编辑(&E)"
End
Begin VB.Menu Meu_Del
Caption = "删除(&D)"
End
Begin VB.Menu Meu_Setup
Caption = "权限设置(&S)"
End
Begin VB.Menu Meu_Exit
Caption = "退出(&X)"
End
End
Attribute VB_Name = "Frm_Group_User"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Load()
On Error GoTo err
Dim node1, node2 As Node
Dim key As String
Dim text As String
key = "GROUP_USER"
text = "部门及用户"
Set node1 = Tvw_Group_User.Nodes.Add(, , key, text, 1)
key = "GROUP"
text = "部门"
Set node2 = Tvw_Group_User.Nodes.Add(node1.Index, tvwChild, key, text, 2)
key = "USER"
text = "用户"
Set node2 = Tvw_Group_User.Nodes.Add(node2.Index, tvwLast, key, text, 3)
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub Form_Unload(Cancel As Integer)
On Error GoTo err
'将变量置位
GroupUser = ""
Group_Add = False
Group_Edit = False
User_Add = False
User_Edit = False
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub Meu_Add_Click()
On Error GoTo err
If GroupUser = "GROUP" Then
Group_Add = True
Group_Edit = False
Load Frm_Group_Add
Frm_Group_Add.Show vbModal
End If
If GroupUser = "USER" Then
If OperatorLevel <> "5" Then
User_Add = True
User_Edit = False
Load Frm_User_Add
Frm_User_Add.Show vbModal
Else
MsgBox "你无权添加用户!", vbCritical
End If
End If
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub Meu_Del_Click()
On Error GoTo err
If GroupUser = "GROUP" Then
If Rs_Common.EOF <> True Or Rs_Common.BOF <> True Then
If MsgBox("你确定要删除此条记录吗?", vbYesNo + vbInformation, "提示信息") = vbYes Then
Rs_Common.Delete
Rs_Common.Update
End If
End If
End If
If GroupUser = "USER" Then
If Rs_Common!权限级别 <> "0" And OperatorLevel < Rs_Common!权限级别 Then
' If OperatorLevel > Rs_Common!权限级别 Then
If Rs_Common.EOF <> True Or Rs_Common.BOF <> True Then
If MsgBox("你确定要删除此条记录吗?", vbYesNo + vbInformation, "提示信息") = vbYes Then
Rs_Common.Delete
Rs_Common.Update
End If
End If
Else
MsgBox "你无权删除此用户!", vbCritical
End If
End If
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub Meu_Edit_Click()
On Error GoTo err
If GroupUser = "GROUP" Then
Group_Add = False
Group_Edit = True
Load Frm_Group_Add
Frm_Group_Add.Show vbModal
End If
If GroupUser = "USER" Then
If OperatorLevel < Rs_Common!权限级别 Then
User_Add = False
User_Edit = True
Load Frm_User_Add
Frm_User_Add.Show vbModal
Else
MsgBox "你无权操作此用户!", vbCritical
End If
End If
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub Meu_Exit_Click()
Unload Me
End Sub
Private Sub Meu_Setup_Click()
On Error GoTo err
If GroupUser = "USER" Then
If OperatorLevel < Rs_Common!权限级别 Then
Load Frm_Private
Frm_Private.Show vbModal
Else
MsgBox "你无权操作此用户!", vbCritical
End If
Else
MsgBox "请先选择要修改的用户后," + Chr(13) + "再单击此选项!", vbCritical
End If
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub Tvw_Group_User_NodeClick(ByVal Node As MSComctlLib.Node)
On Error GoTo err
GroupUser = Node.key
If Node.key = "GROUP" Then
Set Cn_Common = New ADODB.Connection
Cn_Common.Open Cs
Set Rs_Common = New ADODB.Recordset
Rs_Common.Open "select * from department", Cn_Common, adOpenKeyset, adLockOptimistic, adCmdText
Set Me.DataGrd_Group_User.DataSource = Rs_Common
Me.DataGrd_Group_User.Refresh
End If
If Node.key = "USER" Then
Set Cn_Common = New ADODB.Connection
Cn_Common.Open Cs
Set Rs_Common = New ADODB.Recordset
Rs_Common.Open "select 用户名,全名,描述,所在部门,权限级别 from Operator", Cn_Common, adOpenKeyset, adLockOptimistic, adCmdText ',private_press_machine_code as 印刷机号权,private_edition_state as 版状态权,private_expert_color_ink as 专色油墨权,private_color_stylebook as 颜色样本权,private_badness_rate as 不良率权,private_remain_good_count as 剩余良品数权
Set Me.DataGrd_Group_User.DataSource = Rs_Common
Me.DataGrd_Group_User.Refresh
End If
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -