//-----------------------------------------------
// Select: Consulta de PerUsuGruAcc
//-----------------------------------------------
public DataTable Get_PerUsuGruAcc_Get_Interface(BE_Req_PerUsuGruAcc 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 = "[sp_PerUsuGruAcc_Get_Interface]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
if (Request.cIntJerarquia != "")
{
cm.Parameters.AddWithValue("cIntJerarquia", Request.cIntJerarquia);
}
cm.Parameters.AddWithValue("nSisGruCodigo", Request.nSisGruCodigo);
cm.Parameters.AddWithValue("nSisGruTipo", Request.nSisGruTipo);
cm.Parameters.AddWithValue("nObjTipo", Request.nObjTipo);
if (Request.nIntTipo != -1)
{
cm.Parameters.AddWithValue("nIntTipo", Request.nIntTipo);
}
if (Request.nObjCodigo != -1)
{
cm.Parameters.AddWithValue("nObjCodigo", Request.nObjCodigo);
}
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
dt.Load(dr);
}
}
}
catch (Exception)
{
throw;
}
return(dt);
}
public IList <BE_Res_PerUsuGruAcc> ObtenerPermisos(BE_Req_PerUsuGruAcc Request)
{
BE_Res_PerUsuGruAcc Item = new BE_Res_PerUsuGruAcc();
var lista = new List <BE_Res_PerUsuGruAcc>();
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 = "spTD_Obtener_Permisos";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Parameters.AddWithValue("nSisGruTipo", Request.nSisGruTipo);
cm.Parameters.AddWithValue("nObjTipo", Request.nObjTipo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
lista.Clear();
while (dr.Read())
{
Item = new BE_Res_PerUsuGruAcc();
Item.cPerCodigo = dr.GetString(dr.GetOrdinal("cPerCodigo")).Trim();
Item.cIntNombre = dr.GetString(dr.GetOrdinal("cIntNombre")).Trim();
lista.Add(Item);
//dr.NextResult();
}
dr.Close();
}
}
}
}
catch (Exception)
{
throw;
}
return(lista);
}
public IList <BE_Res_PerUsuGruAcc> obtenerPermisos(BE_Req_PerUsuGruAcc Request)
{
DAPerUsuGruAcc ObjPermisos = new DAPerUsuGruAcc();
return(ObjPermisos.ObtenerPermisos(Request));
}
public DataTable Get_PerUsuGruAcc_Get_Interface(BE_Req_PerUsuGruAcc Request)
{
DAPerUsuGruAcc da = new DAPerUsuGruAcc();
return(da.Get_PerUsuGruAcc_Get_Interface(Request));
}
