form1.frm

计量器具管理系统

VERSION 5.00
Begin VB.Form Form1 
   BackColor       =   &H8000000B&
   Caption         =   "Form1"
   ClientHeight    =   3255
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5280
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   ScaleHeight     =   3255
   ScaleWidth      =   5280
   StartUpPosition =   3  '窗口缺省
   Begin VB.PictureBox Picture1 
      BackColor       =   &H00FFFFFF&
      Height          =   2895
      Left            =   2640
      ScaleHeight     =   2835
      ScaleWidth      =   2355
      TabIndex        =   2
      Top             =   120
      Width           =   2415
      Begin VB.CommandButton Command2 
         BackColor       =   &H00C0FFC0&
         Caption         =   "取消"
         Height          =   375
         Left            =   1320
         TabIndex        =   8
         Top             =   2280
         Width           =   855
      End
      Begin VB.CommandButton Command1 
         BackColor       =   &H00C0FFC0&
         Caption         =   "确定"
         Height          =   375
         Left            =   240
         MaskColor       =   &H00C0FFC0&
         TabIndex        =   7
         Top             =   2280
         Width           =   855
      End
      Begin VB.TextBox Text2 
         BackColor       =   &H00C0FFC0&
         Height          =   375
         Left            =   120
         TabIndex        =   6
         Top             =   1680
         Width           =   2055
      End
      Begin VB.Frame Frame2 
         BackColor       =   &H00FFFFFF&
         Caption         =   "运算符"
         Height          =   855
         Left            =   120
         TabIndex        =   4
         Top             =   720
         Width           =   2055
         Begin VB.ComboBox Combo1 
            BackColor       =   &H00C0FFC0&
            Height          =   300
            Left            =   120
            TabIndex        =   5
            Top             =   240
            Width           =   1815
         End
      End
      Begin VB.TextBox Text1 
         BackColor       =   &H00C0FFC0&
         Height          =   375
         Left            =   120
         TabIndex        =   3
         Top             =   120
         Width           =   2055
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "标识字段"
      Height          =   3015
      Left            =   240
      TabIndex        =   0
      Top             =   120
      Width           =   2175
      Begin VB.ListBox List1 
         Height          =   2580
         ItemData        =   "Form1.frx":0000
         Left            =   120
         List            =   "Form1.frx":0002
         TabIndex        =   1
         Top             =   240
         Width           =   1935
      End
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Dim rs As New ADODB.Recordset
Dim y As String
Dim z As String



Private Sub Command1_Click()
Select Case List1.Text
 Case "领域分类"
 z = "lyfl"
 Case "领域编号"
 z = "lyid"
 Case "职务编号"
 z = "zwbh"
 Case "职务名称"
 z = "zwmc"
 Case "代码编号"
 z = "dmid"
 Case "代码名称"
 z = "dmmc"
 
 Case "单位编号"
 z = "dwid"
 
 Case "单位名称"
 z = "dwmc"
End Select
        Select Case Combo1.Text
        Case "大于"
        y = ">"
        Case "小于"
        y = "<"
        Case "等于"
       y = "="
        Case "包含"
        y = "like"
        End Select
If x = 1 Then
        If rs.State = 1 Then rs.Close
        rs.CursorLocation = adUseServer
        rs.Open "select * from lyfl where " & z & "" & y & " '" & Text2.Text & "'", Conn
        Set Frm_领域分类.Grid.DataSource = rs
       Frm_领域分类.Grid.Visible = True
       Unload Me
End If
If x = 2 Then

    
        If rs.State = 1 Then rs.Close
        rs.CursorLocation = adUseServer
        rs.Open "select * from dwfl where " & z & "" & y & " '" & Text2.Text & "'", Conn
        Set frm_单位分类.Grid.DataSource = rs
       frm_单位分类.Grid.Visible = True
       Unload Me
End If

If x = 3 Then
If rs.State = 1 Then rs.Close
        rs.CursorLocation = adUseServer
        rs.Open "select * from dwfl where " & z & "" & y & " '" & Text2.Text & "'", Conn
        Set frm_职务分类.Grid.DataSource = rs
       frm_职务分类.Grid.Visible = True
       Unload Me
End If

If x = 4 Then

List1.AddItem ("代码编号")
List1.AddItem ("代码名称")
End If

If rs.State = 1 Then rs.Close
rs.CursorLocation = adUseServer
'rs.Open "select * "
End Sub

Private Sub Form_Load()
List1.AddItem ("领域编号")
List1.AddItem ("领域名称")
List1.AddItem ("职务编号")
List1.AddItem ("职务名称")
List1.AddItem ("单位编号")
List1.AddItem ("单位名称")
List1.AddItem ("代码编号")
List1.AddItem ("代码名称")

Combo1.AddItem ("大于")
Combo1.AddItem ("小于")
Combo1.AddItem ("等于")
Combo1.AddItem ("包含")

Combo1.Text = "等于"

Command1.BackColor = vbRed

End Sub


Private Sub List1_Click()
Text1.Text = List1.Text
End Sub



Private Sub Text2_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Command1.SetFocus
End If
End Sub