ProcessDB实时/时序数据库——C#读写实时数据

已于 2022-12-12 15:21:30 修改
阅读量1.4k 收藏 2
点赞数
分类专栏： # ProcessDB的C#开发接口 文章标签： 时序数据库 数据库开发 物联网 c# ProcessDB
于 2022-12-12 12:56:07 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sun_race/article/details/128285100
版权

目录

前言

一、实时数据字段介绍

二、根据点名插入实时数据

三、根据点ID插入实时数据

四、根据点名查询实时数据

五、根据点ID查询实时数据

前言

ProcessDB实时/时序数据库支持C#语言开发，本文将针对C#操作ProcessDB库的实时数据的相关操作进行介绍

一、实时数据字段介绍

字段注释
id数据点id
name数据点名

nTagType

数据类型

nQuality

数据质量

nMilliSecond

数据时间(毫秒)

nSecond

数据时间(秒)

nDigital

数字量

bBool

bool类型的值

nuInt8

uint8类型的值

nInt8

in8类型的值

nuInt16

uint16类型的值

nInt16

int16类型的值

nuInt32

uint32类型的值

nInt32

int32类型的值

nuInt64

uint64类型的值

nInt64

Int64类型的值

nTime

time时间类型的值

fFloat32

float32类型的值

fFloat64

float64类型的值

二、根据点名插入实时数据

ProcessDB支持根据点名列表，批量插入实时数据

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ProcessDB;

namespace Data_RealTime
{
    class Program
    {  
        static void Main(string[] args)
        {
            TestRealTime testRealTime = new TestRealTime();
            int res = testRealTime.RealTimeTest();
        }
    }

    public class TestRealTime
    {
        public class pointlist
        {
            public string pointname { get; set; }
            public int pointid { get; set; }
            public DATA_TYPE datatype { get; set; }
        }

        static int add_realtime_data_by_name(string pointname, DATA_TYPE datatype)
        {
            /* 根据点名称添加实时数据到容器 */
            int i = 1;
            float val = i * 2.3f;
            byte val1 = 0;
            byte val2 = 2;
            short val3 = 3;
            int val4 = 4;
            long val5 = 5;
            float val6 = i * 3.4f;
            MemSampleRecord memSampleRecord = new MemSampleRecord();
            memSampleRecord.nTagType = (byte)datatype;
            switch (memSampleRecord.nTagType)
            {
                case (byte)DATA_TYPE.TAG_TYPE_FLOAT32:
                    memSampleRecord.fFloat32 = val;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_DIGITAL:
                    memSampleRecord.nDigital = val1;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_UINT8:
                    memSampleRecord.nUInt8 = val2;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_INT8:
                    memSampleRecord.nInt8 = val2;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_UINT16:
                    memSampleRecord.nUInt16 = val3;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_INT16:
                    memSampleRecord.nInt16 = val3;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_UINT32:
                    memSampleRecord.nUInt32 = val4;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_INT32:
                    memSampleRecord.nInt32 = val4;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_UINT64:
                    memSampleRecord.nUInt64 = val5;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_INT64:
                    memSampleRecord.nInt64 = val5;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_FLOAT64:
                    memSampleRecord.fFloat64 = val6;
                    break;
            }
            int res = ProcessDBDao.getInstance().add_realtime_data_to_update_builder_by_name(pointname, ref memSampleRecord);
            if (0 != res)
            {
                Console.WriteLine("add {0} realtime_data to builder by name failed!error code: {1}", pointname, res);
                return res;
            }
            else
            {
                switch (memSampleRecord.nTagType)
                {
                    case (byte)DATA_TYPE.TAG_TYPE_FLOAT32:
                        Console.WriteLine("Using pointname add realtime data to update builder succeed! pointname: {0} seconds: {1}, status: {2}, value: {3}", pointname, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.fFloat32);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_DIGITAL:
                        Console.WriteLine("Using pointname add realtime data to update builder succeed! pointname: {0} seconds: {1}, status: {2}, value: {3}", pointname, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nDigital);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT8:
                        Console.WriteLine("Using pointname add realtime data to update builder succeed! pointname: {0} seconds: {1}, status: {2}, value: {3}", pointname, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nUInt8);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT8:
                        Console.WriteLine("Using pointname add realtime data to update builder succeed! pointname: {0} seconds: {1}, status: {2}, value: {3}", pointname, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nInt8);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT16:
                        Console.WriteLine("Using pointname add realtime data to update builder succeed! pointname: {0} seconds: {1}, status: {2}, value: {3}", pointname, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nUInt16);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT16:
                        Console.WriteLine("Using pointname add realtime data to update builder succeed! pointname: {0} seconds: {1}, status: {2}, value: {3}", pointname, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nInt16);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT32:
                        Console.WriteLine("Using pointname add realtime data to update builder succeed! pointname: {0} seconds: {1}, status: {2}, value: {3}", pointname, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nUInt32);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT32:
                        Console.WriteLine("Using pointname add realtime data to update builder succeed! pointname: {0} seconds: {1}, status: {2}, value: {3}", pointname, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nInt32);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT64:
                        Console.WriteLine("Using pointname add realtime data to update builder succeed! pointname: {0} seconds: {1}, status: {2}, value: {3}", pointname, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nUInt64);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT64:
                        Console.WriteLine("Using pointname add realtime data to update builder succeed! pointname: {0} seconds: {1}, status: {2}, value: {3}", pointname, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nInt64);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_FLOAT64:
                        Console.WriteLine("Using pointname add realtime data to update builder succeed! pointname: {0} seconds: {1}, status: {2}, value: {3}", pointname, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.fFloat64);
                        break;
                }

            }
            /* 将容器中的数据提交到实时数据库里 */
            res = ProcessDBDao.getInstance().exec_update_realtime();
            if (0 != res)
            {
                Console.WriteLine("execute update realtime failed!error code: {0}", res);
                return res;
            }
            else {
                Console.WriteLine("execute update realtime succeed!");
            }
            return 0;
        }

