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