frm_query.frm

人力资源管理系统,前些年帮人写的毕业设计

VERSION 5.00
Begin VB.Form Frm_query 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "查询"
   ClientHeight    =   2460
   ClientLeft      =   4275
   ClientTop       =   2790
   ClientWidth     =   4035
   Icon            =   "Frm_query.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2460
   ScaleWidth      =   4035
   StartUpPosition =   1  '所有者中心
   Begin VB.ComboBox Combo2 
      Height          =   300
      Left            =   1440
      TabIndex        =   6
      Top             =   900
      Width           =   1935
   End
   Begin VB.CommandButton Command2 
      Caption         =   "取消"
      Height          =   375
      Left            =   2220
      TabIndex        =   5
      Top             =   1740
      Width           =   1095
   End
   Begin VB.CommandButton Command1 
      Caption         =   "确定"
      Height          =   375
      Left            =   600
      TabIndex        =   4
      Top             =   1800
      Width           =   1155
   End
   Begin VB.TextBox Text1 
      Height          =   300
      Left            =   1440
      TabIndex        =   3
      Top             =   900
      Width           =   1935
   End
   Begin VB.ComboBox Combo1 
      Height          =   300
      Left            =   1440
      Style           =   2  'Dropdown List
      TabIndex        =   0
      Top             =   360
      Width           =   1935
   End
   Begin VB.Label Label2 
      Caption         =   "查询内容"
      Height          =   195
      Left            =   480
      TabIndex        =   2
      Top             =   960
      Width           =   795
   End
   Begin VB.Label Label1 
      Caption         =   "查询条件"
      Height          =   315
      Left            =   480
      TabIndex        =   1
      Top             =   420
      Width           =   855
   End
End
Attribute VB_Name = "Frm_query"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Combo1_Change()
    Select Case Combo1
        Case "姓名"
            Text1.Visible = True
            Combo2.Visible = False
        Case "性别"
            Text1.Visible = False
            Combo2.Visible = True
            Combo2.Clear
            Combo2.AddItem "男"
            Combo2.AddItem "女"
        Case "文化程度"
            Text1.Visible = False
            Combo2.Visible = True
            Combo2.Clear
            Combo2.AddItem "高中"
            Combo2.AddItem "大专"
            Combo2.AddItem "大本"
            Combo2.AddItem "硕士"
            Combo2.AddItem "博士"
        Case "政治面貌"
            Text1.Visible = False
            Combo2.Visible = True
            Combo2.Clear
            Combo2.AddItem "群众"
            Combo2.AddItem "团员"
            Combo2.AddItem "党员"
        Case "技术职称"
            ext1.Visible = False
            Combo2.Visible = True
            Combo2.Clear
            Combo2.AddItem "技工"
            Combo2.AddItem "技术员"
            Combo2.AddItem "工程师"
    End Select
            
End Sub

Private Sub Combo1_Click()
    Select Case Combo1
        Case "姓名"
            Text1.Visible = True
            Combo2.Visible = False
        Case "性别"
            Text1.Visible = False
            Combo2.Visible = True
            Combo2.Clear
            Combo2.AddItem "男"
            Combo2.AddItem "女"
        Case "文化程度"
            Text1.Visible = False
            Combo2.Visible = True
            Combo2.Clear
            Combo2.AddItem "高中"
            Combo2.AddItem "大专"
            Combo2.AddItem "大本"
            Combo2.AddItem "硕士"
            Combo2.AddItem "博士"
        Case "政治面貌"
            Text1.Visible = False
            Combo2.Visible = True
            Combo2.Clear
            Combo2.AddItem "群众"
            Combo2.AddItem "团员"
            Combo2.AddItem "党员"
        Case "技术职称"
            Text1.Visible = False
            Combo2.Visible = True
            Combo2.Clear
            Combo2.AddItem "技工"
            Combo2.AddItem "技术员"
            Combo2.AddItem "工程师"
    End Select
End Sub

Private Sub Command1_Click()
    Dim cn As ADODB.Connection
    Dim rst As New ADODB.Recordset
    Dim lt As ListItem
    Dim lm As String
    Dim dbn As String
    Set cn = GetCn
    For i = 1 To Frm_rcgl.ListView1.ColumnHeaders.Count
        lm = lm & Frm_rcgl.ListView1.ColumnHeaders(i).Text & ","
    Next i
    If Len(lm) > 1 Then lm = Left(lm, Len(lm) - 1)
    If Frm_rcgl.Option1 = True Then
        dbn = "技术人才数据表"
    Else
        dbn = "管理人才数据表"
    End If
        
    If Combo1 = "姓名" Then
        rst.Open "select " & lm & " from " & dbn & " where " & Combo1 & " like '%" & Text1 & "%'", cn, 0, 1
    Else
        rst.Open "select " & lm & " from " & dbn & " where " & Combo1 & " like '%" & Combo2 & "%'", cn, 0, 1
    End If
    
    Frm_rcgl.ListView1.ListItems.Clear
    If rst.BOF And rst.EOF Then
        MsgBox "没有符合条件的记录！", vbExclamation, "提示"
        rst.Close
        cn.Close
        Exit Sub
    End If
    Do While Not rst.EOF
        Set lt = Frm_rcgl.ListView1.ListItems.Add(, , Trim(rst(0)), 8, 8)
        For i = 1 To rst.Fields.Count - 1
            lt.SubItems(i) = Trim(rst(i) & "")
        Next i
        rst.MoveNext
    Loop
    rst.Close
    cn.Close
    Unload Me
End Sub

Private Sub Command2_Click()
    Unload Me
End Sub

Private Sub Form_Load()
    Combo1.AddItem "姓名"
    Combo1.AddItem "性别"
    Combo1.AddItem "文化程度"
    Combo1.AddItem "政治面貌"
    Combo1.AddItem "技术职称"
End Sub