까망이의 개발자 마을

[참조: https://github.com/osisoft/PI-AF-SDK-Basic-Samples/tree/master/ExamplesLibrary/WriteValuesExample ]

 PIServers piServers = new PIServers();

            PIServer piServer = piServers[piServerInfo]; //piServerInfo : PI 서버 IP 또는 도메인 정보

            IList<PIPoint> points = PIPoint.FindPIPoints(piServer, new[] { "cdt158"});

            PIPoint floatingPIPoint = points[0];

            IList<AFValue> valuesToWrite = new List<AFValue>();

            for (int i = 0; i < 10; i++)

            {

                AFTime time = new AFTime(new DateTime(2017, 1, 1, 0, 0, i, DateTimeKind.Local));

                AFValue afValueFloat = new AFValue(i, time); //값, 시간

                afValueFloat.PIPoint = floatingPIPoint;

                valuesToWrite.Add(afValueFloat);

            }

            piServer.UpdateValues(valuesToWrite, AFUpdateOption.InsertNoCompression, AFBufferOption.BufferIfPossible);

DECLARE @count INT

SET @count = 1

WHILE @count <= 1000

BEGIN

INSERT INTO T_TAGS (id, timeStamp, value) VALUES ('TEST', DATEADD(SECOND, @count,'2017-10-01 00:00:00') , @count)

SET @count = @count+1

END