public override void Atualiza_Grid()
{
try
{
this.Text = lblNomeTab.Text = "Funcionários";
DB_ConceptDataSet.FuncionarioDataTable dt = new DB_ConceptDataSet.FuncionarioDataTable();
FuncionarioTableAdapter ta = new FuncionarioTableAdapter();
// dt=ta.GetData
DB_ConceptDataSet ds = new DB_ConceptDataSet();
ta.Fill(ds.Funcionario);
dB_ConceptDataSetbindingSource.DataSource = ds.Funcionario;
dgvConsulta.DataSource = dB_ConceptDataSetbindingSource;
//Config Das Colunas do DGV
dgvConsulta.Columns[0].HeaderText = "Cod.";
dgvConsulta.Columns[0].Width = 45;
dgvConsulta.Columns[1].HeaderText = "Nome";
dgvConsulta.Columns[1].Width = 200;
dgvConsulta.Columns[2].HeaderText = "Login";
dgvConsulta.Columns[2].Width = 150;
dgvConsulta.Columns[3].Visible = false;
dtGenerico = ds.Funcionario;
errErro.Clear();
}
catch (Exception)
{
}
}
public override void Atualiza_Grid()
{
try
{
this.Text = lblNomeTab.Text = "Produtos";
DB_ConceptDataSet.ProdutoDataTable dt = new DB_ConceptDataSet.ProdutoDataTable();
ProdutoTableAdapter ta = new ProdutoTableAdapter();
// dt=ta.GetData
DB_ConceptDataSet ds = new DB_ConceptDataSet();
ta.Fill(ds.Produto);
dB_ConceptBindingSource2.DataSource = ds.Produto;
dgvPesquisa.DataSource = dB_ConceptBindingSource2;
//Config Das Colunas do DGV
dgvPesquisa.Columns[0].HeaderText = "Cod.";
dgvPesquisa.Columns[0].Width = 55;
dgvPesquisa.Columns[1].HeaderText = "Forn.";
dgvPesquisa.Columns[1].Width = 55;
dgvPesquisa.Columns[2].Visible = false;
dgvPesquisa.Columns[3].HeaderText = "Produto";
dgvPesquisa.Columns[3].Width = 350;
dgvPesquisa.Columns[4].HeaderText = "Quant.";
dgvPesquisa.Columns[4].Width = 70;
dgvPesquisa.Columns[5].HeaderText = "Preço";
dgvPesquisa.Columns[5].Width = 100;
dgvPesquisa.Columns[5].DefaultCellStyle.Format = "C2";
dgvPesquisa.Columns[6].HeaderText = "Custo";
dgvPesquisa.Columns[6].Width = 100;
dgvPesquisa.Columns[6].DefaultCellStyle.Format = "C2";
dgvPesquisa.Columns[7].HeaderText = "Descrição";
dgvPesquisa.Columns[7].Width = 250;
//Carrega as combos com as colunas
if (cmbColuna.Items.Count == 0)
{
foreach (DataColumn coluna in ds.Produto.Columns)
{
cmbColuna.Items.Add(coluna.ColumnName);
}
}
/*if (cmbColuna.Items.Count == 0)
* {
* for (int i = 0; i < 17; i++)
* {
* cmbColuna.Items.Add(dgvConsulta.Columns[i].HeaderText);
*
* }
* }*/
dtGenerico = ds.Produto;
cmbColuna.Text = "Nome_Prod";
cmbBuscar.SelectedItem = "Que começa com";
txtParam1.Visible = true;
}
catch (Exception)
{
}
}
public override void Atualiza_Grid()
{
try
{
this.Text = lblNomeTab.Text = "Produtos";
DB_ConceptDataSet.ProdutoDataTable dt = new DB_ConceptDataSet.ProdutoDataTable();
ProdutoTableAdapter ta = new ProdutoTableAdapter();
// dt=ta.GetData
DB_ConceptDataSet ds = new DB_ConceptDataSet();
ta.Fill(ds.Produto);
dB_ConceptDataSetbindingSource.DataSource = ds.Produto;
dgvConsulta.DataSource = dB_ConceptDataSetbindingSource;
//Config Das Colunas do DGV
dgvConsulta.Columns[0].HeaderText = "Cod.";
dgvConsulta.Columns[0].Width = 45;
dgvConsulta.Columns[1].HeaderText = "Forn.";
dgvConsulta.Columns[1].Width = 50;
dgvConsulta.Columns[2].HeaderText = "Cod. Barras";
dgvConsulta.Columns[2].Width = 150;
dgvConsulta.Columns[3].HeaderText = "Produto";
dgvConsulta.Columns[3].Width = 180;
dgvConsulta.Columns[4].HeaderText = "Quant.";
dgvConsulta.Columns[4].Width = 60;
dgvConsulta.Columns[5].HeaderText = "Preço";
dgvConsulta.Columns[5].Width = 90;
dgvConsulta.Columns[5].DefaultCellStyle.Format = "C2";
dgvConsulta.Columns[6].HeaderText = "Custo";
dgvConsulta.Columns[6].Width = 90;
dgvConsulta.Columns[6].DefaultCellStyle.Format = "C2";
dgvConsulta.Columns[7].HeaderText = "Descrição";
dgvConsulta.Columns[7].Width = 150;
//Carrega as combos com as colunas
if (cmbColuna.Items.Count == 0)
{
foreach (DataColumn coluna in ds.Produto.Columns)
{
cmbColuna.Items.Add(coluna.ColumnName);
}
}
cmbColuna.SelectedIndex = 3;
dtGenerico = ds.Produto;
}
catch (Exception)
{
}
}
public override void Atualiza_Grid()
{
try
{
DB_ConceptDataSet.DebitoDataTable dtDeb = new DB_ConceptDataSet.DebitoDataTable();
DebitoTableAdapter taDeb = new DebitoTableAdapter();
DB_ConceptDataSet ds = new DB_ConceptDataSet();
dtDeb = taDeb.VerificaDebitos();
dB_ConceptBindingSource2.DataSource = dtDeb;
dgvPesquisa.DataSource = dB_ConceptBindingSource2;
dgvPesquisa.Columns[8].DisplayIndex = 0;
dgvPesquisa.Columns[7].DisplayIndex = 1;
dgvPesquisa.Columns[10].DisplayIndex = 8;
dgvPesquisa.Columns[0].DisplayIndex = 10;
dgvPesquisa.Columns[1].DisplayIndex = 9;
dgvPesquisa.Columns[9].DisplayIndex = 7;
dgvPesquisa.Columns[6].DisplayIndex = 6;
dgvPesquisa.Columns[0].Width = 0;
dgvPesquisa.Columns[1].Width = 0;
dgvPesquisa.Columns[8].HeaderText = "Nome";
dgvPesquisa.Columns[8].Width = 220;
dgvPesquisa.Columns[9].HeaderText = "Total Compra";
dgvPesquisa.Columns[9].Width = 130;
dgvPesquisa.Columns[9].DefaultCellStyle.Format = "C2";
dgvPesquisa.Columns[10].HeaderText = "Data Compra";
dgvPesquisa.Columns[10].Width = 140;
dgvPesquisa.Columns[2].HeaderText = "Aberto";
dgvPesquisa.Columns[2].Width = 70;
dgvPesquisa.Columns[3].HeaderText = "1º Parcela";
dgvPesquisa.Columns[3].Width = 105;
dgvPesquisa.Columns[3].DefaultCellStyle.Format = "C2";
dgvPesquisa.Columns[4].HeaderText = "2º Parcela";
dgvPesquisa.Columns[4].Width = 105;
dgvPesquisa.Columns[4].DefaultCellStyle.Format = "C2";
dgvPesquisa.Columns[5].HeaderText = "3º Parcela";
dgvPesquisa.Columns[5].Width = 105;
dgvPesquisa.Columns[5].DefaultCellStyle.Format = "C2";
dgvPesquisa.Columns[6].HeaderText = "4º Parcela";
dgvPesquisa.Columns[6].Width = 105;
dgvPesquisa.Columns[6].DefaultCellStyle.Format = "C2";
dgvPesquisa.Columns[7].HeaderText = "Vencimento";
dgvPesquisa.Columns[7].Width = 115;
//Carrega as combos com as colunas
VerificaVencimento();
if (cmbColuna.Items.Count == 0)
{
/*foreach (DataColumn coluna in taDeb.VerificaDebitos().Columns)
* {
* cmbColuna.Items.Add(coluna.ColumnName);
* }*/
cmbColuna.Items.Add("Nome_Cli");
cmbColuna.Items.Add("Vencimento");
cmbColuna.Items.Add("Possui_Debito");
cmbColuna.Items.Add("Data_Compra");
}
dgvPesquisa.Rows[0].Selected = false;
dtGenerico = taDeb.VerificaDebitos();
cmbColuna.Text = "Possui_Debito";
cmbBuscar.SelectedItem = "Sim";
}
catch (Exception)
{
}
}
public override void Atualiza_Grid()
{
try
{
this.Text = lblNomeTab.Text = "Fornecedores";
DB_ConceptDataSet.FornecedorDataTable dt = new DB_ConceptDataSet.FornecedorDataTable();
FornecedorTableAdapter ta = new FornecedorTableAdapter();
// dt=ta.GetData
DB_ConceptDataSet ds = new DB_ConceptDataSet();
ta.Fill(ds.Fornecedor);
dB_ConceptBindingSource2.DataSource = ds.Fornecedor;
dgvPesquisa.DataSource = dB_ConceptBindingSource2;
//Config Das Colunas do DGV
dgvPesquisa.Columns[0].HeaderText = "Cod.";
dgvPesquisa.Columns[0].Width = 55;
dgvPesquisa.Columns[1].HeaderText = "Fornecedor";
dgvPesquisa.Columns[1].Width = 290;
dgvPesquisa.Columns[2].HeaderText = "Endereço";
dgvPesquisa.Columns[2].Width = 170;
dgvPesquisa.Columns[3].HeaderText = "N°";
dgvPesquisa.Columns[3].Width = 50;
dgvPesquisa.Columns[4].HeaderText = "CEP";
dgvPesquisa.Columns[4].Width = 90;
dgvPesquisa.Columns[5].HeaderText = "Bairro";
dgvPesquisa.Columns[5].Width = 150;
dgvPesquisa.Columns[6].HeaderText = "Complemento";
dgvPesquisa.Columns[6].Width = 150;
dgvPesquisa.Columns[7].HeaderText = "Cidade";
dgvPesquisa.Columns[7].Width = 100;
dgvPesquisa.Columns[8].HeaderText = "UF";
dgvPesquisa.Columns[8].Width = 45;
dgvPesquisa.Columns[9].HeaderText = "Tel";
dgvPesquisa.Columns[9].Width = 140;
dgvPesquisa.Columns[10].HeaderText = "Cel";
dgvPesquisa.Columns[10].Width = 140;
dgvPesquisa.Columns[11].HeaderText = "E-mail";
dgvPesquisa.Columns[11].Width = 150;
dgvPesquisa.Columns[12].HeaderText = "CNPJ";
dgvPesquisa.Columns[12].Width = 170;
dgvPesquisa.Columns[13].HeaderText = "Vendedores";
dgvPesquisa.Columns[13].Width = 200;
dgvPesquisa.Columns[14].HeaderText = "Obs";
dgvPesquisa.Columns[14].Width = 200;
//Carrega as combos com as colunas
if (cmbColuna.Items.Count == 0)
{
foreach (DataColumn coluna in ds.Fornecedor.Columns)
{
cmbColuna.Items.Add(coluna.ColumnName);
}
}
/*if (cmbColuna.Items.Count == 0)
* {
* for (int i = 0; i < 17; i++)
* {
* cmbColuna.Items.Add(dgvConsulta.Columns[i].HeaderText);
*
* }
* }*/
dtGenerico = ds.Fornecedor;
cmbColuna.Text = "Nome_Forn";
cmbBuscar.SelectedItem = "Que começa com";
txtParam1.Visible = true;
}
catch (Exception)
{
}
}
public override void Atualiza_Grid()
{
try
{
this.Text = lblNomeTab.Text = "Clientes";
DB_ConceptDataSet.ClienteDataTable dt = new DB_ConceptDataSet.ClienteDataTable();
ClienteTableAdapter ta = new ClienteTableAdapter();
// dt=ta.GetData
DB_ConceptDataSet ds = new DB_ConceptDataSet();
ta.Fill(ds.Cliente);
dB_ConceptDataSetbindingSource.DataSource = ds.Cliente;
dgvConsulta.DataSource = dB_ConceptDataSetbindingSource;
//Config Das Colunas do DGV
dgvConsulta.Columns[0].HeaderText = "Cod.";
dgvConsulta.Columns[0].Width = 45;
dgvConsulta.Columns[1].HeaderText = "Nome";
dgvConsulta.Columns[1].Width = 200;
dgvConsulta.Columns[2].HeaderText = "Endereço";
dgvConsulta.Columns[2].Width = 150;
dgvConsulta.Columns[3].HeaderText = "N°";
dgvConsulta.Columns[3].Width = 50;
dgvConsulta.Columns[4].HeaderText = "Bairro";
dgvConsulta.Columns[4].Width = 150;
dgvConsulta.Columns[5].HeaderText = "CEP";
dgvConsulta.Columns[5].Width = 85;
dgvConsulta.Columns[6].HeaderText = "Complemento";
dgvConsulta.Columns[6].Width = 150;
dgvConsulta.Columns[7].HeaderText = "Cidade";
dgvConsulta.Columns[7].Width = 100;
dgvConsulta.Columns[8].HeaderText = "UF";
dgvConsulta.Columns[8].Width = 35;
dgvConsulta.Columns[9].HeaderText = "Tel";
dgvConsulta.Columns[9].Width = 125;
dgvConsulta.Columns[10].HeaderText = "Cel";
dgvConsulta.Columns[10].Width = 125;
dgvConsulta.Columns[11].HeaderText = "E-mail";
dgvConsulta.Columns[11].Width = 150;
dgvConsulta.Columns[12].HeaderText = "RG";
dgvConsulta.Columns[12].Width = 100;
dgvConsulta.Columns[13].HeaderText = "CPF";
dgvConsulta.Columns[13].Width = 110;
dgvConsulta.Columns[14].HeaderText = "Data Nasc.";
dgvConsulta.Columns[14].Width = 105;
dgvConsulta.Columns[15].HeaderText = "Sexo";
dgvConsulta.Columns[15].Width = 50;
dgvConsulta.Columns[16].HeaderText = "Obs";
dgvConsulta.Columns[16].Width = 200;
//Carrega as combos com as colunas
if (cmbColuna.Items.Count == 0)
{
foreach (DataColumn coluna in ds.Cliente.Columns)
{
cmbColuna.Items.Add(coluna.ColumnName);
}
}
cmbColuna.SelectedIndex = 1;
dtGenerico = ds.Cliente;
}
catch (Exception)
{
}
}
