//--------------------------------------------------------------------------
// 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);
}
public IList <BE_Res_Interface> ObtenerPermisosMenu(BE_Req_PermisosMenu 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_General_Get_PermisosMenu_By_Modulo_Per";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Parameters.AddWithValue("cModulo", Request.cModulo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
lista.Clear();
while (dr.Read())
{
Item = new BE_Res_Interface();
Item.cIntJerarquia = dr.GetString(dr.GetOrdinal("cIntJerarquia")).Trim();
Item.cIntNombre = dr.GetString(dr.GetOrdinal("cIntNombre")).Trim();
Item.cIntDescripcion = dr.GetString(dr.GetOrdinal("cIntDescripcion")).Trim();
Item.nIntTipo = dr.GetInt32(dr.GetOrdinal("nIntTipo"));
lista.Add(Item);
//dr.NextResult();
}
dr.Close();
}
}
}
}
catch (Exception)
{
throw;
}
return(lista);
}
public BE_Res_Interface getInterface(BE_Req_Interface Request)
{
BE_Res_Interface Item = new 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 = "sp_get_Interface";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("nIntClase", Request.nIntClase);
cm.Parameters.AddWithValue("nIntCodigo", Request.nIntCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
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"));
Item.cIntJerarquia = dr.GetString(dr.GetOrdinal("cIntJerarquia"));
Item.cIntNombre = dr.GetString(dr.GetOrdinal("cIntNombre"));
}
}
}
}
}
catch (Exception)
{
throw;
}
return(Item);
}
