private void RecibeData(String x1,String x2,String x3,String x4,String x5) { try { txt_serop.Text = x1.ToString(); txt_numop.Text = x2.ToString(); xarticid = x3.ToString(); txt_articidold.Text = x4.ToString(); txt_articname.Text = x5.ToString(); DataTable dt = new DataTable(); String Query = " SELECT (CONVERT(VARCHAR, opf.secuencia) + ' = ' + f.fasename) secuencia,opf.faseid,cl.ctactename " + " FROM tb_pp_ordenprodfase opf " + " LEFT JOIN tb_pp_fase f ON opf.faseid = f.faseid " + " LEFT JOIN tb_cliente cl ON opf.ctacte = cl.ctacte " + " WHERE opf.tipop = 'OP' AND opf.serop = '" + txt_serop.Text + "' AND opf.numop = '" + txt_numop.Text + "'"; dt = DatosSQL(Query); cmb_secuencia.DataSource = dt; cmb_secuencia.ValueMember = "faseid"; cmb_secuencia.DisplayMember = "secuencia"; cmb_secuencia.SelectedIndex = 0; form_bloqueado(true); btn_cancelar.Enabled = true; btn_grabar.Enabled = true; btn_salir.Enabled = true; cmb_tipdoc.Enabled = false; txt_numop.Enabled = false; btn_new.Enabled = true; /********************** * CARGAMOS EL COMBO DE COLORES * ******************/ tb_pp_ordenprodfasemoviBL BL2 = new tb_pp_ordenprodfasemoviBL(); tb_pp_ordenprodfasemovi BE2 = new tb_pp_ordenprodfasemovi(); DataTable dt2 = new DataTable(); BE2.tipop = "OP"; BE2.serop = txt_serop.Text; BE2.numop = txt_numop.Text; BE2.filtro = "1"; dt2 = BL2.GetAll(EmpresaID, BE2).Tables[0]; cmb_color.DataSource = dt2; cmb_color.ValueMember = "colorid"; cmb_color.DisplayMember = "colorname"; cmb_color.SelectedIndex = -1; /************************ * CARGAMOS EL DETALLE * **********************/ var BL3 = new tb_pp_ordenprodfasemoviBL(); var BE3 = new tb_pp_ordenprodfasemovi(); var dt3 = new DataTable(); BE3.tipop = "OP"; BE3.serop = txt_serop.Text; BE3.numop = txt_numop.Text; BE3.filtro = "1"; dt3 = BL3.GetAllPropColor_PIVOT(EmpresaID, BE3).Tables[0]; dgv_color.AutoGenerateColumns = false; dgv_color.DataSource = dt3; ValidaArticulo(); CalculosTotales(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cmb_color_SelectedIndexChanged(object sender, EventArgs e) { if (cmb_color.SelectedIndex != -1) { //Segun se Escoge el Color cargar las tallas if (cmb_color.Text != "System.Data.DataRowView" && cmb_color.SelectedValue.ToString() != "System.Data.DataRowView") { tb_pp_ordenprodfasemoviBL BL = new tb_pp_ordenprodfasemoviBL(); tb_pp_ordenprodfasemovi BE = new tb_pp_ordenprodfasemovi(); DataTable dt2 = new DataTable(); BE.tipop = "OP"; BE.serop = txt_serop.Text; BE.numop = txt_numop.Text; BE.colorid = cmb_color.SelectedValue.ToString(); BE.filtro = "2"; dt2 = BL.GetAll(EmpresaID, BE).Tables[0]; cmb_talla.DataSource = dt2; cmb_talla.ValueMember = "coltalla"; cmb_talla.DisplayMember = "tallaname"; cmb_talla.SelectedIndex = -1; } } }
private void cmb_talla_SelectedIndexChanged(object sender, EventArgs e) { if (cmb_talla.SelectedIndex != -1) { //Segun se Escoge la Talla Cargar el Saldo if (cmb_talla.Text != "System.Data.DataRowView" && cmb_talla.SelectedValue.ToString() != "System.Data.DataRowView") { tb_pp_ordenprodfasemoviBL BL = new tb_pp_ordenprodfasemoviBL(); tb_pp_ordenprodfasemovi BE = new tb_pp_ordenprodfasemovi(); DataTable dt2 = new DataTable(); BE.tipop = "OP"; BE.serop = txt_serop.Text; BE.numop = txt_numop.Text; BE.colorid = cmb_color.SelectedValue.ToString(); BE.coltalla = cmb_talla.SelectedValue.ToString(); BE.filtro = "3"; dt2 = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt2.Rows.Count > 0) txt_saldo.Text = dt2.Rows[0]["cantidad"].ToString(); } } }
void CargamosColorCmb() { tb_pp_ordenprodfasemoviBL BL2 = new tb_pp_ordenprodfasemoviBL(); tb_pp_ordenprodfasemovi BE2 = new tb_pp_ordenprodfasemovi(); DataTable dt2 = new DataTable(); BE2.tipop = "OP"; BE2.serop = txt_serop.Text; BE2.numop = txt_numop.Text; BE2.filtro = "1"; dt2 = BL2.GetAll(EmpresaID, BE2).Tables[0]; cmb_color.DataSource = dt2; cmb_color.ValueMember = "colorid"; cmb_color.DisplayMember = "colorname"; cmb_color.SelectedIndex = -1; }