📄 frm1gzgl.frm
字号:
TabIndex = 11
Top = 0
Width = 4575
Begin VB.CommandButton cmdSSSSSSX
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 600
TabIndex = 16
Top = 120
Visible = 0 'False
Width = 255
End
Begin VB.CheckBox Check1
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 360
TabIndex = 15
Top = 120
Value = 1 'Checked
Width = 255
End
Begin VB.TextBox txtCZ
Height = 330
Left = 2760
TabIndex = 14
ToolTipText = "输入职工姓名"
Top = 60
Width = 1215
End
Begin VB.CommandButton cmdCZ
Caption = "查"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 330
Left = 4080
TabIndex = 13
Top = 60
Width = 330
End
Begin VB.ComboBox Combo1
Height = 345
Left = 960
Style = 2 'Dropdown List
TabIndex = 12
ToolTipText = "选择发放月度"
Top = 60
Width = 1335
End
Begin VB.Image Image4
Height = 240
Left = 0
Picture = "frm1GZGL.frx":419A
ToolTipText = "显示\关闭网格线"
Top = 120
Width = 240
End
Begin VB.Image Image3
Height = 240
Left = 2400
Picture = "frm1GZGL.frx":4724
ToolTipText = "搜索"
Top = 120
Width = 240
End
End
End
Begin VB.Image Image6
Height = 240
Left = 240
Picture = "frm1GZGL.frx":4CAE
Top = 1200
Width = 240
End
Begin VB.Label Label5
BackStyle = 0 'Transparent
Caption = "当前记录："
Height = 255
Left = 360
TabIndex = 9
Top = 0
Width = 975
End
Begin VB.Label Label4
BackStyle = 0 'Transparent
ForeColor = &H00000080&
Height = 255
Left = 1320
TabIndex = 8
Top = 0
Width = 1095
End
End
Attribute VB_Name = "frm1GZGL"
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
Dim Dqyd As String
Private Sub Check1_Click()
Me.ListView1.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 Trim(Me.txtCZ.Text) = "" Then
MsgBox "请输入要查找的职工姓名！", 48, "提示"
Me.txtCZ.SetFocus
Exit Sub
End If
SQL = "select * from 工资发放表 where 姓名 like '%" & Me.txtCZ.Text & "%'"
Call addLIST
End Sub
Private Sub cmdSSSSSSX_Click()
Call addLIST '用于刷新本窗体
End Sub
Private Sub Combo1_Click()
SQL = "select * from 工资发放表 where 月度='" & Me.Combo1.Text & "'"
Call addLIST
End Sub
Private Sub Form_Load()
Me.Caption = gXtmc
'树视图-------------------------
Call addTVW(Me.TreeView1)
'设置lvw--------------------------
With Me.ListView1
.ColumnHeaders.Add = "月度"
.ColumnHeaders.Add = "FFID"
.ColumnHeaders.Add = "姓名"
.ColumnHeaders.Add = "职务"
.ColumnHeaders.Add = "单位"
.ColumnHeaders.Add = "部门"
.ColumnHeaders.Add = "开户银行"
.ColumnHeaders.Add = "银行帐号"
.ColumnHeaders.Add = "实发工资"
.ColumnHeaders(1).Width = 1200
.ColumnHeaders(2).Width = 0
.ColumnHeaders(3).Width = 1200
.ColumnHeaders(4).Width = 1200
.ColumnHeaders(7).Width = 1700
.ColumnHeaders(8).Width = 2300
End With
'添加combo---------------------
Dqyd = Format(Date, "yyyymm") '当前月度
Me.Combo1.AddItem Dqyd
Call OpenConn
SQL = "select DISTINCT 月度 from 工资发放表"
rs.Open SQL, cn, 1, 1
Do While Not rs.EOF
Me.Combo1.AddItem rs!月度
rs.MoveNext
Loop
Call CloseConn
Me.Combo1.ListIndex = 0 '已经触发了combo1的click事件
End Sub
Private Sub Form_Initialize()
Call InitCommonControls 'XP效果
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.picLEFT.Height = Me.ScaleHeight - Me.picLEFT.Top
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
gGzid = Me.ListView1.SelectedItem.SubItems(1)
frm1GZFF.Show 1
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Index
Case Is = 2 '工资设置
frm1GZSZ.Show 1
Case Is = 3 '工资发放
gGzid = 0
frm1GZFF.Show 1
Case Is = 4 '分类汇总
frm1DWFFTJ.Show
Case Is = 5 '导出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 '释放控制权
Call openXLT("gzff.xlt")
Call OpenConn
SQL1 = "select * from 工资发放表 where 月度='" & Me.Combo1.Text & "'"
rs.Open SQL1, cn, 1, 1
i = 4
Do While Not rs.EOF
xlsheet.Cells(i, 1) = rs!姓名
xlsheet.Cells(i, 2) = rs!职务
xlsheet.Cells(i, 3) = rs!月度
xlsheet.Cells(i, 4) = rs!单位
xlsheet.Cells(i, 5) = rs!部门
xlsheet.Cells(i, 6) = rs!开户银行
xlsheet.Cells(i, 7) = rs!银行帐号
xlsheet.Cells(i, 8) = rs!岗位工资
xlsheet.Cells(i, 9) = rs!补贴
xlsheet.Cells(i, 10) = rs!加班工资
xlsheet.Cells(i, 11) = rs!效益工资
xlsheet.Cells(i, 12) = rs!其它应发
xlsheet.Cells(i, 13) = Val(rs!岗位工资) + Val(rs!补贴) + Val(rs!加班工资) + Val(rs!效益工资) + Val(rs!其它应发)
xlsheet.Cells(i, 14) = rs!养老金
xlsheet.Cells(i, 15) = rs!失业金
xlsheet.Cells(i, 16) = rs!医保金
xlsheet.Cells(i, 17) = rs!公积金
xlsheet.Cells(i, 18) = rs!房水电
xlsheet.Cells(i, 19) = rs!其它应扣
xlsheet.Cells(i, 20) = rs!代扣税
xlsheet.Cells(i, 21) = Val(rs!养老金) + Val(rs!失业金) + Val(rs!医保金) + Val(rs!公积金) + Val(rs!房水电) + Val(rs!其它应扣) + Val(rs!代扣税)
xlsheet.Cells(i, 22) = (Val(rs!岗位工资) + Val(rs!补贴) + Val(rs!加班工资) + Val(rs!效益工资) + Val(rs!其它应发)) - (Val(rs!养老金) + Val(rs!失业金) + Val(rs!医保金) + Val(rs!公积金) + Val(rs!房水电) + Val(rs!其它应扣) + Val(rs!代扣税))
xlsheet.Cells(i, 23) = rs!记录人
xlsheet.Cells(i, 24) = rs!备注
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
Set addLVW = Me.ListView1.ListItems.Add(, , rs!月度, , 1)
addLVW.SubItems(1) = rs!ffid
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) = Format((Val(rs!岗位工资) + Val(rs!补贴) + Val(rs!加班工资) + Val(rs!效益工资) + Val(rs!其它应发)) - (Val(rs!养老金) + Val(rs!失业金) + Val(rs!医保金) + Val(rs!公积金) + Val(rs!房水电) + Val(rs!其它应扣) + Val(rs!代扣税)), "currency")
rs.MoveNext
Loop
Me.labCONUT.Caption = rs.RecordCount
Call CloseConn
Me.picLOAD.Visible = False
End Sub
Private Sub TreeView1_NodeClick(ByVal Node As MSComctlLib.Node)
Dim treeFlag As String
treeFlag = Left(Node.Key, 1)
Select Case treeFlag
Case Is = "A"
SQL = "select * from 工资发放表 where 月度='" & Me.Combo1.Text & "'"
Call addLIST
Case Is = "B"
SQL = "select * from 工资发放表 where 单位='" & Node.Text & "' and 月度 = '" & Me.Combo1.Text & "'"
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 * from 工资发放表 where 单位='" & c & "' and 部门='" & Node.Text & "' and 月度='" & Me.Combo1.Text & "'"
Call addLIST
End Select
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -