📄 frm_aduser.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form Frm_GroupUser
Caption = "用户管理"
ClientHeight = 5805
ClientLeft = 1665
ClientTop = 1395
ClientWidth = 8775
HelpContextID = 1015
Icon = "Frm_AdUser.frx":0000
LinkTopic = "Form1"
ScaleHeight = 5805
ScaleWidth = 8775
StartUpPosition = 2 '屏幕中心
Begin VB.PictureBox Picture1
AutoRedraw = -1 'True
AutoSize = -1 'True
BackColor = &H00808080&
BorderStyle = 0 'None
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 45
Left = 30
ScaleHeight = 45
ScaleWidth = 4965
TabIndex = 2
Top = 2070
Visible = 0 'False
Width = 4965
End
Begin MSComctlLib.ListView ListView2
Height = 2085
Left = 0
TabIndex = 1
Top = 2970
Width = 5685
_ExtentX = 10028
_ExtentY = 3678
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = 0 'False
FullRowSelect = -1 'True
_Version = 393217
Icons = "ImageList1"
SmallIcons = "ImageList1"
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 1
NumItems = 2
BeginProperty ColumnHeader(1) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Text = "用户组"
Object.Width = 5292
EndProperty
BeginProperty ColumnHeader(2) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 1
Text = "说明"
Object.Width = 10583
EndProperty
End
Begin MSComctlLib.ListView ListView1
Height = 1995
Left = 0
TabIndex = 0
Top = 420
Width = 5685
_ExtentX = 10028
_ExtentY = 3519
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = 0 'False
FullRowSelect = -1 'True
_Version = 393217
Icons = "ImageList1"
SmallIcons = "ImageList1"
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 1
NumItems = 2
BeginProperty ColumnHeader(1) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Text = "用户名"
Object.Width = 5292
EndProperty
BeginProperty ColumnHeader(2) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 1
Text = "说明"
Object.Width = 10583
EndProperty
End
Begin MSComctlLib.ImageList ImageList1
Left = 6480
Top = 1320
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 8
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_AdUser.frx":038A
Key = "G1"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_AdUser.frx":06A6
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_AdUser.frx":0F82
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_AdUser.frx":185E
Key = "U1"
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_AdUser.frx":1B7A
Key = ""
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_AdUser.frx":2456
Key = ""
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_AdUser.frx":3332
Key = "U"
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_AdUser.frx":4186
Key = "G"
EndProperty
EndProperty
End
Begin MSComctlLib.Toolbar Toolbar
Height = 330
Left = 0
TabIndex = 3
Top = 0
Width = 8655
_ExtentX = 15266
_ExtentY = 582
ButtonWidth = 609
ButtonHeight = 582
AllowCustomize = 0 'False
Style = 1
ImageList = "ImageList1"
DisabledImageList= "ImageList1"
HotImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 1
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
ImageIndex = 6
Style = 5
Object.Width = 3
BeginProperty ButtonMenus {66833FEC-8583-11D1-B16A-00C0F0283628}
NumButtonMenus = 9
BeginProperty ButtonMenu1 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "NewUser"
Text = "新增用户(&U)"
EndProperty
BeginProperty ButtonMenu2 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "NewUserGroup"
Text = "新增用户组(&G)"
EndProperty
BeginProperty ButtonMenu3 {66833FEE-8583-11D1-B16A-00C0F0283628}
Text = "-"
EndProperty
BeginProperty ButtonMenu4 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "Properth"
Text = "属性"
EndProperty
BeginProperty ButtonMenu5 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "Authorization"
Text = "权限"
EndProperty
BeginProperty ButtonMenu6 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "Del"
Text = "删除"
EndProperty
BeginProperty ButtonMenu7 {66833FEE-8583-11D1-B16A-00C0F0283628}
Text = "-"
EndProperty
BeginProperty ButtonMenu8 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "Refresh"
Text = "刷新"
EndProperty
BeginProperty ButtonMenu9 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "Exit"
Text = "关闭(&C)"
EndProperty
EndProperty
EndProperty
EndProperty
End
Begin VB.Image Image1
Height = 135
Left = 30
MousePointer = 7 'Size N S
Top = 2820
Width = 5655
End
Begin VB.Menu User
Caption = "User"
Visible = 0 'False
Begin VB.Menu NewUser
Caption = "添加"
End
Begin VB.Menu Properth
Caption = "属性"
End
Begin VB.Menu Authorization
Caption = "权限"
End
Begin VB.Menu Del
Caption = "删除"
End
End
Begin VB.Menu gurop
Caption = "group"
Visible = 0 'False
Begin VB.Menu NewUserGroup
Caption = "添加"
End
Begin VB.Menu GroupProperth
Caption = "属性"
End
Begin VB.Menu GroupAuthorization
Caption = "权限"
End
Begin VB.Menu GroupDel
Caption = "删除"
End
End
End
Attribute VB_Name = "Frm_GroupUser"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public UserGroupName As String
Public Explain As String
Public UserId As String
Dim UserGroupTF As Boolean
Dim mbMoving As Boolean
Dim mitem As ListItem
Dim Requery_TF As Boolean
Private Sub Form_Activate()
On Error GoTo error_exit
If Requery_TF = True Then Requery_TF = False: Exit Sub
Dim aDo_Group As New Recordset
Dim aDo_User As New Recordset
Set aDo_Group = Conn_System.Execute("select * from " & ListView1.Tag & ".dbo.System_UserGroup")
ListView2.ListItems.Clear
With aDo_Group
Do While Not .EOF
Set mitem = ListView2.ListItems.Add()
mitem.Text = !GroupName
mitem.SmallIcon = "G"
mitem.Icon = "G"
mitem.SubItems(1) = !Explain
mitem.Key = !GroupName
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -