public override System.Data.DataSet Listar()
{
LsEndereco m_oLsEndereco = new LsEndereco();
repositorio.Conectar();
m_oLsEndereco = this.repositorio.Listar();
repositorio.Desconectar();
return m_oLsEndereco;
}
internal LsEndereco Listar()
{
try
{
var m_oEndereco = new LsEndereco();
sbSQL.Length = 0;
sbSQL.Append("SELECT CDCEP, DSCOMP, IDPRO010, IDPRO021, NMBARR, NMCIDD, NMLOGR, NRNUMR");
sbSQL.Append(" FROM TBPRO010");
oAdapter = ObterDataAdapter(sbSQL.ToString());
ITableMapping objMapping = oAdapter.TableMappings.Add("Table", LsEndereco.tbEndereco);
objMapping.ColumnMappings.Add("CDCEP", LsEndereco.cpCep);
objMapping.ColumnMappings.Add("DSCOMP", LsEndereco.cpComplemento);
objMapping.ColumnMappings.Add("IDPRO010", LsEndereco.cpCodigo);
objMapping.ColumnMappings.Add("IDPRO021", LsEndereco.cpCodigoUF);
objMapping.ColumnMappings.Add("NMBARR", LsEndereco.cpBairro);
objMapping.ColumnMappings.Add("NMCIDD", LsEndereco.cpCidade);
objMapping.ColumnMappings.Add("NMLOGR", LsEndereco.cpLogradouro);
objMapping.ColumnMappings.Add("NRNUMR", LsEndereco.cpNumero);
oAdapter.Fill(m_oEndereco);
return m_oEndereco;
}
catch (Exception ex)
{
throw new Dor.Util.OperacaoInvalidaBD(ex);
}
}
