data.dfm

工资管理系统

object dm: Tdm
  OldCreateOrder = False
  OnCreate = DataModuleCreate
  Left = 281
  Top = 198
  Height = 292
  Width = 360
  object ADOQuery1: TADOQuery
    Connection = ADOConnection1
    Parameters = <>
    Left = 16
    Top = 48
  end
  object ADOQuery2: TADOQuery
    Connection = ADOConnection1
    Parameters = <>
    SQL.Strings = (
      
        'SELECT '#24037#36164'.'#24037#21495' as '#24037#21495','#24037#36164'.'#22995#21517' as '#22995#21517','#37096#38376'.'#37096#38376#21517#31216' as '#37096#38376#21517#31216','#24037#36164'.'#24615#21035' as '#24615#21035','#24037#36164'.'#36523#20221 +
        #35777#21495#30721' as '#36523#20221#35777#21495#30721','#24037#36164'.'#38134#34892#24080#21495','#24037#36164'.'#22522#26412#24037#36164' as '#22522#26412#24037#36164','#24037#36164'.'#22870#37329' as  '#22870#37329','#24037#36164'.'#24212#25187'1 as '#24212#25187'1 ' +
        ','#24037#36164'.'#24212#25187'2 as '#24212#25187'2 ,'#24037#36164'.'#20445#38505' as '#20445#38505','#24037#36164'.'#24212#21457#24037#36164' as '#24212#21457#24037#36164','#24037#36164'.'#23454#21457#24037#36164' as '#23454#21457#24037#36164','#24037#36164'.'#21457 +
        #25918#26102#38388' as '#21457#25918#26102#38388' FROM '#24037#36164' INNER JOIN '#37096#38376' ON '#24037#36164'.'#37096#38376#32534#30721' = '#37096#38376'.'#37096#38376#32534#30721)
    Left = 24
    Top = 112
  end
  object ADOConnection1: TADOConnection
    LoginPrompt = False
    Provider = 'SQLOLEDB.1'
    Left = 216
    Top = 112
  end
  object ADODataSet1: TADODataSet
    Connection = ADOConnection1
    CursorType = ctStatic
    CommandText = 
      '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') '#13#10'   ' +
      '   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', '#13#10'      ' +
      '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') '#13#10'      A' +
      'S '#23454#21457#24635#25968#13#10'FROM '#24037#36164' INNER JOIN'#13#10'      '#37096#38376' ON '#24037#36164'.'#37096#38376#32534#30721' = '#37096#38376'.'#37096#38376#32534#30721#13#10'GROUP' +
      ' BY '#37096#38376'.'#37096#38376#21517#31216
    Parameters = <>
    Left = 112
    Top = 40
  end
end