mrezekiel

using OvfgNx.Data;
using OvfgNx.Models;
using System;
using System.ComponentModel.DataAnnotations;
using System.Reflection;

namespace OvfgNx.Validators
{
    /// <summary>
    /// This vaidator checks that the job contains the serial that the user has entered

mrezekiel

DECLARE @StartDate DateTime
DECLARE @EndDate DateTime
DECLARE @iArea INT
DECLARE @sTagName NVARCHAR(50)
SET @StartDate = '19700101 0:00'
SET @EndDate = GETDATE()

/* Get TagName from ID, Historian requires TagName for lookups */
SELECT @sTagName = (SELECT tr.TagName
    FROM TagRef tr

mrezekiel

-- Citect Historian
DECLARE @iArea INT;
-- SET @iArea = 2797;
SET @iArea = 86;
SELECT DISTINCT left([SampleValue],4) as SampleValue
  FROM [dbo].[StringSamples]
WHERE [TagID] = @iArea
AND		[QualityID] = 192
AND		[SampleValue] IS NOT NULL
AND		[SampleValue] <> '' 

mrezekiel

<?php
namespace Application\Entity;

use Application\Factory\ChangeTracker;
use Doctrine\ORM\Mapping as ORM;

/**
 * Contacts
 *
 * @ORM\Table(name="contacts")