private void textBox5_TextChanged(object sender, EventArgs e) { try { string campo = "nombre"; DAO.AviosDAO aviosdao = new GrupoSM_Recepcion.DAO.AviosDAO(); DataView dv; if (comboBox1.SelectedIndex != -1) { aviosdao.tipo = comboBox1.SelectedIndex; dv = new DataView(aviosdao.buscatipobodega()); } else { dv = new DataView(aviosdao.aviosbodega()); } dv.RowFilter = campo + " like '%" + textBox5.Text + "%'"; dataGridView5.DataSource = dv; } catch { } }
private void textBox5_TextChanged(object sender, EventArgs e) { if (comboBox1.SelectedIndex >= 0) { DAO.AviosDAO aviosdao = new GrupoSM_Recepcion.DAO.AviosDAO(); aviosdao.tipo = comboBox1.SelectedIndex; dataGridView1.DataSource = aviosdao.buscatipobodega(); } else { DAO.AviosDAO aviosdao = new GrupoSM_Recepcion.DAO.AviosDAO(); dataGridView1.DataSource = aviosdao.aviosbodega(); } }
private void textBox5_TextChanged(object sender, EventArgs e) { //if (comboBox1.SelectedIndex == 0) //{ // campo = "nombre_prenda"; //} //else //{ // campo = "modelo"; //} string campo = "nombre"; DAO.AviosDAO aviosdao = new GrupoSM_Recepcion.DAO.AviosDAO(); DataView dv; if (label1.Text == "Catalogo avios") { if (comboBox1.SelectedIndex != -1) { aviosdao.tipo = comboBox1.SelectedIndex; dv = new DataView(aviosdao.busca_aviosportipobase()); } else { dv = new DataView(aviosdao.devuelveaviostipobase()); } } else { if (comboBox1.SelectedIndex != -1) { aviosdao.tipo = comboBox1.SelectedIndex; dv = new DataView(aviosdao.buscatipobodega()); } else { dv = new DataView(aviosdao.aviosbodega()); } } dv.RowFilter = campo + " like '%" + textBox5.Text + "%'"; dataGridView1.DataSource = dv; }
private void Avios_Asignacion_Load(object sender, EventArgs e) { DAO.AviosDAO aviosdao = new GrupoSM_Recepcion.DAO.AviosDAO(); aviosdao.idproduccion = int.Parse(label6.Text); //aviosdao.id_ficha_avio = int.Parse(label7.Text); aviosdao.fecha = dateTimePicker1.Value; //aviosdao.verificaavios(); dataGridView1.DataSource = aviosdao.devuelveaviosasignaciones(); if (comboBox1.SelectedIndex >= 0) { aviosdao.tipo = comboBox1.SelectedIndex; dataGridView2.DataSource = aviosdao.buscatipobodega(); } else { dataGridView2.DataSource = aviosdao.aviosbodega(); } }
private void button3_Click(object sender, EventArgs e) { GUI.Bodega.AviosControl aviosgui = new GrupoSM_Recepcion.GUI.Bodega.AviosControl(); aviosgui.textBox2.Text = "0"; aviosgui.textBox3.Text = "0"; aviosgui.textBox2.Enabled = false; aviosgui.textBox3.Enabled = false; aviosgui.checkBox1.Checked = true; aviosgui.checkBox1.Enabled = false; aviosgui.ShowDialog(); DAO.AviosDAO aviosdao = new GrupoSM_Recepcion.DAO.AviosDAO(); if (comboBox1.SelectedIndex != -1) { aviosdao.tipo = comboBox1.SelectedIndex + 14; dataGridView1.DataSource = aviosdao.buscatipobodega(); } else { dataGridView1.DataSource = aviosdao.aviosbodega(); } }