Example #1
0
        internal LsLog Listar()
        {
            try
              {
              var m_oLog = new LsLog();
              sbSQL.Length = 0;
              sbSQL.Append("SELECT DSOBSR, DTLOG, HRLOG, IDPRO015, IDPRO019, IDPRO020");
              sbSQL.Append(" FROM TBPRO019");

              oAdapter = ObterDataAdapter(sbSQL.ToString());

              ITableMapping objMapping = oAdapter.TableMappings.Add("Table" , LsLog.tbLog);
              objMapping.ColumnMappings.Add("DSOBSR","Observacao");
              objMapping.ColumnMappings.Add("DTLOG","Data");
              objMapping.ColumnMappings.Add("HRLOG","Hora");
              objMapping.ColumnMappings.Add("IDPRO015","CodigoUsuario");
              objMapping.ColumnMappings.Add("IDPRO019","Codigo");
              objMapping.ColumnMappings.Add("IDPRO020","CodigoOperacao");

              oAdapter.Fill(m_oLog);

              return m_oLog;
              }
              catch (Exception ex)
              {
              throw new Dor.Util.OperacaoInvalidaBD(ex);
              }
        }
Example #2
0
        public override System.Data.DataSet Listar()
        {
            LsLog m_oLsLog = new LsLog();

             repositorio.Conectar();
             m_oLsLog = this.repositorio.Listar();
             repositorio.Desconectar();

             return m_oLsLog;
        }