private void btBuscar_Click(object sender, EventArgs e) { Departamento.Consultar(json => { dataGridView1.DataSource = Opcion.JsonaListaGenerica <object>(json); }, new ReporteGenerico { idSucursal = cbSucursales.SelectedValue.ToString(), fechaIni = dtFechaIni.Value, fechaFin = dtFechaFin.Value }); }
public void CarregarLista() { listaDepartamentos.Items.Clear(); List <Departamento> departamentos = Departamento.Consultar(); foreach (var departamento in departamentos) { string[] itemLista = { departamento.Id.ToString(), departamento.Descricao }; listaDepartamentos.Items.Add(new ListViewItem(itemLista)); } }
public static Departamento Consultar(int id) { return(Departamento.Consultar(id)); }
private void btBuscar_Click(object sender, EventArgs e) { Departamento.Consultar(json => { BeginInvoke((Action)(() => { var filaprimera = new BindingList <DepartamentoCabecero>(); filaprimera.AddNew(); var list = new List <DepartamentoCabecero>(Opcion.JsonaListaGenerica <DepartamentoCabecero>(json)); list.AddRange((filaprimera)); dataGridView1.DataSource = list; dataGridView1.RowHeadersVisible = false; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.DefaultCellStyle.Font = new Font("Microsoft Sans Serif", 11); DataGridViewCellStyle style = dataGridView1.ColumnHeadersDefaultCellStyle; style.Font = new Font("Microsoft Sans Serif", 14, FontStyle.Bold); dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; label6.Text = cbSucursales.Text; dataGridView1.AutoResizeColumns(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; //var porcentaje = new DataGridViewTextBoxColumn //{ // Name = "%", // HeaderText = @"%", //}; //dataGridView1.Columns.Insert(9, porcentaje); var buttonColumn = new DataGridViewButtonColumn { Name = "Detalle", HeaderText = @"Detalle", Text = "Detalle", UseColumnTextForButtonValue = true }; dataGridView1.Columns.Insert(8, buttonColumn); dataGridView1.Columns[8].DefaultCellStyle.BackColor = Color.Aqua; double suminve = 0; double sumajus = 0; double sumacer = 0; double sumfall = 0; double sumperd = 0; double sumres = 0; for (var x = 0; x < dataGridView1.RowCount; x++) { dataGridView1.Rows[x].Height = 35; dataGridView1.Rows[x].Cells[8].Style.Font = new Font("Microsoft Sans Serif", 12, FontStyle.Bold); var porciento = Convert.ToDouble(dataGridView1.Rows[x].Cells[7].Value); if (porciento <= 0.00) { dataGridView1.Rows[x].Cells[7].Style.BackColor = Color.Red; } if (porciento >= 0.01 && porciento <= 0.10) { dataGridView1.Rows[x].Cells[7].Style.BackColor = Color.DarkRed; } if (porciento >= 0.11 && porciento <= 0.20) { dataGridView1.Rows[x].Cells[7].Style.BackColor = Color.Firebrick; } if (porciento >= 0.21 && porciento <= 0.30) { dataGridView1.Rows[x].Cells[7].Style.BackColor = Color.OrangeRed; } if (porciento >= 0.31 && porciento <= 0.40) { dataGridView1.Rows[x].Cells[7].Style.BackColor = Color.DarkOrange; } if (porciento >= 0.41 && porciento <= 0.50) { dataGridView1.Rows[x].Cells[7].Style.BackColor = Color.DarkGoldenrod; } if (porciento >= 0.51 && porciento <= 0.60) { dataGridView1.Rows[x].Cells[7].Style.BackColor = Color.Goldenrod; } if (porciento >= 0.61 && porciento <= 0.70) { dataGridView1.Rows[x].Cells[7].Style.BackColor = Color.GreenYellow; } if (porciento >= 0.71 && porciento <= 0.80) { dataGridView1.Rows[x].Cells[7].Style.BackColor = Color.LawnGreen; } if (porciento >= 0.81 && porciento <= 0.90) { dataGridView1.Rows[x].Cells[7].Style.BackColor = Color.OliveDrab; } if (porciento >= 0.91 && porciento <= 1.00) { dataGridView1.Rows[x].Cells[7].Style.BackColor = Color.Olive; } var inve = Convert.ToDouble(dataGridView1.Rows[x].Cells["ArticulosInventariados"].Value); suminve += (inve); var ajus = Convert.ToDouble(dataGridView1.Rows[x].Cells["ArticulosSinAjuste"].Value); sumajus += (ajus); var acer = Convert.ToDouble(dataGridView1.Rows[x].Cells["Acertado"].Value); sumacer += (acer); var fall = Convert.ToDouble(dataGridView1.Rows[x].Cells["Fallado"].Value); sumfall += (fall); var res = Convert.ToDouble(dataGridView1.Rows[x].Cells["Restante"].Value); sumres += (res); var perd = Convert.ToDouble(dataGridView1.Rows[x].Cells["Perdida"].Value); sumperd += (perd); } dataGridView1.Rows[dataGridView1.RowCount - 1].Cells["Departamento"].Value = "TOTAL INVENTARIO:"; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[1].Value = suminve.ToString(CultureInfo.InvariantCulture); dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[2].Value = sumajus.ToString(CultureInfo.InvariantCulture); dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[3].Value = sumacer.ToString(CultureInfo.InvariantCulture); dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[4].Value = sumfall.ToString(CultureInfo.InvariantCulture); dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[5].Value = sumres.ToString(CultureInfo.InvariantCulture); dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[6].Value = sumperd.ToString(CultureInfo.InvariantCulture); dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[7].Value = 0; //dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[6].Value =; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[0].Style.BackColor = Color.Gray; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[1].Style.BackColor = Color.Gray; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[2].Style.BackColor = Color.Gray; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[3].Style.BackColor = Color.Gray; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[4].Style.BackColor = Color.Gray; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[5].Style.BackColor = Color.Gray; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[6].Style.BackColor = Color.Gray; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[7].Style.BackColor = Color.Gray; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[8].Style.BackColor = Color.Gray; })); }, new ReporteGenerico { idSucursal = cbSucursales.SelectedValue.ToString(), fechaInicio = dtFechaIni.Value, fechaFin = dtFechaFin.Value, concepto = 2 }); }
public static List <Departamento> Consultar() { return(Departamento.Consultar()); }