📄 frmempman.frm
字号:
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800080&
Height = 225
Left = 6000
TabIndex = 12
Top = 1440
Width = 1440
End
Begin VB.Label Label27
AutoSize = -1 'True
BackColor = &H00FFC0C0&
BackStyle = 0 'Transparent
Caption = "备注"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 180
Left = 4800
TabIndex = 11
Top = 4320
Width = 390
End
Begin VB.Label Lbl_Memo
BackColor = &H00FFC0C0&
BackStyle = 0 'Transparent
Caption = "Memo"
DataField = "Memo"
DataSource = "AdoEmpDetail"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800080&
Height = 225
Left = 6000
TabIndex = 10
Top = 4320
Width = 2880
End
Begin VB.Line Line29
X1 = 1200
X2 = 1200
Y1 = 3840
Y2 = 4920
End
End
Begin VB.CommandButton Cmd_Add
Caption = "添加职员"
Default = -1 'True
Height = 400
Left = 2177
MouseIcon = "FrmEmpMan.frx":0000
MousePointer = 99 'Custom
Style = 1 'Graphical
TabIndex = 8
Top = 5880
Width = 1300
End
Begin VB.CommandButton Cmd_Modi
Caption = "修改资料"
Height = 400
Left = 3720
MouseIcon = "FrmEmpMan.frx":030A
MousePointer = 99 'Custom
Style = 1 'Graphical
TabIndex = 7
Top = 5880
Width = 1300
End
Begin VB.CommandButton Cmd_Del
Caption = "删除职员"
Height = 400
Left = 5237
MouseIcon = "FrmEmpMan.frx":0614
MousePointer = 99 'Custom
Style = 1 'Graphical
TabIndex = 6
Top = 5880
Width = 1300
End
Begin VB.CommandButton Cmd_Back
Cancel = -1 'True
Caption = "返 回"
Height = 400
Left = 8297
MouseIcon = "FrmEmpMan.frx":091E
MousePointer = 99 'Custom
Style = 1 'Graphical
TabIndex = 5
Top = 5880
Width = 1300
End
Begin VB.CommandButton Cmd_Trans
Caption = "部门调转"
Height = 400
Left = 6720
MouseIcon = "FrmEmpMan.frx":0C28
MousePointer = 99 'Custom
Style = 1 'Graphical
TabIndex = 4
Top = 5880
Width = 1300
End
Begin VB.Frame Frame2
BackColor = &H80000004&
Height = 495
Left = 120
TabIndex = 1
Top = 0
Width = 11535
Begin VB.CommandButton Cmd_Family
Caption = "家庭主要成员管理"
Height = 285
Left = 180
MouseIcon = "FrmEmpMan.frx":0F32
MousePointer = 99 'Custom
Style = 1 'Graphical
TabIndex = 3
Top = 150
Width = 1905
End
Begin VB.CommandButton Cmd_Experience
Caption = "学历与工作经历"
Height = 285
Left = 2520
MouseIcon = "FrmEmpMan.frx":123C
MousePointer = 99 'Custom
Style = 1 'Graphical
TabIndex = 2
Top = 150
Width = 2025
End
End
Begin VB.ComboBox ComboState
Height = 300
ItemData = "FrmEmpMan.frx":1546
Left = 120
List = "FrmEmpMan.frx":155C
Style = 2 'Dropdown List
TabIndex = 0
Top = 2880
Width = 2415
End
Begin MSDataListLib.DataList DataList1
Bindings = "FrmEmpMan.frx":159C
Height = 2160
Left = 120
TabIndex = 74
Top = 3240
Width = 2415
_ExtentX = 4260
_ExtentY = 3810
_Version = 393216
ListField = "Emp_Name"
BoundColumn = "Emp_Id"
End
Begin MSAdodcLib.Adodc AdoEmpNameList
Height = 330
Left = 3120
Top = 6360
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=HrSys"
OLEDBString = ""
OLEDBFile = ""
DataSourceName = "HrSys"
OtherAttributes = ""
UserName = "sa"
Password = "sa"
RecordSource = "SELECT Emp_Id,Emp_Name FROM Employees ORDER BY Emp_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 = 0
Top = 1200
_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 = "FrmEmpMan.frx":15D6
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmEmpMan.frx":3F68
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmEmpMan.frx":68FA
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmEmpMan.frx":928C
Key = ""
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmEmpMan.frx":BC1E
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.TreeView TreeView1
Height = 2175
Left = 120
TabIndex = 75
Top = 600
Width = 2415
_ExtentX = 4260
_ExtentY = 3836
_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 = "FrmEmpMan.frx":E5B0
End
Begin MSAdodcLib.Adodc AdoEmpDetail
Height = 330
Left = 120
Top = 6360
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=HrSys"
OLEDBString = ""
OLEDBFile = ""
DataSourceName = "HrSys"
OtherAttributes = ""
UserName = "sa"
Password = "sa"
RecordSource = "SELECT * FROM Employees"
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 = "FrmEmpMan"
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 CurDep.Dep_Id <= 0 Then
MsgBox "请选择所属部门"
Exit Sub
End If
'设置添加标记
FrmEmpEdit.Modify = False
FrmEmpEdit.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 CurEmp.Emp_Id <= 0 Then
MsgBox "请选择要删除的员工"
Exit Sub
End If
'确定是否删除
If MsgBox("姓名:" + Lbl_Emp_Name + Chr(13), vbYesNo, "是否删除") = vbNo Then
Exit Sub
End If
CurEmp.Delete (CurEmp⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -