fangtaixiaofei.dfm

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

object Frmfangtaixiaofei: TFrmfangtaixiaofei
  Left = 268
  Top = 197
  Width = 419
  Height = 351
  BorderIcons = [biSystemMenu, biMinimize]
  Caption = #25151#21488#28040#36153
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  Position = poMainFormCenter
  OnClose = FormClose
  PixelsPerInch = 96
  TextHeight = 13
  object GroupBox1: TGroupBox
    Left = 5
    Top = 1
    Width = 396
    Height = 49
    Caption = #26597#35810#26102#27573
    TabOrder = 0
    object Label1: TLabel
      Left = 7
      Top = 22
      Width = 63
      Height = 13
      AutoSize = False
      Caption = #24320#22987#26085#26399#65306
      Transparent = True
    end
    object Label2: TLabel
      Left = 160
      Top = 22
      Width = 60
      Height = 13
      AutoSize = False
      Caption = #32467#26463#26085#26399#65306
      Transparent = True
    end
    object SpeedButton1: TSpeedButton
      Left = 326
      Top = 16
      Width = 56
      Height = 23
      Caption = #26597#35810
      Glyph.Data = {
        9A020000424D9A020000000000009A0100002800000010000000100000000100
        08000000000000010000120B0000120B0000590000005900000000000000FFFF
        FF00FF00FF00AB00AB008B008B0079017900FF03FF00FA2FFA00FA95FA00F75F
        F4003C133900D7B48C00C2A07200D7A56000E7961100EB9F2200D08A0A00C495
        4100D1921200E7CC6200F0DD8F00F3E39E00FFFFEE007D8F0A00748904001566
        0000146801000087000000830000008200000081000000740000006E0000006A
        000000690000005E0000004C0000004B0000004400000473040000510200018A
        0300038A0600046606004370440000530300025E050004910B0001760800067A
        0E00077F1200468C4D000A9E1A000C9E1D0012811E0014A628002A9A3A000DA1
        230019962D0021A737000AAA27000F8E2700209635001BA138002CD8510016B5
        3A0018B23C0019B8420025BD50002CC6550025CB580027CB59002BD15E0036DA
        67003AE76F0039E9720045F680004DFF880040D7760055D4810078C79E00005F
        4F0005817F003ACCCB0000C4CE000D9AA40036EBFF0038EDFF0000D8FF000202
        02020202022525020202020202020202020202022E4C1E250202020202020202
        020202022E4C1E250202020202020202020202022E4C1E250202020202020202
        020202022E4C1E250202020202020202020202022E4437250202020202020202
        0202022E4843392F250202020202020202022E4A4742352A1D25020202020202
        022E4D4B464134291C1B2502020202022E49453F3D32272122201F250202022E
        2B191A30385354523E3B3A3125022E23180F0E173C4F5658554E40503624022E
        0D1513102D28335751262C090A0202020B161412020202020202080603050202
        020C11020202020202020807040202020202020202020202020202080202}
      OnClick = SpeedButton1Click
    end
    object startdate: TDateTimePicker
      Left = 71
      Top = 18
      Width = 81
      Height = 21
      CalAlignment = dtaLeft
      Date = 38735.9359675116
      Time = 38735.9359675116
      DateFormat = dfShort
      DateMode = dmComboBox
      ImeName = #20013#25991' ('#31616#20307') - '#26497#28857#20013#25991
      Kind = dtkDate
      ParseInput = False
      TabOrder = 0
    end
    object enddate: TDateTimePicker
      Left = 218
      Top = 18
      Width = 97
      Height = 21
      CalAlignment = dtaLeft
      Date = 38735.936350544
      Time = 38735.936350544
      DateFormat = dfShort
      DateMode = dmComboBox
      ImeName = #20013#25991' ('#31616#20307') - '#26497#28857#20013#25991
      Kind = dtkDate
      ParseInput = False
      TabOrder = 1
    end
  end
  object GroupBox2: TGroupBox
    Left = 8
    Top = 56
    Width = 393
    Height = 257
    Caption = #25968#25454#21015#34920
    TabOrder = 1
    object DBGrid1: TDBGrid
      Left = 8
      Top = 16
      Width = 377
      Height = 233
      DataSource = DataSource1
      ImeName = #20013#25991' ('#31616#20307') - '#26497#28857#20013#25991
      Options = [dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'MS Sans Serif'
      TitleFont.Style = []
      Columns = <
        item
          Expanded = False
          FieldName = 'fangtaiid'
          Title.Alignment = taCenter
          Title.Caption = #25151#21488#32534#21495
          Width = 87
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'fangtainame'
          Title.Alignment = taCenter
          Title.Caption = #25151#21488#21517#31216
          Width = 153
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'heji'
          Title.Alignment = taCenter
          Title.Caption = #33853#21333#37329#39069
          Width = 103
          Visible = True
        end>
    end
  end
  object ADOQuery1: TADOQuery
    Connection = dm.conn
    AfterOpen = ADOQuery1AfterOpen
    ParamCheck = False
    Parameters = <>
    SQL.Strings = (
      
        'select a.fangtaiid,a.fangtainame,sum(b.caipincount*b.caipinprice' +
        ') as heji'
      'from Q_fangtai a,Q_customertemp b'
      'where a.fangtaiid=b.fangtaiid'
      'Group by a.fangtaiid,a.fangtainame')
    Left = 176
    Top = 48
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 224
    Top = 48
  end
end