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();
}
}
}
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_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 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";
}
}
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);
}
}
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);
}
}
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);
}
}
