laterleaveearlydailyreport.dfm

用户名：SYSTEM 密码：空 第一次运行请先恢复数据库 DATABASE 到SQL服务器

        mmHeight = 3387
        mmLeft = 6879
        mmTop = 1058
        mmWidth = 12065
        BandType = 8
      end
      object ppSystemVariable1: TppSystemVariable
        UserName = 'SystemVariable1'
        VarType = vtDateTime
        DisplayFormat = 'yyyy/mm/dd hh:mm:ss'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = #26032#32048#26126#39636
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3440
        mmLeft = 19579
        mmTop = 1058
        mmWidth = 34660
        BandType = 8
      end
    end
    object ppSummaryBand1: TppSummaryBand
      mmBottomOffset = 0
      mmHeight = 7144
      mmPrintPosition = 0
      object ppLabel24: TppLabel
        UserName = 'Label24'
        Caption = #32317#35336':'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4022
        mmLeft = 158486
        mmTop = 1323
        mmWidth = 8086
        BandType = 7
      end
      object ppDBCalc2: TppDBCalc
        UserName = 'DBCalc2'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        DBCalcType = dcCount
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3969
        mmLeft = 167482
        mmTop = 1323
        mmWidth = 12965
        BandType = 7
      end
      object ppLabel25: TppLabel
        UserName = 'Label25'
        Caption = #20154
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3969
        mmLeft = 181240
        mmTop = 1323
        mmWidth = 3440
        BandType = 7
      end
      object ppLine31: TppLine
        UserName = 'Line25'
        Weight = 0.75
        mmHeight = 2117
        mmLeft = 114036
        mmTop = 794
        mmWidth = 75142
        BandType = 7
      end
    end
    object ppGroup1: TppGroup
      BreakName = 'cDepartmentName'
      DataPipeline = ppDBPipeline1
      NewPage = True
      UserName = 'Group1'
      mmNewColumnThreshold = 0
      mmNewPageThreshold = 0
      DataPipelineName = 'ppDBPipeline1'
      object ppGroupHeaderBand1: TppGroupHeaderBand
        mmBottomOffset = 0
        mmHeight = 0
        mmPrintPosition = 0
      end
      object ppGroupFooterBand1: TppGroupFooterBand
        mmBottomOffset = 0
        mmHeight = 6879
        mmPrintPosition = 0
        object ppLabel22: TppLabel
          UserName = 'Label22'
          Caption = #23567#35336':'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 10
          Font.Style = []
          Transparent = True
          mmHeight = 3969
          mmLeft = 158486
          mmTop = 1058
          mmWidth = 8202
          BandType = 5
          GroupNo = 0
        end
        object ppDBCalc1: TppDBCalc
          UserName = 'DBCalc1'
          DataPipeline = ppDBPipeline1
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 10
          Font.Style = []
          ResetGroup = ppGroup1
          TextAlignment = taCentered
          Transparent = True
          DBCalcType = dcCount
          DataPipelineName = 'ppDBPipeline1'
          mmHeight = 3969
          mmLeft = 167482
          mmTop = 1058
          mmWidth = 12965
          BandType = 5
          GroupNo = 0
        end
        object ppLabel23: TppLabel
          UserName = 'Label23'
          Caption = #20154
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 10
          Font.Style = []
          Transparent = True
          mmHeight = 3969
          mmLeft = 181240
          mmTop = 1058
          mmWidth = 3440
          BandType = 5
          GroupNo = 0
        end
      end
    end
  end
  object ppDBPipeline1: TppDBPipeline
    DataSource = DataSource1
    UserName = 'DBPipeline1'
    Left = 216
    Top = 168
    object ppDBPipeline1ppField1: TppField
      FieldAlias = 'dDate'
      FieldName = 'dDate'
      FieldLength = 0
      DataType = dtDateTime
      DisplayWidth = 18
      Position = 0
    end
    object ppDBPipeline1ppField2: TppField
      FieldAlias = 'cWorkerNo'
      FieldName = 'cWorkerNo'
      FieldLength = 8
      DisplayWidth = 8
      Position = 1
    end
    object ppDBPipeline1ppField3: TppField
      FieldAlias = 'cWorkerName'
      FieldName = 'cWorkerName'
      FieldLength = 8
      DisplayWidth = 8
      Position = 2
    end
    object ppDBPipeline1ppField4: TppField
      FieldAlias = 'cDepartmentNo'
      FieldName = 'cDepartmentNo'
      FieldLength = 10
      DisplayWidth = 10
      Position = 3
    end
    object ppDBPipeline1ppField5: TppField
      FieldAlias = 'cDepartmentName'
      FieldName = 'cDepartmentName'
      FieldLength = 30
      DisplayWidth = 30
      Position = 4
    end
    object ppDBPipeline1ppField6: TppField
      FieldAlias = 'cClassNo'
      FieldName = 'cClassNo'
      FieldLength = 5
      DisplayWidth = 5
      Position = 5
    end
    object ppDBPipeline1ppField7: TppField
      FieldAlias = 'cClassName'
      FieldName = 'cClassName'
      FieldLength = 10
      DisplayWidth = 10
      Position = 6
    end
    object ppDBPipeline1ppField8: TppField
      FieldAlias = 'tIn1'
      FieldName = 'tIn1'
      FieldLength = 0
      DataType = dtDateTime
      DisplayWidth = 18
      Position = 7
    end
    object ppDBPipeline1ppField9: TppField
      FieldAlias = 'tOut1'
      FieldName = 'tOut1'
      FieldLength = 0
      DataType = dtDateTime
      DisplayWidth = 18
      Position = 8
    end
    object ppDBPipeline1ppField10: TppField
      FieldAlias = 'tIn2'
      FieldName = 'tIn2'
      FieldLength = 0
      DataType = dtDateTime
      DisplayWidth = 18
      Position = 9
    end
    object ppDBPipeline1ppField11: TppField
      FieldAlias = 'tOut2'
      FieldName = 'tOut2'
      FieldLength = 0
      DataType = dtDateTime
      DisplayWidth = 18
      Position = 10
    end
    object ppDBPipeline1ppField12: TppField
      FieldAlias = 'tIn3'
      FieldName = 'tIn3'
      FieldLength = 0
      DataType = dtDateTime
      DisplayWidth = 18
      Position = 11
    end
    object ppDBPipeline1ppField13: TppField
      FieldAlias = 'tOut3'
      FieldName = 'tOut3'
      FieldLength = 0
      DataType = dtDateTime
      DisplayWidth = 18
      Position = 12
    end
    object ppDBPipeline1ppField14: TppField
      Alignment = taRightJustify
      FieldAlias = 'iLaterTime'
      FieldName = 'iLaterTime'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 13
    end
    object ppDBPipeline1ppField15: TppField
      Alignment = taRightJustify
      FieldAlias = 'iLaterTimes'
      FieldName = 'iLaterTimes'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 14
    end
    object ppDBPipeline1ppField16: TppField
      Alignment = taRightJustify
      FieldAlias = 'iLeaveEarlyTime'
      FieldName = 'iLeaveEarlyTime'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 15
    end
    object ppDBPipeline1ppField17: TppField
      Alignment = taRightJustify
      FieldAlias = 'iLeaveEarlyTimes'
      FieldName = 'iLeaveEarlyTimes'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 16
    end
    object ppDBPipeline1ppField18: TppField
      Alignment = taRightJustify
      FieldAlias = 'iOverTime'
      FieldName = 'iOverTime'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 17
    end
    object ppDBPipeline1ppField19: TppField
      FieldAlias = 'cNote'
      FieldName = 'cNote'
      FieldLength = 100
      DisplayWidth = 100
      Position = 18
    end
    object ppDBPipeline1ppField20: TppField
      FieldAlias = 'bIsError'
      FieldName = 'bIsError'
      FieldLength = 0
      DataType = dtBoolean
      DisplayWidth = 5
      Position = 19
    end
    object ppDBPipeline1ppField21: TppField
      FieldAlias = 'cMemo'
      FieldName = 'cMemo'
      FieldLength = 0
      DataType = dtMemo
      DisplayWidth = 10
      Position = 20
      Searchable = False
      Sortable = False
    end
    object ppDBPipeline1ppField22: TppField
      FieldAlias = 'lChecked'
      FieldName = 'lChecked'
      FieldLength = 0
      DataType = dtBoolean
      DisplayWidth = 5
      Position = 21
    end
    object ppDBPipeline1ppField23: TppField
      FieldAlias = 'cUser'
      FieldName = 'cUser'
      FieldLength = 8
      DisplayWidth = 8
      Position = 22
    end
    object ppDBPipeline1ppField24: TppField
      FieldAlias = 'tUpdateTime'
      FieldName = 'tUpdateTime'
      FieldLength = 0
      DataType = dtDateTime
      DisplayWidth = 18
      Position = 23
    end
    object ppDBPipeline1ppField25: TppField
      FieldAlias = 'cAction'
      FieldName = 'cAction'
      FieldLength = 4
      DisplayWidth = 4
      Position = 24
    end
    object ppDBPipeline1ppField26: TppField
      FieldAlias = 'cCardNo'
      FieldName = 'cCardNo'
      FieldLength = 5
      DisplayWidth = 5
      Position = 25
    end
    object ppDBPipeline1ppField27: TppField
      Alignment = taRightJustify
      FieldAlias = 'iFreeTime'
      FieldName = 'iFreeTime'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 26
    end
    object ppDBPipeline1ppField28: TppField
      Alignment = taRightJustify
      FieldAlias = 'iLeaveTime'
      FieldName = 'iLeaveTime'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 27
    end
    object ppDBPipeline1ppField29: TppField
      FieldAlias = 'bErrorMaintenanceEd'
      FieldName = 'bErrorMaintenanceEd'
      FieldLength = 0
      DataType = dtBoolean
      DisplayWidth = 5
      Position = 28
    end
    object ppDBPipeline1ppField30: TppField
      FieldAlias = 'cErrorMaintenanceUser'
      FieldName = 'cErrorMaintenanceUser'
      FieldLength = 8
      DisplayWidth = 8
      Position = 29
    end
    object ppDBPipeline1ppField31: TppField
      FieldAlias = 'tErrorcErrorMaintenanceTime'
      FieldName = 'tErrorcErrorMaintenanceTime'
      FieldLength = 0
      DataType = dtDateTime
      DisplayWidth = 18
      Position = 30
    end
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 184
    Top = 168
  end
  object ADOQuery1: TADOQuery
    Active = True
    Connection = fDataMod.AdoCon
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'Select * From V_DailyCard  where ddate='#39'2002/10/23'#39)
    Left = 152
    Top = 168
  end
end