/// <summary>
/// metodo para actualizar
/// </summary>
public static int Actualizar(ModelSecadorVertical pSV)
{
var retorno = 0;
var conexion = ConexionMySql.ObtenerConexion();
var comando = new MySqlCommand($"UPDATE secadorvertical SET Circuito='{pSV.Circuito}', Fecha='{pSV.Fecha}', MInicial='{pSV.MInicial}', MFinal='{pSV.MFinal}', MEnjuague='{pSV.MEnjuague}', TAInicial='{pSV.TAInicial}', TAFinal='{pSV.TAFinal}', TAEnjuague='{pSV.TAEnjuague}', TTAnalisis='{pSV.TTA}', TipoLavado='{pSV.TipoLavado}', TLInicial='{pSV.TLInicial}', TLFinal='{pSV.TLFinal}', TLEnjuague='{pSV.TLEnjuague}', TTLavado='{pSV.TTLavado}', Color1='{pSV.Color1}', Color2='{pSV.Color2}', Titulacion='{pSV.Titulacion}', RT1='{pSV.RT1}', RT2='{pSV.RT2}', Operador='{pSV.Operador}', Analista='{pSV.Analista}' WHERE IDLinea='{pSV.IdLinea}'", conexion);
retorno = comando.ExecuteNonQuery();
return(retorno);
}
/// <summary>
/// metodo para agregar
/// </summary>
public static int Agregar(ModelSecadorVertical pMsv)
{
var connec = ConexionMySql.ObtenerConexion();
var comando =
new MySqlCommand(
$"CALL sp_SecadorVertical('{pMsv.IdLinea}','{pMsv.Circuito}','{pMsv.Fecha}','{pMsv.MInicial}','{pMsv.MFinal}','{pMsv.MEnjuague}','{pMsv.TAInicial}','{pMsv.TAFinal}','{pMsv.TAEnjuague}','{pMsv.TTA}','{pMsv.TipoLavado}','{pMsv.TLInicial}','{pMsv.TLFinal}','{pMsv.TLEnjuague}','{pMsv.TTLavado}','{pMsv.Color1}','{pMsv.Color2}','{pMsv.Titulacion}','{pMsv.RT1}','{pMsv.RT2}','{pMsv.Operador}','{pMsv.Analista}')",
connec);
var retorno = comando.ExecuteNonQuery();
return(retorno);
}
/// <summary>
/// metodo para mostrar los tipolavado y titulacion los combobox
/// </summary>
public static List <ModelSecadorVertical> Llenarcombo()
{
var lista = new List <ModelSecadorVertical>();
var connec = ConexionMySql.ObtenerConexion();
var comando = new MySqlCommand("SELECT * FROM secadorvertical", connec);
var reader = comando.ExecuteReader();
while (reader.Read())
{
var pSV = new ModelSecadorVertical
{
IdLinea = reader.GetInt32(0),
TipoLavado = reader.GetString(1),
Titulacion = reader.GetString(2)
};
lista.Add(pSV);
}
return(lista);
}
/// <summary>
/// metodo para buscar
/// </summary>
public static List <ModelSecadorVertical> Buscar(string pCircuito)
{
var lista = new List <ModelSecadorVertical>();
var connec = ConexionMySql.ObtenerConexion();
var comando = new MySqlCommand($"SELECT * FROM secadorvertical WHERE Circuito='{pCircuito}'", connec);
var reader = comando.ExecuteReader();
while (reader.Read())
{
var pSV = new ModelSecadorVertical
{
IdLinea = reader.GetInt32(0),
Circuito = reader.GetString(1),
Fecha = reader.GetString(2),
MInicial = reader.GetString(3),
MFinal = reader.GetString(4),
MEnjuague = reader.GetString(5),
TAInicial = reader.GetString(6),
TAFinal = reader.GetString(7),
TAEnjuague = reader.GetString(8),
TTA = reader.GetString(9),
TipoLavado = reader.GetString(10),
TLInicial = reader.GetString(11),
TLFinal = reader.GetString(12),
TLEnjuague = reader.GetString(13),
TTLavado = reader.GetString(14),
Color1 = reader.GetString(15),
Color2 = reader.GetString(16),
Titulacion = reader.GetString(17),
RT1 = reader.GetString(18),
RT2 = reader.GetString(19),
Operador = reader.GetString(20),
Analista = reader.GetString(21)
};
lista.Add(pSV);
}
return(lista);
}
