public bool Delete_dbf(string empresaid, tb_pt_linea BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
" UPDATE LINEA001 SET LI001STAT = ? " +
" WHERE LI001IDLI = ? ";
using (OleDbCommand cmd = new OleDbCommand(commandString, cnx))
{
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.Add("@LI001STAT", OleDbType.Decimal).Value = 9;
cmd.Parameters.Add("@LI001IDLI", OleDbType.Char, 3).Value = BE.lineaidold.ToString();
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Delete_dbf(string empresaid, tb_pt_marca BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
" UPDATE MARCA001 SET MC001STAT = ? " +
" WHERE MC001IDMC = ? ";
using (OleDbCommand cmd = new OleDbCommand(commandString, cnx))
{
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.Add("@MC001STAT", OleDbType.Decimal).Value = 9;
//cmd.Parameters.Add("@MC001NAME", OleDbType.Char, 20).Value = BE.marcaname.ToString();
cmd.Parameters.Add("@MC001IDMC", OleDbType.Char, 2).Value = BE.marcaidold.ToString();
//cmd.Parameters.Add("@ENSQL", OleDbType.Boolean).Value = 1;
}
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_articulocolor BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
"UPDATE ptema712 SET pt712idco = ? ,pt712usid = ? ,pt712feac = ? ,ENSQL = ? ,status = ? " +
" WHERE pt712idar = ? ";
OleDbCommand cmd = new OleDbCommand(commandString, cnx);
//cmd.Parameters.Add("@pt712stat ", OleDbType.Decimal).Value = 1;
cmd.Parameters.Add("@pt712idar ", OleDbType.Char, 7).Value = BE.articid.ToString();
cmd.Parameters.Add("@pt712idco ", OleDbType.Char, 3).Value = BE.colorid.ToString();
cmd.Parameters.Add("@pt712usid ", OleDbType.Char, 3).Value = BE.usuar.ToString();
cmd.Parameters.Add("@pt712feac ", OleDbType.Date).Value = DateTime.Today.ToShortDateString();
cmd.Parameters.Add("@ENSQL ", OleDbType.Boolean).Value = 1;
cmd.Parameters.Add("@status ", OleDbType.Char, 1).Value = BE.status.ToString();
cnx.Open();
try
{
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_articulocolor BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
"INSERT INTO ptema712 (pt712stat ,pt712idar ,pt712idco ,pt712usid ,pt712feac ,ensql ,status) " +
"VALUES (?, ?, ?, ?, ?, ?, ?) ";
OleDbCommand cmd = new OleDbCommand(commandString, cnx);
cmd.Parameters.Add("@pt712stat ", OleDbType.Decimal).Value = 1;
cmd.Parameters.Add("@pt712idar ", OleDbType.Char, 7).Value = BE.articid.ToString();
cmd.Parameters.Add("@pt712idco ", OleDbType.Char, 3).Value = BE.colorid.ToString();
cmd.Parameters.Add("@pt712usid ", OleDbType.Char, 3).Value = BE.usuar.ToString();
cmd.Parameters.Add("@pt712feac ", OleDbType.Date).Value = DateTime.Today.ToShortDateString();
cmd.Parameters.Add("@ENSQL ", OleDbType.Boolean).Value = 1;
cmd.Parameters.Add("@status ", OleDbType.Char, 1).Value = BE.status.ToString();
cnx.Open();
try
{
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
public DataSet GetAll_CODdbf(string empresaid, tb_cliente BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
"SELECT COUNT(*) cant FROM faccl600 WHERE CL600IDCL = ?";
using (OleDbCommand cmd = new OleDbCommand(commandString, cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.Add("@CL600IDCL ", OleDbType.Char, 4).Value = BE.ctacte;
}
try
{
cnx.Open();
using (OleDbDataAdapter da = new OleDbDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
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 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_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);
}
}
}
}
public bool Update_dbf(string empresaid, tb_pt_linea BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
" UPDATE LINEA001 SET LI001NAME = ? " +
" WHERE LI001IDLI = ? ";
using (OleDbCommand cmd = new OleDbCommand(commandString, cnx))
{
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.Add("@LI001NAME", OleDbType.VarChar, 10).Value = BE.lineaname.ToString();
cmd.Parameters.Add("@LI001IDLI", OleDbType.VarChar, 3).Value = BE.lineaidold.ToString();
//cmd.Parameters.Add("@LI001USID ", OleDbType.Char, 3).Value = BE.usuar.ToString();
//.Parameters.Add("@LI001FEAC ", OleDbType.Date).Value = DateTime.Today.ToShortDateString();
}
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_linea BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
"INSERT INTO LINEA001 (LI001STAT ,LI001IDLI ,LI001NAME ,LI001USID ,LI001FEAC ,ENSQL " +
" )" +
" VALUES (?, ?, ?, ?, ?, ? " +
")";
using (OleDbCommand cmd = new OleDbCommand(commandString, cnx))
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.Add("@LI001STAT ", OleDbType.Decimal).Value = 1;
cmd.Parameters.Add("@LI001IDLI ", OleDbType.Char, 32).Value = BE.lineaidold.ToString();
cmd.Parameters.Add("@LI001NAME ", OleDbType.Char, 10).Value = BE.lineaname.ToString();
cmd.Parameters.Add("@LI001USID ", OleDbType.Char, 3).Value = BE.usuar.ToString();
cmd.Parameters.Add("@LI001FEAC ", OleDbType.Date).Value = DateTime.Today.ToShortDateString();
cmd.Parameters.Add("@ENSQL ", OleDbType.Boolean).Value = 0;
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_linea BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
"SELECT MAX(LI001IDLI) AS lineaidold FROM LINEA001;";
using (OleDbCommand cmd = new OleDbCommand(commandString, cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = System.Data.CommandType.Text;
}
try
{
cnx.Open();
using (OleDbDataAdapter da = new OleDbDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Insert_dbf(string empresaid, tb_pt_marca BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
"INSERT INTO MARCA001 (MC001STAT ,MC001IDMC ,MC001NAME ,ENSQL " +
" )" +
" VALUES (?, ?, ?, ? " +
")";
using (OleDbCommand cmd = new OleDbCommand(commandString, cnx))
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.Add("@MC001STAT ", OleDbType.Decimal).Value = 1;
cmd.Parameters.Add("@MC001IDMC ", OleDbType.Char, 2).Value = BE.marcaidold.ToString();
cmd.Parameters.Add("@MC001NAME ", OleDbType.VarChar, 20).Value = BE.marcaname.ToString();
cmd.Parameters.Add("@ENSQL ", OleDbType.Boolean).Value = 0;
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
