public SelectSubMenu ( |
||
oENTSubMenu | Entidad de SubMenu con los filtros necesarios para la consulta | |
return |
void SelectSubMenu(ENTSubMenu oENTSubMenu) { ENTResponse oENTResponse = new ENTResponse(); BPSubMenu oBPSubMenu = new BPSubMenu(); try{ // Transacción oENTResponse = oBPSubMenu.SelectSubMenu(oENTSubMenu); // Validaciones if (oENTResponse.GeneratesException) { throw (new Exception(oENTResponse.sErrorMessage)); } // Transacción exitosa ExportExcel(oENTResponse.dsResponse.Tables[2], "SubMenu"); }catch (Exception ex){ throw (ex); } }
private void SelectSubMenu() { ENTSubMenu oENTSubMenu = new ENTSubMenu(); ENTResponse oENTResponse = new ENTResponse(); ENTSession oENTSession; BPSubMenu oBPSubMenu = new BPSubMenu(); String sMessage = ""; try { // Información de Sesión oENTSession = (ENTSession)this.Session["oENTSession"]; // Formulario oENTSubMenu.idRol = oENTSession.idRol; oENTSubMenu.idSubMenu = 0; oENTSubMenu.idMenu = Int32.Parse(this.ddlMenu.SelectedItem.Value); oENTSubMenu.sNombre = this.txtNombre.Text; oENTSubMenu.tiActivo = Int16.Parse(this.ddlStatus.SelectedItem.Value); // Transacción oENTResponse = oBPSubMenu.SelectSubMenu(oENTSubMenu); // Validaciones if (oENTResponse.GeneratesException) { throw (new Exception(oENTResponse.sErrorMessage)); } // Mensaje de la BD if (oENTResponse.sMessage != "") { sMessage = "alert('" + gcJavascript.ClearText(oENTResponse.sMessage) + "');"; } // Llenado de controles this.gvSubMenu.DataSource = oENTResponse.dsResponse.Tables[1]; this.gvSubMenu.DataBind(); // Mensaje al usuario ScriptManager.RegisterStartupScript(this.Page, this.GetType(), Convert.ToString(Guid.NewGuid()), sMessage, true); } catch (Exception ex) { throw (ex); } }
private void SelectSubMenu_ForEdit(Int32 idSubMenu) { ENTSubMenu oENTSubMenu = new ENTSubMenu(); ENTResponse oENTResponse = new ENTResponse(); ENTSession oENTSession; BPSubMenu oBPSubMenu = new BPSubMenu(); try { // Información de Sesión oENTSession = (ENTSession)this.Session["oENTSession"]; // Formulario oENTSubMenu.idRol = oENTSession.idRol; oENTSubMenu.idSubMenu = idSubMenu; oENTSubMenu.idMenu = 0; oENTSubMenu.sNombre = ""; oENTSubMenu.tiActivo = 2; // Transacción oENTResponse = oBPSubMenu.SelectSubMenu(oENTSubMenu); // Validaciones if (oENTResponse.GeneratesException) { throw (new Exception(oENTResponse.sErrorMessage)); } // Mensaje de la BD this.lblActionMessage.Text = oENTResponse.sMessage; // Llenado de formulario this.ddlActionMenu.SelectedValue = oENTResponse.dsResponse.Tables[1].Rows[0]["idMenu"].ToString(); this.txtActionNombre.Text = oENTResponse.dsResponse.Tables[1].Rows[0]["sNombreSubMenu"].ToString(); this.txtActionDescripcion.Text = oENTResponse.dsResponse.Tables[1].Rows[0]["sDescripcion"].ToString(); this.txtActionPageName.Text = oENTResponse.dsResponse.Tables[1].Rows[0]["sPageName"].ToString(); this.txtActionURL.Text = oENTResponse.dsResponse.Tables[1].Rows[0]["sURL"].ToString(); this.ddlActionStatus.SelectedValue = oENTResponse.dsResponse.Tables[1].Rows[0]["tiActivo"].ToString(); this.ddlActionRequired.SelectedValue = oENTResponse.dsResponse.Tables[1].Rows[0]["tiRequired"].ToString(); } catch (Exception ex) { throw (ex); } }
private void SelectSubMenu_ForViewState() { ENTSubMenu oENTSubMenu = new ENTSubMenu(); ENTResponse oENTResponse = new ENTResponse(); ENTSession oENTSession; BPSubMenu oBPSubMenu = new BPSubMenu(); DataTable tblSubMenu = null; DataRow rowSubMenu = null; try { // Información de Sesión oENTSession = (ENTSession)this.Session["oENTSession"]; // Formulario oENTSubMenu.idRol = oENTSession.idRol; oENTSubMenu.idSubMenu = 0; oENTSubMenu.idMenu = 0; oENTSubMenu.sNombre = ""; oENTSubMenu.tiActivo = 1; // Transacción oENTResponse = oBPSubMenu.SelectSubMenu(oENTSubMenu); // Validaciones if (oENTResponse.GeneratesException) { throw (new Exception(oENTResponse.sErrorMessage)); } // Mensaje de la BD if (oENTResponse.sMessage != "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), Convert.ToString(Guid.NewGuid()), "alert('" + gcJavascript.ClearText(oENTResponse.sMessage) + "');", true); } // Definición del DataTable tblSubMenu = new DataTable("tblSubMenu"); tblSubMenu.Columns.Add("idMenu", typeof(Int32)); tblSubMenu.Columns.Add("idSubMenu", typeof(Int32)); tblSubMenu.Columns.Add("sNombreMenu", typeof(String)); tblSubMenu.Columns.Add("sNombreSubMenu", typeof(String)); tblSubMenu.Columns.Add("tiSelected", typeof(Int32)); tblSubMenu.Columns.Add("tiRequired", typeof(Int32)); // Llenado de DataTable foreach (DataRow rowCurrentSubMenu in oENTResponse.dsResponse.Tables[1].Rows) { rowSubMenu = tblSubMenu.NewRow(); rowSubMenu["idMenu"] = rowCurrentSubMenu["idMenu"]; rowSubMenu["idSubMenu"] = rowCurrentSubMenu["idSubMenu"]; rowSubMenu["sNombreMenu"] = rowCurrentSubMenu["sNombreMenu"]; rowSubMenu["sNombreSubMenu"] = rowCurrentSubMenu["sNombreSubMenu"]; rowSubMenu["tiSelected"] = rowCurrentSubMenu["tiRequired"]; rowSubMenu["tiRequired"] = rowCurrentSubMenu["tiRequired"]; tblSubMenu.Rows.Add(rowSubMenu); } // Almacenar en ViewState this.ViewState["tblSubMenu"] = tblSubMenu; this.ViewState["tblSubMenu_Filtered"] = this.ViewState["tblSubMenu"]; // Llenado de controles this.gvActionSubMenu.DataSource = tblSubMenu; this.gvActionSubMenu.DataBind(); } catch (Exception ex) { throw (ex); } }