private void carregaGrupo()
        {
            DALConexao  cx  = new DALConexao(DadosDaConexao.StringDaConexao);
            BLLCmvGrupo bll = new BLLCmvGrupo(cx);

            DataTable tabela = bll.LocalizarGrupo(unidade);

            var dataSource = new List <Language>();

            dataSource.Add(new Language()
            {
                Name = "", Value = ""
            });

            for (int i = 0; i < tabela.Rows.Count; i++)
            {
                dataSource.Add(new Language()
                {
                    Name = tabela.Rows[i][1].ToString(), Value = Convert.ToInt32(tabela.Rows[i][0]).ToString()
                });
            }

            dataSource.Add(new Language()
            {
                Name = "**Adicionar Grupo**", Value = "-1"
            });

            //Setup data binding
            this.cbGrupos.DataSource    = dataSource;
            this.cbGrupos.DisplayMember = "Name";
            this.cbGrupos.ValueMember   = "Value";
            this.cbGrupos.Text          = "";

            dgvAdmin.Rows.Clear();
            dgvContas.Rows.Clear();
            txtMEtaPercentual1.Clear();
            txtmetaValor1.Clear();
            cbGrupoAdmin.Text = "";
            cbConta.Text      = "";
        }
Exemple #2
0
        private void CarregaCbGrupos()
        {
            DALConexao  cx     = new DALConexao(DadosDaConexao.StringDaConexao);
            BLLCmvGrupo bllg   = new BLLCmvGrupo(cx);
            DataTable   tabela = bllg.LocalizarGrupo(unidade);

            var dataSource1 = new List <Language>();

            dataSource1.Add(new Language()
            {
                Name1 = "", Value1 = "0"
            });
            for (int i = 0; i < tabela.Rows.Count; i++)
            {
                dataSource1.Add(new Language()
                {
                    Name1 = tabela.Rows[i][1].ToString(), Value1 = Convert.ToInt32(tabela.Rows[i][0]).ToString()
                });
            }
            var dataSource2 = new List <Language>();

            dataSource2.Add(new Language()
            {
                Name2 = "", Value2 = "0"
            });

            for (int i = 0; i < tabela.Rows.Count; i++)
            {
                dataSource2.Add(new Language()
                {
                    Name2 = tabela.Rows[i][1].ToString(), Value2 = Convert.ToInt32(tabela.Rows[i][0]).ToString()
                });
            }

            var dataSource4 = new List <Language>();

            dataSource4.Add(new Language()
            {
                Name4 = "", Value4 = "0"
            });

            for (int i = 0; i < tabela.Rows.Count; i++)
            {
                dataSource4.Add(new Language()
                {
                    Name4 = tabela.Rows[i][1].ToString(), Value4 = Convert.ToInt32(tabela.Rows[i][0]).ToString()
                });
            }
            var dataSource5 = new List <Language>();

            dataSource5.Add(new Language()
            {
                Name5 = "", Value5 = "0"
            });

            for (int i = 0; i < tabela.Rows.Count; i++)
            {
                dataSource5.Add(new Language()
                {
                    Name5 = tabela.Rows[i][1].ToString(), Value5 = Convert.ToInt32(tabela.Rows[i][0]).ToString()
                });
            }

            liberado = false;

            //Atualiza grupo 01
            this.cbComparativo01.DataSource    = dataSource1;
            this.cbComparativo01.DisplayMember = "Name1";
            this.cbComparativo01.ValueMember   = "Value1";

            //Atualiza grupo 02
            this.cbComparativo02.DataSource    = dataSource2;
            this.cbComparativo02.DisplayMember = "Name2";
            this.cbComparativo02.ValueMember   = "Value2";
        }