//----------------------------------------------- // 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)); }