public DataTable GetMenu_By_Persona_Clase(BE_ReqMenu Request) { long Resultado = 0; DataTable Item = 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_Web_Get_Permisos"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nIntClase", Request.nIntClase); cm.Parameters.AddWithValue("nSisGruTipo", Request.nSisGruTipo); cm.Parameters.AddWithValue("nSisGruCodigo", Request.nSisGruCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Item.Load(dr); } } } } catch (Exception) { throw; } return(Item); }
public DataTable GetMenu_By_Persona_Clase(BE_ReqMenu Request) { DA_Menu ObjMenu = new DA_Menu(); return(ObjMenu.GetMenu_By_Persona_Clase(Request)); }