tcyyxz.dfm

日昌餐饮管理系统是用Delphi7+SQL写的管理系统

object tcyyForm: TtcyyForm
  Left = 111
  Top = 120
  Width = 558
  Height = 380
  BorderIcons = []
  Caption = #23458#20154#36864#39184#21407#22240#36873#25321
  Color = clBtnFace
  Font.Charset = GB2312_CHARSET
  Font.Color = clWindowText
  Font.Height = -12
  Font.Name = #23435#20307
  Font.Style = []
  OldCreateOrder = False
  Position = poDesktopCenter
  OnActivate = FormActivate
  OnClose = FormClose
  PixelsPerInch = 96
  TextHeight = 12
  object Label1: TLabel
    Left = 66
    Top = 3
    Width = 84
    Height = 12
    Caption = #35831#36873#25321#36864#39184#21407#22240
    Font.Charset = GB2312_CHARSET
    Font.Color = clBlue
    Font.Height = -12
    Font.Name = #23435#20307
    Font.Style = []
    ParentFont = False
  end
  object Label2: TLabel
    Left = 88
    Top = 327
    Width = 36
    Height = 12
    Caption = #25209#20934#20154
  end
  object Label3: TLabel
    Left = 18
    Top = 327
    Width = 48
    Height = 16
    Caption = #35831#21047#21345
    Font.Charset = GB2312_CHARSET
    Font.Color = clBlue
    Font.Height = -16
    Font.Name = #23435#20307
    Font.Style = []
    ParentFont = False
  end
  object Label4: TLabel
    Left = 288
    Top = 8
    Width = 64
    Height = 16
    Caption = #24212#36864#36153#39069
    Font.Charset = GB2312_CHARSET
    Font.Color = clBlue
    Font.Height = -16
    Font.Name = #23435#20307
    Font.Style = []
    ParentFont = False
  end
  object Label5: TLabel
    Left = 384
    Top = 40
    Width = 24
    Height = 12
    Caption = #20854#20013
  end
  object CheckListBox1: TCheckListBox
    Left = 0
    Top = 20
    Width = 257
    Height = 141
    Font.Charset = GB2312_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = #23435#20307
    Font.Style = []
    ItemHeight = 16
    ParentFont = False
    TabOrder = 0
    OnClick = CheckListBox1Click
  end
  object BitBtn1: TBitBtn
    Left = 323
    Top = 311
    Width = 75
    Height = 41
    Caption = #30830#35748
    TabOrder = 1
    Kind = bkOK
  end
  object BitBtn2: TBitBtn
    Left = 411
    Top = 311
    Width = 75
    Height = 41
    Caption = #25918#24323
    TabOrder = 2
    Kind = bkCancel
  end
  object DBGrid2: TDBGrid
    Left = 8
    Top = 166
    Width = 249
    Height = 139
    Hint = #21452#20987#21024#38500#35813#35760#24405
    DataSource = DataSource2
    ParentShowHint = False
    ReadOnly = True
    ShowHint = True
    TabOrder = 3
    TitleFont.Charset = GB2312_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -12
    TitleFont.Name = #23435#20307
    TitleFont.Style = []
    OnDblClick = DBGrid2DblClick
    Columns = <
      item
        Expanded = False
        FieldName = 'djh'
        Title.Caption = #21333#25454#21495
        Width = 43
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'rq'
        Title.Caption = #26085#26399
        Width = 63
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'tcyymc'
        Title.Caption = #36864#39184#21407#22240
        Width = 105
        Visible = True
      end>
  end
  object Edit1: TEdit
    Left = 128
    Top = 322
    Width = 121
    Height = 20
    ReadOnly = True
    TabOrder = 4
  end
  object Edit2: TEdit
    Left = 358
    Top = 2
    Width = 121
    Height = 24
    Font.Charset = GB2312_CHARSET
    Font.Color = clRed
    Font.Height = -16
    Font.Name = #23435#20307
    Font.Style = []
    ParentFont = False
    TabOrder = 5
  end
  object DBGrid1: TDBGrid
    Left = 264
    Top = 56
    Width = 281
    Height = 249
    DataSource = DataSource1
    ReadOnly = True
    TabOrder = 6
    TitleFont.Charset = GB2312_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -12
    TitleFont.Name = #23435#20307
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = 'djh'
        Title.Caption = #21333#21495
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'fkfsmc'
        Title.Caption = #20184#27454#26041#24335
        Width = 94
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'fkje'
        Title.Caption = #37329#39069
        Width = 83
        Visible = True
      end>
  end
  object Query2: TQuery
    CachedUpdates = True
    DatabaseName = 'aa'
    SQL.Strings = (
      'SELECT *'
      'FROM tuicanwj Tuicanwj'
      'where djh=:cs and rq>=:cs1 and rq<=:cs2')
    UpdateObject = UpdateSQL1
    Left = 376
    Top = 136
    ParamData = <
      item
        DataType = ftString
        Name = 'cs'
        ParamType = ptUnknown
      end
      item
        DataType = ftDateTime
        Name = 'cs1'
        ParamType = ptUnknown
      end
      item
        DataType = ftDateTime
        Name = 'cs2'
        ParamType = ptUnknown
      end>
  end
  object UpdateSQL1: TUpdateSQL
    ModifySQL.Strings = (
      'update tuicanwj'
      'set'
      '  rq = :rq,'
      '  djh = :djh,'
      '  bh = :bh,'
      '  tcyybh = :tcyybh,'
      '  tcyymc = :tcyymc,'
      '  pzr = :pzr'
      'where'
      '  id = :OLD_id')
    InsertSQL.Strings = (
      'insert into tuicanwj'
      '  (rq, djh, bh, tcyybh, tcyymc, pzr)'
      'values'
      '  (:rq, :djh, :bh, :tcyybh, :tcyymc, :pzr)')
    DeleteSQL.Strings = (
      'delete from tuicanwj'
      'where'
      '  id = :OLD_id')
    Left = 408
    Top = 136
  end
  object DataSource2: TDataSource
    DataSet = Query2
    Left = 440
    Top = 136
  end
  object Query1: TQuery
    DatabaseName = 'aa'
    SQL.Strings = (
      'SELECT id, tcbh, tcmc'
      'FROM tcyy Tcyy')
    Left = 96
    Top = 40
  end
  object DataSource1: TDataSource
    DataSet = qtForm.fkwj
    Left = 336
    Top = 32
  end
end