Exemple #1
0
        //-------------------------------------
        // Ingresos por Laboratorio y Convenios
        //-------------------------------------
        public DataTable Get_Ingresos_LabExt_Convenio_by_rango_fechas(ReqRptParametros Request)
        {
            DataTable dt = new DataTable();

            try
            {
                clsConection Obj    = new clsConection();
                string       Cadena = Obj.GetConexionString("Naylamp");

                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[usp_Get_Ingresos_LabExt_Convenio_by_rango_fechas]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("dFecIni", Request.dFecIni);
                        cm.Parameters.AddWithValue("dFecFin", Request.dFecFin);
                        cm.Parameters.AddWithValue("nFlag", Request.nFlag);

                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemple #2
0
        //-------------------------------------------------------------------
        // Detalle de Ventas según Fecha de Atención agrupado por Tipo de Atención
        //-------------------------------------------------------------------
        public DataTable Get_Detalle_Venta_by_Tipo_FechaAtencion_Group_cPerJurCodigo(ReqRptParametros Request)
        {
            DataTable dt = new DataTable();

            try
            {
                clsConection Obj    = new clsConection();
                string       Cadena = Obj.GetConexionString("Naylamp");

                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[usp_Get_Detalle_Venta_by_Tipo_FechaAtencion_Group_cPerJurCodigo]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("cPerJurCodigo ", Request.cPerJuridica);
                        cm.Parameters.AddWithValue("cFecIni", Request.cFecIni);
                        cm.Parameters.AddWithValue("cFecFin", Request.cFecFin);
                        cm.Parameters.AddWithValue("nflagFiltro", Request.nFlagFiltro);

                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemple #3
0
        //---------------------------------------------------------------------------------------
        // Detalle Importe Derivacion Get_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin
        //---------------------------------------------------------------------------------------
        public DataTable Get_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin(ReqRptParametros Request)
        {
            DataTable dt = new DataTable();

            try
            {
                clsConection Obj    = new clsConection();
                string       Cadena = Obj.GetConexionString("Naylamp");

                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[usp_Get_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("cPerCodMedico ", Request.cPerCodMedico);
                        cm.Parameters.AddWithValue("dFecIni", Request.dFecIni);
                        cm.Parameters.AddWithValue("dFecFin", Request.dFecFin);

                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemple #4
0
        //------------------------------------------------
        // Ventas según Fecha de Atención por Turnos
        //------------------------------------------------
        public DataTable Get_Ventas_Group_PerJur_Turno_TipoAtencion_by_Fechas(ReqRptParametros Request)
        {
            DataTable dt = new DataTable();

            try
            {
                clsConection Obj    = new clsConection();
                string       Cadena = Obj.GetConexionString("Naylamp");

                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[usp_RRHH_Get_Ventas_Group_PerJur_Turno_TipoAtencion_by_Fechas]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("cFechaIni", Request.cFecIni);
                        cm.Parameters.AddWithValue("cFechaFin", Request.cFecFin);

                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemple #5
0
        public DataTable Get_Ranking_Grupo_Examenes(ReqRptParametros reqRptParametros)
        {
            DataTable dt = new DataTable();

            try
            {
                clsConection Obj    = new clsConection();
                string       Cadena = Obj.GetConexionString("Naylamp");

                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();
                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[usp_Get_Ranking_Grupo_Examenes]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("cCtaCteSerJerarquia", reqRptParametros.cIntJerarquia);
                        cm.Parameters.AddWithValue("dFecIni", reqRptParametros.cFecIni);
                        cm.Parameters.AddWithValue("dFecFin", reqRptParametros.cFecFin);
                        cm.Parameters.AddWithValue("cFlag", reqRptParametros.cTipo);

                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
        //----------------------------------------------------
        //Reporte de Ventas según Fecha de Atención y Turnos
        //----------------------------------------------------
        public DataTable Get_Ventas_Group_PerJur_Turno_TipoAtencion_by_Fechas(string cFecIni, string cFecFin)
        {
            //Recuperando...
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.cFecIni = cFecIni;
            Request.cFecFin = cFecFin;

            return(Obj.Get_Ventas_Group_PerJur_Turno_TipoAtencion_by_Fechas(Request));
        }
        //------------------ 2017-03-03 ------------------------
        // Ver Historial Medico Detalle for (App ANDROID) -EINCIO
        //------------------------------------------------------
        public DataTable Android_Get_Medico_and_comision_Detalle(string cPerCodigo, string FecIni, string FecFin)
        {
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.cPerCodigo = cPerCodigo;
            Request.cFecIni    = FecIni;
            Request.cFecFin    = FecFin;

            //Recuperando...
            return(Obj.Android_Get_Medico_and_comision_Detalle(Request));
        }
        //------------------ 2017-01-24 ------------------------
        // Ver Comision Medico por Promotor for (App ANDROID) -EINCIO
        //------------------------------------------------------
        public DataTable Android_Get_Medico_and_comision(string ApeDoctor, string FecIni, string FecFin)
        {
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.cApeDoctor = ApeDoctor;
            Request.cFecIni    = FecIni;
            Request.cFecFin    = FecFin;

            //Recuperando...
            return(Obj.Android_Get_Medico_and_comision(Request));
        }
        //---------------------------------------------------------------------------------------
        // Detalle Importe Derivacion Get_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin
        //---------------------------------------------------------------------------------------
        public DataTable Get_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin(string cPerCodMedico, DateTime dFecIni, DateTime dFecFin)
        {
            //Recuperando...
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.cPerCodMedico = cPerCodMedico;
            Request.dFecIni       = dFecIni;
            Request.dFecFin       = dFecFin;

            return(Obj.Get_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin(Request));
        }
        //-------------------------------------
        // Ingresos por Laboratorio y Convenios
        //-------------------------------------
        public DataTable Get_Ingresos_LabExt_Convenio_by_rango_fechas(DateTime dFecIni, DateTime dFecFin, string nFlag = "P")
        {
            //Recuperando...
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.dFecIni = dFecIni;
            Request.dFecFin = dFecFin;
            Request.nFlag   = nFlag;

            return(Obj.Get_Ingresos_LabExt_Convenio_by_rango_fechas(Request));
        }
        //-------------------------------------------------------------------
        // Reporte por Sucursal y Rango de fechas
        //-------------------------------------------------------------------
        public DataTable Get_Venta_by_cPerJurCodigo_and_fecini_fecfin(string cPerJurCodigo, DateTime dFecIni, DateTime dFecFin)
        {
            //Recuperando...
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.cPerJuridica = cPerJurCodigo;
            Request.dFecIni      = dFecIni;
            Request.dFecFin      = dFecFin;

            return(Obj.Get_Venta_by_cPerJurCodigo_and_fecini_fecfin(Request));
        }
        //-------------------------------------------------------------------
        // Reporte por Sucursal según Fecha de Atención
        //-------------------------------------------------------------------
        public DataTable Get_Venta_by_cPerJurCodigo_and_FechaAtencion(string cPerJurCodigo, string cFecIni, string cFecFin)
        {
            //Recuperando...
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.cPerJuridica = cPerJurCodigo;
            Request.cFecIni      = cFecIni;
            Request.cFecFin      = cFecFin;

            return(Obj.Get_Venta_by_cPerJurCodigo_and_FechaAtencion(Request));
        }
        //------------------------------------------------------------------------------
        // Reporte por Sucursal según Fecha de Atención y agrupado por Tipo de Atención
        //------------------------------------------------------------------------------
        public DataTable Get_Detalle_Venta_by_Tipo_FechaAtencion_Group_cPerJurCodigo(string cPerJurCodigo, string cFecIni, string cFecFin, string cFlagFiltro)
        {
            //Recuperando...
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.cPerJuridica = cPerJurCodigo;
            Request.cFecIni      = cFecIni;
            Request.cFecFin      = cFecFin;
            Request.nFlagFiltro  = cFlagFiltro;

            return(Obj.Get_Detalle_Venta_by_Tipo_FechaAtencion_Group_cPerJurCodigo(Request));
        }
        //---------------------------------------------------------------------
        // Reporte Ventas por Promotor en TEXTO (by App Android) VENTA SIN IGV
        //---------------------------------------------------------------------
        public DataTable Get_Android_MetaPromotor_Avance_By_Promotor(string cFlag, string cFecIni, string cFecFin, string cPerPromCodigo)
        {
            //Recuperando...
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.nFlag           = cFlag;
            Request.cFecIni         = cFecIni;
            Request.cFecFin         = cFecFin;
            Request.cPerCodPromotor = cPerPromCodigo;

            return(Obj.Get_Android_MetaPromotor_Avance_By_Promotor(Request));
        }
        //------------------------------------------------------------------------------------------
        //Reporte Resumen y Detalle de Pruebas Pendientes de Facturación (Lab. Externo / Convenios)
        //------------------------------------------------------------------------------------------
        public DataTable Get_LabConv_Pendientes_de_Facturacion_By_RangoFecha(string FecIni, string FecFin, string cPerCodigoTerceros = "")
        {
            //Recuperando...
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.cPerCodigoTerceros = cPerCodigoTerceros;
            Request.cFecIni            = FecIni;
            Request.cFecFin            = FecFin;


            return(Obj.Get_LabConv_Pendientes_de_Facturacion_By_RangoFecha(Request));
        }
        //VENTAS DIARIAS SEGÚN REPORTE
        public DataTable Get_VentasDiarias_Segun_Reporte(string cPrdIni = "", string cPrdFin = "", string cFlagReporte = "", string cPerPromCodigo = "")
        {
            //Recuperando...
            ReqRptParametros Request = new ReqRptParametros();

            Request.nFlag           = cFlagReporte;
            Request.cFecIni         = cPrdIni;
            Request.cFecFin         = cPrdFin;
            Request.cPerCodPromotor = cPerPromCodigo;

            DARptMaster Obj = new DARptMaster();

            return(Obj.Get_VentasDiarias_Segun_Reporte(Request));
        }
        //------------------ 2016-06-09 ------------------------
        // Ver Comision Medico por Promotor for (App ANDROID) -EINCIO
        //------------------------------------------------------
        public DataTable Android_Comisiones_By_Promotor(string FecIni, string FecFin, string cPerUsuCodigo, int nFlagTodos = 0, string cTipo = "R", string cPerCodMedico = "", Int32 nFlagComision = 1)
        {
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.cFecIni       = FecIni;
            Request.cFecFin       = FecFin;
            Request.cPerUsuCodigo = cPerUsuCodigo;
            Request.nFlagTodos    = nFlagTodos;
            Request.cTipo         = cTipo;
            Request.cPerCodMedico = cPerCodMedico;
            Request.nFlagComision = nFlagComision;

            //Recuperando...
            return(Obj.Android_Comisiones_By_Promotor(Request));
        }
        //---------------------------------------------------------------------------------
        // Detalle de Saldos agrupado por Clientes y filtro por Rango de fechas for Android
        //---------------------------------------------------------------------------------
        public DataTable Get_Android_Detalle_Saldo_Venta_by_fecini_fecfin_Group_cPerCodigo(string cPerJurCodigo, string cFecIni,
                                                                                           string cFecFin, string nflagFiltro, string nflag)
        {
            //Recuperando...
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.cPerJuridica = cPerJurCodigo;
            Request.cFecIni      = cFecIni;
            Request.cFecFin      = cFecFin;

            Request.nFlagFiltro = nflagFiltro;
            Request.nFlag       = nflag;

            return(Obj.Get_Android_Detalle_Saldo_Venta_by_fecini_fecfin_Group_cPerCodigo(Request));
        }
        //-------------------------------------------------------------------
        // Comsión Doctores usp_Get_ComisionMedico_by_cPerJuridica_cPerMedico
        //-------------------------------------------------------------------
        public DataTable Get_ComisionMedico_by_cPerJuridica_cPerMedico(string cPerJuridica, string cPerCodMedico, DateTime dFecIni, DateTime dFecFin, string nFlag = "G", string cPerCodPromotor = "")
        {
            //Recuperando...
            ReqRptParametros Request = new ReqRptParametros();
            DARptMaster      Obj     = new DARptMaster();

            Request.cPerJuridica  = cPerJuridica;
            Request.cPerCodMedico = cPerCodMedico;
            Request.dFecIni       = dFecIni;
            Request.dFecFin       = dFecFin;


            Request.nFlag           = nFlag;
            Request.cPerCodPromotor = cPerCodPromotor;

            return(Obj.Get_ComisionMedico_by_cPerJuridica_cPerMedico(Request));
        }
Exemple #20
0
        //------------------ 2016-06-09 ------------------------
        // Ver Comision Medico por Promotor for (App ANDROID) -EINCIO
        //------------------------------------------------------
        public DataTable Android_Comisiones_By_Promotor(ReqRptParametros Request)
        {
            DataTable dt = new DataTable();

            try
            {
                clsConection Obj = new clsConection();

                //string Cadena = Obj.GetConexionString("Naylamp");
                string Cadena = "Server=10.0.0.10\\SRVDATOSMED; DataBase = BDDatos; Uid = android; Pwd =C2879442C28147B;Integrated Security=False; Pooling = False";

                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[Android].[usp_Android_Comisiones_By_Promotor]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("cFecIni", Request.cFecIni);
                        cm.Parameters.AddWithValue("cFecFin", Request.cFecFin);
                        cm.Parameters.AddWithValue("cPerUsuCodigo", Request.cPerUsuCodigo);
                        cm.Parameters.AddWithValue("nFlagTodos", Request.nFlagTodos);
                        cm.Parameters.AddWithValue("cTipo", Request.cTipo);
                        cm.Parameters.AddWithValue("cPerCodMedico", Request.cPerCodMedico);
                        cm.Parameters.AddWithValue("nFlagComision", Request.nFlagComision);

                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemple #21
0
        //------------------------------------------------
        // Ventas según Fecha de Atención por Turnos
        //------------------------------------------------
        public DataTable Get_VentasDiarias_Segun_Reporte(ReqRptParametros Request)
        {
            DataTable dt = new DataTable();

            try
            {
                clsConection Obj    = new clsConection();
                string       Cadena = Obj.GetConexionString("Naylamp");

                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[usp_Admision_Get_Ventas_by_Fechas_Reporte]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("cFechaIni", Request.cFecIni);
                        cm.Parameters.AddWithValue("cFechaFin", Request.cFecFin);
                        cm.Parameters.AddWithValue("cFlag", Request.nFlag);
                        if (!Request.cPerCodPromotor.Equals(""))
                        {
                            cm.Parameters.AddWithValue("cPromCodigo", Request.cPerCodPromotor);
                        }

                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemple #22
0
        //------------------------------------------------
        // Laboratorios con Pagos Pendientes de Facturar
        //------------------------------------------------
        public DataTable Get_LabConv_Pendientes_de_Facturacion_By_RangoFecha(ReqRptParametros Request)
        {
            DataTable dt = new DataTable();

            try
            {
                clsConection Obj    = new clsConection();
                string       Cadena = Obj.GetConexionString("Naylamp");

                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[usp_Admision_Get_LabConv_Pendientes_de_Facturacion_By_RangoFecha]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("cFecIni", Request.cFecIni);
                        cm.Parameters.AddWithValue("cFecFin", Request.cFecFin);
                        if (Request.cPerCodPromotor != "")
                        {
                            cm.Parameters.AddWithValue("cPerCodigoTerceros", Request.cPerCodigoTerceros);
                        }

                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemple #23
0
        //-------------------------------------
        // b).- Agrupado por Sucursal y Turno
        //-------------------------------------

        public DataTable Get_Ventas_Group_cPerJur_Turno_TipoAtencion_by_Fechas(ReqRptParametros Request)
        {
            DataTable dt = new DataTable();

            try
            {
                clsConection Obj = new clsConection();

                //string Cadena = Obj.GetConexionString("Naylamp");
                string Cadena = "Server=10.0.0.10\\SRVDATOSMED; DataBase = BDDatos; Uid = android; Pwd =C2879442C28147B;Integrated Security=False; Pooling = False";

                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[Android].[usp_Get_Ventas_Group_cPerJur_Turno_TipoAtencion_by_Fechas]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("cPerJuridica ", Request.cPerJuridica);
                        cm.Parameters.AddWithValue("cFechaIni", Request.cFecIni);
                        cm.Parameters.AddWithValue("cFechaFin", Request.cFecFin);

                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
        public DataTable Get_Ranking_Grupo_Examenes(ReqRptParametros reqRptParametros)
        {
            CtaCteListaServicioDAOSQLServer ctaCteListaServicioDAOSQLServer = new CtaCteListaServicioDAOSQLServer();

            return(ctaCteListaServicioDAOSQLServer.Get_Ranking_Grupo_Examenes(reqRptParametros));
        }
Exemple #25
0
        //-------------------------------------------------------------------
        // Detalle de Saldos agrupado por Clientes y filtro por Rango de fechas for Android
        //-------------------------------------------------------------------
        public DataTable Get_Android_Detalle_Saldo_Venta_by_fecini_fecfin_Group_cPerCodigo(ReqRptParametros Request)
        {
            DataTable dt = new DataTable();

            try
            {
                clsConection Obj = new clsConection();
                //string Cadena = Obj.GetConexionString("Naylamp");
                string Cadena = "Server=10.0.0.10\\SRVDATOSMED; DataBase = BDDatos; Uid = android; Pwd =C2879442C28147B;Integrated Security=False; Pooling = False";


                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[usp_Get_Detalle_Saldo_Venta_by_fecini_fecfin_Group_cPerCodigo]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("cPerJurCodigo ", Request.cPerJuridica);
                        cm.Parameters.AddWithValue("fecini", Request.cFecIni);
                        cm.Parameters.AddWithValue("fecfin", Request.cFecFin);
                        cm.Parameters.AddWithValue("nflagFiltro", Request.nFlagFiltro);
                        cm.Parameters.AddWithValue("nflag", Request.nFlag);

                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemple #26
0
        //--------------------------------------------------------------------------
        // en SqlDataReader: Obtiene List Reporte Admision por Permisos PerUsuGruAcc
        //--------------------------------------------------------------------------
        public List <BE_Res_Interface> Get_List_Report_by_cIntJerarquia_and_cPerCodigo(ReqRptParametros Request)
        {
            BE_Res_Interface Item = new BE_Res_Interface();
            var lista             = new List <BE_Res_Interface>();

            try
            {
                clsConection Obj    = new clsConection();
                string       Cadena = Obj.GetConexionString("Naylamp");

                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[usp_Get_List_Report_by_cIntJerarquia_and_cPerCodigo]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("nIntClase", Request.nIntClase);
                        cm.Parameters.AddWithValue("cIntJerarquia", Request.cIntJerarquia);
                        cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);

                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                        {
                            lista.Clear();
                            while (dr.Read())
                            {
                                Item = new BE_Res_Interface();
                                //Item.nIntClase = dr.GetInt32(dr.GetOrdinal("nIntClase"));
                                //Item.nIntCodigo = dr.GetInt32(dr.GetOrdinal("nIntCodigo"));
                                Item.nIntTipo        = dr.GetInt32(dr.GetOrdinal("nIntTipo"));
                                Item.cIntDescripcion = dr.GetString(dr.GetOrdinal("cIntDescripcion")).Trim();
                                Item.cIntJerarquia   = dr.GetString(dr.GetOrdinal("cIntJerarquia")).Trim();
                                Item.cIntNombre      = dr.GetString(dr.GetOrdinal("cIntNombre")).Trim();
                                lista.Add(Item);
                            }
                            dr.Close();
                        }
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(lista);
        }
        //--------------------------------------------------------------------------
        // en SqlDataReader: Obtiene List Reporte Admision por Permisos PerUsuGruAcc
        //--------------------------------------------------------------------------
        public List <BE_Res_Interface> Get_List_Report_by_cIntJerarquia_and_cPerCodigo(ReqRptParametros Request)
        {
            DARptMaster Obj = new DARptMaster();

            return(Obj.Get_List_Report_by_cIntJerarquia_and_cPerCodigo(Request));
        }