public fAvisos() { InitializeComponent(); avisos = new cAvisos(); }
void MainFormShown(object sender, EventArgs e) { // login frmLogin frm = new frmLogin(); frm.admin = false; frm.sUltimoUsuario = sUltimoUsuario; frm.sUltimaFilial = sUltimaFilial; frm.ShowDialog(); if (!frm.bOK) { Close(); return; } lblUsuario.Text = "Usuário: " + Globais.sUsuario; lblFilial.Text = "Filial: " + Globais.sFilial; // verifica atualizações cAtualizador atualizador = new cAtualizador(); atualizador = null; lblAvisos.Visible = true; cAvisos avisos = new cAvisos(); avisos.Processa(lblAvisos); lblAvisos.Visible = false; // regrava dados do último acesso XmlDocument xml = new XmlDocument(); xml.Load("soft.xml"); XmlNodeList list; XmlNode node; list = xml.GetElementsByTagName("UltimoUsuario"); node = list[0]; node.InnerText = Globais.sUsuario; list = xml.GetElementsByTagName("UltimaFilial"); node = list[0]; node.InnerText = Globais.sFilial; xml.Save("soft.xml"); Button[] botoes = new Button[10]; cSistemas sistemas = new cSistemas(); ArrayList lista = sistemas.ListaAcesso(Globais.bAdministrador, Globais.sUsuario, Globais.sFilial); int y = 10; int b = 0; for (int i = 0; i < lista.Count; i += 2) { botoes[b] = new Button(); botoes[b].SetBounds(10, y, 200, 25); botoes[b].Text = lista[i].ToString(); this.Controls.Add(botoes[b]); botoes[b].TabIndex = b; botoes[b].Click += new System.EventHandler(this.Button1Click); comandos[b] = lista[i + 1].ToString(); y += 30; b++; } /* * int y2Imagem = imgLogo.Top + imgLogo.Height + 10; * if (y < y2Imagem) * y = y2Imagem; * int y1Aniversariantes = lblAniversariantes.Top; * int dif = y1Aniversariantes - y; * if (dif > 0) { * lblAniversariantes.Top -= dif; * dgvAniversariantes.Top -= dif; * lblAgenda.Top -= dif; * dgvHistorico.Top -= dif; * tbPendencia.Top -= dif; * this.Height -= dif; * } */ string sql = "select " + "COD_PARCEIRO,COD_PARCEIRO,extract(day from DAT_NASCIMENTO),'P',IDT_CLIENTE,IDT_CONSULTOR,IDT_FORNECEDOR,IDT_FISJUR from PARCEIROS " + "where IDT_FISJUR='F' and extract(month from DAT_NASCIMENTO) = " + DateTime.Now.Month.ToString() + " union select " + "COD_CONTATO,COD_PARCEIRO,extract(day from DAT_NASCIMENTO),'C','N','N','N','?' from CONTATOS " + "where extract(month from DAT_NASCIMENTO) = " + DateTime.Now.Month.ToString() + " union select " + "NOM_FUNCIONARIO,' ',extract(day from DAT_NASCIMENTO),'F','N','N','N','?' from FUNCIONARIOS " + "where extract(month from DAT_NASCIMENTO) = " + DateTime.Now.Month.ToString(); FbDataAdapter adapter = new FbDataAdapter(); DataTable table = new DataTable(); adapter.SelectCommand = new FbCommand(sql, Globais.bd); adapter.Fill(table); dgvAniversariantes.DataSource = table; table.Columns[0].ColumnName = "Nome"; table.Columns[1].ColumnName = "Empresa"; table.Columns[2].ColumnName = "Dia"; table.Columns[3].ColumnName = "Tipo"; dgvAniversariantes.Columns[4].Visible = false; dgvAniversariantes.Columns[5].Visible = false; dgvAniversariantes.Columns[6].Visible = false; dgvAniversariantes.Columns[7].Visible = false; dgvAniversariantes.Columns["Empresa"].Width = 60; dgvAniversariantes.Columns["Dia"].Width = 20; dgvAniversariantes.Columns["Tipo"].Width = 90; foreach (DataGridViewRow row in dgvAniversariantes.Rows) { if (row.Cells[3].Value.ToString().Equals("P")) { if (row.Cells[7].Value.ToString().Equals("F")) { row.Cells[1].Value = ""; } if (row.Cells[4].Value.ToString().Equals("S")) { row.Cells[3].Value = "Cliente"; } if (row.Cells[5].Value.ToString().Equals("S")) { if (row.Cells[4].Value.ToString().Equals("S")) { row.Cells[3].Value = "Cliente/Consultor"; } else { row.Cells[3].Value = "Consultor"; } } if (row.Cells[6].Value.ToString().Equals("S")) { row.Cells[3].Value = "Fornecedor"; } } if (row.Cells[3].Value.ToString().Equals("C")) { row.Cells[3].Value = "Contato"; } if (row.Cells[3].Value.ToString().Equals("F")) { row.Cells[3].Value = "Funcionário"; } } dgvAniversariantes.Sort(dgvAniversariantes.Columns[2], System.ComponentModel.ListSortDirection.Ascending); /* * StreamWriter sw = new StreamWriter(new FileStream("c:\\softplace\\teste.sql", FileMode.Create)); * sw.WriteLine(table.Rows.Count); * sw.WriteLine(sql); * sw.Close(); */ //this.Height = y + 40; //if (this.Height < 266) this.Height = 266; timer = new System.Windows.Forms.Timer(); timer.Interval = 60000; timer.Tick += new EventHandler(EventoTimer); timer.Start(); CarregaHistorico(); col_sorted = ""; ord_sorted = SortOrder.Ascending; tbMensagem.Text = cMensagens.UltimaMensagem(); }