private void Form2Funcionarios_Load(object sender, EventArgs e)
{
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
string ssql = "SELECT id as ID, nome_funcionario as Nome, telefone as Telefone FROM T_funcionarios";
MyGetData db = new MyGetData();
dataGridView1.DataSource = db.BuscaDados(SConnection.SC, ssql);
dataGridView1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCellsExceptHeader;
dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.ShowEditingIcon = false;
dataGridView1.RowHeadersVisible = false;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
lbl_estado.Text = Convert.ToString(dataGridView1.Rows.Count) + " funcionários";
}
public Form1()
{
InitializeComponent();
string ssql;
// Preencher ComboBoxes
ssql = "SELECT Id, nome_cliente FROM T_clientes";
InitComboBox(comboBox1_clientes, ssql, "nome_cliente", "id", "-- Mostrar Todos --");
InitComboBox(cmb_novo_select_cliente, ssql, "nome_cliente", "id", "-- Selecionar Cliente --");
ssql = "SELECT Id, nome_funcionario FROM T_funcionarios";
InitComboBox(comboBox2_funcionarios, ssql, "nome_funcionario", "id", "-- Mostrar Todos --");
InitComboBox(cmb_novo_select_func, ssql, "nome_funcionario", "id", "-- Selecionar Funcionário --");
// Preencher Gridview
ssql = $"SET ROWCOUNT {DEFAULT_MAX_ROWS} " +
"SELECT T_registo_de_tempos.Id as ID, T_clientes.nome_cliente as Cliente, T_funcionarios.nome_funcionario as Funcionário, data as 'Data', tempo as Tempo, " +
"descritivo as Descrição, categoria as Categoria " +
"FROM T_registo_de_tempos " +
"INNER JOIN T_clientes ON T_registo_de_tempos.cod_cliente = T_clientes.Id " +
"INNER JOIN T_funcionarios ON T_registo_de_tempos.cod_funcionario = T_funcionarios.Id " +
"ORDER BY Id DESC";
dataGridView1.DataSource = db.BuscaDados(SConnection.SC, ssql);
dataGridView1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView1.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataGridView1.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.ShowEditingIcon = false;
dataGridView1.RowHeadersVisible = false;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.ReadOnly = true;
// Preencher combobox categorias
var categorias = new List <string> {
"-- Selecionar cat. --",
"Contabilidade",
"Recursos humanos",
"Análise",
"Correspondência",
"Exterior",
"Reuniões",
"Mapas",
"Outros",
};
foreach (var item in categorias)
{
cmb_novo_categoria.Items.Add(item);
}
cmb_novo_categoria.SelectedIndex = 0;
dt_novo_data.Value = DateTime.Now;
Atualizar_contagem_estado();
AtualizarEstatisticas();
}
