📄 frmjcda.frm
字号:
Height = 240
Left = 0
Picture = "frmJCDA.frx":4466
ToolTipText = "显示\关闭网格线"
Top = 120
Width = 240
End
Begin VB.Image Image3
Height = 240
Left = 2400
Picture = "frmJCDA.frx":49F0
ToolTipText = "搜索"
Top = 120
Width = 240
End
End
End
Begin MSComctlLib.ImageList ImageList1
Left = 3480
Top = 6600
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 3
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmJCDA.frx":4F7A
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmJCDA.frx":5514
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmJCDA.frx":5AAE
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.ListView ListView1
Height = 3555
Left = 2880
TabIndex = 0
Top = 480
Width = 8265
_ExtentX = 14579
_ExtentY = 6271
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
SmallIcons = "ImageList3"
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 0
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Arial"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
NumItems = 0
End
Begin MSComctlLib.ListView ListView2
Height = 3675
Left = 2880
TabIndex = 18
Top = 4080
Width = 8265
_ExtentX = 14579
_ExtentY = 6482
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
SmallIcons = "ImageList3"
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 0
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Arial"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
NumItems = 0
End
End
Attribute VB_Name = "frmJCDA"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'****************************************************************************
'人人为我，我为人人
'枕善居收藏整理
'发布日期：2007/12/17
'描 述：企事业单位人事管理系统 Ver 2007
'网 站：http://www.Mndsoft.com/ (VB6源码博客)
'网 站：http://www.VbDnet.com/ (VB.NET源码博客,主要基于.NET2005)
'e-mail ：Mndsoft@163.com
'e-mail ：Mndsoft@126.com
'OICQ ：88382850
' 如果您有新的好的代码别忘记给枕善居哦!
'****************************************************************************
Dim SQL As String
Dim addLVW As ListItem
Private Sub Check1_Click()
Me.ListView1.Gridlines = Me.Check1.Value
Me.ListView2.Gridlines = Me.Check1.Value
End Sub
Private Sub Check2_Click()
'If Me.Check2.Value = 1 Then
' For i = 1 To Me.TreeView1.Nodes.Count
' Me.TreeView1.Nodes(i).Expanded = True
' Next
'Else
' For i = 1 To Me.TreeView1.Nodes.Count
' Me.TreeView1.Nodes(i).Expanded = False
' Next
'End If
End Sub
Private Sub cmdCZ_Click()
If Not IsDate(Trim(Me.txtCZ.Text)) Then
MsgBox "请输入要查找的日期:YYYY-MM-DD！", 48, "提示"
Me.txtCZ.SetFocus
Exit Sub
End If
SQL = "select zgid,编号,姓名,性别,职务,民族,政治面貌,出生日期,职工类型,单位,部门,联系电话,移动电话,最高学历,职称,来源,用工形式 from 基础档案表"
SQL = SQL & " where 姓名 like '%" & Me.txtCZ.Text & "%' ORDER BY 编号 ASC"
Call addLIST
End Sub
Private Sub cmdSSSSSSX_Click()
Call addLIST '用于刷新本窗口listview,刷新时使用了本窗口的变量SQL
End Sub
Private Sub Combo1_Click()
If Me.Combo1.Text = "全部" Then
SQL = "select zgid,编号,姓名,性别,职务,民族,政治面貌,出生日期,职工类型,单位,部门,联系电话,移动电话,最高学历,职称,来源,用工形式 from 基础档案表"
SQL = SQL & " ORDER BY 编号 ASC"
Else
SQL = "select zgid,编号,姓名,性别,职务,民族,政治面貌,出生日期,职工类型,单位,部门,联系电话,移动电话,最高学历,职称,来源,用工形式 from 基础档案表"
SQL = SQL & " where 职工类型='" & Me.Combo1.Text & "' ORDER BY 编号 ASC"
End If
Call addLIST
End Sub
Private Sub Form_Initialize()
Call InitCommonControls 'XP效果
End Sub
Private Sub Form_Load()
Me.Caption = gXtmc
'------------------------------------
'统计信息
Call OpenConn
SQL = "select count(*) as zgzs from 基础档案表"
rs.Open SQL, cn, 1, 1
Me.labCONUT.Caption = rs!zgzs & " 人"
Call CloseConn
'树视图-------------------------
Call addTVW(Me.TreeView1)
'livsview设置
With Me.ListView1
.ColumnHeaders.Add = "编号"
.ColumnHeaders.Add = "zgid"
.ColumnHeaders.Add = "姓名"
.ColumnHeaders.Add = "性别"
.ColumnHeaders.Add = "职务"
.ColumnHeaders.Add = "民族"
.ColumnHeaders.Add = "政治面貌"
.ColumnHeaders.Add = "出生日期"
.ColumnHeaders.Add = "职工类型"
.ColumnHeaders.Add = "单位"
.ColumnHeaders.Add = "部门"
.ColumnHeaders.Add = "联系电话"
.ColumnHeaders.Add = "移动电话"
.ColumnHeaders.Add = "最高学历"
.ColumnHeaders.Add = "职称"
.ColumnHeaders.Add = "来源"
.ColumnHeaders.Add = "用工形式"
.ColumnHeaders(1).Width = 1200
.ColumnHeaders(2).Width = 0
.ColumnHeaders(4).Width = 600
.ColumnHeaders(5).Width = 1000
.ColumnHeaders(6).Width = 1000
.ColumnHeaders(9).Width = 1000
End With
'增加combo项目
Call OpenConn
SQL = "select * from 参数设置表 where 项目='职工类型'"
rs.Open SQL, cn, 1, 1
Do While Not rs.EOF
Me.Combo1.AddItem rs!值
rs.MoveNext
Loop
Call CloseConn
Me.Combo1.AddItem "全部"
Me.Combo1.ListIndex = 0 'me.combo1的click事件已经激活
End Sub
Private Sub Form_Resize() '窗体内控件尺寸
If Me.ScaleHeight > 8295 Or Me.ScaleWidth > 11280 Then
' Me.ListView1.Height = Me.ScaleHeight - Me.ListView1.Top
Me.ListView1.Width = Me.ScaleWidth - Me.ListView1.Left
Me.ListView2.Width = Me.ScaleWidth - Me.ListView2.Left
Me.ListView2.Height = Me.ScaleHeight - Me.ListView2.Top
Me.PicLEFT.Height = Me.ScaleHeight - Me.PicLEFT.Top
Me.TreeView1.Height = Me.PicLEFT.Height - Me.Shape1(1).Top - 350
End If
Me.Picture1.Left = Me.ScaleWidth - Me.Picture1.Width - 240
End Sub
Private Sub ListView1_DblClick()
If Me.ListView1.ListItems.Count <= 0 Then Exit Sub
gXhcd = Me.ListView1.SelectedItem.SubItems(1)
newFlag = 1
frmXZDA.Show 1
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Index
Case Is = 2 '新增职工
newFlag = 0
frmXZDA.Show 1
Case Is = 3 '家庭成员
frmJTCY.Show 1
Case Is = 4 '个人简历
frmGRJL.Show 1
Case Is = 5 '所获荣誉
frmSHRY.Show 1
Case Is = 6 '导出excel
Me.picLOAD.Left = (Me.ScaleWidth + Me.PicLEFT.Width - Me.picLOAD.Width) / 2
Me.picLOAD.Top = Me.ScaleHeight / 2 - Me.picLOAD.Height
Me.picLOAD.Visible = True
DoEvents '释放控制权
Dim i As Integer
Dim j As Integer
i = 3
Call openXLT("jcda.xlt")
Call OpenConn
If Me.Combo1.Text = "全部" Then
SQL1 = "select * from 基础档案表 ORDER BY 编号 ASC"
Else
SQL1 = "select * from 基础档案表 where 职工类型='" & Me.Combo1.Text & "' ORDER BY 编号 ASC"
End If
rs.Open SQL1, cn, 1, 1
Do While Not rs.EOF
For j = 1 To 33
xlsheet.Cells(i, j) = rs.Fields(j).Value
Next
rs.MoveNext
i = i + 1
Loop
Call CloseConn
Call closeXLT
Me.picLOAD.Visible = False
End Select
End Sub
Private Sub addLIST()
Me.picLOAD.Left = (Me.ScaleWidth + Me.PicLEFT.Width - Me.picLOAD.Width) / 2
Me.picLOAD.Top = Me.ScaleHeight / 2 - Me.picLOAD.Height
Me.picLOAD.Visible = True
DoEvents '释放控制权
Me.ListView1.ListItems.Clear
Call OpenConn
rs.Open SQL, cn, 1, 1
Do While Not rs.EOF
If rs!性别 = "男" Then tb = 1
If rs!性别 = "女" Then tb = 2
Set addLVW = Me.ListView1.ListItems.Add(, , rs!编号, , tb)
addLVW.SubItems(1) = rs!ZGID
addLVW.SubItems(2) = rs!姓名
addLVW.SubItems(3) = rs!性别
addLVW.SubItems(4) = rs!职务
addLVW.SubItems(5) = rs!民族
addLVW.SubItems(6) = rs!政治面貌
addLVW.SubItems(7) = rs!出生日期
addLVW.SubItems(8) = rs!职工类型
addLVW.SubItems(9) = rs!单位
addLVW.SubItems(10) = rs!部门
addLVW.SubItems(11) = rs!联系电话
addLVW.SubItems(12) = rs!移动电话
addLVW.SubItems(13) = rs!最高学历
addLVW.SubItems(14) = rs!职称
addLVW.SubItems(15) = rs!来源
addLVW.SubItems(16) = rs!用工形式
rs.MoveNext
Loop
Me.labDQJL.Caption = rs.RecordCount & " 人"
Call CloseConn
Me.picLOAD.Visible = False
End Sub
Private Sub TreeView1_NodeClick(ByVal Node As MSComctlLib.Node)
Dim zglx As String '职工类型
Dim treeFlag As String
treeFlag = Left(Node.Key, 1)
If Me.Combo1.Text = "全部" Then
zglx = ""
Else
zglx = Me.Combo1.Text
End If
Select Case treeFlag
Case Is = "A"
SQL = "select zgid,编号,姓名,性别,职务,民族,政治面貌,出生日期,职工类型,单位,部门,联系电话,移动电话,最高学历,职称,来源,用工形式 from 基础档案表"
SQL = SQL & " where 职工类型 like '%" & zglx & "%' ORDER BY 编号 ASC"
Call addLIST
Case Is = "B"
SQL = "select zgid,编号,姓名,性别,职务,民族,政治面貌,出生日期,职工类型,单位,部门,联系电话,移动电话,最高学历,职称,来源,用工形式 from 基础档案表"
SQL = SQL & " where 单位='" & Node.Text & "' and 职工类型 like '%" & zglx & "%' ORDER BY 编号 ASC"
Call addLIST
Case Is = "C"
treepath = TreeView1.SelectedItem.FullPath 'tree完整路径
a = InStr(1, treepath, "\") '找第一个\分隔位置
b = InStr(a + 1, treepath, "\") '找第二个 \分隔位置
c = Mid(treepath, a + 1, b - a - 1) '将单位取出
SQL = "select zgid,编号,姓名,性别,职务,民族,政治面貌,出生日期,职工类型,单位,部门,联系电话,移动电话,最高学历,职称,来源,用工形式 from 基础档案表"
SQL = SQL & " where 单位='" & c & "' and 部门='" & Node.Text & "' and 职工类型 like '%" & zglx & "%' ORDER BY 编号 ASC"
Call addLIST
End Select
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -