wagestat.dfm

工资管理系统

object frmwagestat: Tfrmwagestat
  Left = 170
  Top = 210
  Width = 491
  Height = 250
  Caption = #24037#36164#32479#35745
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object cxGrid1: TcxGrid
    Left = 0
    Top = 0
    Width = 483
    Height = 223
    Align = alClient
    PopupMenu = PopupMenu1
    TabOrder = 0
    object cxGrid1DBTableView1: TcxGridDBTableView
      DataController.DataSource = DataSource1
      DataController.Filter.Criteria = {FFFFFFFF0000000000}
      DataController.Summary.DefaultGroupSummaryItems = <>
      DataController.Summary.FooterSummaryItems = <>
      DataController.Summary.SummaryGroups = <>
      NavigatorButtons.ConfirmDelete = False
      object cxGrid1DBTableView1DBColumn: TcxGridDBColumn
        Visible = False
        GroupIndex = 0
        SortOrder = soAscending
        DataBinding.FieldName = #37096#38376#21517#31216
      end
      object cxGrid1DBTableView1DBColumn1: TcxGridDBColumn
        DataBinding.FieldName = #22522#26412#24037#36164#24635#25968
      end
      object cxGrid1DBTableView1DBColumn21: TcxGridDBColumn
        SortOrder = soAscending
        DataBinding.FieldName = #24212#25187'2'#24635#25968
      end
      object cxGrid1DBTableView1DBColumn2: TcxGridDBColumn
        DataBinding.FieldName = #22870#37329#24635#25968
      end
      object cxGrid1DBTableView1DBColumn11: TcxGridDBColumn
        DataBinding.FieldName = #24212#25187'1'#24635#25968
      end
      object cxGrid1DBTableView1DBColumn3: TcxGridDBColumn
        DataBinding.FieldName = #20445#38505#24635#25968
      end
      object cxGrid1DBTableView1DBColumn4: TcxGridDBColumn
        DataBinding.FieldName = #24212#21457#24635#25968
      end
      object cxGrid1DBTableView1DBColumn5: TcxGridDBColumn
        DataBinding.FieldName = #23454#21457#24635#25968
      end
    end
    object cxGrid1Level1: TcxGridLevel
      GridView = cxGrid1DBTableView1
    end
  end
  object DataSource1: TDataSource
    DataSet = dm.ADODataSet1
    Left = 48
    Top = 88
  end
  object PopupMenu1: TPopupMenu
    Left = 48
    Top = 120
    object N2: TMenuItem
      Caption = #25253#34920#39044#35272
      OnClick = N2Click
    end
    object N3: TMenuItem
      Caption = #25253#34920#35774#35745
      OnClick = N3Click
    end
    object N1: TMenuItem
      Caption = #21047#26032
      OnClick = N1Click
    end
  end
  object RMGridReport1: TRMGridReport
    InitialZoom = pzDefault
    PreviewButtons = [pbZoom, pbLoad, pbSave, pbPrint, pbFind, pbPageSetup, pbExit, pbSaveToXLS]
    DefaultCopies = 0
    DefaultCollate = False
    SaveReportOptions.RegistryPath = 'ReportMachine\ReportSettings\'
    Dataset = RMDBDataSet1
    Left = 264
    Top = 96
    ReportData = {}
  end
  object RMDBDataSet1: TRMDBDataSet
    DataSet = ADOQuery1
    CloseDataSet = True
    Left = 304
    Top = 80
  end
  object RMGridReportDesigner1: TRMGridReportDesigner
    DesignerRestrictions = []
    Left = 344
    Top = 96
  end
  object ADOQuery1: TADOQuery
    Connection = dm.ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'SELECT '#37096#38376'.'#37096#38376#21517#31216' AS '#37096#38376#21517#31216', SUM('#24037#36164'.'#22522#26412#24037#36164') AS '#22522#26412#24037#36164#24635#25968', SUM('#24037#36164'.'#22870#37329') '
      '      AS '#22870#37329#24635#25968', SUM('#24037#36164'.'#24212#25187'1) AS '#24212#25187'1'#24635#25968', SUM('#24037#36164'.'#24212#25187'2) AS '#24212#25187'2'#24635#25968', '
      '      SUM('#24037#36164'.'#20445#38505') AS '#20445#38505#24635#25968', SUM('#24037#36164'.'#24212#21457#24037#36164') AS '#24212#21457#24635#25968', SUM('#24037#36164'.'#23454#21457#24037#36164') '
      '      AS '#23454#21457#24635#25968
      'FROM '#24037#36164' INNER JOIN'
      '      '#37096#38376' ON '#24037#36164'.'#37096#38376#32534#30721' = '#37096#38376'.'#37096#38376#32534#30721
      'GROUP BY '#37096#38376'.'#37096#38376#21517#31216)
    Left = 336
    Top = 64
  end
end