本篇文章主要利用PISDK从PI服务器取数，介绍多种取数方法。
首先需要一些基础的代码，比如获取PI服务的：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
/// <summary>/// 获取PI服务/// </summary>/// <param name="servername">//UID=PIUser;PWD=PIUserPassWord</param>/// <returns></returns>private Server GetServer(string servername){ try { if (!string.IsNullOrEmpty(servername)) { //采用认证方式登录 server = pi.Servers[servername]; server.Open(connStr); } else { //采用默认方式登录 server = pi.Servers.DefaultServer; server.Open(); } if (server.Connected) { return server; } else { return null; } } catch (Exception ex) { MessageBox.Show(ex.Message); return null; }} |
还有到PI服务器中找点的方法：
|
1
2
3
4
5
6
7
8
9
10
|
/// <summary>/// 搜索PI中对应的数据点/// </summary>/// <param name="server">PI服务对象</param>/// <param name="condition">选择tag的条件</param>/// <returns></returns>private PointList SearchPIPoints(Server server, String condition){ return server.GetPoints(condition);} |
下面介绍取数方法：
1. 取得单个tag快照值
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
/// <summary>/// 取得单个tag快照值/// </summary>/// <param name="server">PI服务对象</param>/// <param name="tag">tag名称</param>/// <returns></returns>private string GetSingleSnap(Server server, string tag){ string output=string.Empty; PIPoints piPoints = server.PIPoints; //采用标签名称的方式取得对象 PIPoint piPoint = piPoints[tag]; //调用方法取得快照值 PIValue piValue = piPoint.Data.Snapshot; //取到该快照值时PI服务器时间 PITimeServer.PITime piTime = piValue.TimeStamp; output = piTime.LocalDate.ToString() + " " + piValue.Value + Environment.NewLine; return output;} |
2. 取得单个tag一段时间内的历史值
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
/// <summary>/// 取得单个tag段时间内的历史值/// </summary>/// <param name="server">PI服务对象</param>/// <param name="tag">tag名称</param>/// <returns></returns>private string GetSingleHistory(Server server, string tag){ string output = string.Empty; PIPoints piPoints = server.PIPoints; PIPoint piPoint = piPoints[tag]; //取得分钟前到当前时间的历史值 PIValues piValues = piPoint.Data.RecordedValues(DateTime.Now.AddMinutes(-5).ToString(), DateTime.Now.ToString()); foreach (PIValue piValue in piValues) { PITimeServer.PITime piTime = piValue.TimeStamp; //PI时间 output += piTime.LocalDate.ToString() + " " + piValue.Value + Environment.NewLine; } return output;} |
3. 取得多个tag快照值
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
/// <summary>/// 取得多个tag取快照值/// </summary>/// <param name="server">PI服务对象</param>/// <param name="tag">tag值(tag='' or tag='')</param>/// <returns></returns>private string MultipleSnap(Server server, string tag){ string output = string.Empty; //取tag PointList ptlist = SearchPIPoints(server, tag); PISDKCommon.NamedValues nvErrs = new PISDKCommon.NamedValues(); PointValues ptvalues = ptlist.Data.get_Snapshot(out nvErrs); foreach (PointValue myValue in ptvalues) { PITimeServer.PITime piTime = myValue.PIValue.TimeStamp; //PI时间 if (myValue.PIValue.Value.GetType().IsCOMObject) { //状态值 DigitalState myDigState = (DigitalState)myValue.PIValue.Value; output += myValue.PIPoint.Name + " " + piTime.LocalDate.ToString() + " " + myDigState.Name + Environment.NewLine; } else { //模拟值 output += myValue.PIPoint.Name + " " + piTime.LocalDate.ToString() + " " + Convert.ToString(Math.Round(double.Parse(Convert.ToString(myValue.PIValue.Value)), 2)) + Environment.NewLine; } } return output;} |
4. 取得多个tag一段历史时间所有值
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
/// <summary>/// 取得多个tag段历史时间所有值/// </summary>/// <param name="server">PI服务对象</param>/// <param name="tag">tag名称</param>/// <returns></returns>private string MultipleHistory1(Server server,string tag){ string output = string.Empty; PointList ptlist = SearchPIPoints(server, tag); string outPut = string.Empty; PISDKCommon.NamedValues nvErrs = new PISDKCommon.NamedValues(); foreach (PIPoint piPoint in ptlist) { //获取5分钟前到当前时间的历史值 PIValues piValues = piPoint.Data.RecordedValues(DateTime.Now.AddMinutes(-5).ToString(), DateTime.Now.ToString()); foreach (PIValue piValue in piValues) { PITimeServer.PITime piTime = piValue.TimeStamp; //PI时间 output+= piPoint.Name + " " + piTime.LocalDate.ToString() + " " + piValue.Value + Environment.NewLine; } } return output;} |
5. 取得多个tag历史时刻值
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
/// <summary>/// 取得多个tag段历史时间点值/// </summary>/// <param name="server">PI服务对象</param>/// <param name="tag">tag名称</param>/// <returns></returns>private string MultipleHistory2(Server server, string tag){ string output = string.Empty; PointList ptlist = SearchPIPoints(server, tag); PISDKCommon.NamedValues nvErrs = new PISDKCommon.NamedValues(); PITimeServer.PITimeFormat piTime1 = new PITimeServer.PITimeFormat(); piTime1.InputString = "*-2h";//or "2012-2-2 2:2:2" //获取两小时前的时刻值 PointValues ptvalues = ptlist.Data.ArcValue(piTime1, RetrievalTypeConstants.rtAuto, out nvErrs); foreach (PointValue myValue in ptvalues) { PITimeServer.PITime piTime = myValue.PIValue.TimeStamp; //PI时间 if (myValue.PIValue.Value.GetType().IsCOMObject) { //状态值 DigitalState myDigState = (DigitalState)myValue.PIValue.Value; output+= myValue.PIPoint.Name + " " + piTime.LocalDate.ToString() + " " + myDigState.Name + Environment.NewLine; } else { //模拟值 output+= myValue.PIPoint.Name + " " + piTime.LocalDate.ToString() + " " + Convert.ToString(Math.Round(double.Parse(Convert.ToString(myValue.PIValue.Value)), 2)) + Environment.NewLine; } } return output;} |
转载自：https://www.cnblogs.com/Johnny_Z/p/3234849.html