void FrmCadSistemasLoad(object sender, EventArgs e)
{
sistemas = new cSistemas();
this.Cursor = Cursors.WaitCursor;
sistemas.Carrega(dgvCadastro, "");
this.Cursor = Cursors.Default;
DesabilitaEdicaoLocal();
}
void FrmControleAcessoLoad(object sender, EventArgs e)
{
controle = new cControleAcesso();
usuarios = new cUsuarios();
this.Cursor = Cursors.WaitCursor;
usuarios.Carrega(dbgUsuarios, "where IDT_ADMINISTRADOR <> 'S'");
this.Cursor = Cursors.Default;
if (dbgUsuarios.Rows.Count == 0)
{
Close();
}
iUsuario = 0;
filiais = new cFiliais();
this.Cursor = Cursors.WaitCursor;
filiais.Carrega(dbgFiliais);
this.Cursor = Cursors.Default;
if (dbgFiliais.Rows.Count == 0)
{
Close();
}
iFilial = 0;
sistemas = new cSistemas();
this.Cursor = Cursors.WaitCursor;
sistemas.Carrega(dbgSistemas, "where COD_SISTEMA <> 1");
this.Cursor = Cursors.Default;
if (dbgSistemas.Rows.Count == 0)
{
Close();
}
iSistema = 0;
ColoreFiliais();
ColoreSistemas();
CarregaProgramas();
ColoreProgramas();
}
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();
}
