void ValidaArticulo2()
{
if (txt_articidoldbus.Text.ToString().Length == 7)
{
DataTable Data = new DataTable();
String Query = " SELECT DISTINCT a.articid,articidold,articname,max(rd.[version])'version' " +
" FROM tb_pt_articulo a " +
" INNER JOIN tb_pp_recetadet rd ON a.articid = rd.articid " +
" WHERE articidold = '" + txt_articidoldbus.Text + "' GROUP BY a.articid,articidold,articname ";
Data = DatosSQL(Query);
if (Data.Rows.Count > 0)
{
xarticid = Data.Rows[0]["articid"].ToString();
txt_articidoldbus.Text = Data.Rows[0]["articidold"].ToString();
txt_articnamebus.Text = Data.Rows[0]["articname"].ToString();
txt_versionbus.Text = Data.Rows[0]["version"].ToString();
tb_pt_articuloBL BL = new tb_pt_articuloBL();
tb_pt_articulo BE = new tb_pt_articulo();
DataTable dt = new DataTable();
BE.articid = Data.Rows[0]["articid"].ToString();
BE.top = true;
dt = BL.GetAll_Color(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
dgv_color.Columns[2].HeaderText = dt.Rows[0]["talla01"].ToString();
dgv_color.Columns[3].HeaderText = dt.Rows[0]["talla02"].ToString();
dgv_color.Columns[4].HeaderText = dt.Rows[0]["talla03"].ToString();
dgv_color.Columns[5].HeaderText = dt.Rows[0]["talla04"].ToString();
dgv_color.Columns[6].HeaderText = dt.Rows[0]["talla05"].ToString();
dgv_color.Columns[7].HeaderText = dt.Rows[0]["talla06"].ToString();
dgv_color.Columns[8].HeaderText = dt.Rows[0]["talla07"].ToString();
dgv_color.Columns[9].HeaderText = dt.Rows[0]["talla08"].ToString();
dgv_color.Columns[10].HeaderText = dt.Rows[0]["talla09"].ToString();
dgv_color.Columns[11].HeaderText = dt.Rows[0]["talla10"].ToString();
dgv_color.Columns[12].HeaderText = dt.Rows[0]["talla11"].ToString();
dgv_color.Columns[13].HeaderText = dt.Rows[0]["talla12"].ToString();
dgv_color.AutoGenerateColumns = false;
dgv_color.DataSource = dt;
dgv_color.Enabled = true;
}
PintarCeldas();
}
else
{
MessageBox.Show("El Articulo No tiene Recetas...!!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
void ValidaArticulo()
{
tb_pt_articuloBL BL = new tb_pt_articuloBL();
tb_pt_articulo BE = new tb_pt_articulo();
tb_pt_articulo BE2 = new tb_pt_articulo();
DataTable dt = new DataTable();
BE.articidold = txt_articidold.Text;
dt = BL.GetAll(EmpresaID,BE).Tables[0];
if (dt.Rows.Count > 0)
{
txt_articidold.Text = dt.Rows[0]["articidold"].ToString();
txt_articname.Text = dt.Rows[0]["articname"].ToString();
BE2.articid = dt.Rows[0]["articid"].ToString();
xarticid = dt.Rows[0]["articid"].ToString();
// Aca Generamos el Nuevo Correlativo
GeneraVersion(dt.Rows[0]["articid"].ToString());
BE2.top = true;
if (txt_articidold.Text.ToString().Length == 7 || txt_articidoldbus.Text.ToString().Length == 7)
{
dt = BL.GetAll_Color(EmpresaID, BE2).Tables[0];
if (dt.Rows.Count > 0)
{
dgv_color.Columns[2].HeaderText = dt.Rows[0]["talla01"].ToString();
dgv_color.Columns[3].HeaderText = dt.Rows[0]["talla02"].ToString();
dgv_color.Columns[4].HeaderText = dt.Rows[0]["talla03"].ToString();
dgv_color.Columns[5].HeaderText = dt.Rows[0]["talla04"].ToString();
dgv_color.Columns[6].HeaderText = dt.Rows[0]["talla05"].ToString();
dgv_color.Columns[7].HeaderText = dt.Rows[0]["talla06"].ToString();
dgv_color.Columns[8].HeaderText = dt.Rows[0]["talla07"].ToString();
dgv_color.Columns[9].HeaderText = dt.Rows[0]["talla08"].ToString();
dgv_color.Columns[10].HeaderText = dt.Rows[0]["talla09"].ToString();
dgv_color.Columns[11].HeaderText = dt.Rows[0]["talla10"].ToString();
dgv_color.Columns[12].HeaderText = dt.Rows[0]["talla11"].ToString();
dgv_color.Columns[13].HeaderText = dt.Rows[0]["talla12"].ToString();
dgv_color.AutoGenerateColumns = false;
dgv_color.DataSource = dt;
dgv_color.Enabled = true;
}
}
}
}