www.pudn.com > jiudianguanli.rar > frmfangjianmohuchaxun.frm

VERSION 5.00 
Begin VB.Form frmfangjianmohuchaxun  
   BorderStyle     =   1  'Fixed Single 
   Caption         =   "按姓名查询" 
   ClientHeight    =   1470 
   ClientLeft      =   2505 
   ClientTop       =   3675 
   ClientWidth     =   4260 
   Icon            =   "frmfangjianmohuchaxun.frx":0000 
   LinkTopic       =   "Form1" 
   MaxButton       =   0   'False 
   MinButton       =   0   'False 
   ScaleHeight     =   1470 
   ScaleWidth      =   4260 
   Begin VB.CommandButton cmdnianling  
      Caption         =   "退出" 
      Height          =   375 
      Left            =   3120 
      TabIndex        =   3 
      Top             =   840 
      Width           =   975 
   End 
   Begin VB.CommandButton cmdchaxun  
      Caption         =   "查询" 
      Height          =   375 
      Left            =   1440 
      TabIndex        =   2 
      Top             =   840 
      Width           =   975 
   End 
   Begin VB.TextBox txtxingming  
      Height          =   375 
      Left            =   1440 
      TabIndex        =   1 
      Top             =   240 
      Width           =   2655 
   End 
   Begin VB.Label lblxingming  
      Caption         =   "客户姓名" 
      Height          =   375 
      Left            =   240 
      TabIndex        =   0 
      Top             =   240 
      Width           =   855 
   End 
End 
Attribute VB_Name = "frmfangjianmohuchaxun" 
Attribute VB_GlobalNameSpace = False 
Attribute VB_Creatable = False 
Attribute VB_PredeclaredId = True 
Attribute VB_Exposed = False 
Private Sub cmdchaxun_Click() 
    Dim cx As String 
    cx = Empty 
     
    
        If Trim(txtxingming.Text) <> Empty Then 
            cx = "(kehuname like '%" & Trim(txtxingming.Text) & " %')" 
        End If 
        If cx <> Empty Then 
            cx = "select * from kehudengji where" & cx 
        Else 
            cx = "select * from kehudengji" 
        End If 
        If querydata(cx) = True Then 
            Unload Me 
            frmmohujieguo.Show 
        
    End If 
End Sub 
 
Private Sub cmdnianling_Click() 
    Unload Me 
End Sub