public void Listar(DNA.Entidades.Usuario usu, ref DataTable oDT)
{
try
{
ConexaoPersonalizada oConn = new ConexaoPersonalizada();
try
{
OracleParameter[] arParms = new OracleParameter[5];
arParms[0] = new OracleParameter();
arParms[0].ParameterName = "V_CURSOR";
arParms[0].OracleDbType = OracleDbType.RefCursor;
arParms[0].Direction = ParameterDirection.Output;
arParms[1] = new OracleParameter();
arParms[1].ParameterName = "P_ID_USUARIO";
arParms[1].OracleDbType = OracleDbType.Int64;
arParms[1].Direction = ParameterDirection.Input;
if (usu.IdUsuario == 0)
{
arParms[1].Value = DBNull.Value;
}
else
{
arParms[1].Value = usu.IdUsuario;
}
arParms[2] = new OracleParameter();
arParms[2].ParameterName = "P_LOGIN";
arParms[2].OracleDbType = OracleDbType.Varchar2;
arParms[2].Direction = ParameterDirection.Input;
arParms[2].Value = usu.LoginUsuario;
arParms[3] = new OracleParameter();
arParms[3].ParameterName = "P_SENHA";
arParms[3].OracleDbType = OracleDbType.Varchar2;
arParms[3].Direction = ParameterDirection.Input;
arParms[3].Value = usu.SenhaUsuario;
arParms[4] = new OracleParameter();
arParms[4].ParameterName = "P_FLAG_ATIVO";
arParms[4].OracleDbType = OracleDbType.Char;
arParms[4].Direction = ParameterDirection.Input;
arParms[4].Value = usu.FlagAtivo;
oConn.Execute("DNASITE.P_L_USUARIOS", arParms, ref oDT);
}
catch (Exception ex)
{ throw ex; }
finally
{
oConn.CloseConnection();
oConn = null;
}
}
catch (Exception ex)
{ throw ex; }
}
public void ListarPerfilByIdUsuario(DNA.Entidades.PerfilAcesso perf, ref DataTable oDT)
{
try
{
ConexaoPersonalizada oConn = new ConexaoPersonalizada();
try
{
OracleParameter[] arParms = new OracleParameter[4];
arParms[0] = new OracleParameter();
arParms[0].ParameterName = "V_CURSOR";
arParms[0].OracleDbType = OracleDbType.RefCursor;
arParms[0].Direction = ParameterDirection.Output;
arParms[1] = new OracleParameter();
arParms[1].ParameterName = "P_ID";
arParms[1].OracleDbType = OracleDbType.Int64;
arParms[1].Direction = ParameterDirection.Input;
arParms[1].Value = perf.IdPerfilAcessoUsuario;
arParms[2] = new OracleParameter();
arParms[2].ParameterName = "P_ID_PERFIL";
arParms[2].OracleDbType = OracleDbType.Int64;
arParms[2].Direction = ParameterDirection.Input;
arParms[2].Value = perf.IdPerfilAcesso;
arParms[3] = new OracleParameter();
arParms[3].ParameterName = "P_ID_USUARIO";
arParms[3].OracleDbType = OracleDbType.Int64;
arParms[3].Direction = ParameterDirection.Input;
arParms[3].Value = perf.IdUsuario;
oConn.Execute("DNAINFO.P_L_USU_PERF_ACESS", arParms, ref oDT);
}
catch (Exception ex)
{ throw ex; }
finally
{
oConn.CloseConnection();
oConn = null;
}
}
catch (Exception ex)
{ throw ex; }
}
public void PesquisaSearchPF(Entidades.Cadastral.FiltroPesquisaSearchPF filtro, ref DataSet oDS)
{
try
{
ConexaoPersonalizada oConn = new ConexaoPersonalizada();
try
{
OracleParameter[] arParms = new OracleParameter[6];
arParms[0] = new OracleParameter();
arParms[0].ParameterName = "P_NOME";
arParms[0].OracleDbType = OracleDbType.Varchar2;
arParms[0].Direction = ParameterDirection.Input;
arParms[0].Value = filtro.Nome;
arParms[1] = new OracleParameter();
arParms[1].ParameterName = "P_UF";
arParms[1].OracleDbType = OracleDbType.Varchar2;
arParms[1].Direction = ParameterDirection.Input;
if (filtro.UF.Trim().Equals(""))
{
arParms[1].Value = DBNull.Value;
}
else
{
arParms[1].Value = filtro.UF;
}
arParms[2] = new OracleParameter();
arParms[2].ParameterName = "P_CIDADE";
arParms[2].OracleDbType = OracleDbType.Varchar2;
arParms[2].Direction = ParameterDirection.Input;
if (filtro.Cidade.Trim().Equals(""))
{
arParms[2].Value = DBNull.Value;
}
else
{
arParms[2].Value = filtro.Cidade;
}
arParms[3] = new OracleParameter();
arParms[3].ParameterName = "P_DATA_NASCIMENTO";
arParms[3].OracleDbType = OracleDbType.Varchar2;
arParms[3].Direction = ParameterDirection.Input;
if (filtro.DataNascimento.Trim().Equals(""))
{
arParms[3].Value = DBNull.Value;
}
else
{
arParms[3].Value = filtro.DataNascimento;
}
arParms[4] = new OracleParameter();
arParms[4].ParameterName = "P_NOME_MAE";
arParms[4].OracleDbType = OracleDbType.Varchar2;
arParms[4].Direction = ParameterDirection.Input;
if (filtro.NomeMae.Trim().Equals(""))
{
arParms[4].Value = DBNull.Value;
}
else
{
arParms[4].Value = filtro.NomeMae;
}
arParms[5] = new OracleParameter();
arParms[5].ParameterName = "R_CURSOR";
arParms[5].OracleDbType = OracleDbType.RefCursor;
arParms[5].Direction = ParameterDirection.Output;
oConn.Execute("DNAINFO.P_L_WS_RASTREAMENTO_SEARCH_PF", arParms, ref oDS);
}
catch (Exception ex)
{ throw ex; }
finally
{
oConn.CloseConnection();
oConn = null;
}
}
catch (Exception ex)
{ throw ex; }
}
public void Cidades(int idUF, string UF, int idCidade, string NomeCidade, ref DataSet oDS)
{
try
{
ConexaoPersonalizada oConn = new ConexaoPersonalizada();
try
{
OracleParameter[] arParms = new OracleParameter[5];
arParms[0] = new OracleParameter();
arParms[0].ParameterName = "R_CURSOR";
arParms[0].OracleDbType = OracleDbType.RefCursor;
arParms[0].Direction = ParameterDirection.Output;
arParms[1] = new OracleParameter();
arParms[1].ParameterName = "P_UF";
arParms[1].OracleDbType = OracleDbType.Varchar2;
arParms[1].Direction = ParameterDirection.Input;
if (UF.Trim().Equals(""))
{
arParms[1].Value = DBNull.Value;
}
else
{
arParms[1].Value = UF;
}
arParms[2] = new OracleParameter();
arParms[2].ParameterName = "P_ID_UF";
arParms[2].OracleDbType = OracleDbType.Int64;
arParms[2].Direction = ParameterDirection.Input;
arParms[2].Value = idUF;
arParms[3] = new OracleParameter();
arParms[3].ParameterName = "P_ID_CIDADE";
arParms[3].OracleDbType = OracleDbType.Int64;
arParms[3].Direction = ParameterDirection.Input;
arParms[3].Value = idCidade;
arParms[4] = new OracleParameter();
arParms[4].ParameterName = "P_NOME_CIDADE";
arParms[4].OracleDbType = OracleDbType.Varchar2;
arParms[4].Direction = ParameterDirection.Input;
if (NomeCidade.Trim().Equals(""))
{
arParms[4].Value = DBNull.Value;
}
else
{
arParms[4].Value = NomeCidade;
}
oConn.Execute("DNAINFO.P_L_CIDADES", arParms, ref oDS);
}
catch (Exception ex)
{ throw ex; }
finally
{
oConn.CloseConnection();
oConn = null;
}
}
catch (Exception ex)
{ throw ex; }
}
