📄 employeelistform.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "Mscomctl.ocx"
Object = "{0ECD9B60-23AA-11D0-B351-00A0C9055D8E}#6.0#0"; "Mshflxgd.ocx"
Begin VB.Form EmployeeListform
Caption = "Form1"
ClientHeight = 5055
ClientLeft = 60
ClientTop = 450
ClientWidth = 9135
LinkTopic = "Form1"
MDIChild = -1 'True
ScaleHeight = 5055
ScaleWidth = 9135
Begin VB.TextBox Text15
BorderStyle = 0 'None
Enabled = 0 'False
Height = 255
Left = 120
TabIndex = 3
Text = "√"
Top = 1320
Visible = 0 'False
Width = 495
End
Begin MSComctlLib.Toolbar SzToolbar
Align = 1 'Align Top
Height = 570
Left = 0
TabIndex = 0
Top = 0
Width = 9135
_ExtentX = 16113
_ExtentY = 1005
ButtonWidth = 820
ButtonHeight = 953
AllowCustomize = 0 'False
Appearance = 1
Style = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 11
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "新增"
Key = "xz"
Object.ToolTipText = "点击或按Ctrl+N增加"
ImageKey = "xz"
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "修改"
Key = "xg"
Object.ToolTipText = "点击或按F3修改"
ImageKey = "xg"
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "修密"
Key = "xm"
ImageIndex = 2
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "删除"
Key = "sc"
Object.ToolTipText = "点击或按Ctrl+D删除"
ImageKey = "sc"
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.Visible = 0 'False
EndProperty
BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "查询"
Key = "cx"
ImageKey = "cx"
EndProperty
BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "打印"
Key = "dy"
ImageKey = "dy"
EndProperty
BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "刷新"
Key = "sx"
ImageKey = "sx"
EndProperty
BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "权限"
Key = "qx"
ImageKey = "qx"
EndProperty
BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "退出"
Key = "tc"
Object.ToolTipText = "点击或按Ctrl+X退出"
ImageKey = "tc"
EndProperty
EndProperty
BorderStyle = 1
Begin VB.TextBox Text1
Appearance = 0 'Flat
Height = 270
Left = 7080
TabIndex = 4
Text = "Text1"
Top = 120
Width = 1335
End
Begin VB.ComboBox Combo1
Height = 300
Left = 4560
TabIndex = 2
Text = "Combo1"
Top = 120
Width = 1455
End
Begin MSComctlLib.ImageList ImageList1
Left = 8520
Top = 0
_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 = "EmployeeListform.frx":0000
Key = "dy"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "EmployeeListform.frx":039A
Key = "xg"
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "EmployeeListform.frx":0734
Key = "tc"
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "EmployeeListform.frx":0ACE
Key = "xz"
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "EmployeeListform.frx":0E68
Key = "sc"
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "EmployeeListform.frx":1202
Key = "sx"
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "EmployeeListform.frx":159C
Key = "cx"
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "EmployeeListform.frx":1936
Key = "qx"
EndProperty
EndProperty
End
End
Begin MSHierarchicalFlexGridLib.MSHFlexGrid hfg_houseList
Height = 4455
Left = 0
TabIndex = 1
Top = 600
Width = 9135
_ExtentX = 16113
_ExtentY = 7858
_Version = 393216
BackColor = -2147483634
Cols = 37
FixedCols = 0
RowHeightMin = 300
BackColorFixed = 15723503
AllowUserResizing= 3
_NumberOfBands = 1
_Band(0).Cols = 37
End
End
Attribute VB_Name = "EmployeeListform"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'**************************************
'* 模 块 名 称 :员工列表管理用户操作界面
'* 功 能 描 述 :员工列表管理用户操作界面
'* 程序员姓名 : 石春晓
'* 最后修改人 : 石春晓
'* 最后修改时间:2005/08/22
'**************************************
Option Explicit
Private m_EmployeeDAO As employeeDAO ' 员工数据库操作类
Private m_departmentDAO As DepartmentDAO
Private m_recordset As ADODB.Recordset ' 数据操作数据集对象
Private g_recordset As ADODB.Recordset
Public g_application As HApplication ' 自定义的应用程序对象
Private m_queryType As String
Dim m_row As Integer
Dim m_col As Integer
Dim q As Integer
Private m_idList As String ' 在执行查询时查询到的ID列表字符串
Private Sub Combo1_Click()
If Combo1 = "在职员工" Then
m_queryType = "1"
' sxjl
refreshlist
End If
If Combo1 = "历史员工" Then
m_queryType = "2"
' sxjl
refreshlist
End If
If Combo1 = "全部员工" Then
m_queryType = "3"
' sxjl
refreshlist
End If
End Sub
'**************************************
'* 功 能 描 述 :窗体加载函数
'* 输 入 参 数 :无
'* 输 出 能 数 :无
'**************************************
Private Sub Form_Load()
Set m_EmployeeDAO = New employeeDAO
Set m_recordset = New ADODB.Recordset
Set g_application = New HApplication
Set m_departmentDAO = New DepartmentDAO
Set g_recordset = New ADODB.Recordset
Me.caption = "员工管理"
' Combo1.AddItem "全部员工"
Combo1.AddItem "在职员工"
Combo1.AddItem "历史员工"
Combo1.ListIndex = 0
RefreshListTitle
refreshlist
Me.Height = 5580
Me.Width = 9255
SetToCenter Me
End Sub
Private Sub Form_Resize()
hfg_houseList.Height = Me.Height - 1400
hfg_houseList.Width = Me.Width - 350
' Image1.Stretch = False
If (hfg_houseList.Height > hfg_houseList.Height - 300) Or (hfg_houseList.Width > hfg_houseList.Width - 200) Then
hfg_houseList.Height = hfg_houseList.Height + 400
hfg_houseList.Width = hfg_houseList.Width + 200
'
' Image1.Stretch = True
End If
End Sub
Private Sub hfg_houseList_Click()
' If m_row < hfg_houseList.FixedRows Then m_row = hfg_houseList.FixedRows
' If m_col < hfg_houseList.FixedCols Then m_col = hfg_houseList.FixedCols
' hfg_houseList.row = m_row: hfg_houseList.col = m_col
' If m_col = 0 Then ' 优先供应商选择
' If Trim(hfg_houseList.TextMatrix(hfg_houseList.RowSel, 0)) = "00" Then
' Trim(hfg_houseList.TextMatrix(hfg_houseList.RowSel, 0)) = ""
' Else
' Trim(hfg_houseList.TextMatrix(hfg_houseList.RowSel, 0)) = "00"
' ChangePrioritySupplier
' End If
' End If
' SetRowColor hfg_houseList, m_row, &HFFFFFF
' hfg_houseList.row = m_row
' hfg_houseList.col = m_col
' Text15.Visible = False
m_row = hfg_houseList.MouseRow
m_col = hfg_houseList.MouseCol
If m_col = 34 Then
Text15.Visible = True
If m_row < hfg_houseList.FixedRows Then m_row = hfg_houseList.FixedRows
If m_col < hfg_houseList.FixedCols Then m_col = hfg_houseList.FixedCols
hfg_houseList.row = m_row: hfg_houseList.col = m_col
Text15.Move hfg_houseList.Left + hfg_houseList.CellLeft, hfg_houseList.Top + hfg_houseList.CellTop - 20, hfg_houseList.CellWidth - 20, hfg_houseList.CellHeight - 20
Text15.text = Trim(hfg_houseList.text)
Text15.Visible = True
End If
If m_col = 0 Then ' 优先供应商选择
If Trim(hfg_houseList.text) = "√" Then
hfg_houseList.text = ""
Else
hfg_houseList.text = "√"
ChangePrioritySupplier
End If
End If
End Sub
Private Sub hfg_houseList_DblClick()
employeeSingform.m_operatorType = 1
If Trim(hfg_houseList.TextMatrix(hfg_houseList.row, 35)) <> "" Then
employeeSingform.m_employeeId = Trim(hfg_houseList.TextMatrix(hfg_houseList.row, 35))
employeeSingform.show 1
If q = 1 Then
RefreshQueryList
Else
refreshlist
End If
End If
' Text15.text = ""
' employeeSingform.m_operatorType = 1
' If Trim(hfg_houseList.TextMatrix(hfg_houseList.row, 0)) <> "" Then
' employeeSingform.m_employeeId = Trim(hfg_houseList.TextMatrix(hfg_houseList.row, 0))
' employeeSingform.show 1
' RefreshList
' End If
End Sub
'**************************************
'* 功 能 描 述 :工具栏按钮的单击操作按钮
'* 输 入 参 数 :无
'* 输 出 能 数 :无
'**************************************
Private Sub SzToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Key
Case "xz" ' 新增
employeeSingform.m_operatorType = 0
employeeSingform.show 1
refreshlist
Case "xg" ' 修改
employeeSingform.m_operatorType = 1
If Trim(hfg_houseList.TextMatrix(hfg_houseList.row, 35)) <> "" Then
employeeSingform.m_employeeId = Trim(hfg_houseList.TextMatrix(hfg_houseList.row, 35))
employeeSingform.show 1
If q = 1 Then
RefreshQueryList
Else
refreshlist
End If
End If
Case "xm" ' 修改密码
Dim ret As Boolean
ret = yhqxpd(MainForm.g_application.m_userId, Trim(str(PASSWORD_MODIFY))) ' 权限判断
If Not ret Then
MainForm.g_msgText = "该功能您无权操作！"
HMsgBox MainForm.g_msgText, 0, 1
Exit Sub
End If
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -