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