        public int RealTimeTest() {
            int res = 0;
            /* 初始化连接控制块 */
            res = ProcessDBDao.getInstance().init();
            if (0 != res)
            {
                Console.WriteLine("ProcessDBDao init failed! error code: {0}", res);
                return res;
            }
            /* 建立连接 */
            res = ProcessDBDao.getInstance().connect("127.0.0.1", 8301, "root", "root");
            //res = ProcessDBDao.getInstance().connect("192.168.0.186", 8301, "root", "root");
            if (0 != res)
            {
                Console.WriteLine("login failed! error code: {0}", res);
                return res;
            }
            /* 采样点 */
            var pointlist = new List<pointlist>
            {
                new pointlist{ pointname = "D99.T99.P99", pointid = 1003000009, datatype = DATA_TYPE.TAG_TYPE_FLOAT32},
            };

            /* 通过点名更新实时数据、查询实时数据*/
            for (int i = 0; i < pointlist.Count; i++)
            {

                /* 根据点名更新实时数据 */
                add_realtime_data_by_name(pointlist[i].pointname, pointlist[i].datatype);

            }

            /* 关闭连接 */
            res = ProcessDBDao.getInstance().close();
            return res;

        }

       
    }
}

三、根据点ID插入实时数据

ProcessDB支持根据点ID列表，批量插入实时数据

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ProcessDB;

namespace Data_RealTime
{
    class Program
    {  
        static void Main(string[] args)
        {
            TestRealTime testRealTime = new TestRealTime();
            int res = testRealTime.RealTimeTest();
        }
    }

    public class TestRealTime
    {
        public class pointlist
        {
            public string pointname { get; set; }
            public int pointid { get; set; }
            public DATA_TYPE datatype { get; set; }
        }

