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
    评论
专栏目录
ProcessDB-202405 Win64位实时数据库系统安装程序
06-13
ProcessDB实时数据库/时序数据库系统，广泛应用于石油，化工，火电，冶金，橡胶，船舶，造船，港口，分布式存储，高性能分析海量数据 支持windows/linux/麒麟系统、支持微秒级、读写实时数据＞300万记录/秒、读写历史数据＞400万记录/秒、亿级别标签点数、50年数据存储、支持多种内置函数的计算表达式、支持OPC、ODBC、JDBC、API（java/c/c++/js/csharp/python）等二次开发接口。
实时/历史数据库和关系型数据库的区别
12-22
实时数据库和关系数据库有着很多的不同，但是目前实时数据库和关系数据库集成的趋势越来越明显。将生产管理信息系统中使用的关系数据库和实时数据库集成到一起，可以同时满足控制和管理的要求，真正成为管理控制一体化的平台。例如，目前大多行业均利用实时数据库与关系数据库作为基础数据库软件构建监控中心及数据中心的基础数据库。其中实时数据库处理并存储生产实时数据，关系数据库处理并存储业务关系数据。
C#使用OpcUaHelper开源库开发客户端实现读取、订阅OPC UA服务器节点信息
热门推荐
CoffeMilk的博客
05-25 2万+
目录 一、内容准备 1.1、搭建OPC UA服务器环境 1.2、项目安装OPCUaHelper开源库 1.3、OpcUaHelper开源库 二、实现操作 2.1、连接OPC UA服务器，浏览所有节点信息 2.2、OpcUaHelper帮助类的常用方法 2.2.1、连接OPC UA服务器方法 2.2.2、读取OPC UA服务器的节点数据 2.2.3、读取OPC UA服务器中节点信息 三、运行测试 3.1、自己写的核心类 3.2、运行项目测试 一、内容准备 1.1、搭建OPC UA
时序数据库TDengine安装及c#连接读写数据
qq_16005627的博客
12-06 2609
物联网数据采集，需写入大量数据，这时就用到时序数据库来存储和快速读取我个人使用感觉国产的开源项目TDengine，比InfluxDB操作方便很多，容易上手，支持使用SqlSugar进行数据操作，跟操作mysql数据库一样的体验跟mysql最有特别之处，就是TDengine有个超级表=表结构模板 的概念，可以基于这个超级表的结构，建N个数量的子表，查询的时候，可以查单个子表，也可以查超级表所有子表的数据集合超级表概念如：建超级表A基于超级表A的结构 建子表 ： A1、A2、A3、N。
C#保存数据到文件，读取文件数据
scimence的专栏
04-02 2万+
C#保存数据到文件，SaveToFile(String data, String name, bool mute)
C#读写Influxdb代码例子
02-27
C#读写Influxdb代码示例源代码，简单、易用，新手可直接调用InfluxDBHelper，有其他方法的欢迎一起讨论学习
【学习C#】对SQL Server数据库进行读写（DataReader方式）
和我一起学习
06-02 5453
以DataReader方式进行查询、更新，以ListView控件为例查看查询内容
ProcessDB实时/时序数据库——C#检索测点信息
sun_race的专栏
11-09 112
ProcessDB实时/时序数据库支持C#语言开发，本文将针对C#操作ProcessDB检索测点信息进行介绍
C# 基于TPC/IP数据采集工具
tony_lhb的博客
10-13 1177
自定义客户端，数据保存在Access数据库，支持多客户端同时执行
Python的InfluxDB时序数据库读写代码
最新发布
04-18
Python读写时序数据库数据实例代码。 使用Python写入InfluxDB记录，读取InfluxDB记录实例代码。 注意适用于InfluxDB 2.0以上版本
C#连接PI实时库获取数据
05-31
C#连接PI实时库获取数据案列，配置相应的PI实时数据库的配置信息，然后运行，直接运行可执行文件。
数据采集显示和存储
09-23
数据采集显示和存储
c#数据库读写程序
07-26
c#下的数据库读写程序，测试过了，针对sdf类型
C#实现的GPS实时跟踪系统
07-06
采用C#语言实现的GPS实时跟踪系统，里面包含了详尽的API及说明。
ASP.NET Core2读写InfluxDB时序数据库的方法教程
10-17
Influxdb是一个开源的分布式时序、时间和指标数据库，使用go语言编写，无需外部依赖，下面这篇文章主要给大家介绍了关于ASP.NET Core2读写InfluxDB时序数据库的相关资料，需要的朋友可以参考下
时序数据库influxdb2的java读写示例
04-02
由于influxdb2实际是个列存储的数据库，读写跟一般的rds不一样的，这里实现了一个相对通用的查询结果处理方法
C# 使用ClickHouse时序数据库封装
流星雨的博客
12-19 3784
一、引用nuget包 ClickHouse.Ado ClickHouse.Net 二、基础封装类 类库封装借鉴了其它博客 public class ClickHouseHelper : IDisposable { private readonly string _connectionString = "Compress=False;BufferSize=32768;SocketTimeout=10000;CheckCompressedHash=False;Compressor
时序数据库 InfluxDB介绍
changyanmanman的专栏
03-09 9142
整理自：https://sq.163yun.com/blog/article/169866295296581632 InfluxDB 数据模型 InfluxDB的数据模型和其他时序数据库有些许不同，下图是InfluxDB中的一张示意表： 1. Measurement：从原理上讲更像SQL中表的概念。这和其他很多时序数据库有些不同，其他时序数据库中Measurement可能与Metric等...
时序数据库学习笔记
vtnews的专栏
05-15 2516
1-时序数据库有多少种类型 DB-Engines： https://db-engines.com/en/ranking/time+series+dbms Graphite vs. InfluxDB vs. Kdb+ vs. OpenTSDB vs. RRDtool https://db-engines.com/en/system/RRDtool%3BInfluxDB%3BKdb%2B%3...
时序/时空/向量/密态数据库
02-22
当然，我可以为您介绍一下时序数据库、时空数据库、向量数据库和密态数据库。 1. 时序数据库（Time Series Database）： 时序数据库是一种专门用于存储和处理时间序列数据的数据库。时间序列数据是按照时间顺序排列的数据点或事件的集合，例如传感器数据、股票价格、气象数据等。时序数据库具有高效的数据存储和查询能力，可以支持快速的时间范围查询、聚合计算和模式识别等操作。 2. 时空数据库（Spatial Database）： 时空数据库是一种专门用于存储和处理时空数据的数据库。时空数据是具有地理位置和时间属性的数据，例如地理信息系统（GIS）数据、移动轨迹数据等。时空数据库提供了对时空数据进行索引、查询和分析的功能，可以支持空间范围查询、空间关系分析和轨迹分析等操作。 3. 向量数据库（Vector Database）： 向量数据库是一种专门用于存储和处理向量数据的数据库。向量数据是由数值组成的多维向量，例如图像特征向量、文本向量等。向量数据库提供了高效的向量索引和相似度搜索功能，可以支持基于向量的检索和聚类分析等操作。 4. 密态数据库（Dense Database）： 密态数据库是一种专门用于存储和处理密集数据的数据库。密集数据是指具有高维度和大规模的数据，例如科学计算、机器学习和人工智能领域的数据。密态数据库提供了高效的存储和计算能力，可以支持大规模数据的并行处理和分布式计算。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值