frmsum.dfm

蛮好的系统大家一起使用看看!~呵呵!关于图书仓库管理系统的!

    ControlType = xtCheck
    SparseRows = False
    SparseCols = False
    Left = 184
    DimensionCount = 3
    SummaryCount = 1
    CurrentSummary = 0
    SparseRows = False
    SparseCols = False
    DimensionInfo = (
      2
      0
      1
      0
      0
      1
      -1
      2
      0
      0
      1
      0
      1
      1
      0)
  end
  object DecisionCube1: TDecisionCube
    DataSet = DecisionQuery1
    DimensionMap = <
      item
        ActiveFlag = diAsNeeded
        FieldType = ftFloat
        Fieldname = 'outid'
        BaseName = 'outrecord.outid'
        Name = 'outid'
        DerivedFrom = -1
        DimensionType = dimDimension
        BinType = binNone
        ValueCount = 3
        Active = True
      end
      item
        ActiveFlag = diAsNeeded
        FieldType = ftFloat
        Fieldname = 'bookid'
        BaseName = 'outrecord.bookid'
        Name = 'bookid'
        DerivedFrom = -1
        DimensionType = dimDimension
        BinType = binNone
        ValueCount = 3
        Active = True
      end
      item
        ActiveFlag = diAsNeeded
        FieldType = ftFloat
        Fieldname = 'employeeid'
        BaseName = 'outrecord.employeeid'
        Name = 'employeeid'
        DerivedFrom = -1
        DimensionType = dimDimension
        BinType = binNone
        ValueCount = 3
        Active = True
      end
      item
        ActiveFlag = diAsNeeded
        FieldType = ftFloat
        Fieldname = 'SUM OF number2'
        BaseName = 'outrecord.number2'
        Name = 'SUM OF number2'
        DerivedFrom = -1
        DimensionType = dimSum
        BinType = binNone
        ValueCount = -1
        Active = True
      end>
    ShowProgressDialog = True
    MaxDimensions = 5
    MaxSummaries = 10
    MaxCells = 0
    Left = 136
  end
  object DecisionQuery1: TDecisionQuery
    DatabaseName = 'd:\'#22270#20070#20179#24211#31649#29702#31995#32479'\date'
    SQL.Strings = (
      
        'SELECT BOOKID '#22270#20070#32534#21495', EMPLOYEEID '#21592#24037#32534#21495', ID '#20379#24212#21830#32534#21495', INDATE '#20837#24211#26102#38388', SUM(' +
        ' NUMBER ) '#20837#24211#22270#20070#37327
      'FROM inrecord'
      'GROUP BY BOOKID, EMPLOYEEID, ID, INDATE')
    Left = 96
  end
  object DecisionSource2: TDecisionSource
    DecisionCube = DecisionCube2
    ControlType = xtCheck
    SparseRows = False
    SparseCols = False
    Left = 312
    DimensionCount = 4
    SummaryCount = 1
    CurrentSummary = 0
    SparseRows = False
    SparseCols = False
    DimensionInfo = (
      2
      0
      1
      0
      0
      1
      -1
      2
      0
      0
      1
      -1
      2
      1
      0
      1
      -1
      2
      2
      -1)
  end
  object DecisionCube2: TDecisionCube
    DataSet = DecisionQuery2
    DimensionMap = <
      item
        ActiveFlag = diAsNeeded
        FieldType = ftFloat
        Fieldname = 'inid'
        BaseName = 'inrecord.inid'
        Name = 'inid'
        DerivedFrom = -1
        DimensionType = dimDimension
        BinType = binNone
        ValueCount = 4
        Active = True
      end
      item
        ActiveFlag = diAsNeeded
        FieldType = ftFloat
        Fieldname = 'bookid'
        BaseName = 'inrecord.bookid'
        Name = 'bookid'
        DerivedFrom = -1
        DimensionType = dimDimension
        BinType = binNone
        ValueCount = 3
        Active = True
      end
      item
        ActiveFlag = diAsNeeded
        FieldType = ftFloat
        Fieldname = 'employeeid'
        BaseName = 'inrecord.employeeid'
        Name = 'employeeid'
        DerivedFrom = -1
        DimensionType = dimDimension
        BinType = binNone
        ValueCount = 3
        Active = True
      end
      item
        ActiveFlag = diAsNeeded
        FieldType = ftFloat
        Fieldname = 'id'
        BaseName = 'inrecord.id'
        Name = 'id'
        DerivedFrom = -1
        DimensionType = dimDimension
        BinType = binNone
        ValueCount = 4
        Active = True
      end
      item
        ActiveFlag = diAsNeeded
        FieldType = ftFloat
        Fieldname = 'SUM OF number'
        BaseName = 'inrecord.number'
        Name = 'SUM OF number'
        DerivedFrom = -1
        DimensionType = dimSum
        BinType = binNone
        ValueCount = -1
        Active = True
      end>
    ShowProgressDialog = True
    MaxDimensions = 5
    MaxSummaries = 10
    MaxCells = 0
    Left = 272
  end
  object DecisionQuery2: TDecisionQuery
    DatabaseName = 'd:\'#22270#20070#20179#24211#31649#29702#31995#32479'\date'
    SQL.Strings = (
      
        'SELECT BOOKID '#22270#20070#32534#21495', EMPLOYEEID '#21592#24037#32534#21495', OUTDATE '#20986#24211#26102#38388', GUESTID '#23458#25143#32534#21495',' +
        ' OUTTYPE '#20986#24211#31867#22411', SUM( NUMBER2 ) '#20986#24211#22270#20070#37327
      'FROM outrecord'
      'GROUP BY BOOKID, EMPLOYEEID, OUTDATE, GUESTID, OUTTYPE')
    Left = 232
  end
  object DecisionCube3: TDecisionCube
    DataSet = DecisionQuery3
    DimensionMap = <>
    ShowProgressDialog = True
    MaxDimensions = 5
    MaxSummaries = 10
    MaxCells = 0
    Left = 432
  end
  object DecisionCube4: TDecisionCube
    DataSet = DecisionQuery4
    DimensionMap = <>
    ShowProgressDialog = True
    MaxDimensions = 5
    MaxSummaries = 10
    MaxCells = 0
    Left = 536
  end
  object DecisionCube5: TDecisionCube
    DataSet = DecisionQuery5
    DimensionMap = <>
    ShowProgressDialog = True
    MaxDimensions = 5
    MaxSummaries = 10
    MaxCells = 0
    Left = 296
    Top = 136
  end
  object DecisionCube6: TDecisionCube
    DataSet = DecisionQuery6
    DimensionMap = <>
    ShowProgressDialog = True
    MaxDimensions = 5
    MaxSummaries = 10
    MaxCells = 0
    Left = 344
    Top = 304
  end
  object DecisionQuery3: TDecisionQuery
    DatabaseName = 'd:\'#22270#20070#20179#24211#31649#29702#31995#32479'\date'
    SQL.Strings = (
      'SELECT BOOKID '#22270#20070#32534#21495', SUM( NUMBER1 ) '#24211#23384#37327
      'FROM bookrecord'
      'GROUP BY BOOKID')
    Left = 360
  end
  object DecisionQuery4: TDecisionQuery
    DatabaseName = 'd:\'#22270#20070#20179#24211#31649#29702#31995#32479'\date'
    SQL.Strings = (
      'SELECT EMPLOYEEID '#21592#24037#32534#21495', COUNT( EMPLOYEEID ) '#21592#24037#24635#25968
      'FROM employee'
      'GROUP BY EMPLOYEEID')
    Left = 472
  end
  object DecisionQuery5: TDecisionQuery
    DatabaseName = 'd:\'#22270#20070#20179#24211#31649#29702#31995#32479'\date'
    SQL.Strings = (
      'SELECT GUESTID '#23458#25143#32534#21495', COUNT( GUESTID ) '#23458#25143#24635#25968
      'FROM "guest.DBF"'
      'GROUP BY GUESTID')
    Left = 192
    Top = 136
  end
  object DecisionQuery6: TDecisionQuery
    DatabaseName = 'd:\'#22270#20070#20179#24211#31649#29702#31995#32479'\date'
    SQL.Strings = (
      'SELECT ID '#20379#24212#21830#32534#21495', COUNT( ID ) '#20379#24212#21830#24635#25968
      'FROM "shopkeeper.DBF"'
      'GROUP BY ID')
    Left = 240
    Top = 304
  end
  object DecisionSource3: TDecisionSource
    DecisionCube = DecisionCube3
    ControlType = xtCheck
    SparseRows = False
    SparseCols = False
    Left = 400
    DimensionCount = 0
    SummaryCount = 0
    CurrentSummary = 0
    SparseRows = False
    SparseCols = False
    DimensionInfo = ()
  end
  object DecisionSource4: TDecisionSource
    DecisionCube = DecisionCube4
    ControlType = xtCheck
    SparseRows = False
    SparseCols = False
    Left = 504
    DimensionCount = 0
    SummaryCount = 0
    CurrentSummary = 0
    SparseRows = False
    SparseCols = False
    DimensionInfo = ()
  end
  object DecisionSource5: TDecisionSource
    DecisionCube = DecisionCube5
    ControlType = xtCheck
    SparseRows = False
    SparseCols = False
    Left = 240
    Top = 136
    DimensionCount = 0
    SummaryCount = 0
    CurrentSummary = 0
    SparseRows = False
    SparseCols = False
    DimensionInfo = ()
  end
  object DecisionSource6: TDecisionSource
    DecisionCube = DecisionCube6
    ControlType = xtCheck
    SparseRows = False
    SparseCols = False
    Left = 296
    Top = 304
    DimensionCount = 0
    SummaryCount = 0
    CurrentSummary = 0
    SparseRows = False
    SparseCols = False
    DimensionInfo = ()
  end
end