public Planilla CodigoPlanilla(string strUsuWebLogin)
{
Planilla objPlanillaRS = null;
var nmOracle = new Conexion();
OracleConnection connection;
using (connection = new OracleConnection(nmOracle.strCadena))
{
if (nmOracle.Connect(connection, false))
{
nmOracle.SP_Command(nmOracle.Esquema + ".PKG_PERSONAL.SP_PERS_OBTIENE_X_LOGIN", nmOracle.strStoredProcedure);
nmOracle.AgregarParametro("pVarLogin_in", strUsuWebLogin.ToString(), OracleDbType.Varchar2, ParameterDirection.Input);
nmOracle.AgregarParametro("pCurResult_out", null, OracleDbType.RefCursor, ParameterDirection.Output);
var datareade = nmOracle._ExecuteReader(false);
if (datareade.HasRows)
{
while (datareade.Read())
{
objPlanillaRS = new Planilla
{
strIdEmpresaPlanilla = nmOracle.LeeColumnasDataReader(datareade, "ID_EMPRESA_PLANILLA", "-1"),
strIdCodigoPlanilla = nmOracle.LeeColumnasDataReader(datareade, "ID_CODIGO_PLANILLA", "-1")
};
}
}
}
}
return(objPlanillaRS);
}