frmquerybuildinginf.frm

这是一个在某本书上获得的一个小区物业管理系统

VERSION 5.00
Begin VB.Form BuildingInfQuery 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "楼盘信息查询"
   ClientHeight    =   2670
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   5250
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   2670
   ScaleWidth      =   5250
   Begin VB.CommandButton cmdClear 
      Caption         =   "清除"
      Height          =   300
      Left            =   2280
      TabIndex        =   14
      Top             =   2040
      Width           =   735
   End
   Begin VB.CommandButton cmdQuery 
      Caption         =   "查询"
      Default         =   -1  'True
      Height          =   300
      Left            =   1080
      TabIndex        =   7
      Top             =   2040
      Width           =   735
   End
   Begin VB.CommandButton cmdExit 
      Caption         =   "关闭"
      Height          =   300
      Left            =   3480
      TabIndex        =   8
      Top             =   2040
      Width           =   735
   End
   Begin VB.CheckBox chkSale 
      Caption         =   "出售"
      DataField       =   "出售"
      Height          =   255
      Left            =   3960
      TabIndex        =   6
      Top             =   1493
      Width           =   735
   End
   Begin VB.CheckBox chkLend 
      Caption         =   "出租"
      DataField       =   "出租"
      Height          =   255
      Left            =   3240
      TabIndex        =   5
      Top             =   1493
      Width           =   735
   End
   Begin VB.ComboBox cmbTypeList 
      DataField       =   "户型"
      Height          =   300
      ItemData        =   "frmQueryBuildingInf.frx":0000
      Left            =   1080
      List            =   "frmQueryBuildingInf.frx":0010
      TabIndex        =   4
      Top             =   1470
      Width           =   2055
   End
   Begin VB.TextBox txtPropertyNumber 
      Height          =   270
      Left            =   1080
      MaxLength       =   50
      TabIndex        =   3
      Top             =   1095
      Width           =   3495
   End
   Begin VB.TextBox txtLandNumber 
      Height          =   270
      Left            =   1080
      MaxLength       =   50
      TabIndex        =   2
      Top             =   705
      Width           =   3495
   End
   Begin VB.TextBox txtHouseHolder 
      Height          =   270
      Left            =   3240
      MaxLength       =   15
      TabIndex        =   1
      Top             =   315
      Width           =   1335
   End
   Begin VB.TextBox txtDoorNumber 
      Height          =   270
      Left            =   1080
      MaxLength       =   9
      TabIndex        =   0
      Top             =   315
      Width           =   1335
   End
   Begin VB.Label Label5 
      AutoSize        =   -1  'True
      Caption         =   "土地号"
      Height          =   180
      Left            =   480
      TabIndex        =   13
      Top             =   750
      Width           =   540
   End
   Begin VB.Label Label4 
      AutoSize        =   -1  'True
      Caption         =   "产权号"
      Height          =   180
      Left            =   480
      TabIndex        =   12
      Top             =   1140
      Width           =   540
   End
   Begin VB.Label Label3 
      AutoSize        =   -1  'True
      Caption         =   "户  型"
      Height          =   180
      Left            =   480
      TabIndex        =   11
      Top             =   1530
      Width           =   540
   End
   Begin VB.Label Label2 
      AutoSize        =   -1  'True
      Caption         =   "户  主"
      Height          =   180
      Left            =   2640
      TabIndex        =   10
      Top             =   360
      Width           =   540
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      Caption         =   "门牌号"
      Height          =   180
      Left            =   480
      TabIndex        =   9
      Top             =   360
      Width           =   540
   End
End
Attribute VB_Name = "BuildingInfQuery"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub cmdClear_Click()
    txtDoorNumber = "": txtHouseHolder = "": txtLandNumber = ""
    txtPropertyNumber = "": cmbTypeList.Text = "": chkLend.Value = 0: chkSale.Value = 0
End Sub




Private Sub cmdQuery_Click()
    Dim strFilter As String, strSQL As String
    strFilter = "门牌号 LIKE '" & Trim(txtDoorNumber) & "%' and 户主 LIKE '" _
            & txtHouseHolder & "%' and 土地号 LIKE '" & txtLandNumber _
            & "%' and 产权号 LIKE '" & txtPropertyNumber & "%' and " _
            & "户型 LIKE '" & cmbTypeList & "%'" _
            & " and 出售= " & chkSale.Value & " and 出租= " & chkLend.Value
    strSQL = "SELECT * FROM 楼盘数据 WHERE " & strFilter
    '显示查询结果
    BuildingQueryResult.Adodc1.CommandType = adCmdText
    BuildingQueryResult.Adodc1.RecordSource = strSQL
    BuildingQueryResult.Adodc1.Refresh
    BuildingQueryResult.Show
End Sub

Private Sub cmdRefresh_Click()
    Adodc1.Refresh      '刷新控件的数据
End Sub
Private Sub cmdExit_Click()
    Unload Me               '关闭查询楼盘数据窗体
End Sub