        static int add_realtime_data_by_id(int pointid, DATA_TYPE datatype)
        {
            /* 根据点id添加实时数据到容器 */
            int i = 1;
            float val = i * 8.9f;
            byte val1 = 1;
            byte val2 = 3;
            short val3 = 4;
            int val4 = 5;
            long val5 = 6;
            float val6 = i * 6.4f;
            MemSampleRecord memSampleRecord = new MemSampleRecord();
            memSampleRecord.nTagType = (byte)datatype;
            switch (memSampleRecord.nTagType)
            {
                case (byte)DATA_TYPE.TAG_TYPE_FLOAT32:
                    memSampleRecord.fFloat32 = val;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_DIGITAL:
                    memSampleRecord.nDigital = val1;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_UINT8:
                    memSampleRecord.nUInt8 = val2;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_INT8:
                    memSampleRecord.nInt8 = val2;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_UINT16:
                    memSampleRecord.nUInt16 = val3;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_INT16:
                    memSampleRecord.nInt16 = val3;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_UINT32:
                    memSampleRecord.nUInt32 = val4;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_INT32:
                    memSampleRecord.nInt32 = val4;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_UINT64:
                    memSampleRecord.nUInt64 = val5;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_INT64:
                    memSampleRecord.nInt64 = val5;
                    break;
                case (byte)DATA_TYPE.TAG_TYPE_FLOAT64:
                    memSampleRecord.fFloat64 = val6;
                    break;

            }
            int res = ProcessDBDao.getInstance().add_realtime_data_to_update_builder_by_id(pointid, ref memSampleRecord);
            if (0 != res)
            {
                Console.WriteLine("add {0} realtime_data to builder by id failed!error code: {1}", pointid, res);
                return res;
            }
            else
            {
                switch (memSampleRecord.nTagType)
                {
                    case (byte)DATA_TYPE.TAG_TYPE_FLOAT32:
                        Console.WriteLine("Using pointid add realtime data to update builder succeed! pointid: {0} seconds: {1}, status: {2}, value: {3}", pointid, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.fFloat32);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_DIGITAL:
                        Console.WriteLine("Using pointid add realtime data to update builder succeed! pointid: {0} seconds: {1}, status: {2}, value: {3}", pointid, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nDigital);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT8:
                        Console.WriteLine("Using pointid add realtime data to update builder succeed! pointid: {0} seconds: {1}, status: {2}, value: {3}", pointid, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nUInt8);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT8:
                        Console.WriteLine("Using pointid add realtime data to update builder succeed! pointid: {0} seconds: {1}, status: {2}, value: {3}", pointid, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nInt8);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT16:
                        Console.WriteLine("Using pointid add realtime data to update builder succeed! pointid: {0} seconds: {1}, status: {2}, value: {3}", pointid, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nUInt16);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT16:
                        Console.WriteLine("Using pointid add realtime data to update builder succeed! pointid: {0} seconds: {1}, status: {2}, value: {3}", pointid, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nInt16);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT32:
                        Console.WriteLine("Using pointid add realtime data to update builder succeed! pointid: {0} seconds: {1}, status: {2}, value: {3}", pointid, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nUInt32);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT32:
                        Console.WriteLine("Using pointid add realtime data to update builder succeed! pointid: {0} seconds: {1}, status: {2}, value: {3}", pointid, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nInt32);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT64:
                        Console.WriteLine("Using pointid add realtime data to update builder succeed! pointid: {0} seconds: {1}, status: {2}, value: {3}", pointid, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nUInt64);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT64:
                        Console.WriteLine("Using pointid add realtime data to update builder succeed! pointid: {0} seconds: {1}, status: {2}, value: {3}", pointid, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.nInt64);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_FLOAT64:
                        Console.WriteLine("Using pointid add realtime data to update builder succeed! pointid: {0} seconds: {1}, status: {2}, value: {3}", pointid, memSampleRecord.nSecond, memSampleRecord.nQuality, memSampleRecord.fFloat64);
                        break;
                }

            }
            /* 将容器中的数据提交到实时数据库里 */
            res = ProcessDBDao.getInstance().exec_update_realtime();
            if (0 != res)
            {
                Console.WriteLine("execute update realtime failed!error code: {0}", res);
                return res;
            }
            else {
                Console.WriteLine("execute update realtime succeed!");
            }
            return 0;
        }

