frmcsxz1.frm

采用VB6.0开发,是一个简单的人事管理系统.

VERSION 5.00
Begin VB.Form frmCSXZ1 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "双击选择"
   ClientHeight    =   3105
   ClientLeft      =   45
   ClientTop       =   435
   ClientWidth     =   3840
   BeginProperty Font 
      Name            =   "Arial"
      Size            =   9
      Charset         =   0
      Weight          =   400
      Underline       =   0   'False
      Italic          =   0   'False
      Strikethrough   =   0   'False
   EndProperty
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3105
   ScaleWidth      =   3840
   StartUpPosition =   2  '屏幕中心
   Begin VB.PictureBox Picture1 
      BackColor       =   &H8000000D&
      BorderStyle     =   0  'None
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   0
      ScaleHeight     =   375
      ScaleWidth      =   3855
      TabIndex        =   1
      Top             =   0
      Width           =   3855
      Begin VB.Label Label1 
         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        =   2
         Top             =   60
         Width           =   1095
      End
   End
   Begin VB.ListBox List1 
      Height          =   2760
      Left            =   0
      TabIndex        =   0
      Top             =   360
      Width           =   3855
   End
End
Attribute VB_Name = "frmCSXZ1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim SQL As String
Private Sub Form_Load()
Select Case gCsxzcd
    Case Is = 0
        SQL = "select * from 参数设置表 where 项目='民族'"
    Case Is = 1
        SQL = "select * from 参数设置表 where 项目='政治面貌'"
    Case Is = 2
        SQL = "select * from 参数设置表 where 项目='职工类型'"
    Case Is = 3
        SQL = "select * from 参数设置表 where 项目='学历'"
    Case Is = 4
        SQL = "select * from 参数设置表 where 项目='学历'"
    Case Is = 5
        SQL = "select * from 参数设置表 where 项目='岗位'"
    Case Is = 6
        SQL = "select * from 参数设置表 where 项目='岗别'"
    Case Is = 7
        SQL = "select * from 参数设置表 where 项目='档次'"
    Case Is = 8
        SQL = "select * from 参数设置表 where 项目='职务'"
    Case Is = 9
        SQL = "select * from 参数设置表 where 项目='职称'"
    Case Is = 10
        SQL = "select * from 参数设置表 where 项目='来源'"
    Case Is = 11
        SQL = "select * from 参数设置表 where 项目='用工形式'"
End Select

Call OpenConn '加入list项目
rs.Open SQL, cn, 1, 1
Do While Not rs.EOF
    Me.List1.AddItem rs!值
    rs.MoveNext
Loop
Call CloseConn

End Sub

Private Sub List1_DblClick() '双击更新frmXZDA相关字段
frmXZDA.Text1(gCsxzcd).Text = Me.List1.Text
Unload Me
End Sub