public static ModelRecepcion ObtenerRecepcion(int IdLinea)
        {
            var pMr     = new ModelRecepcion();
            var connec  = ConexionMySql.ObtenerConexion();
            var comando = new MySqlCommand($"SELECT * FROM recepcion WHERE IDLinea ='{IdLinea}'", connec);
            var reader  = comando.ExecuteReader();

            while (reader.Read())
            {
                RecepcionSelect.IdLinea    = reader.GetInt32(0);
                RecepcionSelect.Circuito   = reader.GetString(1);
                RecepcionSelect.Fecha      = reader.GetString(2);
                RecepcionSelect.MInicial   = reader.GetString(3);
                RecepcionSelect.MFinal     = reader.GetString(4);
                RecepcionSelect.MEnjuague  = reader.GetString(5);
                RecepcionSelect.TAInicial  = reader.GetString(6);
                RecepcionSelect.TAFinal    = reader.GetString(7);
                RecepcionSelect.TAEnjuague = reader.GetString(8);
                RecepcionSelect.TTA        = reader.GetString(9);
                RecepcionSelect.TipoLavado = reader.GetString(10);
                RecepcionSelect.TLInicial  = reader.GetString(11);
                RecepcionSelect.TLFinal    = reader.GetString(12);
                RecepcionSelect.TLEnjuague = reader.GetString(13);
                RecepcionSelect.TTLavado   = reader.GetString(14);
                RecepcionSelect.Color1     = reader.GetString(15);
                RecepcionSelect.Color2     = reader.GetString(16);
                RecepcionSelect.Titulacion = reader.GetString(17);
                RecepcionSelect.RT1        = reader.GetString(18);
                RecepcionSelect.RT2        = reader.GetString(19);
                RecepcionSelect.Operador   = reader.GetString(20);
                RecepcionSelect.Analista   = reader.GetString(21);
            }
            connec.Close();
            return(pMr);
        }
        /// <summary>
        /// metodo para exportar funciona todo
        /// </summary>
        public static int Exportar(ModelRecepcion pRecepcion, int pOperacion)
        {
            var          retorno  = 0;
            var          conexion = ConexionMySql.ObtenerConexion();
            MySqlCommand comando;

            switch (pOperacion)
            {
            case 1:     //exportar todos los datos
                comando = new MySqlCommand(
                    $"Select * from recepcion('{pOperacion}','{pRecepcion.IdLinea}','{pRecepcion.Circuito}','{pRecepcion.Fecha}','{pRecepcion.MInicial}','{pRecepcion.MFinal}','{pRecepcion.MEnjuague}','{pRecepcion.TAInicial}','{pRecepcion.TAFinal}','{pRecepcion.TAEnjuague}','{pRecepcion.TTA}','{pRecepcion.TipoLavado}','{pRecepcion.TLInicial}','{pRecepcion.TLFinal}','{pRecepcion.TLEnjuague}','{pRecepcion.TTLavado}','{pRecepcion.Color1}','{pRecepcion.Color2}','{pRecepcion.Titulacion}','{pRecepcion.RT1}','{pRecepcion.RT2}','{pRecepcion.Operador}','{pRecepcion.Analista}'),'a','a')",
                    conexion);
                retorno = comando.ExecuteNonQuery();
                break;

            case 2:     //exportar los datos de muestras
                comando = new MySqlCommand(
                    $"Select * from recepcion('{pOperacion}','{pRecepcion.IdLinea}','{pRecepcion.Fecha}','{pRecepcion.MInicial}','{pRecepcion.MFinal}','{pRecepcion.MEnjuague}')",
                    conexion);
                retorno = comando.ExecuteNonQuery();
                break;

            case 3:     //exportar los datos de titulacion
                comando = new MySqlCommand(
                    $"Select * from recepcion('{pOperacion}','{pRecepcion.IdLinea}','{pRecepcion.Fecha}','{pRecepcion.Titulacion}','{pRecepcion.RT1}','{pRecepcion.RT2}')",
                    conexion);
                retorno = comando.ExecuteNonQuery();
                break;
            }
            return(retorno);
        }
        /// <summary>
        ///     metodo para agregar
        /// </summary>
        public static int Agregar(ModelRecepcion pMr)
        {
            var connec  = ConexionMySql.ObtenerConexion();
            var comando = new MySqlCommand($"CALL sp_Recepcion('{pMr.IdLinea}','{pMr.Circuito}','{pMr.Fecha}','{pMr.MInicial}','{pMr.MFinal}','{pMr.MEnjuague}','{pMr.TAInicial}','{pMr.TAFinal}','{pMr.TAEnjuague}','{pMr.TTA}','{pMr.TipoLavado}','{pMr.TLInicial}','{pMr.TLFinal}','{pMr.TLEnjuague}','{pMr.TTLavado}','{pMr.Color1}','{pMr.Color2}','{pMr.Titulacion}','{pMr.RT1}','{pMr.RT2}','{pMr.Operador}','{pMr.Analista}')", connec);
            var retorno = comando.ExecuteNonQuery();

            return(retorno);
        }
        /// <summary>
        ///     metodo para actualizar
        /// </summary>
        public static int Actualizar(ModelRecepcion pRecepcion)
        {
            var retorno  = 0;
            var conexion = ConexionMySql.ObtenerConexion();
            var comando  = new MySqlCommand(string.Format($"UPDATE recepcion SET Circuito = '{pRecepcion.Circuito}', Fecha = '{pRecepcion.Fecha}', MInicial = '{pRecepcion.MInicial}', MFinal = '{pRecepcion.MFinal}', MEnjuague = '{pRecepcion.MEnjuague}', TAInicial = '{pRecepcion.TAInicial}', TAFinal = '{pRecepcion.TAFinal}', TAEnjuague = '{pRecepcion.TAEnjuague}', TTAnalisis = '{pRecepcion.TTA}', TipoLavado = '{pRecepcion.TipoLavado}', TLInicial = '{pRecepcion.TLInicial}', TLFinal = '{pRecepcion.TLFinal}', TLEnjuague = '{pRecepcion.TAEnjuague}', TTLavado = '{pRecepcion.TTLavado}', Color1 = '{pRecepcion.Color1}', Color2 = '{pRecepcion.Color2}', Titulacion = '{pRecepcion.Titulacion}', RT1 = '{pRecepcion.RT1}', RT2 = '{pRecepcion.RT2}', Operador = '{pRecepcion.Operador}', Analista = '{pRecepcion.Analista}' WHERE IDLinea = '{pRecepcion.IdLinea}';"), conexion);

            retorno = comando.ExecuteNonQuery();
            return(retorno);
        }
        /// <summary>
        ///     metodo para buscar
        /// </summary>
        public static List <ModelRecepcion> Buscar(string pCircuito)
        {
            var lista   = new List <ModelRecepcion>();
            var connec  = ConexionMySql.ObtenerConexion();
            var comando = new MySqlCommand($"SELECT * FROM recepcion WHERE Circuito='{pCircuito}'", connec);
            var reader  = comando.ExecuteReader();

            while (reader.Read())
            {
                var pRecepcion = new ModelRecepcion
                {
                    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(pRecepcion);
            }
            return(lista);
        }