cw_kcsn.~dfm

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

object Form23: TForm23
  Left = 192
  Top = 103
  Width = 696
  Height = 480
  BorderIcons = [biSystemMenu]
  Caption = #30424#28857#24211#23384'=='#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 = 280
    Top = 8
    Width = 81
    Height = 19
    AutoSize = False
    Caption = #30424#28857#24211#23384
    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 = 57
    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 splb: 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 Button1: TButton
      Left = 248
      Top = 16
      Width = 75
      Height = 25
      Caption = #26597'  '#35810
      TabOrder = 1
      OnClick = Button1Click
    end
  end
  object GroupBox2: TGroupBox
    Left = 360
    Top = 32
    Width = 321
    Height = 57
    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 = 96
    Width = 673
    Height = 345
    Caption = #26597#35810#32467#26524
    TabOrder = 2
    object DBGrid1: TDBGrid
      Left = 8
      Top = 16
      Width = 657
      Height = 281
      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 = 187
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'TypeName'
          Title.Alignment = taCenter
          Title.Caption = #31867#22411
          Width = 69
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'Unit'
          Title.Alignment = taCenter
          Title.Caption = #21333#20301
          Width = 50
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'InPrice'
          Title.Alignment = taCenter
          Title.Caption = #20837#24211#20215
          Width = 94
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'SalePrice'
          Title.Alignment = taCenter
          Title.Caption = #38144#21806#20215
          Width = 76
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'sl'
          Title.Alignment = taCenter
          Title.Caption = #24211#23384#25968#37327
          Width = 121
          Visible = True
        end>
    end
    object Button3: TButton
      Left = 136
      Top = 312
      Width = 75
      Height = 25
      Caption = #26174#31034#20840#37096
      TabOrder = 1
      OnClick = Button3Click
    end
    object Button5: TButton
      Left = 464
      Top = 312
      Width = 75
      Height = 25
      Caption = #36820'  '#22238
      TabOrder = 2
      OnClick = Button5Click
    end
  end
  object Q_splb: TQuery
    DatabaseName = 'Hotel'
    SQL.Strings = (
      'select * from sn_kucun order by MenuNo')
    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
  object Q_spmc: TQuery
    DatabaseName = 'Hotel'
    SQL.Strings = (
      'select * from sn_Menu where kc='#39#26159#39' order by MenuType,MenuNo')
    Left = 488
    Top = 8
  end
end