        public int RealTimeTest() {
            int res = 0;
            /* 初始化连接控制块 */
            res = ProcessDBDao.getInstance().init();
            if (0 != res)
            {
                Console.WriteLine("ProcessDBDao init failed! error code: {0}", res);
                return res;
            }
            /* 建立连接 */
            res = ProcessDBDao.getInstance().connect("127.0.0.1", 8301, "root", "root");
            if (0 != res)
            {
                Console.WriteLine("login failed! error code: {0}", res);
                return res;
            }
         
            /* 采样点 */
            var pointlist = new List<pointlist>
            {
                new pointlist{ pointname = "D99.T99.P99", pointid = 1003000009, datatype = DATA_TYPE.TAG_TYPE_FLOAT32}
              
            };

 

            /* 通过点id更新实时数据*/
            for (int j = 0; j < pointlist.Count; j++)
            {
                /* 根据点id更新实时数据 */
                add_realtime_data_by_id(pointlist[j].pointid, pointlist[j].datatype);
              
            }
            /* 关闭连接 */
            res = ProcessDBDao.getInstance().close();
            return res;

        }

       
    }
}

四、根据点名查询实时数据

根据数据点名的集合，批量查询实时数据

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ProcessDB;

namespace Data_RealTime
{
    class Program
    {  
        static void Main(string[] args)
        {
            TestRealTime testRealTime = new TestRealTime();
            int res = testRealTime.RealTimeTest();
        }
    }

    public class TestRealTime
    {
        public class pointlist
        {
            public string pointname { get; set; }
            public int pointid { get; set; }
            public DATA_TYPE datatype { get; set; }
        }

