caipingroup.dfm

小管理程序主要管理的小咖啡厅我是从网上下的经测试可用

object Frmcaipingroup: TFrmcaipingroup
  Left = 231
  Top = 139
  Width = 746
  Height = 478
  BorderIcons = [biSystemMenu, biMinimize]
  Caption = #22871#39184#31649#29702
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  Position = poDesktopCenter
  OnClose = FormClose
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object SpeedButton1: TSpeedButton
    Left = 72
    Top = 392
    Width = 81
    Height = 38
    Caption = #20445'   '#23384
    OnClick = SpeedButton1Click
  end
  object SpeedButton2: TSpeedButton
    Left = 296
    Top = 392
    Width = 81
    Height = 38
    Caption = #21462'    '#28040
    OnClick = SpeedButton2Click
  end
  object GroupBox2: TGroupBox
    Left = 5
    Top = 8
    Width = 476
    Height = 321
    Caption = #25152#36873#33756#21697#21015#34920
    TabOrder = 0
    object DBGridTemp: TDBGrid
      Left = 3
      Top = 16
      Width = 471
      Height = 297
      DataSource = caipintempDataSource
      ImeName = #20013#25991' ('#31616#20307') - '#26497#28857#20013#25991
      Options = [dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      PopupMenu = PopupMenu1
      ReadOnly = True
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'MS Sans Serif'
      TitleFont.Style = []
      Columns = <
        item
          Expanded = False
          FieldName = 'caipinid'
          Title.Alignment = taCenter
          Title.Caption = #32534#21495
          Width = 60
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'caipinname'
          Title.Alignment = taCenter
          Title.Caption = #33756#21697#21517#31216
          Width = 112
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'caipincount'
          Title.Alignment = taCenter
          Title.Caption = #25968#37327
          Width = 51
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'caipinunit'
          Title.Alignment = taCenter
          Title.Caption = #21333#20301
          Width = 62
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'caipinprice'
          Title.Alignment = taCenter
          Title.Caption = #20215#26684
          Width = 80
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'caipinleipie'
          Title.Alignment = taCenter
          Title.Caption = #22871#39184#32534#21495
          Width = 79
          Visible = True
        end>
    end
  end
  object GroupBox3: TGroupBox
    Left = 485
    Top = 8
    Width = 250
    Height = 433
    Caption = #33756#21697#21015#34920
    TabOrder = 1
    object BtnListAll: TSpeedButton
      Left = 204
      Top = 403
      Width = 41
      Height = 26
      Caption = #21015' '#34920
      Flat = True
      OnClick = BtnListAllClick
    end
    object DBGridCaiPin: TDBGrid
      Left = 2
      Top = 120
      Width = 246
      Height = 281
      DataSource = QueryCaiPinDataSource
      ImeName = #20013#25991' ('#31616#20307') - '#26497#28857#20013#25991
      Options = [dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      ReadOnly = True
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'MS Sans Serif'
      TitleFont.Style = []
      OnDblClick = DBGridCaiPinDblClick
      Columns = <
        item
          Expanded = False
          FieldName = 'Caipinid'
          Title.Alignment = taCenter
          Title.Caption = #32534#21495
          Width = 60
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'caipinname'
          Title.Alignment = taCenter
          Title.Caption = #33756#21697#21517#31216
          Width = 110
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'caipinprice'
          Title.Alignment = taCenter
          Title.Caption = #21333#20215
          Width = 60
          Visible = True
        end>
    end
    object DBGridFenLei: TDBGrid
      Left = 3
      Top = 15
      Width = 244
      Height = 102
      DataSource = QueryFenLeiDataSource
      ImeName = #20013#25991' ('#31616#20307') - '#26497#28857#20013#25991
      Options = [dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      ReadOnly = True
      TabOrder = 1
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'MS Sans Serif'
      TitleFont.Style = []
      OnCellClick = DBGridFenLeiCellClick
      Columns = <
        item
          Expanded = False
          FieldName = 'chclassid'
          Title.Alignment = taCenter
          Title.Caption = #20998#31867#32534#21495
          Width = 80
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Chclass_name'
          Title.Alignment = taCenter
          Title.Caption = #33756#21697#20998#31867
          Width = 130
          Visible = True
        end>
    end
    object Edqueryma: TEdit
      Left = 2
      Top = 404
      Width = 194
      Height = 24
      CharCase = ecUpperCase
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -16
      Font.Name = #23435#20307
      Font.Style = []
      ImeName = #20013#25991' ('#31616#20307') - '#26497#28857#20013#25991
      ParentFont = False
      TabOrder = 2
      OnKeyPress = EdquerymaKeyPress
    end
  end
  object GroupBox4: TGroupBox
    Left = 5
    Top = 331
    Width = 476
    Height = 46
    Caption = #33756#21697#35814#24773
    TabOrder = 2
    object Label2: TLabel
      Left = 8
      Top = 23
      Width = 60
      Height = 12
      AutoSize = False
      Caption = #33756#21697#21517#31216#65306
      Transparent = True
    end
    object Label6: TLabel
      Left = 178
      Top = 23
      Width = 36
      Height = 12
      AutoSize = False
      Caption = #25968#37327#65306
      Transparent = True
    end
    object Label7: TLabel
      Left = 274
      Top = 23
      Width = 36
      Height = 12
      AutoSize = False
      Caption = #21333#20215#65306
      Transparent = True
    end
    object Label8: TLabel
      Left = 365
      Top = 22
      Width = 37
      Height = 12
      AutoSize = False
      Caption = #21512#35745#65306
      Transparent = True
    end
    object DBEdit1: TDBEdit
      Left = 66
      Top = 18
      Width = 109
      Height = 21
      DataField = 'caipinname'
      DataSource = caipintempDataSource
      ImeName = #20013#25991' ('#31616#20307') - '#26497#28857#20013#25991
      ReadOnly = True
      TabOrder = 0
    end
    object DBEdit2: TDBEdit
      Left = 212
      Top = 18
      Width = 58
      Height = 21
      DataField = 'caipincount'
      DataSource = caipintempDataSource
      ImeName = #20013#25991' ('#31616#20307') - '#26497#28857#20013#25991
      TabOrder = 1
    end
    object DBEdit3: TDBEdit
      Left = 309
      Top = 18
      Width = 54
      Height = 21
      DataField = 'caipinprice'
      DataSource = caipintempDataSource
      ImeName = #20013#25991' ('#31616#20307') - '#26497#28857#20013#25991
      TabOrder = 2
    end
    object DBEdit4: TDBEdit
      Left = 399
      Top = 16
      Width = 72
      Height = 21
      DataField = 'caipinheji'
      DataSource = caipintempDataSource
      ImeName = #20013#25991' ('#31616#20307') - '#26497#28857#20013#25991
      ReadOnly = True
      TabOrder = 3
    end
  end
  object caipintemp: TClientDataSet
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'caipinid'
        DataType = ftInteger
      end
      item
        Name = 'caipinname'
        DataType = ftString
        Size = 20
      end
      item
        Name = 'caipincount'
        DataType = ftInteger
      end
      item
        Name = 'caipinunit'
        DataType = ftString
        Size = 20
      end
      item
        Name = 'caipinprice'
        DataType = ftCurrency
      end
      item
        Name = 'caipinleipie'
        DataType = ftString
        Size = 20
      end>
    IndexDefs = <>
    Params = <>
    StoreDefs = True
    OnCalcFields = caipintempCalcFields
    Left = 328
    Top = 136
    object caipintempcaipinid: TIntegerField
      FieldName = 'caipinid'
    end
    object caipintempcaipinname: TStringField
      FieldName = 'caipinname'
    end
    object caipintempcaipincount: TIntegerField
      FieldName = 'caipincount'
    end
    object caipintempcaipinunit: TStringField
      FieldName = 'caipinunit'
    end
    object caipintempcaipinprice: TCurrencyField
      FieldName = 'caipinprice'
    end
    object caipintempcaipinleipie: TStringField
      FieldName = 'caipinleipie'
    end
    object caipintempcaipinheji: TCurrencyField
      FieldKind = fkCalculated
      FieldName = 'caipinheji'
      Calculated = True
    end
  end
  object caipintempDataSource: TDataSource
    DataSet = caipintemp
    Left = 264
    Top = 136
  end
  object QueryFenLei: TADOQuery
    Connection = dm.conn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from Q_childclass'
      'where isdel=0')
    Left = 552
    Top = 82
  end
  object QueryFenLeiDataSource: TDataSource
    DataSet = QueryFenLei
    Left = 592
    Top = 83
  end
  object QueryCaiPin: TADOQuery
    Connection = dm.conn
    AfterOpen = QueryCaiPinAfterOpen
    Parameters = <>
    SQL.Strings = (
      'select * from Q_caipin where isdel=0')
    Left = 576
    Top = 288
  end
  object QueryCaiPinDataSource: TDataSource
    DataSet = QueryCaiPin
    Left = 616
    Top = 288
  end
  object PopupMenu1: TPopupMenu
    AutoHotkeys = maManual
    Left = 168
    Top = 112
    object N1: TMenuItem
      Tag = 1
      Caption = #21024#38500#25152#36873
      OnClick = N1Click
    end
  end
  object SaveQuery: TADOQuery
    Connection = dm.conn
    Parameters = <>
    Left = 224
    Top = 200
  end
end