salsumjia.dfm

pasa人力资源考勤管理系统

      DataType = dtDouble
      DisplayWidth = 19
      Position = 0
    end
    object ppBDEPipeline3ppField2: TppField
      Alignment = taRightJustify
      FieldAlias = 'facttech'
      FieldName = 'facttech'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 1
    end
    object ppBDEPipeline3ppField3: TppField
      Alignment = taRightJustify
      FieldAlias = 'mustgive'
      FieldName = 'mustgive'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 2
    end
    object ppBDEPipeline3ppField4: TppField
      Alignment = taRightJustify
      FieldAlias = 'mustdec'
      FieldName = 'mustdec'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 3
    end
    object ppBDEPipeline3ppField5: TppField
      Alignment = taRightJustify
      FieldAlias = 'factmoney'
      FieldName = 'factmoney'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 4
    end
    object ppBDEPipeline3ppField6: TppField
      Alignment = taRightJustify
      FieldAlias = 'factbasepay'
      FieldName = 'factbasepay'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 5
    end
    object ppBDEPipeline3ppField7: TppField
      Alignment = taRightJustify
      FieldAlias = 'factdays'
      FieldName = 'factdays'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 6
    end
    object ppBDEPipeline3ppField8: TppField
      Alignment = taRightJustify
      FieldAlias = 'yearmoney'
      FieldName = 'yearmoney'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 7
    end
    object ppBDEPipeline3ppField9: TppField
      Alignment = taRightJustify
      FieldAlias = 'smoney'
      FieldName = 'smoney'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 8
    end
    object ppBDEPipeline3ppField10: TppField
      Alignment = taRightJustify
      FieldAlias = 'otmoney'
      FieldName = 'otmoney'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 9
    end
    object ppBDEPipeline3ppField11: TppField
      Alignment = taRightJustify
      FieldAlias = 'eightornine'
      FieldName = 'eightornine'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 10
    end
    object ppBDEPipeline3ppField12: TppField
      Alignment = taRightJustify
      FieldAlias = 'latedec'
      FieldName = 'latedec'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 11
    end
    object ppBDEPipeline3ppField13: TppField
      Alignment = taRightJustify
      FieldAlias = 'kuanggongdec'
      FieldName = 'kuanggongdec'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 12
    end
    object ppBDEPipeline3ppField14: TppField
      Alignment = taRightJustify
      FieldAlias = 'otherdec'
      FieldName = 'otherdec'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 25
      Position = 13
    end
    object ppBDEPipeline3ppField15: TppField
      Alignment = taRightJustify
      FieldAlias = 'otheradd'
      FieldName = 'otheradd'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 28
      Position = 14
    end
    object ppBDEPipeline3ppField16: TppField
      FieldAlias = 'deptname'
      FieldName = 'deptname'
      FieldLength = 30
      DisplayWidth = 30
      Position = 15
    end
    object ppBDEPipeline3ppField17: TppField
      Alignment = taRightJustify
      FieldAlias = 'otjieri'
      FieldName = 'otjieri'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 16
    end
    object ppBDEPipeline3ppField18: TppField
      Alignment = taRightJustify
      FieldAlias = 'othours'
      FieldName = 'othours'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 17
    end
    object ppBDEPipeline3ppField19: TppField
      Alignment = taRightJustify
      FieldAlias = 'otjiari'
      FieldName = 'otjiari'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 18
    end
    object ppBDEPipeline3ppField20: TppField
      Alignment = taRightJustify
      FieldAlias = 'facthours'
      FieldName = 'facthours'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 19
    end
    object ppBDEPipeline3ppField21: TppField
      Alignment = taRightJustify
      FieldAlias = 'noname55'
      FieldName = 'noname55'
      FieldLength = 2
      DataType = dtDouble
      DisplayWidth = 19
      Position = 20
    end
  end
  object DataSource3: TDataSource
    DataSet = ADODataSet5
    Left = 32
    Top = 32
  end
  object ADODataSet5: TADODataSet
    Active = True
    Connection = DataMod.Database1
    CursorType = ctStatic
    CommandText = 
      'select  deptname,sum(isnull(otjieri,0)) otjieri,sum(isnull(yearm' +
      'oney,0)) yearmoney,sum(isnull(othours,0)) othours,sum(isnull(otm' +
      'oney,0)) otmoney,sum(isnull(otjiari,0)) otjiari,sum(isnull(smone' +
      'y,0)) smoney,sum(isnull(factbasepay,0)) factbasepay,sum(isnull(f' +
      'actdays,0)) factdays,sum(isnull(facthours,0)) facthours,'#13#10'sum(is' +
      'null(noname55,0)) noname55,sum(isnull(insurance,0)) insurance,su' +
      'm(isnull(facttech,0)) facttech,sum(isnull(mustgive,0)) mustgive,' +
      'sum(isnull(mustdec,0)) mustdec,sum(isnull(factmoney,0)) factmone' +
      'y,sum(isnull(eightornine,0)) eightornine,sum(isnull(latedec,0)) ' +
      'latedec,sum(isnull(kuanggongdec,0)) kuanggongdec ,sum(isnull(mus' +
      'tdec,0)-isnull(insurance,0)-isnull(medmoney,0)-isnull(latedec,0)' +
      '-isnull(kuanggongdec,0)) otherdec, sum(isnull(mustgive,0)-isnull' +
      '(factbasepay,0)-isnull(otmoney,0)-isnull(yearmoney,0)-isnull(smo' +
      'ney,0)-isnull(noname55,0)) otheradd '#13#10'from sal21010 group by dep' +
      'tname'#13#10
    CommandTimeout = 0
    Parameters = <>
    Left = 56
    Top = 8
    object BCDField1: TBCDField
      DisplayLabel = '夜宵'
      FieldName = 'insurance'
      Precision = 18
      Size = 2
    end
    object BCDField2: TBCDField
      DisplayLabel = '主管津贴'
      FieldName = 'facttech'
      Precision = 18
      Size = 2
    end
    object BCDField3: TBCDField
      DisplayLabel = '应发工资'
      FieldName = 'mustgive'
      Precision = 18
      Size = 2
    end
    object BCDField4: TBCDField
      DisplayLabel = '扣款合计'
      FieldName = 'mustdec'
      Precision = 18
      Size = 2
    end
    object BCDField5: TBCDField
      DisplayLabel = '实发薪资'
      FieldName = 'factmoney'
      Precision = 18
      Size = 2
    end
    object BCDField6: TBCDField
      DisplayLabel = '本薪'
      FieldName = 'factbasepay'
      Precision = 18
      Size = 2
    end
    object BCDField7: TBCDField
      DisplayLabel = '实出勤天'
      FieldName = 'factdays'
      Precision = 18
      Size = 2
    end
    object BCDField8: TBCDField
      DisplayLabel = '节日加班费'
      FieldName = 'yearmoney'
      Precision = 18
      Size = 2
    end
    object BCDField9: TBCDField
      DisplayLabel = '假日加班费'
      FieldName = 'smoney'
      Precision = 18
      Size = 2
    end
    object BCDField10: TBCDField
      DisplayLabel = '平时加班费'
      FieldName = 'otmoney'
      Precision = 18
      Size = 2
    end
    object IntegerField1: TIntegerField
      DisplayLabel = '税金'
      FieldName = 'eightornine'
    end
    object BCDField11: TBCDField
      DisplayLabel = '迟到扣款'
      FieldName = 'latedec'
      Precision = 18
      Size = 2
    end
    object BCDField12: TBCDField
      DisplayLabel = '旷工扣款'
      FieldName = 'kuanggongdec'
      Precision = 18
      Size = 2
    end
    object BCDField13: TBCDField
      DisplayLabel = '其它扣款'
      FieldName = 'otherdec'
      ReadOnly = True
      Precision = 24
      Size = 2
    end
    object BCDField14: TBCDField
      DisplayLabel = '其它津贴'
      FieldName = 'otheradd'
      ReadOnly = True
      Precision = 27
      Size = 2
    end
    object StringField4: TStringField
      DisplayLabel = '部门'
      FieldName = 'deptname'
      Size = 30
    end
    object BCDField15: TBCDField
      DisplayLabel = '节日加班工时'
      FieldName = 'otjieri'
      Precision = 18
      Size = 2
    end
    object BCDField16: TBCDField
      DisplayLabel = '平时加班工时'
      FieldName = 'othours'
      Precision = 18
      Size = 2
    end
    object BCDField17: TBCDField
      DisplayLabel = '假日加班工时'
      FieldName = 'otjiari'
      Precision = 18
      Size = 2
    end
    object BCDField18: TBCDField
      DisplayLabel = '出勤工时'
      FieldName = 'facthours'
      Precision = 18
      Size = 2
    end
    object BCDField19: TBCDField
      DisplayLabel = '综合奖'
      FieldName = 'noname55'
      Precision = 18
      Size = 2
    end
  end
  object ppReport4: TppReport
    AutoStop = False
    DataPipeline = ppBDEPipeline3
    PassSetting = psTwoPass
    PrinterSetup.BinName = 'Default'
    PrinterSetup.DocumentName = 'Report'
    PrinterSetup.Orientation = poLandscape
    PrinterSetup.PaperName = 'Letter Transverse'
    PrinterSetup.PrinterName = 'Default'
    PrinterSetup.mmMarginBottom = 6350
    PrinterSetup.mmMarginLeft = 6350
    PrinterSetup.mmMarginRight = 6350
    PrinterSetup.mmMarginTop = 6350
    PrinterSetup.mmPaperHeight = 215900
    PrinterSetup.mmPaperWidth = 279401
    PrinterSetup.PaperSize = 54
    BeforePrint = ppReport4BeforePrint
    DeviceType = 'Screen'
    OnPreviewFormCreate = ppReport4PreviewFormCreate
    Left = 88
    Top = 32
    Version = '5.56'
    mmColumnWidth = 0
    object ppHeaderBand1: TppHeaderBand
      mmBottomOffset = 0
      mmHeight = 31485
      mmPrintPosition = 0
      object ppLabel19: TppLabel
        UserName = 'Label315'
        Caption = '公司名'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 18
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        mmHeight = 7144
        mmLeft = 123561
        mmTop = 0
        mmWidth = 19579
        BandType = 0
      end
      object ppLabel20: TppLabel
        UserName = 'Label350'
        Caption = '制表人'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        mmHeight = 3704
        mmLeft = 234950
        mmTop = 0
        mmWidth = 9525
        BandType = 0
      end
      object ppLabel21: TppLabel
        UserName = 'Label351'
        Caption = '制表日期'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        mmHeight = 3704
        mmLeft = 234950
        mmTop = 4498
        mmWidth = 12965
        BandType = 0
      end
      object ppLabel22: TppLabel
        UserName = 'Label352'
        Caption = '页次'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        mmHeight = 3704
        mmLeft = 234950
        mmTop = 9525
        mmWidth = 6350
        BandType = 0
      end
      object ppLabel23: TppLabel
        UserName = 'Label353'
        Caption = 'Label353'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        mmHeight = 3704
        mmLeft = 248973
        mmTop = 0
        mmWidth = 13229
        BandType = 0
      end
      object ppSystemVariable1: TppSystemVariable
        UserName = 'SystemVariable7'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        mmHeight = 3704
        mmLeft = 248973
        mmTop = 4498
        mmWidth = 15875
        BandType = 0
      end
      object ppSystemVariable2: TppSystemVariable
        UserName = 'SystemVariable8'
        VarType = vtPageSetDesc
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        mmHeight = 3704
        mmLeft = 248973
        mmTop = 9260
        mmWidth = 16404
        BandType = 0
      end
      object ppLabel24: TppLabel
        UserName = 'Label1'
        Caption = '月份'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 12
        Font.Style = []
        TextAlignment = taCentered
        Transparent = T