u_gs_dm.dfm

小型劳资管理系统,用visual basic+access编写

object GS_DM: TGS_DM
  OldCreateOrder = False
  Left = 199
  Top = 120
  Height = 375
  Width = 544
  object Q_empbktimestable: TQuery
    DatabaseName = 'person_DB'
    SQL.Strings = (
      'select * from bktimestable')
    Left = 40
    Top = 16
  end
  object DQ_empbktimestable: TDataSource
    DataSet = Q_empbktimestable
    Left = 40
    Top = 88
  end
  object Q_everydaytime: TQuery
    DatabaseName = 'person_DB'
    RequestLive = True
    SQL.Strings = (
      'select distinct  * from everydaytime')
    Left = 136
    Top = 16
    object Q_everydaytimeemp_id: TIntegerField
      FieldName = 'emp_id'
      Origin = 'PERSON_DB.everydaytime.emp_id'
    end
    object Q_everydaytimeworkday: TStringField
      DisplayLabel = #58907#59142#12425
      FieldName = 'workday'
      Origin = 'PERSON_DB.everydaytime.workday'
      FixedChar = True
      Size = 10
    end
    object Q_everydaytimeZB_time: TFloatField
      DisplayLabel = #12479#30145#57760#35745
      DisplayWidth = 8
      FieldName = 'ZB_time'
      Origin = 'PERSON_DB.everydaytime.ZB_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeJB_time: TFloatField
      DisplayLabel = #58977#30145#57760#35745
      DisplayWidth = 8
      FieldName = 'JB_time'
      Origin = 'PERSON_DB.everydaytime.JB_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeZBsj_time: TFloatField
      DisplayLabel = #12479#30145#12550#23433
      DisplayWidth = 8
      FieldName = 'ZBsj_time'
      Origin = 'PERSON_DB.everydaytime.ZBsj_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeJBsj_time: TFloatField
      DisplayLabel = #58977#30145#12550#23433
      DisplayWidth = 8
      FieldName = 'JBsj_time'
      Origin = 'PERSON_DB.everydaytime.JBsj_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeZBbj_time: TFloatField
      DisplayLabel = #12479#30145#30172#23433
      DisplayWidth = 8
      FieldName = 'ZBbj_time'
      Origin = 'PERSON_DB.everydaytime.ZBbj_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeJBbj_time: TFloatField
      DisplayLabel = #58977#30145#30172#23433
      DisplayWidth = 8
      FieldName = 'JBbj_time'
      Origin = 'PERSON_DB.everydaytime.JBbj_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeTBJ: TFloatField
      DisplayLabel = #30125#59157#23433
      FieldName = 'TBJ'
      Origin = 'PERSON_DB.everydaytime.TBJ'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeCD_time: TFloatField
      DisplayLabel = #31568#59343'('#12384#29287')'
      FieldName = 'CD_time'
      Origin = 'PERSON_DB.everydaytime.CD_time'
    end
    object Q_everydaytimeCD_int: TIntegerField
      DisplayLabel = #921#36479#937#57757
      DisplayWidth = 8
      FieldName = 'CD_int'
      Origin = 'PERSON_DB.everydaytime.CD_int'
      DisplayFormat = '0'
    end
    object Q_everydaytimeZT_time: TFloatField
      DisplayLabel = #925#30326'('#12384#29287')'
      DisplayWidth = 8
      FieldName = 'ZT_time'
      Origin = 'PERSON_DB.everydaytime.ZT_time'
    end
    object Q_everydaytimeZT_int: TIntegerField
      DisplayLabel = #921#36479#937#35745
      DisplayWidth = 8
      FieldName = 'ZT_int'
      Origin = 'PERSON_DB.everydaytime.ZT_int'
      DisplayFormat = '0'
    end
    object Q_everydaytimeKG_time: TFloatField
      DisplayLabel = #32994#58907#57760#35745
      DisplayWidth = 8
      FieldName = 'KG_time'
      Origin = 'PERSON_DB.everydaytime.KG_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeKG_int: TIntegerField
      DisplayLabel = #921#36479#937#35745
      DisplayWidth = 8
      FieldName = 'KG_int'
      Origin = 'PERSON_DB.everydaytime.KG_int'
      DisplayFormat = '0'
    end
    object Q_everydaytimeGS_time: TFloatField
      DisplayLabel = #58907#31471#57760#35745
      DisplayWidth = 8
      FieldName = 'GS_time'
      Origin = 'PERSON_DB.everydaytime.GS_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeDL_time: TFloatField
      DisplayLabel = #57498#57757#57760#35745
      DisplayWidth = 8
      FieldName = 'DL_time'
      Origin = 'PERSON_DB.everydaytime.DL_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeGX_time: TFloatField
      DisplayLabel = #12381#12528#57760#35745
      DisplayWidth = 8
      FieldName = 'GX_time'
      Origin = 'PERSON_DB.everydaytime.GX_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeJ_time: TFloatField
      DisplayLabel = #24178#57760
      DisplayWidth = 4
      FieldName = 'J_time'
      Origin = 'PERSON_DB.everydaytime.J_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimeK_time: TFloatField
      DisplayLabel = #921#57760
      DisplayWidth = 4
      FieldName = 'K_time'
      Origin = 'PERSON_DB.everydaytime.K_time'
      DisplayFormat = '0.0'
    end
    object Q_everydaytimememe2_time: TFloatField
      FieldName = 'meme2_time'
      Origin = 'PERSON_DB.everydaytime.meme2_time'
    end
    object Q_everydaytimeGC_time: TFloatField
      FieldName = 'GC_time'
      Origin = 'PERSON_DB.everydaytime.GC_time'
    end
  end
  object DQ_everydaytime: TDataSource
    DataSet = Q_everydaytime
    Left = 136
    Top = 80
  end
  object V_empworktime: TQuery
    AfterScroll = V_empworktimeAfterScroll
    OnCalcFields = V_empworktimeCalcFields
    DatabaseName = 'person_DB'
    RequestLive = True
    SQL.Strings = (
      'select distinct * from V_empworktime '
      '')
    UniDirectional = True
    Left = 240
    Top = 16
    object V_empworktimeworkday: TDateTimeField
      DisplayLabel = #58907#59142#12425#25139
      DisplayWidth = 10
      FieldName = 'workday'
      Origin = 'PERSON_DB.V_empworktime.workday'
      ReadOnly = True
    end
    object V_empworktimeejbm_id: TIntegerField
      FieldName = 'ejbm_id'
      Origin = 'PERSON_DB.V_empworktime.ejbm_id'
    end
    object V_empworktimeyjbm_name: TStringField
      DisplayLabel = #58854#57850#22330#57432
      DisplayWidth = 8
      FieldName = 'yjbm_name'
      Origin = 'PERSON_DB.V_empworktime.yjbm_name'
      ReadOnly = True
      FixedChar = True
      Size = 16
    end
    object V_empworktimeejbm_name: TStringField
      DisplayLabel = #58861#57850#22330#57432
      DisplayWidth = 10
      FieldName = 'ejbm_name'
      Origin = 'PERSON_DB.V_empworktime.ejbm_name'
      ReadOnly = True
      FixedChar = True
      Size = 16
    end
    object V_empworktimework_num: TStringField
      DisplayLabel = #58907#33145
      DisplayWidth = 7
      FieldName = 'work_num'
      Origin = 'PERSON_DB.V_empworktime.work_num'
      ReadOnly = True
      FixedChar = True
      Size = 10
    end
    object V_empworktimename: TStringField
      DisplayLabel = #65102'  '#59069
      DisplayWidth = 6
      FieldName = 'name'
      Origin = 'PERSON_DB.V_empworktime.name'
      ReadOnly = True
      FixedChar = True
      Size = 10
    end
    object V_empworktimeZB_time: TFloatField
      DisplayLabel = #12479#30145#33713#932#57760#35745
      DisplayWidth = 8
      FieldName = 'ZB_time'
      Origin = 'PERSON_DB.V_empworktime.ZB_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimeJB_time: TFloatField
      DisplayLabel = #58977#30145#57760#35745
      DisplayWidth = 8
      FieldName = 'JB_time'
      Origin = 'PERSON_DB.V_empworktime.JB_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimeZBsj_time: TFloatField
      DisplayLabel = #12479#30145#12550#23433
      DisplayWidth = 8
      FieldName = 'ZBsj_time'
      Origin = 'PERSON_DB.V_empworktime.ZBsj_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimeJBsj_time: TFloatField
      DisplayLabel = #58977#30145#12550#23433
      DisplayWidth = 8
      FieldName = 'JBsj_time'
      Origin = 'PERSON_DB.V_empworktime.JBsj_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimeZBbj_time: TFloatField
      DisplayLabel = #12479#30145#30172#23433
      DisplayWidth = 8
      FieldName = 'ZBbj_time'
      Origin = 'PERSON_DB.V_empworktime.ZBbj_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimeJBbj_time: TFloatField
      DisplayLabel = #58977#30145#30172#23433
      DisplayWidth = 8
      FieldName = 'JBbj_time'
      Origin = 'PERSON_DB.V_empworktime.JBbj_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimeTBJ: TFloatField
      DisplayLabel = #30125#58977#23433
      DisplayWidth = 6
      FieldName = 'TBJ'
      Origin = 'PERSON_DB.V_empworktime.TBJ'
      DisplayFormat = '0.0'
    end
    object V_empworktimeCD_time: TFloatField
      DisplayLabel = #31568#59343#12384#29287
      DisplayWidth = 8
      FieldName = 'CD_time'
      Origin = 'PERSON_DB.V_empworktime.CD_time'
    end
    object V_empworktimeCD_int: TIntegerField
      DisplayLabel = #921#36479#937#35745
      DisplayWidth = 8
      FieldName = 'CD_int'
      Origin = 'PERSON_DB.V_empworktime.CD_int'
    end
    object V_empworktimeZT_time: TFloatField
      DisplayLabel = #925#30326#12384#29287
      DisplayWidth = 8
      FieldName = 'ZT_time'
      Origin = 'PERSON_DB.V_empworktime.ZT_time'
    end
    object V_empworktimeZT_int: TIntegerField
      DisplayLabel = #921#36479#937#35745
      DisplayWidth = 8
      FieldName = 'ZT_int'
      Origin = 'PERSON_DB.V_empworktime.ZT_int'
    end
    object V_empworktimeKG_time: TFloatField
      DisplayLabel = #32994#58907#57760#35745
      DisplayWidth = 8
      FieldName = 'KG_time'
      Origin = 'PERSON_DB.V_empworktime.KG_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimeKG_int: TIntegerField
      DisplayLabel = #921#36479#937#35745
      DisplayWidth = 8
      FieldName = 'KG_int'
      Origin = 'PERSON_DB.V_empworktime.KG_int'
    end
    object V_empworktimeGS_time: TFloatField
      DisplayLabel = #58907#31471#57760#35745
      DisplayWidth = 8
      FieldName = 'GS_time'
      Origin = 'PERSON_DB.V_empworktime.GS_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimeDL_time: TFloatField
      DisplayLabel = #57498#57757#57760#35745
      DisplayWidth = 8
      FieldName = 'DL_time'
      Origin = 'PERSON_DB.V_empworktime.DL_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimeGX_time: TFloatField
      DisplayLabel = #12381#12528#57760#35745
      DisplayWidth = 8
      FieldName = 'GX_time'
      Origin = 'PERSON_DB.V_empworktime.GX_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimeJ_time: TFloatField
      DisplayLabel = #24178#57760
      DisplayWidth = 4
      FieldName = 'J_time'
      Origin = 'PERSON_DB.V_empworktime.J_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimeK_time: TFloatField
      DisplayLabel = #921#57760
      DisplayWidth = 4
      FieldName = 'K_time'
      Origin = 'PERSON_DB.V_empworktime.K_time'
      DisplayFormat = '0.0'
    end
    object V_empworktimememe2_time: TFloatField
      FieldName = 'meme2_time'
      Origin = 'PERSON_DB.V_empworktime.meme2_time'
    end
    object V_empworktimeZB: TFloatField
      DisplayLabel = #40863#24724#12479#30145
      DisplayWidth = 8
      FieldKind = fkCalculated
      FieldName = 'ZB'
      ReadOnly = True
      DisplayFormat = '0.0'
      Calculated = True
    end
    object V_empworktimeJB: TFloatField
      DisplayLabel = #40863#24724#58977#30145
      DisplayWidth = 8
      FieldKind = fkCalculated
      FieldName = 'JB'
      ReadOnly = True
      DisplayFormat = '0.0'
      Calculated = True
    end
    object V_empworktimemoringup: TIntegerField
      DisplayLabel = #58877#12392#58877#30145
      DisplayWidth = 8
      FieldName = 'moringup'
      Origin = 'PERSON_DB.V_empworktime.moringup'
      DisplayFormat = '00:00'
    end
    object V_empworktimechar1: TStringField
      DisplayLabel = #22841#37274
      FieldName = 'char1'
      Origin = 'PERSON_DB.V_empworktime.char1'
      FixedChar = True
      Size = 1
    end
    object V_empworktimemoringdown: TIntegerField
      DisplayLabel = #58877#12392#58875#30145
      DisplayWidth = 8
      FieldName = 'moringdown'
      Origin = 'PERSON_DB.V_empworktime.moringdown'
      DisplayFormat = '00:00'
    end
    object V_empworktimechar2: TStringField
      DisplayLabel = #22841#37274
      FieldName = 'char2'
      Origin = 'PERSON_DB.V_empworktime.char2'
      FixedChar = True
      Size = 1
    end
    object V_empworktimeafternoonup: TIntegerField
      DisplayLabel = #58875#12392#58877#30145
      DisplayWidth = 8
      FieldName = 'afternoonup'
      Origin = 'PERSON_DB.V_empworktime.afternoonup'
      DisplayFormat = '00:00'
    end
    object V_empworktimechar3: TStringField
      DisplayLabel = #22841#37274
      FieldName = 'char3'
      Origin = 'PERSON_DB.V_empworktime.char3'
      FixedChar = True
      Size = 1
    end
    object V_empworktimeafternoondown: TIntegerField
      DisplayLabel = #58875#12392#58875#30145
      DisplayWidth = 8
      FieldName = 'afternoondown'
      Origin = 'PERSON_DB.V_empworktime.afternoondown'
      DisplayFormat = '00:00'
    end
    object V_empworktimechar4: TStringField
      DisplayLabel = #22841#37274
      FieldName = 'char4'
      Origin = 'PERSON_DB.V_empworktime.char4'
      FixedChar = True
      Size = 1
    end
    object V_empworktimeeveningup: TIntegerField
      DisplayLabel = #36793#19969#58877#30145
      DisplayWidth = 8
      FieldName = 'eveningup'
      Origin = 'PERSON_DB.V_empworktime.eveningup'
      DisplayFormat = '00:00'
    end
    object V_empworktimechar5: TStringField
      DisplayLabel = #22841#37274
      FieldName = 'char5'
      Origin = 'PERSON_DB.V_empworktime.char5'
      FixedChar = True
      Size = 1
    end
    object V_empworktimeeveningdown: TIntegerField
      DisplayLabel = #36793#19969#58875#30145
      DisplayWidth = 8
      FieldName = 'eveningdown'
      Origin = 'PERSON_DB.V_empworktime.eveningdown'
      DisplayFormat = '00:00'
    end
    object V_empworktimechar6: TStringField
      DisplayLabel = #22841#37274
      FieldName = 'char6'
      Origin = 'PERSON_DB.V_empworktime.char6'
      FixedChar = True
      Size = 1
    end
    object V_empworktimeempid: TIntegerField
      FieldName = 'empid'
      Origin = 'PERSON_DB.V_empworktime.empid'
    end
    object V_empworktimeteamsid: TIntegerField
      DisplayLabel = #30145#937