?? 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 + -