cw_snin.~dfm

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

object Form20: TForm20
  Left = 211
  Top = 200
  Width = 696
  Height = 480
  BorderIcons = [biSystemMenu]
  Caption = 'Form20'
  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 = 280
    Top = 8
    Width = 120
    Height = 19
    AutoSize = False
    Caption = #21830#21697#20837#24211#26597#35810
    Font.Charset = ANSI_CHARSET
    Font.Color = clWindowText
    Font.Height = -19
    Font.Name = #23435#20307
    Font.Style = [fsBold]
    ParentFont = False
  end
  object GroupBox1: TGroupBox
    Left = 8
    Top = 32
    Width = 345
    Height = 49
    Caption = #20219#24847#31867#21035#26597#35810
    TabOrder = 0
    object Label2: TLabel
      Left = 16
      Top = 24
      Width = 57
      Height = 13
      AutoSize = False
      Caption = #31867#21035#21517#31216#65306
    end
    object Button1: TButton
      Left = 256
      Top = 16
      Width = 75
      Height = 25
      Caption = #26597'  '#35810
      TabOrder = 0
      OnClick = Button1Click
    end
    object splb: TComboBox
      Left = 72
      Top = 16
      Width = 145
      Height = 20
      Style = csDropDownList
      ImeName = #20013#25991' ('#31616#20307') - '#26234#33021' ABC'
      ItemHeight = 12
      TabOrder = 1
    end
  end
  object GroupBox2: TGroupBox
    Left = 368
    Top = 32
    Width = 313
    Height = 49
    Caption = #20219#24847#21830#21697#26597#35810
    TabOrder = 1
    object Label4: TLabel
      Left = 16
      Top = 24
      Width = 60
      Height = 13
      AutoSize = False
      Caption = #21830#21697#21517#31216#65306
    end
    object spmc: TComboBox
      Left = 72
      Top = 16
      Width = 145
      Height = 20
      Style = csDropDownList
      ImeName = #20013#25991' ('#31616#20307') - '#26234#33021' ABC'
      ItemHeight = 12
      TabOrder = 0
    end
    object Button2: TButton
      Left = 232
      Top = 16
      Width = 75
      Height = 25
      Caption = #26597'  '#35810
      TabOrder = 1
      OnClick = Button2Click
    end
  end
  object GroupBox3: TGroupBox
    Left = 8
    Top = 88
    Width = 673
    Height = 361
    BiDiMode = bdLeftToRight
    Caption = #26597#35810#32467#26524
    ParentBiDiMode = False
    TabOrder = 2
    object SpeedButton2: TSpeedButton
      Left = 104
      Top = 328
      Width = 81
      Height = 22
      Caption = #26174#31034#20840#37096
      OnClick = SpeedButton2Click
    end
    object SpeedButton3: TSpeedButton
      Left = 280
      Top = 328
      Width = 81
      Height = 22
      Caption = #25171#21360#25253#34920
      OnClick = SpeedButton3Click
    end
    object SpeedButton4: TSpeedButton
      Left = 456
      Top = 328
      Width = 81
      Height = 22
      Caption = #36820'  '#22238
      OnClick = SpeedButton4Click
    end
    object DBGrid1: TDBGrid
      Left = 8
      Top = 16
      Width = 657
      Height = 305
      DataSource = DataSource1
      ImeName = #20013#25991' ('#31616#20307') - '#26234#33021' ABC'
      Options = [dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      ReadOnly = True
      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 = 'MenuNo'
          Title.Alignment = taCenter
          Title.Caption = ' '#32534#21495
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'MenuName'
          Title.Alignment = taCenter
          Title.Caption = #21830#21697#21517#31216
          Width = 169
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'TypeName'
          Title.Alignment = taCenter
          Title.Caption = #31867#22411
          Width = 51
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'Unit'
          Title.Alignment = taCenter
          Title.Caption = #21333#20301
          Width = 41
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'InPrice'
          Title.Alignment = taCenter
          Title.Caption = #20837#24211#20215
          Width = 55
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'SalePrice'
          Title.Alignment = taCenter
          Title.Caption = #38144#21806#20215
          Width = 50
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'sl'
          Title.Alignment = taCenter
          Title.Caption = #25968#37327
          Width = 51
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'Operator'
          Title.Alignment = taCenter
          Title.Caption = #20837#24211#20154
          Width = 57
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'InTime'
          Title.Alignment = taCenter
          Title.Caption = #20837#24211#26102#38388
          Width = 115
          Visible = True
        end>
    end
  end
  object Q_spmc: TQuery
    DatabaseName = 'Hotel'
    SQL.Strings = (
      'select * from Menu where kc='#39#26159#39' order by MenuType,MenuNo')
    Left = 488
    Top = 8
  end
  object Q_splb: TQuery
    Active = True
    DatabaseName = 'Hotel'
    SQL.Strings = (
      'select * from sn_H_in order by MenuNo,Intime')
    Left = 104
    Top = 8
  end
  object DataSource1: TDataSource
    DataSet = Q_splb
    Left = 136
    Top = 8
  end
  object Q_lb: TQuery
    Active = True
    DatabaseName = 'Hotel'
    SQL.Strings = (
      'select * from Dtype ')
    Left = 192
    Top = 8
  end
end