public string Desativar(TRegistro_Triggers val)
{
System.Collections.Hashtable hs = new System.Collections.Hashtable(0);
string a = " alter table " + val.table_nome + " " + val.ativo + " trigger " + val.trigger_nome + "";
return(this.executarSql(a, hs));
}
private void btn_Inserir_Item_Click(object sender, EventArgs e)
{
using (FCadTrigger trigger = new FCadTrigger())
{
trigger.tb_name = (bsTabelas.Current as TRegistro_Tabelasbd).nome_tabela;
CamadaDados.Diversos.TRegistro_Triggers triggers = new CamadaDados.Diversos.TRegistro_Triggers();
triggers.lColunas = (bsColunas.List as TList_Colunasbd);
trigger.rCol = triggers;
//triggers.trigger_script = (bsTrigger.Current as TRegistro_Triggers).trigger_script;
//trigger.rcoluna =
if (trigger.ShowDialog() == DialogResult.OK)
{
afterbusca();
}
}
}
private void bbalterar_Click(object sender, EventArgs e)
{
using (FCadTrigger trigger = new FCadTrigger())
{
trigger.tb_name = (bsTabelas.Current as TRegistro_Tabelasbd).nome_tabela;
CamadaDados.Diversos.TRegistro_Triggers triggers = new CamadaDados.Diversos.TRegistro_Triggers();
triggers.lColunas = (bsColunas.List as TList_Colunasbd);
triggers.trigger_nome = (bsTrigger.Current as TRegistro_Triggers).trigger_nome;
trigger.rCol = triggers;
triggers.trigger_script = (bsTrigger.Current as TRegistro_Triggers).trigger_script;
if (trigger.ShowDialog() == DialogResult.OK)
{
bsTabelas_PositionChanged(this, new EventArgs());
}
}
}
public string ExecutarTrigger(TRegistro_Triggers val)
{
System.Collections.Hashtable hs = new System.Collections.Hashtable(6);
return(executarSql(val.trigger_script, null));
}
