private void data_articuloid(String xarticid)
{
form_bloqueado(false);
var rowarticid = Tablaarticulo.Select("articid='" + xarticid + "'");
if (rowarticid.Length > 0)
{
foreach (DataRow row in rowarticid)
{
articid.Text = row["articid"].ToString().Trim();
articidold.Text = row["articidold"].ToString().Trim();
grupoid.Text = row["grupoid"].ToString().Trim();
gruponame.Text = row["gruponame"].ToString().Trim();
articname.Text = row["articname"].ToString().Trim();
marcaid.Text = row["marcaid"].ToString().Trim();
Valida_Marca(marcaid.Text);
marcaname.Text = row["marcaname"].ToString().Trim();
lineaid.Text = row["lineaid"].ToString().Trim();
Valida_Linea(lineaid.Text);
lineaname.Text = row["lineaname"].ToString().Trim();
modeloid.Text = row["modeloid"].ToString().Trim();
modeloname.Text = row["modeloname"].ToString().Trim();
familiatelaid.Text = row["familiatelaid"].ToString().Trim();
if (familiatelaid.Text.Length > 0)
{
Valida_Familia(familiatelaid.Text);
}
familiatelaname.Text = row["familianame"].ToString().Trim();
coleccionid.Text = row["coleccionid"].ToString().Trim();
coleccionname.Text = row["coleccionname"].ToString().Trim();
cboCanalventaid.SelectedValue = row["canalventaid"].ToString().Trim();
cmb_estacionid.SelectedValue = row["estacionid"].ToString().Trim();
cmb_temporadaid.SelectedValue = row["temporadaid"].ToString().Trim();
cmb_categoriaid.SelectedValue = row["categoriaid"].ToString().Trim();
cmb_generoid.SelectedValue = row["generoid"].ToString().Trim();
cmb_parteid.SelectedValue = row["parteid"].ToString().Trim();
cmb_entalleid.SelectedValue = row["entalleid"].ToString().Trim();
cmb_botapieid.SelectedValue = row["botapieid"].ToString().Trim();
cmb_tallaid.SelectedValue = row["tallaid"].ToString().Trim();
cmb_estadoid.SelectedValue = row["estadoid"].ToString().Trim();
var num = Convert.ToBoolean(row["es_mercaderia"].ToString());
var n = 0;
if (num)
{
n = 1;
}
else
{
if (!num)
{
n = 0;
}
}
cmb_esmercaderia.SelectedIndex = n;
cmb_procedenciaid.SelectedValue = row["procedenciaid"].ToString().Trim();
chk_ta01.Checked = Convert.ToBoolean(row["ta01"].ToString().Trim());
chk_ta01.Text = row["talla01"].ToString().Trim();
chk_ta02.Checked = Convert.ToBoolean(row["ta02"].ToString().Trim());
chk_ta02.Text = row["talla02"].ToString().Trim();
chk_ta03.Checked = Convert.ToBoolean(row["ta03"].ToString().Trim());
chk_ta03.Text = row["talla03"].ToString().Trim();
chk_ta04.Checked = Convert.ToBoolean(row["ta04"].ToString().Trim());
chk_ta04.Text = row["talla04"].ToString().Trim();
chk_ta05.Checked = Convert.ToBoolean(row["ta05"].ToString().Trim());
chk_ta05.Text = row["talla05"].ToString().Trim();
chk_ta06.Checked = Convert.ToBoolean(row["ta06"].ToString().Trim());
chk_ta06.Text = row["talla06"].ToString().Trim();
chk_ta07.Checked = Convert.ToBoolean(row["ta07"].ToString().Trim());
chk_ta07.Text = row["talla07"].ToString().Trim();
chk_ta08.Checked = Convert.ToBoolean(row["ta08"].ToString().Trim());
chk_ta08.Text = row["talla08"].ToString().Trim();
chk_ta09.Checked = Convert.ToBoolean(row["ta09"].ToString().Trim());
chk_ta09.Text = row["talla09"].ToString().Trim();
chk_ta10.Checked = Convert.ToBoolean(row["ta10"].ToString().Trim());
chk_ta10.Text = row["talla10"].ToString().Trim();
chk_ta11.Checked = Convert.ToBoolean(row["ta11"].ToString().Trim());
chk_ta11.Text = row["talla11"].ToString().Trim();
chk_ta12.Checked = Convert.ToBoolean(row["ta12"].ToString().Trim());
chk_ta12.Text = row["talla12"].ToString().Trim();
txtvariante.Text = row["variante"].ToString();
txtcodtizados.Text = row["codinge"].ToString();
prec_costo.Text = row["prec_costo"].ToString();
real_costo.Text = row["real_costo"].ToString();
precventa_cre_mayor.Text = row["precventa_cre_mayor"].ToString();
precventa_cre_menor.Text = row["precventa_cre_menor"].ToString();
precventa_tda_mayor.Text = row["precventa_tda_mayor"].ToString();
precventa_tda_menor.Text = row["precventa_tda_menor"].ToString();
precventa_csc_mayor.Text = row["precventa_csc_mayor"].ToString();
precventa_csc_menor.Text = row["precventa_csc_menor"].ToString();
prec_etiq.Text = row["prec_etiq"].ToString();
prec_ofer.Text = row["prec_ofer"].ToString();
var BE = new tb_pt_articulo();
var BL = new tb_pt_articuloBL();
var dt = new DataTable();
BE.articidold = articidold.Text.Trim();
dt = BL.GetAll_foto(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["foto"].ToString() != string.Empty)
{
var MyData1 = (byte[])null;
MyData1 = (byte[])(dt.Rows[0]["foto"]);
if (MyData1 != null && MyData1.Length != 0)
{
vmContenidoFile = MyData1;
foto.Visible = true;
foto.Image = null;
var ms = new System.IO.MemoryStream();
_nombreFoto = dt.Rows[0]["docname"].ToString();
ms.Write(MyData1, 0, MyData1.Length);
foto.Image = Image.FromStream(ms);
}
else
{
foto.Visible = false;
foto.ImageLocation = string.Empty;
}
}
else
{
foto.Visible = false;
foto.ImageLocation = string.Empty;
}
}
else
{
foto.Visible = false;
foto.ImageLocation = string.Empty;
}
btn_nuevo.Enabled = true;
btn_editar.Enabled = true;
btn_eliminar.Enabled = true;
btn_imprimir.Enabled = true;
btn_primero.Enabled = false;
btn_anterior.Enabled = false;
btn_siguiente.Enabled = false;
btn_ultimo.Enabled = false;
btn_log.Enabled = true;
btn_salir.Enabled = true;
}
}
}
