frm1gzffxz.frm

一款代码完整

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form frm1GZFFXZ 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "请选择职工"
   ClientHeight    =   5415
   ClientLeft      =   45
   ClientTop       =   435
   ClientWidth     =   7440
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   5415
   ScaleWidth      =   7440
   StartUpPosition =   2  '屏幕中心
   Begin VB.PictureBox Picture1 
      BackColor       =   &H8000000D&
      BorderStyle     =   0  'None
      Height          =   495
      Left            =   0
      ScaleHeight     =   495
      ScaleWidth      =   7455
      TabIndex        =   0
      Top             =   0
      Width           =   7455
      Begin VB.Label Label3 
         BackStyle       =   0  'Transparent
         Caption         =   "双击选择职工"
         BeginProperty Font 
            Name            =   "Arial"
            Size            =   10.5
            Charset         =   0
            Weight          =   700
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00FFFFFF&
         Height          =   255
         Left            =   240
         TabIndex        =   1
         Top             =   120
         Width           =   1695
      End
   End
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   1260
      Top             =   855
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   16
      ImageHeight     =   16
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   1
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frm1GZFFXZ.frx":0000
            Key             =   ""
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.ListView lvwZG 
      Height          =   4695
      Left            =   120
      TabIndex        =   2
      Top             =   600
      Width           =   7215
      _ExtentX        =   12726
      _ExtentY        =   8281
      View            =   3
      LabelEdit       =   1
      LabelWrap       =   -1  'True
      HideSelection   =   -1  'True
      FullRowSelect   =   -1  'True
      _Version        =   393217
      SmallIcons      =   "ImageList1"
      ForeColor       =   -2147483640
      BackColor       =   -2147483643
      Appearance      =   1
      NumItems        =   0
   End
End
Attribute VB_Name = "frm1GZFFXZ"
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  ：[e-mail]
'e-mail  ：[e-mail]
'OICQ    ：88382850
'          如果您有新的好的代码别忘记给枕善居哦!
'****************************************************************************

Dim addLVW As ListItem
Private Sub Form_Load()
Me.Icon = MDIfrm.Icon '图标

With Me.lvwZG
.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.Add = "其它应扣"
.ColumnHeaders.Add = "代扣税"
.ColumnHeaders(2).Width = 0
.ColumnHeaders(4).Width = 1900
.ColumnHeaders(5).Width = 1900
.ColumnHeaders(6).Width = 0
.ColumnHeaders(7).Width = 0
.ColumnHeaders(8).Width = 0
.ColumnHeaders(9).Width = 0
.ColumnHeaders(10).Width = 0
.ColumnHeaders(11).Width = 0
.ColumnHeaders(12).Width = 0
.ColumnHeaders(13).Width = 0
.ColumnHeaders(14).Width = 0
.ColumnHeaders(15).Width = 0
.ColumnHeaders(16).Width = 0
.ColumnHeaders(17).Width = 0
.ColumnHeaders(18).Width = 0
.ColumnHeaders(19).Width = 0

End With

Call OpenConn
SQL = "select * from 工资管理表 where 姓名 like '%" & frm1GZFF.txtXM.Text & "%'"
rs.Open SQL, cn, 1, 1
Do While Not rs.EOF
    Set addLVW = Me.lvwZG.ListItems.Add(, , rs!姓名, , 1)
        addLVW.SubItems(1) = rs!gzgid
        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!房水电
        addLVW.SubItems(17) = rs!其它应扣
        addLVW.SubItems(18) = rs!代扣税
        rs.MoveNext
Loop
Call CloseConn
End Sub



Private Sub lvwZG_DblClick()
If Me.lvwZG.ListItems.Count <= 0 Then Exit Sub
frm1GZFF.txtXM.Text = Me.lvwZG.SelectedItem
frm1GZFF.Tag = Me.lvwZG.SelectedItem.SubItems(1)
frm1GZFF.txtZW.Text = Me.lvwZG.SelectedItem.SubItems(2)
frm1GZFF.txtDW.Text = Me.lvwZG.SelectedItem.SubItems(3)
frm1GZFF.txtBM.Text = Me.lvwZG.SelectedItem.SubItems(4)
frm1GZFF.txtKHYH.Text = Me.lvwZG.SelectedItem.SubItems(5)
frm1GZFF.txtYHZH.Text = Me.lvwZG.SelectedItem.SubItems(6)
frm1GZFF.Text1(0).Text = Me.lvwZG.SelectedItem.SubItems(7)
frm1GZFF.Text1(1).Text = Me.lvwZG.SelectedItem.SubItems(8)
frm1GZFF.Text1(2).Text = Me.lvwZG.SelectedItem.SubItems(9)
frm1GZFF.Text1(3).Text = Me.lvwZG.SelectedItem.SubItems(10)
frm1GZFF.Text1(4).Text = Me.lvwZG.SelectedItem.SubItems(11)
frm1GZFF.Text1(5).Text = Me.lvwZG.SelectedItem.SubItems(12)
frm1GZFF.Text1(6).Text = Me.lvwZG.SelectedItem.SubItems(13)
frm1GZFF.Text1(7).Text = Me.lvwZG.SelectedItem.SubItems(14)
frm1GZFF.Text1(8).Text = Me.lvwZG.SelectedItem.SubItems(15)
frm1GZFF.Text1(9).Text = Me.lvwZG.SelectedItem.SubItems(16)
frm1GZFF.Text1(10).Text = Me.lvwZG.SelectedItem.SubItems(17)
frm1GZFF.Text1(11).Text = Me.lvwZG.SelectedItem.SubItems(18)
Unload Me
End Sub