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