public DataSet GeneraCod2(string empresaid, tb_pt_articulo BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPtArticulo_GENERA_cod2", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@marcaid", SqlDbType.Char, 2).Value = BE.marcaid;
cmd.Parameters.Add("@modeloid", SqlDbType.Char, 4).Value = BE.modeloid;
cmd.Parameters.Add("@familiatelaid", SqlDbType.Char, 3).Value = BE.familiatelaid;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Delete(string empresaid, tb_pt_articulo BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPtArticulo_DELETE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@articid", SqlDbType.Char, 4).Value = BE.articid;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll_CODdbf(string empresaid, tb_pt_articulo BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
"SELECT COUNT(*) cant FROM ptema700 WHERE pt700idar = ?";
using (OleDbCommand cmd = new OleDbCommand(commandString, cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.Add("@pt700idar ", OleDbType.Char, 7).Value = BE.articidold.ToString();
}
try
{
cnx.Open();
using (OleDbDataAdapter da = new OleDbDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private void ValidaArticulo(String xcod)
{
var BE = new tb_pt_articulo();
var BL = new tb_pt_articuloBL();
var dt = new DataTable();
BE.articid = xcod.Trim();
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
articid.Text = dt.Rows[0]["articid"].ToString();
articidold.Text = dt.Rows[0]["articidold"].ToString();
articname.Text = dt.Rows[0]["articname"].ToString();
}
else
{
articid.Text = string.Empty;
articidold.Text = string.Empty;
articname.Text = string.Empty;
}
}
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;
}
}
}
private void ValidaInsert_Update()
{
var BL = new tb_pt_articuloBL();
var BE = new tb_pt_articulo();
var dt = new DataTable();
BE.articidold = articidold.Text.Trim();
dt = BL.GetAll_CODdbf(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
var n = Convert.ToInt32(dt.Rows[0]["cant"].ToString());
if (n > 0)
{
Update_DBF();
}
else
{
Insert_DBF();
}
}
}
private void Update_DBF()
{
try
{
if (articid.Text.Trim().Length != 4)
{
MessageBox.Show("Falta Codigo Artículo !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (grupoid.Text.Trim().Length == 0)
{
MessageBox.Show("Falta Codigo de Proveedor", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (marcaid.Text.Trim().Length == 0)
{
MessageBox.Show("Falta Codigo de Marca", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (lineaid.Text.Trim().Length == 0)
{
MessageBox.Show("Falta Codigo de Linea", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (articidold.Text.Trim().Length == 0)
{
MessageBox.Show("Falta Codigo de Articulo-Generado", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (cmb_categoriaid.SelectedIndex == -1)
{
MessageBox.Show("Falta Seleccionar La Categoria", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (cmb_generoid.SelectedIndex == -1)
{
MessageBox.Show("Falta Seleccionar el Genero", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (cmb_tallaid.SelectedIndex == -1)
{
MessageBox.Show("Falta Seleccionar Talla", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (cmb_procedenciaid.SelectedIndex == -1)
{
MessageBox.Show("Falta Seleccionar Procedencia", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (cmb_estadoid.SelectedIndex == -1)
{
MessageBox.Show("Falta Seleccionar Situación", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (prec_costo.Text.Trim().Length == 0)
{
MessageBox.Show("Falta Ingresar el Prec-Costo", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var BL = new tb_pt_articuloBL();
var BE = new tb_pt_articulo();
BE.articid = articid.Text.Trim();
BE.articidold = articidold.Text.Trim();
BE.articname = articname.Text.Trim();
BE.articdsav = string.Empty;
BE.preccosto = Convert.ToDecimal(prec_costo.Text.Trim());
if (real_costo.Text.Length > 0)
{
BE.real_costo = Convert.ToDecimal(real_costo.Text.Trim());
}
else
{
BE.real_costo = Convert.ToDecimal("0.00".ToString());
}
BE.precventa_cre_mayor = Convert.ToDecimal(precventa_cre_mayor.Text.Trim());
BE.precventa_cre_menor = Convert.ToDecimal(precventa_cre_menor.Text.Trim());
BE.precventa_tda_mayor = Convert.ToDecimal(precventa_tda_mayor.Text.Trim());
BE.precventa_tda_menor = Convert.ToDecimal(precventa_tda_menor.Text.Trim());
BE.precventa_csc_mayor = Convert.ToDecimal(precventa_csc_mayor.Text.Trim());
BE.precventa_csc_menor = Convert.ToDecimal(precventa_csc_menor.Text.Trim());
BE.categoriaid = Equivalencias.Right(cmb_categoriaid.SelectedValue.ToString(), 1);
BE.marcaid = marcaid.Text.Trim();
BE.lineaid = lineaid.Text.Trim();
BE.generoid = cmb_generoid.SelectedValue.ToString();
if (cmb_generoid.SelectedValue.ToString() == "1".ToString())
{
BE.generoid2 = "C".ToString();
}
if (cmb_generoid.SelectedValue.ToString() == "2".ToString())
{
BE.generoid2 = "D".ToString();
}
if (cmb_generoid.SelectedValue.ToString() == "3".ToString())
{
BE.generoid2 = "N".ToString();
}
BE.tejidoid = _tejidoid.ToString();
BE.familiatelaid = familiatelaid.Text.Trim();
if (cmb_botapieid.SelectedIndex != -1)
{
BE.botapieid = cmb_botapieid.SelectedValue.ToString();
}
else
{
BE.botapieid = string.Empty.ToString();
}
if (cmb_entalleid.SelectedIndex != -1)
{
BE.entalleid = cmb_entalleid.SelectedValue.ToString();
}
else
{
BE.entalleid = string.Empty.ToString();
}
BE.coleccionid = coleccionid.Text.Trim();
BE.subcoleccionid = subcoleccionid.Text.Trim();
if (cmb_temporadaid.SelectedIndex != -1)
{
BE.temporadaid = cmb_temporadaid.SelectedValue.ToString();
}
else
{
BE.temporadaid = string.Empty;
}
BE.telaidvfp = string.Empty;
BE.modeloid = modeloid.Text.Trim();
BE.estructuraid = _estructuraid.ToString();
if (cmb_estacionid.SelectedValue != null)
{
BE.estacionid = cmb_estacionid.SelectedValue.ToString();
}
else
{
BE.estacionid = string.Empty.ToString();
}
if (cmb_temporadaid.SelectedValue != null)
{
BE.temporadaid = cmb_temporadaid.SelectedValue.ToString();
}
else
{
BE.temporadaid = string.Empty.ToString();
}
BE.procedenciaid = cmb_procedenciaid.SelectedValue.ToString();
BE.grupoid = grupoid.Text.Trim();
BE.rubroid = string.Empty;
if (cmb_parteid.SelectedIndex != -1)
{
BE.parte = cmb_parteid.SelectedValue.ToString();
}
else
{
BE.parte = string.Empty.ToString();
}
BE.tallaid = cmb_tallaid.SelectedValue.ToString();
BE.ta01 = chk_ta01.Checked;
BE.ta02 = chk_ta02.Checked;
BE.ta03 = chk_ta03.Checked;
BE.ta04 = chk_ta04.Checked;
BE.ta05 = chk_ta05.Checked;
BE.ta06 = chk_ta06.Checked;
BE.ta07 = chk_ta07.Checked;
BE.ta08 = chk_ta08.Checked;
BE.ta09 = chk_ta09.Checked;
BE.ta10 = chk_ta10.Checked;
BE.ta11 = chk_ta11.Checked;
BE.ta12 = chk_ta12.Checked;
BE.variante = txtvariante.Text.Trim();
BE.codinge = txtcodtizados.Text.Trim();
BE.prec_etiq = Convert.ToDecimal(prec_etiq.Text.ToString());
BE.prec_ofer = Convert.ToDecimal(prec_ofer.Text.ToString());
BE.fechpi = DateTime.Today;
BE.fechui = DateTime.Today;
if (cmb_estadoid.SelectedValue.ToString() == "SA")
{
BE.estado2 = true;
}
else
{
BE.estado2 = false;
}
BE.estado = cmb_estadoid.SelectedValue.ToString();
if (cmb_esmercaderia.SelectedIndex != -1)
{
BE.es_mercaderia = Convert.ToBoolean(cmb_esmercaderia.SelectedIndex);
}
BE.status = "0";
BE.usuar = VariablesPublicas.Usuar.Trim();
BE.marcaname = marcaname.Text.ToString();
BE.lineaidold = _xlineaidold.ToString();
BE.marcaidold = _xmarcaidold.ToString();
if (BL.Update_dbf(EmpresaID, BE))
{
MessageBox.Show("Datos Modificados Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
procesado = true;
}
}
}
}
}
}
}
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Insert_Foto()
{
try
{
var BL = new tb_pt_articuloBL();
var BE = new tb_pt_articulo();
BE.articidold = articidold.Text.Trim();
BE.docname = _nombreFoto.ToString();
var ms = new System.IO.MemoryStream();
if (foto.Image != null)
{
foto.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
}
BE.Foto = ms.GetBuffer();
BL.Insert_Foto(EmpresaID, BE);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
void act_Nombre()
{
var BL = new tb_pt_articuloBL();
var BE = new tb_pt_articulo();
DataTable dt = new DataTable();
BE.variante = txtvariante.Text.ToString().ToUpper().Trim();
dt = BL.GetAll_DESCORT(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
_xmarcadescort = dt.Rows[0]["marcadescort"].ToString();
_xlineadescort = dt.Rows[0]["lineadescort"].ToString();
_xmodelodescort = dt.Rows[0]["modelodescort"].ToString();
_xentalledescort = dt.Rows[0]["entalledescort"].ToString();
_xbotapiedescort = dt.Rows[0]["botapiedescort"].ToString();
_xgenerodescort = dt.Rows[0]["generodescort"].ToString();
_GenerarNombre();
}
}
private void ValidamosCombinación()
{
var BE = new tb_pt_articulo();
var BL = new tb_pt_articuloBL();
var dt = new DataTable();
BE.marcaid = marcaid.Text.Trim();
BE.lineaid = lineaid.Text.Trim();
BE.modeloid = modeloid.Text.Trim();
BE.familiatelaid = familiatelaid.Text.Trim();
dt = BL.GeneraCod(EmpresaID, BE).Tables[0];
if (dt.Rows[0]["codigo"].ToString() != string.Empty)
{
codtizado.Text = dt.Rows[0]["codigo"].ToString();
pnl_02.Enabled = false;
}
else
{
MessageBox.Show("Ya Existe Combinación ...!!!");
limpiar_documento();
pnl_02.Enabled = true;
return;
}
}
public bool Update_foto(string empresaid, tb_pt_articulo BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPtArticulo_UPDATE_foto", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@articidold", SqlDbType.Char, 8).Value = BE.articidold;
cmd.Parameters.Add("@docname", SqlDbType.VarChar, 100).Value = BE.docname;
cmd.Parameters.Add("@foto", SqlDbType.Image).Value = BE.Foto;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Update_dbf(string empresaid, tb_pt_articulo BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
"UPDATE ptema700 SET pt700name = ? ,pt700dsav = ? ,pt700pcos = ? ,pt700pma1 = ? ,pt700pme1 = ? ,pt700pma2 = ? ,pt700pme2 = ? ,pt700pma3 = ? " +
",pt700pme3 = ? ,pt700gene = ? ,pt700idta = ? ,pt700marc = ? ,pt700usid = ? ,pt700feac = ? ,pt700idmc = ? ,pt700idli = ? " +
",pt700idgn = ? ,pt700idca = ? ,pt700inge = ? ,pt700petq = ? ,pt700pofe = ? ,pt700idtp = ? ,pt700idprv = ? " +
",pt700flsa = ? ,pt700idco = ? ,pt700idtj = ? ,pt700fecho = ? ,temporadaid = ? ,estacionid = ? ,parteid = ? ,estructuraid = ? " +
",botapieid = ? ,entalleid = ? " +
" WHERE pt700idar = ? " ;
OleDbCommand cmd = new OleDbCommand(commandString, cnx);
cmd.Parameters.Add("@pt700name ", OleDbType.VarChar, 40).Value = BE.articname.ToString();
cmd.Parameters.Add("@pt700dsav ", OleDbType.Char, 35).Value = BE.articdsav.ToString();
cmd.Parameters.Add("@pt700pcos ", OleDbType.Decimal).Value = BE.preccosto.ToString();
cmd.Parameters.Add("@pt700pma1 ", OleDbType.Decimal).Value = BE.precventa_cre_mayor.ToString();
cmd.Parameters.Add("@pt700pme1 ", OleDbType.Decimal).Value = BE.precventa_cre_menor.ToString();
cmd.Parameters.Add("@pt700pma2 ", OleDbType.Decimal).Value = BE.precventa_tda_mayor.ToString();
cmd.Parameters.Add("@pt700pme2 ", OleDbType.Decimal).Value = BE.precventa_tda_menor.ToString();
cmd.Parameters.Add("@pt700pma3 ", OleDbType.Decimal).Value = BE.precventa_csc_mayor.ToString();
cmd.Parameters.Add("@pt700pme3 ", OleDbType.Decimal).Value = BE.precventa_csc_menor.ToString();
cmd.Parameters.Add("@pt700gene ", OleDbType.Char, 1).Value = BE.generoid.ToString();
cmd.Parameters.Add("@pt700idta ", OleDbType.Char, 2).Value = BE.tallaid.ToString();
cmd.Parameters.Add("@pt700marc ", OleDbType.VarChar, 15).Value = BE.marcaname.ToString();
cmd.Parameters.Add("@pt700usid ", OleDbType.Char, 3).Value = BE.usuar.ToString();
cmd.Parameters.Add("@pt700feac ", OleDbType.Date).Value = DateTime.Today.ToShortDateString();
cmd.Parameters.Add("@pt700idmc ", OleDbType.Char, 2).Value = BE.marcaidold.ToString();
cmd.Parameters.Add("@pt700idli ", OleDbType.Char, 3).Value = BE.lineaidold.ToString();
cmd.Parameters.Add("@pt700idgn ", OleDbType.Char, 1).Value = BE.generoid.ToString();
cmd.Parameters.Add("@pt700idca ", OleDbType.Char, 1).Value = BE.categoriaid.ToString();
cmd.Parameters.Add("@pt700inge ", OleDbType.Char, 7).Value = BE.articidold.ToString();
cmd.Parameters.Add("@pt700petq ", OleDbType.Decimal).Value = BE.prec_etiq.ToString();
cmd.Parameters.Add("@pt700pofe ", OleDbType.Decimal).Value = BE.prec_ofer.ToString();
cmd.Parameters.Add("@pt700idtp ", OleDbType.Char, 2).Value = BE.estado.ToString();
cmd.Parameters.Add("@pt700idprv", OleDbType.Char, 4).Value = BE.grupoid.ToString();
cmd.Parameters.Add("@pt700flsa ", OleDbType.Boolean).Value = BE.estado2;
cmd.Parameters.Add("@pt700idco ", OleDbType.Char, 3).Value = BE.coleccionid.ToString();
cmd.Parameters.Add("@pt700idtj ", OleDbType.Char, 3).Value = BE.tejidoid.ToString();
cmd.Parameters.Add("@pt700fecho ", OleDbType.Date).Value = DateTime.Today.ToShortDateString();
cmd.Parameters.Add("@temporadaid ", OleDbType.Char, 1).Value = BE.temporadaid.ToString();
cmd.Parameters.Add("@estacionid ", OleDbType.Char, 1).Value = BE.estacionid.ToString();
cmd.Parameters.Add("@parteid ", OleDbType.Char, 1).Value = BE.parte.ToString();
cmd.Parameters.Add("@estructuraid ", OleDbType.Char, 1).Value = BE.estructuraid.ToString();
cmd.Parameters.Add("@botapieid ", OleDbType.Char, 2).Value = BE.botapieid.ToString();
cmd.Parameters.Add("@entalleid ", OleDbType.Char, 2).Value = BE.entalleid.ToString();
cmd.Parameters.Add("@pt700idar ", OleDbType.Char, 7).Value = BE.articidold.ToString();
cnx.Open();
try
{
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
public bool Update(string empresaid, tb_pt_articulo BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPtArticulo_UPDATE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@articid", SqlDbType.Char, 4).Value = BE.articid;
cmd.Parameters.Add("@articidold", SqlDbType.Char, 8).Value = BE.articidold;
cmd.Parameters.Add("@articname", SqlDbType.VarChar, 50).Value = BE.articname;
cmd.Parameters.Add("@articdsav", SqlDbType.VarChar, 35).Value = BE.articdsav;
cmd.Parameters.Add("@prec_costo", SqlDbType.Decimal).Value = BE.preccosto;
cmd.Parameters.Add("@real_costo", SqlDbType.Decimal).Value = BE.real_costo;
cmd.Parameters.Add("@precventaCreMayor", SqlDbType.Decimal).Value = BE.precventa_cre_mayor;
cmd.Parameters.Add("@precventaCreMenor", SqlDbType.Decimal).Value = BE.precventa_cre_menor;
cmd.Parameters.Add("@precventaTdaMayor", SqlDbType.Decimal).Value = BE.precventa_tda_mayor;
cmd.Parameters.Add("@precventaTdaMenor", SqlDbType.Decimal).Value = BE.precventa_tda_menor;
cmd.Parameters.Add("@precventaCscMayor", SqlDbType.Decimal).Value = BE.precventa_csc_mayor;
cmd.Parameters.Add("@precventaCscMenor", SqlDbType.Decimal).Value = BE.precventa_csc_menor;
cmd.Parameters.Add("@categoriaid", SqlDbType.Char, 2).Value = BE.categoriaid;
cmd.Parameters.Add("@marcaid", SqlDbType.Char, 2).Value = BE.marcaid;
cmd.Parameters.Add("@lineaid", SqlDbType.Char, 2).Value = BE.lineaid;
cmd.Parameters.Add("@generoid", SqlDbType.Char, 1).Value = BE.generoid;
cmd.Parameters.Add("@tejidoid", SqlDbType.Char, 3).Value = BE.tejidoid;
cmd.Parameters.Add("@familiatelaid", SqlDbType.Char, 3).Value = BE.familiatelaid;
cmd.Parameters.Add("@telaid", SqlDbType.Char, 10).Value = BE.telaid;
cmd.Parameters.Add("@botapieid", SqlDbType.Char, 10).Value = BE.botapieid;
cmd.Parameters.Add("@entalleid", SqlDbType.Char, 10).Value = BE.entalleid;
cmd.Parameters.Add("@coleccionid", SqlDbType.Char, 3).Value = BE.coleccionid;
cmd.Parameters.Add("@subcoleccionid", SqlDbType.Char, 2).Value = BE.subcoleccionid;
cmd.Parameters.Add("@procedenciaid", SqlDbType.Char, 1).Value = BE.procedenciaid;
cmd.Parameters.Add("@telaidvfp", SqlDbType.Char, 10).Value = BE.telaidvfp;
cmd.Parameters.Add("@modeloid", SqlDbType.Char, 4).Value = BE.modeloid;
cmd.Parameters.Add("@estructuraid", SqlDbType.Char, 1).Value = BE.estructuraid;
cmd.Parameters.Add("@canalventaid", SqlDbType.Char, 3).Value = BE.canalventaid;
cmd.Parameters.Add("@estacionid", SqlDbType.Char, 1).Value = BE.estacionid;
cmd.Parameters.Add("@temporadaid", SqlDbType.Char, 1).Value = BE.temporadaid;
cmd.Parameters.Add("@grupoid", SqlDbType.Char, 4).Value = BE.grupoid;
//cmd.Parameters.Add("@rubroid", SqlDbType.Char, 2).Value = BE.rubroid;
cmd.Parameters.Add("@parteid", SqlDbType.Char, 1).Value = BE.parte;
cmd.Parameters.Add("@tallaid", SqlDbType.Char, 2).Value = BE.tallaid;
cmd.Parameters.Add("@ta01", SqlDbType.Bit).Value = BE.ta01;
cmd.Parameters.Add("@ta02", SqlDbType.Bit).Value = BE.ta02;
cmd.Parameters.Add("@ta03", SqlDbType.Bit).Value = BE.ta03;
cmd.Parameters.Add("@ta04", SqlDbType.Bit).Value = BE.ta04;
cmd.Parameters.Add("@ta05", SqlDbType.Bit).Value = BE.ta05;
cmd.Parameters.Add("@ta06", SqlDbType.Bit).Value = BE.ta06;
cmd.Parameters.Add("@ta07", SqlDbType.Bit).Value = BE.ta07;
cmd.Parameters.Add("@ta08", SqlDbType.Bit).Value = BE.ta08;
cmd.Parameters.Add("@ta09", SqlDbType.Bit).Value = BE.ta09;
cmd.Parameters.Add("@ta10", SqlDbType.Bit).Value = BE.ta10;
cmd.Parameters.Add("@ta11", SqlDbType.Bit).Value = BE.ta11;
cmd.Parameters.Add("@ta12", SqlDbType.Bit).Value = BE.ta12;
cmd.Parameters.Add("@variante", SqlDbType.Char, 6).Value = BE.variante;
cmd.Parameters.Add("@codinge", SqlDbType.Char, 7).Value = BE.codinge;
cmd.Parameters.Add("@precEtiq", SqlDbType.Decimal).Value = BE.prec_etiq;
cmd.Parameters.Add("@precOfer", SqlDbType.Decimal).Value = BE.prec_ofer;
cmd.Parameters.Add("@fechpi", SqlDbType.DateTime).Value = BE.fechpi;
cmd.Parameters.Add("@fechui", SqlDbType.DateTime).Value = BE.fechui;
cmd.Parameters.Add("@estadoid", SqlDbType.Char, 2).Value = BE.estado;
cmd.Parameters.Add("@esMercaderia", SqlDbType.Bit).Value = BE.es_mercaderia;
cmd.Parameters.Add("@foto", SqlDbType.VarChar, 50).Value = BE.docname;
cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
cmd.Parameters.Add("@nivel", SqlDbType.Char, 1).Value = BE.nivel;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Insert_dbf(string empresaid, tb_pt_articulo BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
"INSERT INTO ptema700 (pt700stat ,pt700idar ,pt700name ,pt700dsav ,pt700pcos ,pt700pma1 ,pt700pme1 ,pt700pma2 ,pt700pme2 ,pt700pma3 " +
",pt700pme3 ,pt700gene ,pt700tabl ,pt700idta ,pt700marc ,pt700usid ,pt700feac ,pt700idmc ,pt700idli ,pt700idtj " +
",pt700idgn ,pt700idca ,pt700inge ,pt700petq ,pt700pofe ,pt700fecr ,pt700idtp ,pt700idprv,pt700flsa ,pt700idco " +
",pt700idrb ,pt700idmd ,pt700idva ,pt700fepi ,pt700feui ,pt700equi ,pt700flac ,pt700idte ,pt700feps ,pt700feus " +
",pt700artic ,pt700fecho ,temporadaid ,estacionid ,parteid ,estructuraid ,botapieid ,entalleid ,PT700PMA2O, PT700PME2O" +
",ENSQL ,FECHPITDA " +
" )" +
" VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?, ?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?, ?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?, ?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?, ?, ?, ?, ?, ?," +
"?, ? " +
")";
OleDbCommand cmd = new OleDbCommand(commandString, cnx);
cmd.Parameters.Add("@pt700stat ", OleDbType.Decimal).Value = 1;
cmd.Parameters.Add("@pt700idar ", OleDbType.Char, 7).Value = BE.articidold.ToString();
cmd.Parameters.Add("@pt700name ", OleDbType.VarChar, 40).Value = BE.articname.ToString();
cmd.Parameters.Add("@pt700dsav ", OleDbType.Char, 35).Value = BE.articdsav.ToString();
cmd.Parameters.Add("@pt700pcos ", OleDbType.Decimal).Value = BE.preccosto.ToString();
cmd.Parameters.Add("@pt700pma1 ", OleDbType.Decimal).Value = BE.precventa_cre_mayor.ToString();
cmd.Parameters.Add("@pt700pme1 ", OleDbType.Decimal).Value = BE.precventa_cre_menor.ToString();
cmd.Parameters.Add("@pt700pma2 ", OleDbType.Decimal).Value = BE.precventa_tda_mayor.ToString();
cmd.Parameters.Add("@pt700pme2 ", OleDbType.Decimal).Value = BE.precventa_tda_menor.ToString();
cmd.Parameters.Add("@pt700pma3 ", OleDbType.Decimal).Value = BE.precventa_csc_mayor.ToString();
cmd.Parameters.Add("@pt700pme3 ", OleDbType.Decimal).Value = BE.precventa_csc_menor.ToString();
cmd.Parameters.Add("@pt700gene ", OleDbType.Char, 1).Value = BE.generoid.ToString();
cmd.Parameters.Add("@pt700tabl ", OleDbType.Decimal).Value = 0;
cmd.Parameters.Add("@pt700idta ", OleDbType.Char, 2).Value = BE.tallaid.ToString();
cmd.Parameters.Add("@pt700marc ", OleDbType.VarChar, 15).Value = BE.marcaname.ToString();
cmd.Parameters.Add("@pt700usid ", OleDbType.Char, 3).Value = BE.usuar.ToString();
cmd.Parameters.Add("@pt700feac ", OleDbType.Date).Value = DateTime.Today.ToShortDateString();
cmd.Parameters.Add("@pt700idmc ", OleDbType.Char, 2).Value = BE.marcaidold.ToString();
cmd.Parameters.Add("@pt700idli ", OleDbType.Char, 3).Value = BE.lineaidold.ToString();
cmd.Parameters.Add("@pt700idtj ", OleDbType.Char, 3).Value = BE.tejidoid.ToString();
cmd.Parameters.Add("@pt700idgn ", OleDbType.Char, 1).Value = BE.generoid.ToString();
cmd.Parameters.Add("@pt700idca ", OleDbType.Char, 1).Value = BE.categoriaid.ToString();
cmd.Parameters.Add("@pt700inge ", OleDbType.Char, 7).Value = BE.articidold.ToString();
cmd.Parameters.Add("@pt700petq ", OleDbType.Decimal).Value = BE.prec_etiq.ToString();
cmd.Parameters.Add("@pt700pofe ", OleDbType.Decimal).Value = BE.prec_ofer.ToString();
cmd.Parameters.Add("@pt700fecr ", OleDbType.Date).Value = DateTime.Today.ToShortDateString();
cmd.Parameters.Add("@pt700idtp ", OleDbType.Char, 2).Value = BE.estado.ToString();
cmd.Parameters.Add("@pt700idprv", OleDbType.Char, 4).Value = BE.grupoid.ToString();
cmd.Parameters.Add("@pt700flsa ", OleDbType.Boolean).Value = BE.estado2;
cmd.Parameters.Add("@pt700idco ", OleDbType.Char, 3).Value = BE.coleccionid.ToString();
cmd.Parameters.Add("@pt700idrb ", OleDbType.Char, 2).Value = "01".ToString();
cmd.Parameters.Add("@pt700idmd ", OleDbType.Char, 4).Value = "".ToString();
cmd.Parameters.Add("@pt700idva ", OleDbType.Char, 6).Value = "".ToString();
cmd.Parameters.Add("@pt700fepi ", OleDbType.Date).Value = null;
cmd.Parameters.Add("@pt700feui ", OleDbType.Date).Value = null;
cmd.Parameters.Add("@pt700equi ", OleDbType.Char, 15).Value = "".ToString();
cmd.Parameters.Add("@pt700flac ", OleDbType.Boolean).Value = 0;
cmd.Parameters.Add("@pt700idte ", OleDbType.Char, 8).Value = "".ToString();
cmd.Parameters.Add("@pt700feps ", OleDbType.Date).Value = null;
cmd.Parameters.Add("@pt700feus ", OleDbType.Date).Value = null;
cmd.Parameters.Add("@pt700artic ", OleDbType.Char, 10).Value = "".ToString();
cmd.Parameters.Add("@pt700fecho ", OleDbType.Date).Value = DateTime.Today.ToShortDateString();
cmd.Parameters.Add("@temporadaid ", OleDbType.Char, 1).Value = BE.temporadaid.ToString();
cmd.Parameters.Add("@estacionid ", OleDbType.Char, 1).Value = BE.estacionid.ToString();
cmd.Parameters.Add("@parteid ", OleDbType.Char, 1).Value = BE.parte.ToString();
cmd.Parameters.Add("@estructuraid ", OleDbType.Char, 1).Value = BE.estructuraid.ToString();
cmd.Parameters.Add("@botapieid ", OleDbType.Char, 2).Value = BE.botapieid.ToString();
cmd.Parameters.Add("@entalleid ", OleDbType.Char, 2).Value = BE.entalleid.ToString();
cmd.Parameters.Add("@PT700PMA2O ", OleDbType.Decimal).Value = 0;
cmd.Parameters.Add("@PT700PME2O ", OleDbType.Decimal).Value = 0;
cmd.Parameters.Add("@ENSQL ", OleDbType.Boolean).Value = 1;
cmd.Parameters.Add("@FECHPITDA ", OleDbType.Date).Value = null;
cnx.Open();
try
{
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
public DataSet GetAll_foto(string empresaid, tb_pt_articulo BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPtArticulo_SEARCH_foto", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@articidold", SqlDbType.Char, 8).Value = BE.articidold;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Update_foto(string empresaid, tb_pt_articulo BE)
{
return tablaDA.Update_foto(empresaid, BE);
}
private void data_Tablaarticulo()
{
try
{
if (Tablaarticulo.Rows.Count > 0)
{
Tablaarticulo.Rows.Clear();
}
var BL = new tb_pt_articuloBL();
var BE = new tb_pt_articulo();
BE.articname = txt_criterio.Text.Trim().ToUpper();
Tablaarticulo = BL.GetAll2(EmpresaID, BE).Tables[0];
if (Tablaarticulo.Rows.Count > 0)
{
btn_imprimir.Enabled = true;
mdi_gridarticulo.DataSource = Tablaarticulo;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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 Delete()
{
try
{
if (articid.Text.Trim().Length != 4)
{
MessageBox.Show("Falta Codigo Artículo !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var BL = new tb_pt_articuloBL();
var BE = new tb_pt_articulo();
BE.articid = articid.Text.Trim().PadLeft(4, '0');
if (BL.Delete(EmpresaID, BE))
{
SEGURIDAD_LOG("E");
MessageBox.Show("Datos Eliminados Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
NIVEL_FORMS();
form_bloqueado(false);
data_Tablaarticulo();
btn_nuevo.Enabled = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void data_gridArticulo()
{
tb_pt_articuloBL BL = new tb_pt_articuloBL();
tb_pt_articulo BE = new tb_pt_articulo();
DataTable dt = new DataTable();
BE.articidold = txt_articidold.Text.ToUpper();
switch (cbo_filtro.SelectedValue)
{
case "01":
BE.articidold = txt_filter.Text.Trim().ToUpper();
break;
case "02":
BE.articname = txt_filter.Text.Trim().ToUpper();
break;
default:
//**
break;
}
try
{
//Eliminar Columnas Actuales(Opcional):
GridView1.Columns.Clear();
GridView1.Width = 550;
//Objeto Columna:
CommandField image;
//Crear Columna:
image = new CommandField();
image.ButtonType = ButtonType.Image;
image.SelectImageUrl = "~/Images/go-search.png";
image.ShowSelectButton = true;
image.ItemStyle.Width = 10;
image.ItemStyle.Wrap = true;
GridView1.Columns.Add(image);
BoundField ARTICIDOLD;
ARTICIDOLD = new BoundField();
ARTICIDOLD.DataField = "articidold";
ARTICIDOLD.HeaderText = "CODIGO_OLD";
ARTICIDOLD.ItemStyle.Width = 70;
GridView1.Columns.Add(ARTICIDOLD);
BoundField ARTICNAME;
ARTICNAME = new BoundField();
ARTICNAME.DataField = "articname";
ARTICNAME.HeaderText = "ARTICULO";
ARTICNAME.ItemStyle.Width = 250;
GridView1.Columns.Add(ARTICNAME);
GridView1.DataSource = BL.GetAll(Session["ssEmpresaID"].ToString(), BE);
GridView1.DataBind();
GridView1.Visible = true;
}
catch (Exception ex)
{
ClientMessage(ex.Message);
}
}
private void toolRegenDenom_Click(object sender, EventArgs e)
{
//CargarDatosVariantes(txtvariante.Text.ToString());
//cmb_generoid_SelectedIndexChanged(sender, e);
//cmb_entalleid_SelectedIndexChanged(sender, e);
//cmb_botapieid_SelectedIndexChanged(sender, e);
var BL = new tb_pt_articuloBL();
var BE = new tb_pt_articulo();
DataTable dt = new DataTable();
BE.variante = txtvariante.Text.ToString().ToUpper().Trim();
dt = BL.GetAll_DESCORT(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
_xmarcadescort = dt.Rows[0]["marcadescort"].ToString();
_xlineadescort = dt.Rows[0]["lineadescort"].ToString();
_xmodelodescort = dt.Rows[0]["modelodescort"].ToString();
_xentalledescort = dt.Rows[0]["entalledescort"].ToString();
_xbotapiedescort = dt.Rows[0]["botapiedescort"].ToString();
_xgenerodescort = dt.Rows[0]["generodescort"].ToString();
_GenerarNombre();
}
}
private void MetodoCargarLineal()
{
tb_pt_articuloBL BL = new tb_pt_articuloBL();
tb_pt_articulo BE = new tb_pt_articulo();
DataTable dt = new DataTable();
BE.articidold = txt_articidold.Text.ToUpper();
dt = BL.GetAll(Session["ssEmpresaID"].ToString(), BE).Tables[0];
if (dt.Rows.Count > 0)
{
Session["bd_marcaid"] = dt.Rows[0]["marcaid"].ToString();
txt_marcaname.Text = dt.Rows[0]["marcaname"].ToString();
Session["bd_articid"] = dt.Rows[0]["articid"].ToString();
txt_articname.Text = dt.Rows[0]["articname"].ToString();
txt_precventa_cre_menor.Text = dt.Rows[0]["precventa_cre_menor"].ToString();
Session["bd_tallaid"] = dt.Rows[0]["tallaid"].ToString();
// Metodos De Cargar Combos
CargarComboArticuloColor(dt.Rows[0]["articid"].ToString());
CargarComboArticuloTallas(dt.Rows[0]["tallaid"].ToString());
btn_add.Enabled = true;
btn_add.CssClass = "boton_add2";
}
}
private void Update_Foto()
{
try
{
var BL = new tb_pt_articuloBL();
var BE = new tb_pt_articulo();
BE.articidold = articidold.Text.Trim();
BE.docname = _nombreFoto.ToString();
var ms = new System.IO.MemoryStream();
if (foto.Image != null)
{
foto.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
}
BE.Foto = ms.GetBuffer();
BL.Update_foto(EmpresaID, BE);
}
catch (Exception)
{
throw;
}
}
public bool Delete(string empresaid, tb_pt_articulo BE)
{
return tablaDA.Delete(empresaid, BE);
}
private void Combinación_Marca_Modelo_Tela()
{
var BE = new tb_pt_articulo();
var BL = new tb_pt_articuloBL();
var dt = new DataTable();
BE.marcaid = marcaid.Text.Trim();
BE.modeloid = modeloid.Text.Trim();
BE.familiatelaid = familiatelaid.Text.Trim();
dt = BL.GeneraCod2(EmpresaID, BE).Tables[0];
if (dt.Rows[0]["codigo"].ToString() != string.Empty)
{
articidold.Text = dt.Rows[0]["codigo"].ToString();
bloqueo_paneles(true);
pnl_02.Enabled = false;
pnl_06.Enabled = false;
pnl_05.Enabled = false;
pnl_03.Enabled = true;
}
else
{
MessageBox.Show("!!!... Ya Existe Combinación ...!!!");
limpiar_documento();
grupoid.Focus();
bloqueo_paneles(false);
pnl_02.Enabled = false;
pnl_06.Enabled = false;
pnl_05.Enabled = false;
return;
}
}
public DataSet GeneraCod2(string empresaid, tb_pt_articulo BE)
{
return tablaDA.GeneraCod2(empresaid, BE);
}
// ARTICULOS
private void data_gridArticulo()
{
tb_pt_articuloWebBL BL = new tb_pt_articuloWebBL();
tb_pt_articulo BE = new tb_pt_articulo();
DataTable dt = new DataTable();
switch (cmb_articulo.SelectedValue)
{
case "01":
BE.articidold = txt_buscar.Text.Trim().ToUpper();
break;
case "02":
BE.articname = txt_buscar.Text.Trim().ToUpper();
break;
default:
//**
break;
}
try
{
//Eliminar Columnas Actuales(Opcional):
dgb_articulo.Columns.Clear();
dgb_articulo.Width = 535;
//Objeto Columna:
CommandField image;
//Crear Columna:
image = new CommandField();
image.ButtonType = ButtonType.Image;
image.SelectImageUrl = "~/Images/go-search.png";
image.ShowSelectButton = true;
image.ItemStyle.Width = 10;
image.ItemStyle.Wrap = true;
dgb_articulo.Columns.Add(image);
BoundField ARTICID;
ARTICID = new BoundField();
ARTICID.DataField = "articid";
ARTICID.HeaderText = "CODIGO";
ARTICID.ItemStyle.Width = 50;
dgb_articulo.Columns.Add(ARTICID);
BoundField ARTICIDOLD;
ARTICIDOLD = new BoundField();
ARTICIDOLD.DataField = "articidold";
ARTICIDOLD.HeaderText = "CODIGO";
ARTICIDOLD.ItemStyle.Width = 80;
dgb_articulo.Columns.Add(ARTICIDOLD);
BoundField ARTICNAME;
ARTICNAME = new BoundField();
ARTICNAME.DataField = "articname";
ARTICNAME.HeaderText = "ARTICULO";
ARTICNAME.ItemStyle.Width = 250;
dgb_articulo.Columns.Add(ARTICNAME);
BE.top = true;
//BE.vendorid = txt_vendorid.Value.ToString();
dt = BL.GetAll(Session["ssEmpresaID"].ToString(), BE).Tables[0];
if (dt.Rows.Count > 0)
{
dgb_articulo.DataSource = dt;
dgb_articulo.DataBind();
dgb_articulo.Visible = true;
}
}
catch (Exception ex)
{
throw ex;// ClientMessage(ex.Message);
}
}
public DataSet GetAll_foto(string empresaid, tb_pt_articulo BE)
{
return tablaDA.GetAll_foto(empresaid, BE);
}
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();
}
}
}
public bool Insert_Foto(string empresaid, tb_pt_articulo BE)
{
return tablaDA.Insert_Foto(empresaid, BE);
}
