public void actualizatabla() { if (label1.Text == "Catalogo avios") { if (comboBox1.SelectedIndex >= 0) { DAO.AviosDAO aviosdao = new DAO.AviosDAO(); aviosdao.tipo = comboBox1.SelectedIndex; dataGridView1.DataSource = aviosdao.busca_aviosportipobase(); } else { DAO.AviosDAO aviosdao = new DAO.AviosDAO(); dataGridView1.DataSource = aviosdao.devuelveaviostipobase(); } } else { if (comboBox1.SelectedIndex >= 0) { DAO.AviosDAO aviosdao = new DAO.AviosDAO(); aviosdao.tipo = comboBox1.SelectedIndex; dataGridView1.DataSource = aviosdao.buscatipobodega(); } else { DAO.AviosDAO aviosdao = new GrupoSM_Recepcion.DAO.AviosDAO(); dataGridView1.DataSource = aviosdao.aviosbodega(); } } }
public void Generardatagrid() { DAO.AviosDAO aviosdao = new DAO.AviosDAO(); BindingSource source = new BindingSource(); string nombre, tipo; int clave, id; foreach (DataGridViewRow row in dataGridView5.Rows) { aviosdao.nombre = row.Cells[0].Value.ToString(); dataGridView4.DataSource = aviosdao.datosalmacen(); nombre = row.Cells[0].Value.ToString(); tipo = dataGridView4.CurrentRow.Cells[0].Value.ToString(); id = Convert.ToInt16(dataGridView4.CurrentRow.Cells[1].Value.ToString()); clave = Convert.ToInt16(dataGridView4.CurrentRow.Cells[2].Value.ToString()); source.Add(new Services.Avios.Avio(nombre, tipo, clave, id)); } dataGridView2.DataSource = source; cargacombobox(); }
private void button1_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex == 0) { DAO.AviosDAO aviosdao = new DAO.AviosDAO(); dataGridView2.DataSource = aviosdao.existenciascatalogoalmacenavios(); BindingSource source = new BindingSource(); string nombre, tipo; int id; decimal cantidad; foreach (DataGridViewRow row in dataGridView2.Rows) { aviosdao.nombre = row.Cells[0].Value.ToString(); dataGridView3.DataSource = aviosdao.datoscatalogoalmacenavios(); nombre = row.Cells[0].Value.ToString(); cantidad = Convert.ToDecimal(row.Cells[1].Value.ToString()); foreach (DataGridViewRow row1 in dataGridView3.Rows) { tipo = row1.Cells[0].Value.ToString(); id = Convert.ToInt16(row1.Cells[0].Value); source.Add(new Services.AviosAlmacen.AvioAlmacen(nombre, tipo, cantidad, id)); } } dataGridView1.DataSource = source; } }
private void ImpresionBodegaAvios_Faltantes_Load(object sender, EventArgs e) { //GUI.PLANTILLAS.VistaBodegaAvios_Faltantes report = new PLANTILLAS.VistaBodegaAvios_Faltantes(); DAO.AviosDAO aviosdao = new DAO.AviosDAO(); //report.SetDataSource(aviosdao.devuelvefaltantesaviosbodega()); //report.Subreports["AviosSubRPT"].SetDataSource(aviosdao.sacar_avios()); // report.Subreports["PiezasSubRPT"].SetDataSource(piezasdao.devuelvepiezasfichas()); //crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); }
private void ImpresionBodegaAvios_PorTipo_Load(object sender, EventArgs e) { //GUI.PLANTILLAS.VistaBodegaAvios_PorTipo report = new PLANTILLAS.VistaBodegaAvios_PorTipo(); DAO.AviosDAO aviosdao = new DAO.AviosDAO(); aviosdao.tipo = this.tipoavio; //report.SetDataSource(aviosdao.vistaimpresionbodegaaviosportipo()); //report.Subreports["AviosSubRPT"].SetDataSource(aviosdao.sacar_avios()); // report.Subreports["PiezasSubRPT"].SetDataSource(piezasdao.devuelvepiezasfichas()); //crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); }
private void ImpresionBodegaDeavios_Load(object sender, EventArgs e) { DAO.AviosDAO daoavios = new DAO.AviosDAO(); //GUI.PLANTILLAS.Vistabodega_Avios report = new PLANTILLAS.Vistabodega_Avios(); //report.SetDataSource(daoavios.devuelvebodegaaviosparaimprimir()); //report.Subreports["CrystalReport1.rpt"].SetDataSource(produccion.tallas_preliminaresproduccion()); //report.Subreports["ModeloSubrpt"].SetDataSource(ordendao.devuelvepellones()); //crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); }
private void button3_Click_1(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Tenga en cuenta que la entrada del avio se eliminara de bodega y de catalogo", "Confirmacion", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { DAO.AviosDAO aviosdao = new DAO.AviosDAO(); aviosdao.IDAvioAlmacen = Convert.ToInt32(dataGridView2.CurrentRow.Cells["ID"].Value); aviosdao.eliminadebodegaalmacen(); devuelvecampos(); Generardatagrid(); cargacombobox(); } }