frmstatisticfind.frm

车辆管理系统是一个协助各单位进行全面的车辆管理的系统。包括车辆档案管理；驾驶员档案管理；车辆运营信息管理；车辆事故信息管理；车辆维修信息管理；车辆费用管理等几个功能模块。

VERSION 5.00
Begin VB.Form frmstatisticfind 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "运营信息查询"
   ClientHeight    =   2730
   ClientLeft      =   5550
   ClientTop       =   2025
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   2730
   ScaleWidth      =   4680
   Begin VB.CheckBox Check2 
      Caption         =   "司机姓名"
      Height          =   375
      Left            =   360
      TabIndex        =   5
      Top             =   1200
      Width           =   1335
   End
   Begin VB.CheckBox Check1 
      Caption         =   "车辆牌照:"
      Height          =   375
      Left            =   360
      TabIndex        =   4
      Top             =   480
      Width           =   1335
   End
   Begin VB.CommandButton cmdcancel 
      Caption         =   "取 消"
      Height          =   375
      Left            =   2760
      TabIndex        =   3
      Top             =   2040
      Width           =   1215
   End
   Begin VB.CommandButton cmdok 
      Caption         =   "查 询"
      Height          =   375
      Left            =   1200
      TabIndex        =   2
      Top             =   2040
      Width           =   1095
   End
   Begin VB.TextBox Txtitem 
      Height          =   375
      Index           =   1
      Left            =   1800
      TabIndex        =   1
      Top             =   1200
      Width           =   2295
   End
   Begin VB.TextBox Txtitem 
      Height          =   375
      Index           =   0
      Left            =   1800
      TabIndex        =   0
      Top             =   480
      Width           =   2295
   End
End
Attribute VB_Name = "frmstatisticfind"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Check1_Click()
   If Check1.Value = 1 Then
      Check2.Enabled = False
      Txtitem(1).Enabled = False
   Else
      Check1.Enabled = True
      Check2.Enabled = True
      Txtitem(0).Enabled = True
      Txtitem(1).Enabled = True
   End If
End Sub

Private Sub Check2_Click()
   If Check2.Value = 1 Then
      Check1.Enabled = False
      Txtitem(0).Enabled = False
   Else
      Check1.Enabled = True
      Check2.Enabled = True
      Txtitem(0).Enabled = True
      Txtitem(1).Enabled = True
   End If
End Sub

Private Sub cmdcancel_Click()
   Unload Me
End Sub

Private Sub cmdok_Click()
   Dim txtsql As String
   If Check1.Value = vbChecked Then
      If Trim(Txtitem(0)) = "" Then
         MsgBox "查询条件不能为空!", vbOKOnly + vbExclamation, "警告"
      Else
         txtsql = "yy_id='" & Trim(Txtitem(0)) & "'"
      End If
   End If
   If Check2.Value = vbChecked Then
      If Trim(Txtitem(1)) = "" Then
         MsgBox "查询条件不能为空!", vbOKOnly + vbExclamation, "警告"
      Else
         txtsql = "yy_driver='" & Trim(Txtitem(1)) & "'"
      End If
   End If
   If Trim(txtsql) = "" Then
      MsgBox "请设置查询方式!", vbOKOnly + vbExclamation, "提示"
   Else
      Unload Me
      frmstatisticlist.txtsql = "select * from statistic where " & txtsql
      frmstatisticlist.Show
   End If
   
   
End Sub

Private Sub Form_Load()
 Me.Left = 5505
 Me.Top = 1695
End Sub