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