unit12.dfm

一个用DELPHI编的酒店管理系统。 其中数据库：SQL Server2000, 只需恢复 My database文件夹中 My database_Data.MDF和 My database_Log.

object Form12: TForm12
  Left = 249
  Top = 108
  Width = 696
  Height = 557
  Caption = #21830#21697#20837#24211#32426#24405
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -16
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  Position = poScreenCenter
  OnClose = FormClose
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 20
  object GroupBox1: TGroupBox
    Left = 16
    Top = 16
    Width = 649
    Height = 153
    Caption = #22635#20889#21830#21697#20837#24211#20449#24687
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = 'MS Sans Serif'
    Font.Style = []
    ParentFont = False
    TabOrder = 0
    object Label1: TLabel
      Left = 24
      Top = 40
      Width = 97
      Height = 20
      AutoSize = False
      Caption = #21830#21697#32534#21495#65306
    end
    object Label2: TLabel
      Left = 200
      Top = 40
      Width = 89
      Height = 20
      AutoSize = False
      Caption = #21830#21697#21517#31216#65306
    end
    object Label3: TLabel
      Left = 24
      Top = 80
      Width = 97
      Height = 20
      AutoSize = False
      Caption = #20837#24211#25968#37327#65306
    end
    object Label5: TLabel
      Left = 432
      Top = 80
      Width = 89
      Height = 20
      AutoSize = False
      Caption = #36827#36135#21333#20215#65306
    end
    object Label7: TLabel
      Left = 200
      Top = 80
      Width = 89
      Height = 20
      AutoSize = False
      Caption = #20837#24211#26085#26399#65306
    end
    object Label9: TLabel
      Left = 432
      Top = 40
      Width = 105
      Height = 20
      AutoSize = False
      Caption = #20379#24212#21830#32534#21495#65306
    end
    object goodsId: TEdit
      Left = 120
      Top = 32
      Width = 65
      Height = 28
      AutoSize = False
      TabOrder = 0
      Text = 'goodsId'
    end
    object innum: TEdit
      Left = 120
      Top = 72
      Width = 65
      Height = 28
      AutoSize = False
      TabOrder = 1
      Text = 'innum'
      OnExit = innumExit
    end
    object inprice: TEdit
      Left = 544
      Top = 72
      Width = 81
      Height = 28
      AutoSize = False
      TabOrder = 2
      Text = 'inprice'
      OnExit = inpriceExit
    end
    object indate: TDateTimePicker
      Left = 296
      Top = 72
      Width = 121
      Height = 28
      CalAlignment = dtaLeft
      Date = 38153.8697073843
      Time = 38153.8697073843
      DateFormat = dfShort
      DateMode = dmComboBox
      Kind = dtkDate
      ParseInput = False
      TabOrder = 3
    end
    object providerid: TEdit
      Left = 544
      Top = 32
      Width = 81
      Height = 28
      AutoSize = False
      TabOrder = 4
      Text = 'providerid'
    end
    object instorage: TButton
      Left = 448
      Top = 120
      Width = 75
      Height = 25
      Caption = #20837#24211
      TabOrder = 5
      OnClick = instorageClick
    end
    object exit: TButton
      Left = 544
      Top = 120
      Width = 75
      Height = 25
      Caption = #36864#20986
      TabOrder = 6
      OnClick = exitClick
    end
    object goodsname: TComboBox
      Left = 296
      Top = 32
      Width = 121
      Height = 28
      Style = csDropDownList
      ItemHeight = 20
      TabOrder = 7
      OnSelect = goodsnameSelect
    end
  end
  object DBGrid1: TDBGrid
    Left = 16
    Top = 176
    Width = 649
    Height = 337
    DataSource = DataSource1
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -16
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object goods: TTable
    Active = True
    DatabaseName = 'my database'
    TableName = 'dbo.goods'
    Left = 144
    Top = 136
  end
  object storage: TTable
    Active = True
    DatabaseName = 'My database'
    TableName = 'dbo.storage'
    Left = 192
    Top = 136
  end
  object Query1: TQuery
    Active = True
    DatabaseName = 'My database'
    SQL.Strings = (
      
        'select goods.'#21830#21697#32534#21495',goods.'#21830#21697#21517#31216',storage.'#36827#36135#21333#20215',storage.'#20379#24212#21830#32534#21495',storage.' +
        #20837#24211#25968#37327',storage.'#20837#24211#26085#26399' '
      'from goods,storage '
      'where goods.'#21830#21697#32534#21495'=storage.'#21830#21697#32534#21495)
    Left = 240
    Top = 136
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 96
    Top = 136
  end
end