private void tsBB_AddConsulta_Click(object sender, EventArgs e) { try { TFCad_SQL fSQL = new TFCad_SQL(new TRegistro_Cad_Consulta(), true); fSQL.Homologacao = true; fSQL.pNMConsulta.Visible = true; fSQL.ShowDialog(); if (!string.IsNullOrEmpty(fSQL.Cad_Consulta.DS_SQL)) { //ADD OS DADOS QUE FALTA fSQL.Cad_Consulta.DS_Consulta = fSQL.NM_Consulta.Text; fSQL.Cad_Consulta.ID_Consulta = System.Guid.NewGuid().ToString(); fSQL.Cad_Consulta.Login = Utils.Parametros.pubLogin; //ADD AO BIND lConsulta.Add(fSQL.Cad_Consulta); (BS_Relatorio.Current as TRegistro_Cad_Report).lConsulta.Add(fSQL.Cad_Consulta); BS_Relatorio.ResetBindings(true); } } catch (Exception erro) { MessageBox.Show("ERRO: " + erro.Message, "Mensagem"); } }
private void BB_Remover_Click(object sender, EventArgs e) { if (treeConsulta.SelectedNode != null) { try { TreeNode no = treeConsulta.SelectedNode; if (!((BS_Relatorio.Current as TRegistro_Cad_Report).lConsulta.Exists(p => p.ID_Consulta == no.Name.Trim()))) { throw new Exception("Não existe esta consulta adicionado no relatório!"); } else { TRegistro_Cad_Consulta RegConsulta = BuscaConsulta(no.Name.Trim()); TreeNode noMenu = new TreeNode(RegConsulta.DS_Consulta.Trim()); noMenu.Name = RegConsulta.ID_Consulta.ToString().Trim(); noMenu.ImageIndex = 0; treeConsulta.Nodes.RemoveByKey(noMenu.Name); (BS_Relatorio.Current as TRegistro_Cad_Report).lConsulta.Remove(RegConsulta); BS_Relatorio.ResetBindings(true); AtualizaTreeConsulta(); } } catch (Exception erro) { MessageBox.Show("ERRO: " + erro.Message, "Mensagem"); } } }
private void bbEditReport_Click(object sender, EventArgs e) { Type t = null; if (BIntelegence) { t = Application.OpenForms["TFBInteligence"].GetType(); t.GetMethod("DefineDadosConexao").Invoke(Application.OpenForms["TFBInteligence"], new object[] { "N" }); } Query_Report relatorio = new Query_Report(); relatorio.Homologacao = true; relatorio.vEditor = true; if (BIntelegence) { relatorio.vBIntelligence = true; } relatorio.vURLWebService = URLWebService; relatorio.vSistema = "AL"; relatorio.MontaFormRelatorio((BS_Relatorio.Current as TRegistro_Cad_Report), null); (BS_Relatorio.Current as TRegistro_Cad_Report).Code_Report = relatorio.Cad_Report.Code_Report; (BS_Relatorio.Current as TRegistro_Cad_Report).Code_Chart = relatorio.Cad_Report.Code_Chart; (BS_Relatorio.Current as TRegistro_Cad_Report).Code_DataCube = relatorio.Cad_Report.Code_DataCube; BS_Relatorio.ResetBindings(true); if (BIntelegence) { t.GetMethod("DefineDadosConexao").Invoke(Application.OpenForms["TFBInteligence"], new object[] { "C" }); } }
private void TFCad_Report_Load(object sender, EventArgs e) { this.Icon = Utils.ResourcesUtils.TecnoAliance_ICO; if (rreport != null) { BS_Relatorio.DataSource = new TList_Cad_Report() { rreport }; rreport.lConsulta.ForEach(p => { TreeNode noMenu = new TreeNode(p.DS_Consulta.Trim()); noMenu.Name = p.ID_Consulta.ToString().Trim(); noMenu.ImageIndex = 0; treeConsulta.Nodes.AddRange(new TreeNode[] { noMenu }); }); this.AtualizaTreeConsulta(); } else { bb_Menu.Visible = false; bbEditReport.Visible = false; BS_Relatorio.AddNew(); } }
public override void excluirRegistro() { try { if ((this.vTP_Modo == TTpModo.tm_Standby) || (this.vTP_Modo == TTpModo.tm_busca)) { if (MessageBox.Show("Confirma Exclusão do Registro?", "Mensagem", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes) { TCN_Cad_Report.DeletarReport(BS_Relatorio.Current as TRegistro_Cad_Report, null); BS_Relatorio.RemoveCurrent(); afterBusca(); if (!BIntelegence) { //CARREGA NOVAMENTE O MENU Type t = Application.OpenForms["FMenuPrin"].GetType(); t.GetMethod("CarregaMenu").Invoke(Application.OpenForms["FMenuPrin"], new object[] { "MASTER", true }); } } } } catch (Exception erro) { MessageBox.Show("ERRO: " + erro.Message, "Mensagem"); } }
private void tsBB_EditarConsulta_Click(object sender, EventArgs e) { TRegistro_Cad_Consulta Reg_Consulta = null; if (treeConsulta.Focused && treeConsulta.SelectedNode != null) { Reg_Consulta = BuscaConsulta(treeConsulta.SelectedNode.Name); } else if (treeConsultaBusca.Focused && treeConsultaBusca.SelectedNode != null) { Reg_Consulta = BuscaConsulta(treeConsultaBusca.SelectedNode.Name); } if (Reg_Consulta != null) { try { TFCad_SQL fSQL = new TFCad_SQL(Reg_Consulta, true); fSQL.Homologacao = true; fSQL.pNMConsulta.Visible = true; fSQL.NM_Consulta.Text = Reg_Consulta.DS_Consulta; fSQL.ShowDialog(); if (fSQL.Cad_Consulta.DS_SQL != "") { //ADD OS DADOS QUE FALTA Reg_Consulta.DS_Consulta = fSQL.NM_Consulta.Text; Reg_Consulta.DS_SQL = fSQL.DS_SQL.Text; //ADD AO BIND if (lConsulta.Exists(p => p.ID_Consulta == Reg_Consulta.ID_Consulta)) { lConsulta.Remove(Reg_Consulta); lConsulta.Add(Reg_Consulta); TCN_Cad_Consulta.GravaConsulta(Reg_Consulta, null); } else { (BS_Relatorio.Current as TRegistro_Cad_Report).lConsulta.Remove(Reg_Consulta); (BS_Relatorio.Current as TRegistro_Cad_Report).lConsulta.Add(Reg_Consulta); BS_Relatorio.ResetBindings(true); } AtualizaTreeConsulta(); } } catch (Exception erro) { MessageBox.Show("ERRO: " + erro.Message, "Mensagem"); } } }
public override void afterNovo() { if ((vTP_Modo == TTpModo.tm_busca) || (vTP_Modo == TTpModo.tm_Standby)) { BS_Relatorio.AddNew(); base.afterNovo(); cbChart.Enabled = false; cbDataCube.Enabled = false; cbRelatorio.Enabled = false; HabilitaConsulta(true); cbModulo.SelectedIndex = 0; if (cbModulo.Enabled) { cbModulo.Focus(); } } }