📄 frmstaffman.frm
字号:
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 180
Left = 2520
TabIndex = 1
Top = 360
Width = 390
End
End
Begin VB.CommandButton Cmd_Back
Cancel = -1 'True
Caption = "返 回"
Height = 400
Left = 6840
MouseIcon = "FrmStaffMan.frx":0CCA
MousePointer = 99 'Custom
Style = 1 'Graphical
TabIndex = 34
Top = 3840
Width = 1300
End
Begin VB.CommandButton Cmd_Del
Caption = "删除员工"
Height = 400
Left = 5160
MouseIcon = "FrmStaffMan.frx":0FD4
MousePointer = 99 'Custom
Style = 1 'Graphical
TabIndex = 33
Top = 3840
Width = 1300
End
Begin VB.CommandButton Cmd_Modi
Caption = "修改资料"
Height = 400
Left = 3584
MouseIcon = "FrmStaffMan.frx":12DE
MousePointer = 99 'Custom
Style = 1 'Graphical
TabIndex = 32
Top = 3840
Width = 1300
End
Begin VB.CommandButton Cmd_Add
Caption = "添加员工"
Default = -1 'True
Height = 400
Left = 1998
MouseIcon = "FrmStaffMan.frx":15E8
MousePointer = 99 'Custom
Style = 1 'Graphical
TabIndex = 31
Top = 3840
Width = 1300
End
Begin MSDataListLib.DataList DataList1
Bindings = "FrmStaffMan.frx":18F2
Height = 1530
Left = 120
TabIndex = 35
Top = 2040
Width = 2415
_ExtentX = 4260
_ExtentY = 2699
_Version = 393216
ListField = "Staff_Name"
BoundColumn = "Staff_Id"
End
Begin MSAdodcLib.Adodc AdoStaffNameList
Height = 330
Left = 3120
Top = 4200
Visible = 0 'False
Width = 3135
_ExtentX = 5530
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 1
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 3
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "DSN=Enterprise"
OLEDBString = ""
OLEDBFile = ""
DataSourceName = "Enterprise"
OtherAttributes = ""
UserName = "sa"
Password = "sa"
RecordSource = "SELECT Staff_Id,Staff_Name FROM Staff ORDER BY Staff_Id"
Caption = "AdoEmpNameList"
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
Begin MSComctlLib.ImageList ImageList3
Left = 120
Top = 0
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483628
ImageWidth = 16
ImageHeight = 16
MaskColor = 16777215
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 5
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStaffMan.frx":192E
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStaffMan.frx":42C0
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStaffMan.frx":6C52
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStaffMan.frx":95E4
Key = ""
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStaffMan.frx":BF76
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.TreeView TreeView1
Height = 1695
Left = 120
TabIndex = 36
Top = 240
Width = 2415
_ExtentX = 4260
_ExtentY = 2990
_Version = 393217
HideSelection = 0 'False
LabelEdit = 1
Sorted = -1 'True
Style = 7
HotTracking = -1 'True
SingleSel = -1 'True
ImageList = "ImageList3"
BorderStyle = 1
Appearance = 1
MousePointer = 99
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
MouseIcon = "FrmStaffMan.frx":E908
End
Begin MSAdodcLib.Adodc AdoStaffDetail
Height = 330
Left = 120
Top = 4200
Visible = 0 'False
Width = 2775
_ExtentX = 4895
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 1
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 3
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "DSN=Enterprise"
OLEDBString = ""
OLEDBFile = ""
DataSourceName = "Enterprise"
OtherAttributes = ""
UserName = "sa"
Password = "sa"
RecordSource = "SELECT * FROM Staff"
Caption = "AdoEmpDetail"
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
Attribute VB_Name = "FrmStaffMan"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public TmpOk As Boolean
Private Sub Cmd_Add_Click()
TmpOk = False
'如果没有选择部门 , 则提示重新选择
If CurDepart.Depart_Id <= 0 Then
MsgBox "请选择所属院系班级"
Exit Sub
End If
'设置添加标记
FrmStaffEdit.Modify = False
'启动编辑员工信息窗体
FrmStaffEdit.Show 1
'如果用户编辑完成后,单击"确定"按钮,则刷新员工列表
If TmpOk = True Then
TreeView1_Click
End If
End Sub
Private Sub Cmd_Back_Click()
If FrmPhotoMenu.Visible = True Then
Unload FrmPhotoMenu
End If
Unload Me
End Sub
Private Sub Cmd_Del_Click()
'检查是否选择要删除的员工记录
If CurStaff.Staff_Id <= 0 Then
MsgBox "请选择要删除的员工"
Exit Sub
End If
'确定是否删除
If MsgBox("姓名:" + Lbl_Staff_Name + Chr(13), vbYesNo, "是否删除") = vbNo Then
Exit Sub
End If
'CurStu对象为当前选择的员工
'调用Delete方法删除选择的员工信息
CurStaff.Delete (CurStaff.Staff_Id)
CurStaff.Staff_Id = 0
TreeView1_Click
End Sub
Private Sub Cmd_Modi_Click()
'检查是否选择要修改的员工记录
If CurStaff.Staff_Id <= 0 Then
MsgBox "请选择要修改的员工"
Exit Sub
End If
'设置修改标记
FrmStaffEdit.Modify = True
FrmStaffEdit.Show 1
'通过单击DataList控件刷新员工信息的显示
DataList1_Click
End Sub
Private Sub DataList1_Click()
'如果没有选择员工,则进行初始化处理
If DataList1.BoundText = "" Then
CurStaff.Init
Image1.Picture = LoadPicture("")
AdoStaffDetail.RecordSource = "SELECT * FROM Staff WHERE Staff_Id<0"
AdoStaffDetail.Refresh
Exit Sub
End If
'根据选择的员工更新AdoStuDetail
AdoStaffDetail.RecordSource = "SELECT * FROM Staff " _
+ "WHERE Staff_Id=" + Trim(Str(DataList1.BoundText))
AdoStaffDetail.Refresh
'显示员工照片
'Call ShowImage(Image1, AdoStaffDetail)
'读取当前员工信息到CurStaff
CurStaff.GetInfo (DataList1.BoundText)
End Sub
Private Sub Form_Load()
'Root Node
Set TmpNode = TreeView1.Nodes.Add(, , "a0", "企业部门信息 ", 1, 3)
TmpNode.Selected = True
TmpNode.ExpandedImage = 2
'将部门信息添加到TreeView控件中
Call Add_DepartToTree(TreeView1, "a0")
TreeView1_Click
DataList1_Click
End Sub
Private Sub Image1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
'单击左键，则关闭照片管理菜单
If Button = 1 Then
If FrmPhotoMenu.Visible = True Then
Unload FrmPhotoMenu
End If
End If
'单击右键，打开照片管理菜单
If Button = 2 Then
If CurStu.Student_Id <= 0 Then
Exit Sub
End If
FrmPhotoMenu.Left = X + Image1.Left + 200 ' - 1610
FrmPhotoMenu.Top = Y + Image1.Top + 1900
FrmPhotoMenu.Show
End If
End Sub
Private Sub TreeView1_Click()
Dim Focuskey As String
'根据关键字获取部门信息
Focuskey = TreeView1.SelectedItem.Key
CurDepart.Depart_Name = TreeView1.SelectedItem.Text
CurDepart.Depart_Id = Val(Right(TreeView1.SelectedItem.Key, Len(TreeView1.SelectedItem.Key) - 1))
If Focuskey = "a0" Then '根结点
AdoStaffNameList.RecordSource = "SELECT * FROM Staff WHERE Depart_Id<0"
AdoStaffNameList.Refresh
DataList1.ReFill
Exit Sub
End If
'如果包含子结点，则设置图像格式
If CurDepart.HaveSon(CurDepart.Depart_Id) = False Then
TreeView1.SelectedItem.ExpandedImage = 4
TreeView1.SelectedItem.Image = 4
TreeView1.SelectedItem.SelectedImage = 5
End If
'读取CurDepart中的所有部门信息
CurDepart.GetInfo (CurDepart.Depart_Id)
'根据选择的部门编号刷新AdoStaffNameList1，从而选择符合条件的员工姓名
AdoStaffNameList.RecordSource = "SELECT Staff_Id, Staff_Name FROM Staff WHERE Depart_Id=" _
+ Trim(Str(CurDepart.Depart_Id))
AdoStaffNameList.Refresh
DataList1.ReFill
DataList1_Click
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -