public void OnShow() { try { if (StringConnection.Equals("")) StringConnection = CapaDatos.Datos.ConnectionString; Storer st = new WebHelper.Storer(Tipo); st.Valores = ValoresCombo; st.ValoresCombo = ValoresCombo; if (Insert.Equals("")) Insert = st.GetInsert(); if (Select.Equals("")) Select = st.GetSelect(); if (Update.Equals("")) Update = st.GetUpdate(); if (Delete.Equals("")) Delete = st.GetDelete(); this.SqlDataSource1.ProviderName = "MySql.Data.MySqlClient"; this.SqlDataSource1.ConnectionString = StringConnection; this.SqlDataSource1.InsertCommand = Insert; this.SqlDataSource1.SelectCommand = Select; this.SqlDataSource1.UpdateCommand = Update; this.SqlDataSource1.DeleteCommand = Delete; st.ObjectToSqlDataSource(ref SqlDataSource1); st.ObjectToStore(ref Store1); // st.ObjectToGridPanel(ref GridPanel1); // Permisos de la tabla if (Permisos == null) Permisos = ContabilidadGlobal.Admin.Permisos; if (!Permisos.Alta) { this.btnInsert.Enabled = false; this.btnInsert.Hide(); if (!Permisos.Modif) { this.btnSave.Enabled = false; this.btnSave.Hide(); } } if (!Permisos.Baja) { this.btnDelete.Enabled = false; this.btnDelete.Hide(); } cargarFiltros(st); } catch (Exception ex) { UIHelper.MostrarExcepcionSimple(ex, "Error"); } }
/// <summary> /// Actualiza las consultas si se modificaron los sqlvalor. /// </summary> public void ActualizarConsultas() { try { Storer st = new WebHelper.Storer(Tipo); st.Valores = Valores; Insert = st.GetInsert(); Select = st.GetSelect(); Update = st.GetUpdate(); Delete = st.GetDelete(); this.SqlDataSource1.InsertCommand = Insert; this.SqlDataSource1.SelectCommand = Select; this.SqlDataSource1.UpdateCommand = Update; this.SqlDataSource1.DeleteCommand = Delete; //Solución mágica this.Store1.DataBind(); // Linea mágica que trae los nuevos registros this.GridPanel1.Reconfigure(); } #if DEBUG catch(Exception ex) { UIHelper.MostrarExcepcionSimple(ex, "Error al actualizar referencias"); } #else catch { UIHelper.MostrarError("Por favor, recargue la página para solucionar el problema. Si este persiste, por favor, comuníquese con el área de soporte técnico.", "Error al actualizar referencias"); } #endif }
public void OnShow() { try { if (StringConnection.Equals("")) StringConnection = CapaDatos.Datos.ConnectionString; Storer st = new WebHelper.Storer(Tipo); if (Insert.Equals("")) Insert = st.GetInsert(); if (Select.Equals("")) Select = st.GetSelect(); if (Update.Equals("")) Update = st.GetUpdate(); if (Delete.Equals("")) Delete = st.GetDelete(); this.SqlDataSource1.ProviderName = "MySql.Data.MySqlClient"; this.SqlDataSource1.ConnectionString = StringConnection; this.SqlDataSource1.InsertCommand = Insert; this.SqlDataSource1.SelectCommand = Select; this.SqlDataSource1.UpdateCommand = Update; this.SqlDataSource1.DeleteCommand = Delete; st.ObjectToSqlDataSource(ref SqlDataSource1); st.ObjectToStore(ref Store1); } catch (Exception ex) { UIHelper.MostrarExcepcionSimple(ex, "Error"); } }
public void OnShow() { try { //Harcoded here if (StringConnection.Equals("")) StringConnection = CapaDatos.Datos.ConnectionString; //End hard Storer st = new WebHelper.Storer(Tipo); st.Valores = Valores; st.ValoresCombo = ValoresCombo; if (Insert.Equals("")) Insert = st.GetInsert(); if (Select.Equals("")) Select = st.GetSelect(); if (Update.Equals("")) Update = st.GetUpdate(); if (Delete.Equals("")) Delete = st.GetDelete(); this.SqlDataSource1.ProviderName = "MySql.Data.MySqlClient"; this.SqlDataSource1.ConnectionString = StringConnection; this.SqlDataSource1.InsertCommand = Insert; this.SqlDataSource1.SelectCommand = Select; this.SqlDataSource1.UpdateCommand = Update; this.SqlDataSource1.DeleteCommand = Delete; st.ObjectToSqlDataSource(ref SqlDataSource1); st.ObjectToStore(ref Store1); st.ObjectToGridPanel(ref GridPanel1); //Aplicar cuestiones de seguridad if (Permisos == null) { Permisos = Permisos.PermisosAdmin; } if (!Permisos.Alta) { this.btnInsert.Enabled = false; if (!Permisos.Modif) { this.btnSave.Enabled = false; } } if (!Permisos.Baja) { this.btnDelete.Enabled = false; } } catch (Exception ex) { UIHelper.MostrarExcepcionSimple(ex, "Error"); } }