mddatabases.~dfm

被系统名叫生产信息管理系统

object dmDataSource: TdmDataSource
  OldCreateOrder = False
  Left = 575
  Top = 159
  Height = 382
  Width = 415
  object dbaDataBases: TDatabase
    Connected = True
    DatabaseName = 'MISData'
    DriverName = 'MSSQL'
    LoginPrompt = False
    Params.Strings = (
      'SERVER NAME=localhost'
      'DATABASE NAME=statistic'
      'USER NAME=sa'
      'OPEN MODE=READ/WRITE'
      'PASSWORD=sa')
    SessionName = 'Default'
    Left = 40
    Top = 24
  end
  object tblPerson: TTable
    Active = True
    CachedUpdates = True
    AutoRefresh = True
    DatabaseName = 'MISData'
    TableName = 'dbo.PERSON_TABLE'
    Left = 40
    Top = 88
    object tblPersonID: TStringField
      FieldName = 'ID'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblPersonPERSON_NAME: TStringField
      FieldName = 'PERSON_NAME'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblPersonPERSON_PASSWORD: TStringField
      FieldName = 'PERSON_PASSWORD'
      Required = True
      FixedChar = True
      Size = 30
    end
    object tblPersonPERSON_SEX: TStringField
      FieldName = 'PERSON_SEX'
      Required = True
      FixedChar = True
      Size = 30
    end
    object tblPersonPERSON_BIRTHDAY: TDateTimeField
      FieldName = 'PERSON_BIRTHDAY'
      Required = True
    end
    object tblPersonPERSON_WORKDATE: TDateTimeField
      FieldName = 'PERSON_WORKDATE'
      Required = True
    end
    object tblPersonDEPARTMENT: TStringField
      FieldName = 'DEPARTMENT'
      Required = True
      FixedChar = True
    end
    object tblPersonJOB: TStringField
      FieldName = 'JOB'
      Required = True
      FixedChar = True
    end
    object tblPersonBASE_SALARY: TFloatField
      FieldName = 'BASE_SALARY'
      Required = True
    end
    object tblPersonADDRESS: TStringField
      FieldName = 'ADDRESS'
      FixedChar = True
      Size = 50
    end
    object tblPersonTEL: TStringField
      FieldName = 'TEL'
      FixedChar = True
      Size = 15
    end
    object tblPersonOTHER_SALARY1: TFloatField
      FieldName = 'OTHER_SALARY1'
    end
    object tblPersonOTHER_SALARY2: TFloatField
      FieldName = 'OTHER_SALARY2'
    end
    object tblPersonDESCRIPTION: TStringField
      FieldName = 'DESCRIPTION'
      Size = 50
    end
  end
  object dsPerson: TDataSource
    DataSet = tblPerson
    Left = 40
    Top = 152
  end
  object tblDepartment: TTable
    Active = True
    CachedUpdates = True
    AutoRefresh = True
    DatabaseName = 'MISData'
    TableName = 'dbo.DEPARTMENT_TABLE'
    Left = 104
    Top = 88
    object tblDepartmentID: TStringField
      FieldName = 'ID'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblDepartmentDEPARTMENT_NAME: TStringField
      FieldName = 'DEPARTMENT_NAME'
      Required = True
      FixedChar = True
    end
    object tblDepartmentDEPARTMENT_MASTER_ID: TStringField
      FieldName = 'DEPARTMENT_MASTER_ID'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblDepartmentDEPARTMENT_SUBSIDY: TFloatField
      FieldName = 'DEPARTMENT_SUBSIDY'
      Required = True
    end
    object tblDepartmentDESCRIPTION: TStringField
      FieldName = 'DESCRIPTION'
      Size = 50
    end
  end
  object dsDepartment: TDataSource
    DataSet = tblDepartment
    Left = 104
    Top = 152
  end
  object tblHoliday: TTable
    Active = True
    CachedUpdates = True
    AutoRefresh = True
    DatabaseName = 'MISData'
    TableName = 'dbo.HOLIDAY_TABLE'
    Left = 168
    Top = 88
    object tblHolidayPERSON_ID: TStringField
      FieldName = 'PERSON_ID'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblHolidayHOLIDAY_REASON: TStringField
      FieldName = 'HOLIDAY_REASON'
      Required = True
      FixedChar = True
      Size = 16
    end
    object tblHolidaySTARTTIME: TDateTimeField
      FieldName = 'STARTTIME'
      Required = True
    end
    object tblHolidayENDTIME: TDateTimeField
      FieldName = 'ENDTIME'
      Required = True
    end
    object tblHolidayOPERATOR: TStringField
      FieldName = 'OPERATOR'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblHolidayDESCRIPTION: TStringField
      FieldName = 'DESCRIPTION'
      Size = 50
    end
    object tblHolidayTIMECOUNT: TFloatField
      FieldName = 'TIMECOUNT'
      Required = True
    end
    object tblHolidaySALARY: TFloatField
      FieldName = 'SALARY'
      Required = True
    end
  end
  object dsHoliday: TDataSource
    DataSet = tblHoliday
    Left = 168
    Top = 152
  end
  object tblOperator: TTable
    Active = True
    CachedUpdates = True
    AutoRefresh = True
    DatabaseName = 'MISData'
    TableName = 'dbo.OPERATOR_TABLE'
    Left = 232
    Top = 88
    object tblOperatorID: TStringField
      FieldName = 'ID'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblOperatorOPERATOR_NAME: TStringField
      FieldName = 'OPERATOR_NAME'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblOperatorOPERATOR_PASSWORD: TStringField
      FieldName = 'OPERATOR_PASSWORD'
      Required = True
      FixedChar = True
      Size = 30
    end
    object tblOperatorOPERATOR_RIGHTS: TStringField
      FieldName = 'OPERATOR_RIGHTS'
      Required = True
      FixedChar = True
      Size = 30
    end
    object tblOperatorDESCRIPTION: TStringField
      FieldName = 'DESCRIPTION'
      Size = 50
    end
  end
  object dsOperator: TDataSource
    DataSet = tblOperator
    Left = 232
    Top = 152
  end
  object tblOverTime: TTable
    Active = True
    CachedUpdates = True
    AutoRefresh = True
    DatabaseName = 'MISData'
    TableName = 'dbo.OVERTIME_TABLE'
    Left = 296
    Top = 88
    object tblOverTimePERSON_ID: TStringField
      FieldName = 'PERSON_ID'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblOverTimeSTART_TIME: TDateTimeField
      FieldName = 'START_TIME'
      Required = True
    end
    object tblOverTimeEND_TIME: TDateTimeField
      FieldName = 'END_TIME'
      Required = True
    end
    object tblOverTimeOPERATOR: TStringField
      FieldName = 'OPERATOR'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblOverTimeDESCRIPTION: TStringField
      FieldName = 'DESCRIPTION'
      Size = 50
    end
    object tblOverTimeTIMECOUNT: TFloatField
      FieldName = 'TIMECOUNT'
      Required = True
    end
    object tblOverTimeSALARY: TFloatField
      FieldName = 'SALARY'
      Required = True
    end
  end
  object dsOverTime: TDataSource
    DataSet = tblOverTime
    Left = 296
    Top = 152
  end
  object tblSalary: TTable
    Active = True
    CachedUpdates = True
    AutoRefresh = True
    DatabaseName = 'MISData'
    TableName = 'dbo.SALARY_TABLE'
    Left = 40
    Top = 216
    object tblSalaryID: TStringField
      FieldName = 'ID'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblSalaryPERSON_ID: TStringField
      FieldName = 'PERSON_ID'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblSalaryPERSON_NAME: TStringField
      FieldName = 'PERSON_NAME'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblSalaryBASE_SALARY: TFloatField
      FieldName = 'BASE_SALARY'
      Required = True
    end
    object tblSalaryDEPARTMENT_SALARY: TFloatField
      FieldName = 'DEPARTMENT_SALARY'
      Required = True
    end
    object tblSalaryVOCATION_SALARY: TFloatField
      FieldName = 'VOCATION_SALARY'
      Required = True
    end
    object tblSalaryOTHER_SALARY1: TFloatField
      FieldName = 'OTHER_SALARY1'
    end
    object tblSalaryOTHER_SALARY2: TFloatField
      FieldName = 'OTHER_SALARY2'
    end
    object tblSalaryBONUS: TFloatField
      FieldName = 'BONUS'
      Required = True
    end
    object tblSalaryMULCT: TFloatField
      FieldName = 'MULCT'
      Required = True
    end
    object tblSalarySHOULD_PAY_SALARY: TFloatField
      FieldName = 'SHOULD_PAY_SALARY'
      Required = True
    end
    object tblSalaryREAL_PAY_SALARY: TFloatField
      FieldName = 'REAL_PAY_SALARY'
      Required = True
    end
    object tblSalaryIS_PAY: TIntegerField
      FieldName = 'IS_PAY'
      Required = True
    end
  end
  object dsSalary: TDataSource
    DataSet = tblSalary
    Left = 40
    Top = 280
  end
  object tblVocation: TTable
    Active = True
    CachedUpdates = True
    DatabaseName = 'MISData'
    TableName = 'dbo.VOCATION_TABLE'
    Left = 104
    Top = 216
    object tblVocationID: TStringField
      FieldName = 'ID'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblVocationVOCATION_NAME: TStringField
      FieldName = 'VOCATION_NAME'
      Required = True
      FixedChar = True
      Size = 16
    end
    object tblVocationVOCATION_SUBSIDY: TFloatField
      FieldName = 'VOCATION_SUBSIDY'
      Required = True
    end
    object tblVocationDESCRIPTION: TStringField
      FieldName = 'DESCRIPTION'
      Size = 50
    end
  end
  object dsVocation: TDataSource
    DataSet = tblVocation
    Left = 104
    Top = 280
  end
  object CheckBox1: TCheckBox
    Left = 16
    Top = 448
    Width = 97
    Height = 17
    Caption = #20462#25913#24037#36164#39033
  end
  object tblCheckTime: TTable
    Active = True
    CachedUpdates = True
    DatabaseName = 'MISData'
    FieldDefs = <
      item
        Name = 'ID'
        Attributes = [faRequired]
        DataType = ftString
        Size = 10
      end
      item
        Name = 'RECORDTIME'
        Attributes = [faRequired]
        DataType = ftDateTime
      end
      item
        Name = 'RECORDTYPE'
        Attributes = [faRequired]
        DataType = ftString
        Size = 20
      end
      item
        Name = 'RESULT'
        Attributes = [faRequired]
        DataType = ftString
        Size = 10
      end
      item
        Name = 'TIMECOUNT'
        Attributes = [faRequired]
        DataType = ftFloat
      end
      item
        Name = 'SALARY'
        Attributes = [faRequired]
        DataType = ftFloat
      end>
    StoreDefs = True
    TableName = 'dbo.CHECKTIMERECORD'
    Left = 168
    Top = 216
    object tblCheckTimeID: TStringField
      FieldName = 'ID'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblCheckTimeRECORDTIME: TDateTimeField
      FieldName = 'RECORDTIME'
      Required = True
    end
    object tblCheckTimeRECORDTYPE: TStringField
      FieldName = 'RECORDTYPE'
      Required = True
      FixedChar = True
    end
    object tblCheckTimeRESULT: TStringField
      FieldName = 'RESULT'
      Required = True
      FixedChar = True
      Size = 10
    end
    object tblCheckTimeTIMECOUNT: TFloatField
      FieldName = 'TIMECOUNT'
      Required = True
    end
    object tblCheckTimeSALARY: TFloatField
      FieldName = 'SALARY'
      Required = True
    end
  end
  object dsCheckTime: TDataSource
    DataSet = tblCheckTime
    Left = 168
    Top = 280
  end
  object qrySQLCommand: TQuery
    AutoRefresh = True
    DatabaseName = 'MISData'
    SQL.Strings = (
      'SELECT PERSON_ID '
      'FROM HOLIDAY_TABLE Holiday_table '
      'WHERE (ENDTIME >= :dtmStartTime '
      'AND PERSON_ID = :strID)')
    Left = 232
    Top = 216
    ParamData = <
      item
        DataType = ftDateTime
        Name = 'dtmStartTime'
        ParamType = ptUnknown
      end
      item
        DataType = ftString
        Name = 'strID'
        ParamType = ptUnknown
      end>
  end
  object dsSQLCommand: TDataSource
    Left = 232
    Top = 280
  end
end