object DM: TDM
  OldCreateOrder = False
  Height = 414
  Width = 627
  object conexao: TSQLConnection
    ConnectionName = 'GESTAO'
    DriverName = 'Firebird'
    LoginPrompt = False
    Params.Strings = (
      'DriverName=Firebird'
      'DriverUnit=Data.DBXFirebird'
      
        'DriverPackageLoader=TDBXDynalinkDriverLoader,DbxCommonDriver260.' +
        'bpl'
      
        'DriverAssemblyLoader=Borland.Data.TDBXDynalinkDriverLoader,Borla' +
        'nd.Data.DbxCommonDriver,Version=24.0.0.0,Culture=neutral,PublicK' +
        'eyToken=91d62ebb5b0d1b1b'
      
        'MetaDataPackageLoader=TDBXFirebirdMetaDataCommandFactory,DbxFire' +
        'birdDriver260.bpl'
      
        'MetaDataAssemblyLoader=Borland.Data.TDBXFirebirdMetaDataCommandF' +
        'actory,Borland.Data.DbxFirebirdDriver,Version=24.0.0.0,Culture=n' +
        'eutral,PublicKeyToken=91d62ebb5b0d1b1b'
      'LibraryName=dbxfb.dll'
      'LibraryNameOsx=libsqlfb.dylib'
      'VendorLib=fbclient.dll'
      'VendorLibWin64=fbclient.dll'
      'VendorLibOsx=/Library/Frameworks/Firebird.framework/Firebird'
      'Database=C:\SISPREF\GESTAO\banco\banco.fdb'
      'User_Name=sysdba'
      'Password=masterkey'
      'Role=RoleName'
      'MaxBlobSize=-1'
      'LocaleCode=0000'
      'IsolationLevel=ReadCommitted'
      'SQLDialect=3'
      'CommitRetain=False'
      'WaitOnLocks=True'
      'TrimChar=False'
      'BlobSize=-1'
      'ErrorResourceFile='
      'RoleName=RoleName'
      'ServerCharSet='
      'Trim Char=False')
    BeforeConnect = conexaoBeforeConnect
    Connected = True
    Left = 16
    Top = 8
  end
  object SDSlogin: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from acesso'#13#10'where USUARIO = :nome and SENHA = :senha'
    MaxBlobSize = 1
    Params = <
      item
        DataType = ftString
        Name = 'nome'
        ParamType = ptInput
      end
      item
        DataType = ftString
        Name = 'senha'
        ParamType = ptInput
      end>
    SQLConnection = conexao
    Left = 72
    Top = 16
    object SDSloginID_SENHA: TIntegerField
      FieldName = 'ID_SENHA'
    end
    object SDSloginNOME: TStringField
      FieldName = 'NOME'
      Size = 40
    end
    object SDSloginUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 30
    end
    object SDSloginSENHA: TStringField
      FieldName = 'SENHA'
      Size = 30
    end
    object SDSloginNIVEL: TIntegerField
      FieldName = 'NIVEL'
    end
  end
  object DSPlogin: TDataSetProvider
    DataSet = SDSlogin
    Options = [poAllowCommandText, poUseQuoteChar]
    Left = 68
    Top = 68
  end
  object CDSlogin: TClientDataSet
    Aggregates = <>
    Params = <
      item
        DataType = ftString
        Name = 'nome'
        ParamType = ptInput
      end
      item
        DataType = ftString
        Name = 'senha'
        ParamType = ptInput
      end>
    ProviderName = 'DSPlogin'
    Left = 64
    Top = 122
    object CDSloginID_SENHA: TIntegerField
      FieldName = 'ID_SENHA'
    end
    object CDSloginNOME: TStringField
      FieldName = 'NOME'
      Size = 40
    end
    object CDSloginUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 30
    end
    object CDSloginSENHA: TStringField
      FieldName = 'SENHA'
      Size = 30
    end
    object CDSloginNIVEL: TIntegerField
      FieldName = 'NIVEL'
    end
  end
  object SqlUsuario: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from  ACESSO'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 136
    Top = 16
    object SqlUsuarioID_SENHA: TIntegerField
      FieldName = 'ID_SENHA'
      Required = True
    end
    object SqlUsuarioNOME: TStringField
      FieldName = 'NOME'
      Size = 40
    end
    object SqlUsuarioUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 30
    end
    object SqlUsuarioSENHA: TStringField
      FieldName = 'SENHA'
      Size = 30
    end
    object SqlUsuarioNIVEL: TIntegerField
      FieldName = 'NIVEL'
    end
  end
  object DspUsuario: TDataSetProvider
    DataSet = SqlUsuario
    Left = 136
    Top = 72
  end
  object CdsUsuario: TClientDataSet
    Aggregates = <>
    IndexFieldNames = 'USUARIO'
    Params = <>
    ProviderName = 'DspUsuario'
    Left = 136
    Top = 123
    object CdsUsuarioID_SENHA: TIntegerField
      FieldName = 'ID_SENHA'
      Required = True
    end
    object CdsUsuarioNOME: TStringField
      FieldName = 'NOME'
      Size = 40
    end
    object CdsUsuarioUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 30
    end
    object CdsUsuarioSENHA: TStringField
      FieldName = 'SENHA'
      Size = 30
    end
    object CdsUsuarioNIVEL: TIntegerField
      FieldName = 'NIVEL'
    end
  end
  object sql_patrimonio: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from PATRIMONIO'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 336
    Top = 16
  end
  object prov_patrimonio: TDataSetProvider
    DataSet = sql_patrimonio
    Left = 336
    Top = 72
  end
  object cds_patrimonio: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'prov_patrimonio'
    Left = 336
    Top = 131
    object cds_patrimonioID: TIntegerField
      FieldName = 'ID'
      Required = True
    end
    object cds_patrimonioNUM_PATRIMONIO: TIntegerField
      FieldName = 'NUM_PATRIMONIO'
    end
    object cds_patrimonioDATA: TDateField
      FieldName = 'DATA'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_patrimonioDESCRICAO: TStringField
      FieldName = 'DESCRICAO'
      Size = 200
    end
    object cds_patrimonioSETOR: TStringField
      FieldName = 'SETOR'
      Size = 100
    end
    object cds_patrimonioESTADO: TStringField
      FieldName = 'ESTADO'
      Size = 50
    end
    object cds_patrimonioQTD: TIntegerField
      FieldName = 'QTD'
    end
  end
  object sql_funcionario: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from FUNCIONARIO'
    MaxBlobSize = 1
    Params = <>
    SQLConnection = conexao
    Left = 240
    Top = 16
  end
  object prov_funcionario: TDataSetProvider
    DataSet = sql_funcionario
    Left = 240
    Top = 72
  end
  object cds_funcionario: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'prov_funcionario'
    Left = 240
    Top = 131
    object cds_funcionarioID: TIntegerField
      FieldName = 'ID'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cds_funcionarioNOME: TStringField
      FieldName = 'NOME'
      Size = 100
    end
    object cds_funcionarioENDERECO: TStringField
      FieldName = 'ENDERECO'
      Size = 100
    end
    object cds_funcionarioNUMERO: TStringField
      FieldName = 'NUMERO'
      Size = 10
    end
    object cds_funcionarioBAIRRO: TStringField
      FieldName = 'BAIRRO'
      Size = 30
    end
    object cds_funcionarioCIDADE: TStringField
      FieldName = 'CIDADE'
      Size = 30
    end
    object cds_funcionarioCONTATO: TStringField
      FieldName = 'CONTATO'
      EditMask = '!\(99\)00000-0000;1;_'
    end
    object cds_funcionarioFUNCAO: TStringField
      FieldName = 'FUNCAO'
      Size = 50
    end
    object cds_funcionarioDN: TDateField
      FieldName = 'DN'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_funcionarioFOTO: TBlobField
      FieldName = 'FOTO'
      Size = 1
    end
    object cds_funcionarioDATA_ADMISSAO: TDateField
      FieldName = 'DATA_ADMISSAO'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_funcionarioSEXO: TStringField
      FieldName = 'SEXO'
    end
    object cds_funcionarioNATURALIDADE: TStringField
      FieldName = 'NATURALIDADE'
      Size = 30
    end
    object cds_funcionarioCPF: TStringField
      FieldName = 'CPF'
      EditMask = '000\.000\.000\-00;1;_'
    end
    object cds_funcionarioRG: TStringField
      FieldName = 'RG'
    end
    object cds_funcionarioRG_D_EMISSAO: TDateField
      FieldName = 'RG_D_EMISSAO'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_funcionarioRG_ORGAO: TStringField
      FieldName = 'RG_ORGAO'
      Size = 10
    end
    object cds_funcionarioCNH: TStringField
      FieldName = 'CNH'
      Size = 30
    end
    object cds_funcionarioCNH_CAT: TStringField
      FieldName = 'CNH_CAT'
      FixedChar = True
      Size = 10
    end
    object cds_funcionarioTITULO_ELEITOR: TStringField
      FieldName = 'TITULO_ELEITOR'
      Size = 30
    end
    object cds_funcionarioTITULO_ZONA: TStringField
      FieldName = 'TITULO_ZONA'
      FixedChar = True
      Size = 10
    end
    object cds_funcionarioTITULO_SECAO: TStringField
      FieldName = 'TITULO_SECAO'
      FixedChar = True
      Size = 10
    end
    object cds_funcionarioPASSAPORTE: TStringField
      FieldName = 'PASSAPORTE'
      Size = 30
    end
    object cds_funcionarioMAE: TStringField
      FieldName = 'MAE'
      Size = 100
    end
    object cds_funcionarioPAI: TStringField
      FieldName = 'PAI'
      Size = 100
    end
    object cds_funcionarioUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 50
    end
    object cds_funcionarioMATRICULA: TStringField
      FieldName = 'MATRICULA'
      Size = 50
    end
  end
end
