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); } } } }