protected void Page_Load(object sender, EventArgs e) { if (!ValidarConexionYUsuarioLogueado(sender)) { return; } try { if (Session["UiQueryList"] != null) { UiQueryList.DataSource = Session["UiQueryList"]; UiQueryList.DataBind(); } if (Session["UiLookupTeam"] != null) { UiLookupTeam.DataSource = Session["UiLookupTeam"]; UiLookupTeam.DataBind(); } if (Session["UiGridLookupListaQuery"] != null) { UiGridLookupListaQuery.DataSource = Session["UiGridLookupListaQuery"]; UiGridLookupListaQuery.DataBind(); } } catch (Exception ex) { EstablecerError(ex.Message, sender); } }
public void CargarConsulta() { try { var pResult = ""; var LoginId = Session["LOGIN"].ToString(); var IdQuery = UiGridLookupListaQuery.Text.Split(';')[0]; var QueryTitle = UiGridLookupListaQuery.Text.Split(';')[1]; var sWhere = ""; var ds = _objQueryList.GetQuerySelected(Session["connectionString"].ToString(), Convert.ToInt32(IdQuery), sWhere, LoginId, ref pResult); if (pResult == "") { Session["UiQueryList"] = ds; UiQueryList.Columns.Clear(); UiQueryList.AutoGenerateColumns = true; UiQueryList.KeyFieldName = string.Empty; UiQueryList.DataSource = ds; UiQueryList.FilterExpression = ""; UiQueryList.Caption = QueryTitle.ToString(); UiQueryList.DataBind(); CargarLayout(LoginId, Convert.ToInt32(IdQuery)); CargaPermisos(IdQuery); ((ASPxGridView)(UiQueryList)).JSProperties.Add("cpTerminoDeProcesarQuery", true); } else { Session["UiQueryList"] = null; UiQueryList.DataSource = null; UiQueryList.KeyFieldName = string.Empty; UiQueryList.Caption = ""; UiQueryList.FilterExpression = ""; UiQueryList.Columns.Clear(); UiQueryList.DataBind(); UiLookupTeam.Text = ""; ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + pResult + "');", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }