cw_sntj.dfm

结于初学者来说这对数据库是一个很好的例子

object Form32: TForm32
  Left = 293
  Top = 83
  Width = 379
  Height = 261
  BorderIcons = [biSystemMenu]
  Caption = #32479#35745#25253#34920'=='#27927#28020
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -12
  Font.Name = #23435#20307
  Font.Style = []
  OldCreateOrder = False
  Position = poDesktopCenter
  Scaled = False
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 12
  object Label1: TLabel
    Left = 152
    Top = 16
    Width = 80
    Height = 19
    AutoSize = False
    Caption = #32479#35745#25253#34920
    Font.Charset = ANSI_CHARSET
    Font.Color = clWindowText
    Font.Height = -19
    Font.Name = #23435#20307
    Font.Style = [fsBold]
    ParentFont = False
  end
  object SpeedButton1: TSpeedButton
    Left = 296
    Top = 16
    Width = 33
    Height = 33
    Glyph.Data = {
      B60C0000424DB60C000000000000360000002800000021000000200000000100
      180000000000800C0000C40E0000C40E00000000000000000000C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C000C0C0
      C0C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0
      C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0C0C0C0000000000000000000
      C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C000C0C0C0C0C0C0C6C6C6C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0
      C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0000000FFFF
      00FFFF00000000C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C000C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0C0C0C0C6C6
      C6C6C6C6C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0C0C0C0C6C6C600
      0000FFFF00FFFF00848400000000C6C6C6C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6
      C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0
      C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0
      C0C0C0000000FFFF00FFFF00848400848400000000C0C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C6C6C6C6C6C6C0C0C000C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0
      C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0C0C0
      C0C6C6C6C6C6C6000000FFFF00FFFF00848400848400848400000000C0C0C0C6
      C6C6C6C6C6C0C0C0C0C0C0C0C0C0C0C0C000C6C6C6C0C0C0C0C0C0C0C0C0C6C6
      C6C6C6C6C0C0C0C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0C0C0C0C6C6C6C6
      C6C6C0C0C0C0C0C0C0C0C0000000FFFF00FFFF00848400848400848400848400
      000000C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C00000000000000000000000
      0000000000000000000000000000000000000000000000000000000000C0C0C0
      C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0000000FFFF00FFFF008484008484008484
      00848400848400000000000000000000000000000000C0C0C000C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C00000
      00C6C6C6C6C6C6C0C0C0C0C0C0C0C0C0C6C6C6000000FFFF00FFFF0084840084
      8400848400848400848400000000848484C6C6C6C0C0C0C0C0C0C0C0C000C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C0C0000000C0C0C0C0C0C0C6C6C6C6C6C6C0C0C0C0C0C0000000FFFF00FFFF00
      848400848400848400848400848400000000848484C6C6C6C0C0C0C0C0C0C0C0
      C000C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C6C6C6C0C0C0000000000000000000000000000000000000000000000000FFFF
      00FFFF00848400848400848400848400848400000000848484C6C6C6C0C0C0C0
      C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C0000000C6C6C6C6C6C600000084848484848484848484848484848484848400
      0000FFFF00FFFF00848400848400848400848400848400000000848484C6C6C6
      C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C0000000000000C6C6C6000000848484848484848484848484848484
      848484000000FFFF00FFFF008484008484008484008484008484000000008484
      84C6C6C6C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C00000008484000000000000008484848484848484848484
      84848484848484000000FFFF00FFFF0084840084840084840084840084840000
      0000848484C6C6C6C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C000000084840084840000000084848484848484
      8484848484848484848484000000FFFF00FFFF00848400000000000000848400
      848400000000848484C6C6C6C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0
      C0C0C6C6C6C6C6C6C6C6C6C6C6C6C6C6C6000000FFFF00848400848400000000
      848484848484848484848484848484000000FFFF00FFFF000000008484840000
      00848400848400000000848484C6C6C6C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0
      C0C0C0C6C6C6C6C6C6C6C6C6C6C6C6C6C6C6C6C6C6000000FFFF00FFFF008484
      00848400000000848484848484848484848484000000FFFF00FFFF00000000FF
      FFFF000000848400848400000000848484C6C6C6C0C0C0C0C0C0C0C0C000C0C0
      C0C0C0C0000000000000000000000000000000000000000000000000FFFF00FF
      FF00FFFF00848400848400000000848484848484848484000000FFFF00FFFF00
      848400000000000000848400848400000000848484C6C6C6C0C0C0C0C0C0C0C0
      C000C0C0C0000000848400848400848400848400848400848400848400848400
      FFFF00FFFF00FFFF00FFFF00848400848400000000848484848484000000FFFF
      00FFFF00848400848400848400848400848400000000848484C6C6C6C0C0C0C0
      C0C0C0C0C000C0C0C0000000FFFF00FFFF00FFFF00FFFF00FFFF00FFFF00FFFF
      00FFFF00FFFF00FFFF00FFFF00FFFF00FFFF0084840084840000000084848400
      0000FFFF00FFFF00848400848400848400848400848400000000848484C6C6C6
      C0C0C0C0C0C0C0C0C000C0C0C0000000FFFF00FFFF00FFFFFFFFFFFFFFFFFFFF
      FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF00FFFF00848400000000
      848484000000FFFF00FFFF008484008484008484008484008484000000008484
      84C6C6C6C0C0C0C0C0C0C0C0C000C0C0C0000000FFFF00FFFF00FFFF00FFFF00
      FFFF00FFFF00FFFF00FFFF00FFFF00FFFF00FFFFFFFFFF00FFFF008484000000
      00848484848484000000FFFF00FFFF0084840084840084840084840084840000
      0000848484C6C6C6C0C0C0C0C0C0C0C0C000C0C0C0C0C0C00000000000000000
      00000000000000000000000000000000FFFF00FFFFFFFFFF00FFFF0084840000
      0000848484848484848484000000FFFF00FFFF00848400848400848400848400
      848400000000848484C6C6C6C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0000000FFFF00FFFF00FFFF00848400
      000000848484848484848484848484000000FFFF00FFFF008484008484008484
      00848400848400000000848484C6C6C6C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0000000FFFF00FFFF008484
      00000000848484848484848484848484848484000000FFFF00FFFF0084840084
      8400848400848400848400000000848484C6C6C6C0C0C0C0C0C0C0C0C000C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0000000FFFF0084
      8400000000848484848484848484848484848484848484000000FFFF00FFFF00
      848400848400848400848400848400000000848484C6C6C6C0C0C0C0C0C0C0C0
      C000C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0000000
      8484000000000000008484848484848484848484848484848484848484840000
      00FFFF00FFFF00848400848400848400848400000000848484C6C6C6C0C0C0C0
      C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C0000000000000C0C0C000000084848484848484848484848484848484848484
      8484848484000000FFFF00FFFF00848400848400848400000000848484C6C6C6
      C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0000000848484848484848484848484848484
      848484848484848484848484000000FFFF00FFFF008484008484000000008484
      84C6C6C6C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C00000008484848484848484848484
      84848484848484848484848484848484848484000000FFFF00FFFF0084840000
      0000848484C6C6C6C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C000000084848484848484
      8484848484848484848484848484848484848484848484848484000000FFFF00
      FFFF00000000848484C0C0C0C0C0C0C0C0C0C0C0C000C0C0C0C0C0C0C0C0C0C0
      C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000C0C0C0C0C0C0C0C0C0C0C0C0C0C0C000}
    OnClick = SpeedButton1Click
  end
  object GroupBox1: TGroupBox
    Left = 32
    Top = 48
    Width = 305
    Height = 153
    TabOrder = 0
    object Label2: TLabel
      Left = 16
      Top = 32
      Width = 12
      Height = 12
      Caption = #20174
    end
    object Label3: TLabel
      Left = 160
      Top = 32
      Width = 12
      Height = 12
      Caption = #33267
    end
    object Button2: TButton
      Left = 80
      Top = 112
      Width = 145
      Height = 25
      Caption = #28040#36153#21830#21697#32479#35745#25253#34920#65288'A4'#65289
      Enabled = False
      TabOrder = 0
      OnClick = Button2Click
    end
    object Button3: TButton
      Left = 80
      Top = 64
      Width = 145
      Height = 25
      Caption = #32467#24080#24773#20917#32479#35745#25253#34920#65288'A4'#65289
      TabOrder = 1
      OnClick = Button3Click
    end
    object rqq: TDateTimePicker
      Left = 32
      Top = 24
      Width = 121
      Height = 20
      CalAlignment = dtaLeft
      Date = 37539.3541666667
      Time = 37539.3541666667
      DateFormat = dfShort
      DateMode = dmComboBox
      ImeName = #20013#25991' ('#31616#20307') - '#20840#25340
      Kind = dtkDate
      ParseInput = False
      TabOrder = 2
    end
    object rqh: TDateTimePicker
      Left = 176
      Top = 24
      Width = 121
      Height = 20
      CalAlignment = dtaLeft
      Date = 37539.3541666667
      Time = 37539.3541666667
      DateFormat = dfShort
      DateMode = dmComboBox
      ImeName = #20013#25991' ('#31616#20307') - '#20840#25340
      Kind = dtkDate
      ParseInput = False
      TabOrder = 3
    end
  end
  object Q_ckxf: TQuery
    DatabaseName = 'hotel'
    SQL.Strings = (
      
        'select * from h_sn_dinlist where menuname='#39#38376#31080#39' and quantity=-1 a' +
        'nd endtime between :aa and :bb')
    Left = 80
    Top = 8
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'aa'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'bb'
        ParamType = ptUnknown
      end>
  end
end