        static void get_realtime_data_by_name(string pointname)
        {
            int res = ProcessDBDao.getInstance().add_name_to_query_builder(pointname);
            ProcessDBDao.getInstance().exec_query_realtime();
            /* 根据点名查出实时数据 */
            MemSampleRecord memSampleRecord = new MemSampleRecord();
            res = ProcessDBDao.getInstance().get_realtime_data_by_name(pointname, ref memSampleRecord);
            if (0 != res)
            {
                Console.WriteLine("Using pointName get realTime-data failed! pointname : {0}, error code: {1}", pointname, res);
                return;
            }
            else
            {
                switch (memSampleRecord.nTagType)
                {
                    case (byte)DATA_TYPE.TAG_TYPE_FLOAT32:
                        Console.WriteLine("Using pointName get realTime-data succeed!,pointname: {0}, value: {1}, status: {2}", pointname, memSampleRecord.fFloat32, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_DIGITAL:
                        Console.WriteLine("Using pointName get realTime-data succeed!,pointname: {0}, value: {1}, status:{2}", pointname, memSampleRecord.nDigital, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT8:
                        Console.WriteLine("Using pointName get realTime-data succeed!,pointname: {0}, value:{1}, status:{2}", pointname, memSampleRecord.nUInt8, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT8:
                        Console.WriteLine("Using pointName get realTime-data succeed!,pointname: {0}, value:{1}, status:{2}", pointname, memSampleRecord.nInt8, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT16:
                        Console.WriteLine("Using pointName get realTime-data succeed!,pointname: {0}, value:{1}, status:{2}", pointname, memSampleRecord.nUInt16, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT16:
                        Console.WriteLine("Using pointName get realTime-data succeed!,pointname: {0}, value:{1}, status:{2}", pointname, memSampleRecord.nInt16, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT32:
                        Console.WriteLine("Using use pointName get realTime-data succeed!,pointname: {0}, value:{1}, status:{2}", pointname, memSampleRecord.nUInt32, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT32:
                        Console.WriteLine("Using use pointName get realTime-data succeed!,pointname: {0}, value:{1}, status:{2}", pointname, memSampleRecord.nInt32, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT64:
                        Console.WriteLine("Using use pointName get realTime-data succeed!,pointname: {0}, value:{1}, status:{2}", pointname, memSampleRecord.nUInt64, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT64:
                        Console.WriteLine("Using use pointName get realTime-data succeed!,pointname: {0}, value:{1}, status:{2}", pointname, memSampleRecord.nInt64, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_FLOAT64:
                        Console.WriteLine("Using use pointName get realTime-data succeed!,pointname: {0}, value:{1}, status:{2}", pointname, memSampleRecord.fFloat64, memSampleRecord.nQuality);
                        break;
                }
            }
        }

        public int RealTimeTest() {
            int res = 0;
            /* 初始化连接控制块 */
            res = ProcessDBDao.getInstance().init();
            if (0 != res)
            {
                Console.WriteLine("ProcessDBDao init failed! error code: {0}", res);
                return res;
            }
            /* 建立连接 */
            res = ProcessDBDao.getInstance().connect("127.0.0.1", 8301, "root", "root");
            //res = ProcessDBDao.getInstance().connect("192.168.0.186", 8301, "root", "root");
            if (0 != res)
            {
                Console.WriteLine("login failed! error code: {0}", res);
                return res;
            }
            /* 采样点 */
            var pointlist = new List<pointlist>
            {
                new pointlist{ pointname = "D99.T99.P99", pointid = 1003000009, datatype = DATA_TYPE.TAG_TYPE_FLOAT32}  ,
                 new pointlist{ pointname = "D99.T99.P98", pointid = 1003000010, datatype = DATA_TYPE.TAG_TYPE_FLOAT32} 
            };

            /* 通过点名查询实时数据*/
            for (int i = 0; i < pointlist.Count; i++)
            {
                /* 根据点名查询实时数据 */
                get_realtime_data_by_name(pointlist[i].pointname);

            }

            /* 关闭连接 */
            res = ProcessDBDao.getInstance().close();
            return res;

        }

       
    }
}

示例运行结果：

Using pointName get realTime-data succeed!,pointname: D99.T99.P99, value: 8.9, status: 0
Using pointName get realTime-data succeed!,pointname: D99.T99.P98, value: 999, status: 0

五、根据点ID查询实时数据

根据数据点ID的集合，批量查询实时数据

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ProcessDB;

namespace Data_RealTime
{
    class Program
    {  
        static void Main(string[] args)
        {
            TestRealTime testRealTime = new TestRealTime();
            int res = testRealTime.RealTimeTest();
        }
    }

    public class TestRealTime
    {
        public class pointlist
        {
            public string pointname { get; set; }
            public int pointid { get; set; }
            public DATA_TYPE datatype { get; set; }
        }

        static void get_realtime_data_by_id(int pointid)
        {
            int res = ProcessDBDao.getInstance().add_id_to_query_builder(pointid);
            ProcessDBDao.getInstance().exec_query_realtime();
            /* 根据点id查出实时数据 */
            MemSampleRecord memSampleRecord = new MemSampleRecord();
            res = ProcessDBDao.getInstance().get_realtime_data_by_id(pointid, ref memSampleRecord);
            if (0 != res)
            {
                Console.WriteLine("Using pointID get realTime-data failed! pointid : {0}, error code : {1}", pointid, res);
                return;
            }
            else
            {
                switch (memSampleRecord.nTagType)
                {
                    case (byte)DATA_TYPE.TAG_TYPE_FLOAT32:
                        Console.WriteLine("Using pointID get realTime-data succeed! pointid:{0}, value:{1}, status:{2}", pointid, memSampleRecord.fFloat32, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_DIGITAL:
                        Console.WriteLine("Using pointID get realTime-data succeed! pointid:{0}, value:{1}, status:{2}", pointid, memSampleRecord.nDigital, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT8:
                        Console.WriteLine("Using pointID get realTime-data succeed! pointid:{0}, value:{1}, status:{2}", pointid, memSampleRecord.nUInt8, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT8:
                        Console.WriteLine("Using pointID get realTime-data succeed! pointid:{0}, value:{1}, status:{2}", pointid, memSampleRecord.nInt8, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT16:
                        Console.WriteLine("Using pointID get realTime-data succeed! pointid:{0}, value:{1}, status:{2}", pointid, memSampleRecord.nUInt16, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT16:
                        Console.WriteLine("Using pointID get realTime-data succeed! pointid:{0}, value:{1}, status:{2}", pointid, memSampleRecord.nInt16, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT32:
                        Console.WriteLine("Using pointID get realTime-data succeed! pointid:{0}, value:{1}, status:{2}", pointid, memSampleRecord.nUInt32, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT32:
                        Console.WriteLine("Using pointID get realTime-data succeed! pointid:{0}, value:{1}, status:{2}", pointid, memSampleRecord.nInt32, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_UINT64:
                        Console.WriteLine("Using pointID get realTime-data succeed! pointid:{0}, value:{1}, status:{2}", pointid, memSampleRecord.nUInt64, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_INT64:
                        Console.WriteLine("Using pointID get realTime-data succeed! pointid:{0}, value:{1}, status:{2}", pointid, memSampleRecord.nInt64, memSampleRecord.nQuality);
                        break;
                    case (byte)DATA_TYPE.TAG_TYPE_FLOAT64:
                        Console.WriteLine("Using pointID get realTime-data succeed! pointid:{0}, value:{1}, status:{2}", pointid, memSampleRecord.fFloat64, memSampleRecord.nQuality);
                        break;
                }
            }
        }
        public int RealTimeTest() {
            int res = 0;
            /* 初始化连接控制块 */
            res = ProcessDBDao.getInstance().init();
            if (0 != res)
            {
                Console.WriteLine("ProcessDBDao init failed! error code: {0}", res);
                return res;
            }
            /* 建立连接 */
            res = ProcessDBDao.getInstance().connect("127.0.0.1", 8301, "root", "root");
            //res = ProcessDBDao.getInstance().connect("192.168.0.186", 8301, "root", "root");
            if (0 != res)
            {
                Console.WriteLine("login failed! error code: {0}", res);
                return res;
            }

            /*数据点 */
            var pointlist = new List<pointlist>
            {
               new pointlist{ pointname = "D99.T99.P99", pointid = 1003000009, datatype = DATA_TYPE.TAG_TYPE_FLOAT32}  ,
               new pointlist{ pointname = "D99.T99.P98", pointid = 1003000010, datatype = DATA_TYPE.TAG_TYPE_FLOAT32}
            };


            /* 通过点id查询实时数据*/
            for (int j = 0; j < pointlist.Count; j++)
            {
                /* 根据点id获取实时数据 */
                get_realtime_data_by_id(pointlist[j].pointid);
            }


            /* 关闭连接 */
            res = ProcessDBDao.getInstance().close();
            return res;

        }

       
    }
}

示例运行结果：

Using pointID get realTime-data succeed! pointid:1003000009, value:8.9, status:0
Using pointID get realTime-data succeed! pointid:1003000010, value:999, status:0
ProcessDB
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
实时/历史数据库和关系型数据库的区别
12-22
实时数据库和关系数据库有着很多的不同，但是目前实时数据库和关系数据库集成的趋势越来越明显。将生产管理信息系统中使用的关系数据库和...其中实时数据库处理并存储生产实时数据，关系数据库处理并存储业务关系数据。
Python的InfluxDB时序数据库读写代码
04-18
Python的InfluxDB时序数据库是一个专为时间序列数据设计的高性能、开源数据库。InfluxDB 2.0及以上版本提供了更加丰富的功能和优化的性能，使得它在监控、物联网(IoT)、日志分析等领域广泛应用。在这个场景中，我们...
如何通过C#读取PI实时数据
知行合一
11-13 3280
PI 实时数据库系统(Plant Information System)是由美国 OSI Software 公司开发的基于C/S、B/S结构的商品化软件应用平台，是工厂底层控制网络与上层管理信息系统连接的桥梁，PI在工厂信息集成中扮演着特殊和重要的角色。PI实时数据库系统适用于电力、石油、化工、冶金、造纸、制药、水处理、食品饮料、通讯等各种生产流程企业的生产过程优化。 很多场景需要从PI读取数据，这个怎么搞？ 这个读数的套路和PHD差不多，也是先安装客户端，然后通过OSI自...
时序数据库介绍及应用场景，C#实例
赵玉的专栏
06-02 1555
时序数据库是一种优化用于摄取、处理和存储时间戳数据的数据库。时间序列数据是指随时间不断产生的一系列数据，每个数据点都包含用于索引、聚合和采样的时间戳。
ProcessDB实时/时序数据库——C#目录
sun_race的专栏
12-12 224
ProcessDB实时/时序数据库——C#目录
ProcessDB实时/时序数据库——备份及恢复
sun_race的专栏
03-15 447
ProcessDB实时/时序数据库支持点表备份、历史数据备份以及对应的恢复功能，接下来将和大家分享下如何使用ProcessDBConsole控制台进行相应操作。
ProcessDB实时/时序数据库——JAVA_API读写实时数据
sun_race的专栏
11-04 311
ProcessDB实时/时序数据库——JAVA_API读写实时数据
ProcessDB实时/时序数据库——数据报警功能
sun_race的专栏
11-09 662
ProcessDB实时/时序数据库——数据报警功能
ProcessDB实时/时序数据库——C/C++读写实时数据
sun_race的专栏
11-24 659
ProcessDB实时/时序数据库——C/C++读写实时数据
ProcessDB实时/时序数据库——C/C++连接数据库
sun_race的专栏
11-23 940
ProcessDB实时/时序数据库——C/C++连接数据库
ProcessDB实时/时序数据库——EXCEL查询数据
sun_race的专栏
11-10 942
ProcessDB实时/时序数据库——EXCEL查询数据
ProcessDB实时/时序数据库——EXCEL查看实时报表
sun_race的专栏
11-14 715
ProcessDB实时/时序数据库——EXCEL查看实时报表
OPC实时数据发布到MQTT及存储InfluxDB时序数据库
04-01
在本项目中，“OPC实时数据发布到MQTT及存储InfluxDB时序数据库”描述了一个集成系统，该系统首先使用C#和WinForm开发，通过OPC_DA接口与自动化设备通信，获取实时生产数据。C#是一种广泛使用的面向对象的编程语言，...
时序数据库influxdb2的java读写示例
04-02
总结，InfluxDB2作为时序数据库，其Java读写操作包括连接数据库、构建Point或Batch进行数据写入，以及使用InfluxQL执行查询并处理结果。理解这些核心概念和操作，将有助于你有效地在Java应用程序中集成和利用...
时序数据库.docx 数据顺序追加
12-16
数据库特性方面，时序数据库强调写入速率远大于读取速率，因为数据通常是实时产生的，而分析往往是事后进行。时间窗口访问是常见操作，数据更新较少，存在一定的覆盖写窗口。批量删除功能也很重要，同时保持高可用性...
时序数据库-03-opentsdb-分布式时序数据库
07-20 1200
StumbleUpon编写了一个名为tcollector的Python框架，用于从Linux 2.6，Apache的HTTPd，MySQL，HBase，memcached，Varnish等中收集数千个指标。如果找不到满足需求的工具，则可能需要编写从系统中收集数据的脚本（例如，通过从Linux上的/ proc读取有趣的指标，通过SNMP从网络设备收集计数器，或者从您的应用程序，通过JMX，例如Java应用程序），并定期将数据点推送到其中一个TSD。
数据库开发：MySQL基础（二）
最新发布
m0_66925868的博客
07-25 914
一对一关系（One-to-One Relationship）指的是两个实体之间存在一种对应关系，其中一个实体的每个记录只能对应另一个实体的一条记录，而另一个实体的每个记录也只能对应一个实体的记录。如果“表2”的某行在“表1”中没有匹配行，那么在返回结果中，“表1”的字段值均为空值（NULL）。如果“表1”的某行在“表2”中没有匹配行，那么在返回结果中，“表2”的字段值均为空值（NULL）。对于两个具有关联关系的表而言，相关联字段中主键所在的表就是主表（父表），外键所在的表就是从表（子表）。
物联网在电力行业的应用
专研计算机网络，数据通信，网络安全，系统集成
07-22 1023
物联网（IoT）在电力行业中的应用不仅仅限于智能电表和设备监控，还包括智能电网、能耗管理、预测性维护、电力负载预测等。本文将深入探讨这些应用，并提供更详细的代码示例来展示如何实现这些应用。
Vicdas2.0：工业级实时/历史数据库解决方案
Vicdas2.0提供数据采集、实时库、历史库、流程图显示、报警机制、趋势分析以及实时计算等功能，适用于电力、石油、煤炭等多个工业领域的生产实时数据管理和分析。系统具备高稳定性和性能，如快速查询响应、大量数据...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值