public bool Delete(string empresaid, tb_pt_talla BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPtTalla_DELETE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tallaid", SqlDbType.Char, 2).Value = BE.tallaid; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet GetAll(string empresaid, tb_pt_talla BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPtTalla_SEARCH", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tallaid", SqlDbType.Char, 2).Value = BE.tallaid; cmd.Parameters.Add("@tallaname", SqlDbType.VarChar, 20).Value = BE.tallaname; cmd.Parameters.Add("@talla01", SqlDbType.Char, 2).Value = BE.talla01; cmd.Parameters.Add("@talla02", SqlDbType.Char, 2).Value = BE.talla02; cmd.Parameters.Add("@talla03", SqlDbType.Char, 2).Value = BE.talla03; cmd.Parameters.Add("@talla04", SqlDbType.Char, 2).Value = BE.talla04; cmd.Parameters.Add("@talla05", SqlDbType.Char, 2).Value = BE.talla05; cmd.Parameters.Add("@talla06", SqlDbType.Char, 2).Value = BE.talla06; cmd.Parameters.Add("@talla07", SqlDbType.Char, 2).Value = BE.talla07; cmd.Parameters.Add("@talla08", SqlDbType.Char, 2).Value = BE.talla08; cmd.Parameters.Add("@talla09", SqlDbType.Char, 2).Value = BE.talla09; cmd.Parameters.Add("@talla10", SqlDbType.Char, 2).Value = BE.talla10; cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet GetAll_paginacion(string empresaid, tb_pt_talla BE) { return tablaDA.GetAll_paginacion(empresaid, BE); }
public bool Delete(string empresaid, tb_pt_talla BE) { return tablaDA.Delete(empresaid, BE); }
private void cmb_tallaid_SelectedIndexChanged(object sender, EventArgs e) { if (cmb_tallaid.SelectedIndex >= 0) { var BE = new tb_pt_talla(); var BL = new tb_pt_tallaBL(); var dt = new DataTable(); BE.tallaid = cmb_tallaid.SelectedValue.ToString(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; foreach (DataRow fila in dt.Rows) { chk_ta01.Text = fila["talla01"].ToString(); chk_ta02.Text = fila["talla02"].ToString(); chk_ta03.Text = fila["talla03"].ToString(); chk_ta04.Text = fila["talla04"].ToString(); chk_ta05.Text = fila["talla05"].ToString(); chk_ta06.Text = fila["talla06"].ToString(); chk_ta07.Text = fila["talla07"].ToString(); chk_ta08.Text = fila["talla08"].ToString(); chk_ta09.Text = fila["talla09"].ToString(); chk_ta10.Text = fila["talla10"].ToString(); chk_ta11.Text = fila["talla11"].ToString(); chk_ta12.Text = fila["talla12"].ToString(); } } }
private void Cargar_cmbTalla() { tb_pt_talla BE = new tb_pt_talla(); tb_pt_tallaBL BL = new tb_pt_tallaBL(); DataTable dt = new DataTable(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { cmb_tallaid.DataSource = dt; cmb_tallaid.ValueMember = "tallaid"; cmb_tallaid.DisplayMember = "tallaname"; } }
private void CargarComboArticuloTallas(String xtallaid) { //Cargamos el Combo de Tallas ----> Que biene en forma Vertical tb_pt_tallaBL BL3 = new tb_pt_tallaBL(); tb_pt_talla BE3 = new tb_pt_talla(); DataTable dt3 = new DataTable(); BE3.tallaid = xtallaid.ToString(); dt3 = BL3.GetAll_vertical(Session["ssEmpresaID"].ToString(), BE3).Tables[0]; cmb_tallaid.DataSource = dt3; cmb_tallaid.ValueField = "talla"; cmb_tallaid.TextField = "talla"; cmb_tallaid.DataBind(); }
private void data_Tablatalla() { try { if (Tablatalla.Rows.Count > 0) Tablatalla.Rows.Clear(); tb_pt_tallaBL BL = new tb_pt_tallaBL(); tb_pt_talla BE = new tb_pt_talla(); switch (cbo_buscar.SelectedIndex) { case 0: BE.tallaname = txt_criterio.Text.Trim(); break; case 1: if (txt_criterio.Text.Trim().Length > 0) { BE.tallaid = txt_criterio.Text.Trim().ToUpper().PadLeft(2, '0'); } break; default: //** break; } Tablatalla = BL.GetAll(EmpresaID, BE).Tables[0]; if (Tablatalla.Rows.Count > 0) { btn_imprimir.Enabled = true; gridtalla.DataSource = Tablatalla; gridtalla.Rows[0].Selected = false; gridtalla.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool Update(string empresaid, tb_pt_talla BE) { return tablaDA.Update(empresaid, BE); }
public bool Update(string empresaid, tb_pt_talla BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPtTalla_UPDATE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tallaid", SqlDbType.Char, 2).Value = BE.tallaid; cmd.Parameters.Add("@tallaname", SqlDbType.VarChar, 20).Value = BE.tallaname; cmd.Parameters.Add("@talla01", SqlDbType.Char, 2).Value = BE.talla01; cmd.Parameters.Add("@talla02", SqlDbType.Char, 2).Value = BE.talla02; cmd.Parameters.Add("@talla03", SqlDbType.Char, 2).Value = BE.talla03; cmd.Parameters.Add("@talla04", SqlDbType.Char, 2).Value = BE.talla04; cmd.Parameters.Add("@talla05", SqlDbType.Char, 2).Value = BE.talla05; cmd.Parameters.Add("@talla06", SqlDbType.Char, 2).Value = BE.talla06; cmd.Parameters.Add("@talla07", SqlDbType.Char, 2).Value = BE.talla07; cmd.Parameters.Add("@talla08", SqlDbType.Char, 2).Value = BE.talla08; cmd.Parameters.Add("@talla09", SqlDbType.Char, 2).Value = BE.talla09; cmd.Parameters.Add("@talla10", SqlDbType.Char, 2).Value = BE.talla10; cmd.Parameters.Add("@talla11", SqlDbType.Char, 2).Value = BE.talla11; cmd.Parameters.Add("@talla12", SqlDbType.Char, 2).Value = BE.talla12; cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
private void llenar_GridExaminar() { try { var BL = new pt_tallaBL(); var BE = new tb_pt_talla(); BE.coltall = txtDescrip.Text; PCGCURSOR = BL.GetAll_vertical(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Update() { try { if (tallaid.Text.Trim().Length != 2) { MessageBox.Show("Falta Codigo Talla !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (tallaname.Text.Trim().Length == 0) { MessageBox.Show("Ingrese Nombre de Talla", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { tb_pt_tallaBL BL = new tb_pt_tallaBL(); tb_pt_talla BE = new tb_pt_talla(); BE.tallaid = tallaid.Text.Trim().PadLeft(2, '0'); BE.tallaname = tallaname.Text.ToUpper(); BE.talla01 = talla01.Text; BE.talla02 = talla02.Text; BE.talla03 = talla03.Text; BE.talla04 = talla04.Text; BE.talla05 = talla05.Text; BE.talla06 = talla06.Text; BE.talla07 = talla07.Text; BE.talla08 = talla08.Text; BE.talla09 = talla09.Text; BE.talla10 = talla10.Text; BE.talla11 = talla11.Text; BE.talla12 = talla12.Text; BE.usuar = VariablesPublicas.Usuar.Trim(); if (BL.Update(EmpresaID, BE)) { SEGURIDAD_LOG("M"); MessageBox.Show("Datos Modificado Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); procesado = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void form_cargar_datos(String posicion) { try { tb_pt_tallaBL BL = new tb_pt_tallaBL(); tb_pt_talla BE = new tb_pt_talla(); DataTable dt = new DataTable(); if (tallaid.Text.Trim().Length > 0){ BE.tallaid = tallaid.Text.Trim().PadLeft(2, '0'); } BE.posicion = posicion.Trim(); dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { limpiar_documento(); ssModo = "EDIT"; tallaid.Text = dt.Rows[0]["tallaid"].ToString().Trim(); tallaname.Text = dt.Rows[0]["tallaname"].ToString().Trim(); talla01.Text = dt.Rows[0]["talla01"].ToString().Trim(); talla02.Text = dt.Rows[0]["talla02"].ToString().Trim(); talla03.Text = dt.Rows[0]["talla03"].ToString().Trim(); talla04.Text = dt.Rows[0]["talla04"].ToString().Trim(); talla05.Text = dt.Rows[0]["talla05"].ToString().Trim(); talla06.Text = dt.Rows[0]["talla06"].ToString().Trim(); talla07.Text = dt.Rows[0]["talla07"].ToString().Trim(); talla08.Text = dt.Rows[0]["talla08"].ToString().Trim(); talla09.Text = dt.Rows[0]["talla09"].ToString().Trim(); talla10.Text = dt.Rows[0]["talla10"].ToString().Trim(); talla11.Text = dt.Rows[0]["talla11"].ToString().Trim(); talla12.Text = dt.Rows[0]["talla12"].ToString().Trim(); btn_editar.Enabled = true; btn_eliminar.Enabled = true; btn_imprimir.Enabled = true; btn_primero.Enabled = true; btn_anterior.Enabled = true; btn_siguiente.Enabled = true; btn_ultimo.Enabled = true; btn_log.Enabled = true; btn_salir.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Delete() { try { if (tallaid.Text.Trim().Length != 2) { MessageBox.Show("Falta Codigo Talla !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { tb_pt_tallaBL BL = new tb_pt_tallaBL(); tb_pt_talla BE = new tb_pt_talla(); BE.tallaid = tallaid.Text.Trim().PadLeft(2, '0'); //BE.tallaname = tallaname.Text.ToUpper(); //BE.usuar = VariablesPublicas.Usuar.Trim(); if (BL.Delete(EmpresaID, BE)) { SEGURIDAD_LOG("E"); MessageBox.Show("Datos Eliminado Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); NIVEL_FORMS(); limpiar_documento(); form_bloqueado(false); data_Tablatalla(); btn_nuevo.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public DataSet GetAll_vertical(string empresaid, tb_pt_talla BE) { return tablaDA.GetAll_vertical(empresaid, BE); }
public DataSet GetAll_paginacion(string empresaid, tb_pt_talla BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPtTalla_SEARCH_paginacion", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tallaid", SqlDbType.Char, 2).Value = BE.tallaid; cmd.Parameters.Add("@posicion", SqlDbType.Char, 10).Value = BE.posicion; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public bool Insert(string empresaid, tb_pt_talla BE) { return tablaDA.Insert(empresaid, BE); }
void ValidaArticulo() { try { tb_pt_articuloBL BL = new tb_pt_articuloBL(); tb_pt_articulo BE = new tb_pt_articulo(); DataTable dt = new DataTable(); BE.top = true; BE.articidold = txt_articidold.Text; if (txt_articidold.Text.ToString().Trim().Length == 7) { dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { /************************** * PONEMOS NOMBRE A LAS COLUMNAS DEACUERDO A LA TALLAID * ***************/ tb_pt_tallaBL BL4 = new tb_pt_tallaBL(); tb_pt_talla BE4 = new tb_pt_talla(); DataTable tall = new DataTable(); BE4.tallaid = dt.Rows[0]["tallaid"].ToString(); tall = BL4.GetAll(EmpresaID, BE4).Tables[0]; dgv_color.Columns[3].HeaderText = tall.Rows[0]["talla01"].ToString(); dgv_color.Columns[4].HeaderText = tall.Rows[0]["talla02"].ToString(); dgv_color.Columns[5].HeaderText = tall.Rows[0]["talla03"].ToString(); dgv_color.Columns[6].HeaderText = tall.Rows[0]["talla04"].ToString(); dgv_color.Columns[7].HeaderText = tall.Rows[0]["talla05"].ToString(); dgv_color.Columns[8].HeaderText = tall.Rows[0]["talla06"].ToString(); dgv_color.Columns[9].HeaderText = tall.Rows[0]["talla07"].ToString(); dgv_color.Columns[10].HeaderText = tall.Rows[0]["talla08"].ToString(); dgv_color.Columns[11].HeaderText = tall.Rows[0]["talla09"].ToString(); dgv_color.Columns[12].HeaderText = tall.Rows[0]["talla10"].ToString(); dgv_color.Columns[13].HeaderText = tall.Rows[0]["talla11"].ToString(); dgv_color.Columns[14].HeaderText = tall.Rows[0]["talla12"].ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
void ValidaArticulo() { tb_pt_articuloBL BL = new tb_pt_articuloBL(); tb_pt_articulo BE = new tb_pt_articulo(); DataTable dt = new DataTable(); ArmaGrilla(); BE.top = true; BE.articidold = txt_articid.Text.ToString().ToUpper(); if (txt_articid.Text.ToString().Length == 7) { dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { xarticid = dt.Rows[0]["articid"].ToString(); txt_articid.Text = dt.Rows[0]["articidold"].ToString(); txt_articname.Text = dt.Rows[0]["articname"].ToString(); txt_marcaname.Text = dt.Rows[0]["marcaname"].ToString(); txt_lineaname.Text = dt.Rows[0]["lineaname"].ToString(); txt_generoname.Text = dt.Rows[0]["generoname"].ToString(); txt_temporadaname.Text = dt.Rows[0]["temporadaname"].ToString(); txt_familiatelaname.Text = dt.Rows[0]["familianame"].ToString(); cmb_canalvta.SelectedValue = dt.Rows[0]["canalventaid"].ToString(); txt_variante.Text = dt.Rows[0]["variante"].ToString(); tb_pt_tallaBL BL2 = new tb_pt_tallaBL(); tb_pt_talla BE2 = new tb_pt_talla(); DataTable tall = new DataTable(); BE2.tallaid = dt.Rows[0]["tallaid"].ToString(); tall = BL2.GetAll(EmpresaID, BE2).Tables[0]; dgv_grilla.Columns[1].HeaderText = tall.Rows[0]["talla01"].ToString(); dgv_grilla.Columns[2].HeaderText = tall.Rows[0]["talla02"].ToString(); dgv_grilla.Columns[3].HeaderText = tall.Rows[0]["talla03"].ToString(); dgv_grilla.Columns[4].HeaderText = tall.Rows[0]["talla04"].ToString(); dgv_grilla.Columns[5].HeaderText = tall.Rows[0]["talla05"].ToString(); dgv_grilla.Columns[6].HeaderText = tall.Rows[0]["talla06"].ToString(); dgv_grilla.Columns[7].HeaderText = tall.Rows[0]["talla07"].ToString(); dgv_grilla.Columns[8].HeaderText = tall.Rows[0]["talla08"].ToString(); dgv_grilla.Columns[9].HeaderText = tall.Rows[0]["talla09"].ToString(); dgv_grilla.Columns[10].HeaderText = tall.Rows[0]["talla10"].ToString(); dgv_grilla.Columns[11].HeaderText = tall.Rows[0]["talla11"].ToString(); dgv_grilla.Columns[12].HeaderText = tall.Rows[0]["talla12"].ToString(); dgv_grilla.Columns[1].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta01"]); dgv_grilla.Columns[1].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta01"])) == true ? Color.LightSteelBlue : Color.Teal; dgv_grilla.Columns[2].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta02"]); dgv_grilla.Columns[2].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta02"])) == true ? Color.LightSteelBlue : Color.Teal; dgv_grilla.Columns[3].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta03"]); dgv_grilla.Columns[3].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta03"])) == true ? Color.LightSteelBlue : Color.Teal; dgv_grilla.Columns[4].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta04"]); dgv_grilla.Columns[4].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta04"])) == true ? Color.LightSteelBlue : Color.Teal; dgv_grilla.Columns[5].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta05"]); dgv_grilla.Columns[5].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta05"])) == true ? Color.LightSteelBlue : Color.Teal; dgv_grilla.Columns[6].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta06"]); dgv_grilla.Columns[6].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta06"])) == true ? Color.LightSteelBlue : Color.Teal; dgv_grilla.Columns[7].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta07"]); dgv_grilla.Columns[7].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta07"])) == true ? Color.LightSteelBlue : Color.Teal; dgv_grilla.Columns[8].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta08"]); dgv_grilla.Columns[8].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta08"])) == true ? Color.LightSteelBlue : Color.Teal; dgv_grilla.Columns[9].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta09"]); dgv_grilla.Columns[9].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta09"])) == true ? Color.LightSteelBlue : Color.Teal; dgv_grilla.Columns[10].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta10"]); dgv_grilla.Columns[10].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta10"])) == true ? Color.LightSteelBlue : Color.Teal; dgv_grilla.Columns[11].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta11"]); dgv_grilla.Columns[11].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta11"])) == true ? Color.LightSteelBlue : Color.Teal; dgv_grilla.Columns[12].ReadOnly = !Convert.ToBoolean(dt.Rows[0]["ta12"]); dgv_grilla.Columns[12].DefaultCellStyle.BackColor = !(Convert.ToBoolean(dt.Rows[0]["ta12"])) == true ? Color.LightSteelBlue : Color.Teal; lbltaco01.Text = tall.Rows[0]["talla01"].ToString(); lbltaco02.Text = tall.Rows[0]["talla02"].ToString(); lbltaco03.Text = tall.Rows[0]["talla03"].ToString(); lbltaco04.Text = tall.Rows[0]["talla04"].ToString(); lbltaco05.Text = tall.Rows[0]["talla05"].ToString(); lbltaco06.Text = tall.Rows[0]["talla06"].ToString(); lbltaco07.Text = tall.Rows[0]["talla07"].ToString(); lbltaco08.Text = tall.Rows[0]["talla08"].ToString(); lbltaco09.Text = tall.Rows[0]["talla09"].ToString(); lbltaco10.Text = tall.Rows[0]["talla10"].ToString(); lbltaco11.Text = tall.Rows[0]["talla11"].ToString(); lbltaco12.Text = tall.Rows[0]["talla12"].ToString(); txt_taco01.Enabled = Convert.ToBoolean(dt.Rows[0]["ta01"]); txt_taco01.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta01"])) == true ? Color.Teal : Color.White; txt_taco01.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta01"])) == true ? Color.White : Color.Black; txt_taco02.Enabled = Convert.ToBoolean(dt.Rows[0]["ta02"]); txt_taco02.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta02"])) == true ? Color.Teal : Color.White; txt_taco02.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta02"])) == true ? Color.White : Color.Black; txt_taco03.Enabled = Convert.ToBoolean(dt.Rows[0]["ta03"]); txt_taco03.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta03"])) == true ? Color.Teal : Color.White; txt_taco03.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta03"])) == true ? Color.White : Color.Black; txt_taco04.Enabled = Convert.ToBoolean(dt.Rows[0]["ta04"]); txt_taco04.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta04"])) == true ? Color.Teal : Color.White; txt_taco04.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta04"])) == true ? Color.White : Color.Black; txt_taco05.Enabled = Convert.ToBoolean(dt.Rows[0]["ta05"]); txt_taco05.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta05"])) == true ? Color.Teal : Color.White; txt_taco05.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta05"])) == true ? Color.White : Color.Black; txt_taco06.Enabled = Convert.ToBoolean(dt.Rows[0]["ta06"]); txt_taco06.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta06"])) == true ? Color.Teal : Color.White; txt_taco06.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta06"])) == true ? Color.White : Color.Black; txt_taco07.Enabled = Convert.ToBoolean(dt.Rows[0]["ta07"]); txt_taco07.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta07"])) == true ? Color.Teal : Color.White; txt_taco07.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta07"])) == true ? Color.White : Color.Black; txt_taco08.Enabled = Convert.ToBoolean(dt.Rows[0]["ta08"]); txt_taco08.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta08"])) == true ? Color.Teal : Color.White; txt_taco08.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta08"])) == true ? Color.White : Color.Black; txt_taco09.Enabled = Convert.ToBoolean(dt.Rows[0]["ta09"]); txt_taco09.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta09"])) == true ? Color.Teal : Color.White; txt_taco09.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta09"])) == true ? Color.White : Color.Black; txt_taco10.Enabled = Convert.ToBoolean(dt.Rows[0]["ta10"]); txt_taco10.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta10"])) == true ? Color.Teal : Color.White; txt_taco10.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta10"])) == true ? Color.White : Color.Black; txt_taco11.Enabled = Convert.ToBoolean(dt.Rows[0]["ta11"]); txt_taco11.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta11"])) == true ? Color.Teal : Color.White; txt_taco11.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta11"])) == true ? Color.White : Color.Black; txt_taco12.Enabled = Convert.ToBoolean(dt.Rows[0]["ta12"]); txt_taco12.BackColor = (Convert.ToBoolean(dt.Rows[0]["ta12"])) == true ? Color.Teal : Color.White; txt_taco12.ForeColor = (Convert.ToBoolean(dt.Rows[0]["ta12"])) == true ? Color.White : Color.Black; //dgv_grilla.Columns[12].HeaderText = tall.Rows[0]["talla12"].ToString(); dgv_ordenprodcolor.Columns[6].HeaderText = tall.Rows[0]["talla01"].ToString(); dgv_ordenprodcolor.Columns[7].HeaderText = tall.Rows[0]["talla02"].ToString(); dgv_ordenprodcolor.Columns[8].HeaderText = tall.Rows[0]["talla03"].ToString(); dgv_ordenprodcolor.Columns[9].HeaderText = tall.Rows[0]["talla04"].ToString(); dgv_ordenprodcolor.Columns[10].HeaderText = tall.Rows[0]["talla05"].ToString(); dgv_ordenprodcolor.Columns[11].HeaderText = tall.Rows[0]["talla06"].ToString(); dgv_ordenprodcolor.Columns[12].HeaderText = tall.Rows[0]["talla07"].ToString(); dgv_ordenprodcolor.Columns[13].HeaderText = tall.Rows[0]["talla08"].ToString(); dgv_ordenprodcolor.Columns[14].HeaderText = tall.Rows[0]["talla09"].ToString(); dgv_ordenprodcolor.Columns[15].HeaderText = tall.Rows[0]["talla10"].ToString(); dgv_ordenprodcolor.Columns[16].HeaderText = tall.Rows[0]["talla11"].ToString(); dgv_ordenprodcolor.Columns[17].HeaderText = tall.Rows[0]["talla12"].ToString(); } } }
private void CargarComboArticuloTallas(String xtallaid) { //Cargamos el Combo de Tallas ----> Que biene en forma Vertical tb_pt_tallaWebBL BL3 = new tb_pt_tallaWebBL(); tb_pt_talla BE3 = new tb_pt_talla(); DataTable dt3 = new DataTable(); BE3.tallaid = xtallaid.ToString(); TablaTallas = BL3.GetAll_vertical(Session["ssEmpresaID"].ToString(), BE3).Tables[0]; DataTable dtDatos = new DataTable(); if (TablaTallas.Rows.Count > 0) { dtDatos.Columns.Add("tallaid"); dtDatos.Columns.Add("tallacol"); dtDatos.Columns.Add("talla"); string talla0 = " - [ Talla: "; string talla1 = ""; for (int i = 0; i < TablaTallas.Rows.Count; i++) { DataRow dtRow = dtDatos.NewRow(); dtRow["tallaid"] = TablaTallas.Rows[i]["tallaid"].ToString(); talla1 = TablaTallas.Rows[i]["tallacol"].ToString().Substring(5, 2) + talla0.ToString() + TablaTallas.Rows[i]["talla"].ToString() +' '+']'; dtRow["talla"] = talla1.ToString(); //dtRow["tallacol"] = TablaTallas.Rows[i]["tallacol"].ToString(); //dtRow["talla"] = TablaTallas.Rows[i]["talla"].ToString(); dtDatos.Rows.Add(dtRow); } cmb_tallaid.DataSource = dtDatos; cmb_tallaid.DataValueField = "tallaid"; cmb_tallaid.DataTextField = "talla"; cmb_tallaid.DataBind(); } }