findjh.frm

来自「一套VB完整的灯具销售管理系统设计」· FRM 代码 · 共 162 行

VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form FindJH 
   AutoRedraw      =   -1  'True
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "进货一览表"
   ClientHeight    =   4800
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   8055
   ClipControls    =   0   'False
   Icon            =   "FindJH.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   4800
   ScaleWidth      =   8055
   ShowInTaskbar   =   0   'False
   StartUpPosition =   3  'Windows Default
   Begin VB.Frame Frame1 
      Height          =   630
      Left            =   3330
      TabIndex        =   5
      Top             =   -15
      Width           =   4395
      Begin VB.TextBox Text1 
         Height          =   270
         Left            =   2130
         TabIndex        =   0
         Top             =   240
         Width           =   1935
      End
      Begin VB.Label Label2 
         AutoSize        =   -1  'True
         Caption         =   "请输入产品名查找："
         ForeColor       =   &H00800080&
         Height          =   180
         Left            =   315
         TabIndex        =   6
         Top             =   270
         Width           =   1620
      End
   End
   Begin VB.Data Data1 
      Caption         =   "Data1"
      Connect         =   "Access"
      DatabaseName    =   ""
      DefaultCursorType=   0  'DefaultCursor
      DefaultType     =   2  'UseODBC
      Exclusive       =   0   'False
      Height          =   285
      Left            =   -1155
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   ""
      Top             =   615
      Width           =   1140
   End
   Begin MSDBGrid.DBGrid DBGrid1 
      Bindings        =   "FindJH.frx":0442
      Height          =   4050
      Left            =   45
      OleObjectBlob   =   "FindJH.frx":0452
      TabIndex        =   1
      ToolTipText     =   "按鼠标右键返回！"
      Top             =   705
      Width           =   7965
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "进货产品一览"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   18
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000C0&
      Height          =   360
      Index           =   2
      Left            =   615
      TabIndex        =   4
      Top             =   150
      Width           =   2265
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "进货产品一览"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   18
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00FFFFFF&
      Height          =   360
      Index           =   0
      Left            =   630
      TabIndex        =   3
      Top             =   150
      Width           =   2265
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "进货产品一览"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   18
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00808080&
      Height          =   360
      Index           =   1
      Left            =   660
      TabIndex        =   2
      Top             =   150
      Width           =   2265
   End
End
Attribute VB_Name = "FindJH"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub DBGrid1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
If Button = 2 Then
  Unload Me
  Exit Sub
  End If
End Sub

Private Sub Form_Load()
FindJH.Left = (Screen.Width - FindJH.Width) / 2 + 130
FindJH.Top = (Screen.Height - FindJH.Height) / 2 + 190
Data1.DatabaseName = appData
Data1.RecordSource = "WZK"
Data1.Refresh
End Sub

Private Sub Text1_Change()
FStr = "品名 Like '*" & Trim(Text1.Text) & "*'"
FStr = "select 品名,单价,数量,总金额,经手人 from WZK where " & FStr
Data1.RecordSource = FStr
Data1.Refresh
End Sub