cw_spcx.dfm

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

object Form51: TForm51
  Left = 237
  Top = 170
  Width = 690
  Height = 480
  BorderIcons = [biSystemMenu]
  Caption = #28040#36153#21450#25163#29260#26597#35810
  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 SpeedButton1: TSpeedButton
    Left = 636
    Top = 0
    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 Label3: TLabel
    Left = 280
    Top = 8
    Width = 119
    Height = 16
    AutoSize = False
    Caption = #28040#36153#21450#25163#29260#26597#35810
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = #23435#20307
    Font.Style = [fsBold]
    ParentFont = False
  end
  object GroupBox1: TGroupBox
    Left = 8
    Top = 32
    Width = 665
    Height = 73
    Caption = #25353#28040#36153#39033#30446#26597#35810
    TabOrder = 0
    object Label1: TLabel
      Left = 400
      Top = 20
      Width = 72
      Height = 12
      AutoSize = False
      Caption = #25353#28040#36153#39033#30446#65306
    end
    object Label2: TLabel
      Left = 411
      Top = 53
      Width = 60
      Height = 12
      Caption = #25353#25163#29260#21495#65306
    end
    object Label4: TLabel
      Left = 33
      Top = 24
      Width = 89
      Height = 13
      AutoSize = False
      Caption = #35831#36873#25321#26102#38388#65306#20174
    end
    object Label5: TLabel
      Left = 238
      Top = 22
      Width = 12
      Height = 12
      AutoSize = False
      Caption = #33267
    end
    object Label6: TLabel
      Left = 67
      Top = 48
      Width = 6
      Height = 12
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlue
      Font.Height = -12
      Font.Name = #23435#20307
      Font.Style = []
      ParentFont = False
    end
    object CB_menu: TComboBox
      Left = 470
      Top = 16
      Width = 113
      Height = 20
      Style = csDropDownList
      DropDownCount = 16
      ItemHeight = 12
      TabOrder = 0
    end
    object Button1: TButton
      Left = 592
      Top = 11
      Width = 67
      Height = 25
      Caption = #26597'  '#35810
      TabOrder = 1
      OnClick = Button1Click
    end
    object E_handno: TEdit
      Left = 470
      Top = 45
      Width = 110
      Height = 21
      TabOrder = 2
    end
    object Button2: TButton
      Left = 592
      Top = 42
      Width = 67
      Height = 25
      Caption = #26597'  '#35810
      TabOrder = 3
      OnClick = Button2Click
    end
    object rqq: TDateTimePicker
      Left = 122
      Top = 17
      Width = 111
      Height = 20
      CalAlignment = dtaLeft
      Date = 37625.3541666667
      Time = 37625.3541666667
      DateFormat = dfShort
      DateMode = dmComboBox
      Kind = dtkDate
      ParseInput = False
      TabOrder = 4
    end
    object rqh: TDateTimePicker
      Left = 255
      Top = 15
      Width = 111
      Height = 20
      CalAlignment = dtaLeft
      Date = 37625.3541666667
      Time = 37625.3541666667
      DateFormat = dfShort
      DateMode = dmComboBox
      Kind = dtkDate
      ParseInput = False
      TabOrder = 5
    end
  end
  object GroupBox3: TGroupBox
    Left = 8
    Top = 112
    Width = 665
    Height = 337
    TabOrder = 1
    object DBGrid1: TDBGrid
      Left = 6
      Top = 11
      Width = 651
      Height = 318
      DataSource = DS_zhangdan
      Options = [dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -12
      TitleFont.Name = #23435#20307
      TitleFont.Style = []
      Columns = <
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'AccountNo'
          Title.Alignment = taCenter
          Title.Caption = #21333#21495
          Width = 48
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'HandNo'
          Title.Alignment = taCenter
          Title.Caption = #25163#29260
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'MenuName'
          Title.Alignment = taCenter
          Title.Caption = #39033#30446#21517#31216
          Width = 101
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'SalePrice'
          Title.Alignment = taCenter
          Title.Caption = #21333#20215
          Width = 41
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Quantity'
          Title.Alignment = taCenter
          Title.Caption = #25968#37327
          Width = 47
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'Waiter'
          Title.Alignment = taCenter
          Title.Caption = #26381#21153#21592
          Width = 47
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'operator'
          Title.Alignment = taCenter
          Title.Caption = #30331#35760#20154
          Width = 51
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'BeginTime'
          Title.Alignment = taCenter
          Title.Caption = #30331#35760#26102#38388
          Width = 126
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'EndTime'
          Title.Alignment = taCenter
          Title.Caption = #32467#24080#26102#38388
          Width = 119
          Visible = True
        end>
    end
  end
  object T_snmenu: TTable
    DatabaseName = 'hotel'
    TableName = 'Sn_menu'
    Left = 464
    Top = 8
  end
  object Q_zhangdan: TQuery
    Active = True
    DatabaseName = 'hotel'
    SQL.Strings = (
      'select * from h_sn_dinlist')
    Left = 184
    Top = 16
  end
  object DS_zhangdan: TDataSource
    DataSet = Q_zhangdan
    Left = 216
    Top = 16
  end
end