C# Class HistorianFunctions, openHistorian

openHistorian SQL CLR procedure used to query historian data.

Mostra file Open project: GridProtectionAlliance/openHistorian Class Usage Examples

Public Methods

Method	Description
GetHistorianData_FillRow ( object source, SqlInt64 &id, DateTime &time, SqlSingle &value ) : void	Used to fill table columns with enumerable data returned from GetHistorianData.
HighDoubleWord ( SqlInt64 quadWord ) : SqlInt32	Returns the unsigned high-double-word (SqlInt32) from a quad-word (SqlInt64). On little-endian architectures (e.g., Intel platforms), this will be the word value whose in-memory representation is the same as the right-most, most-significant-word of the integer value.
LowDoubleWord ( SqlInt64 quadWord ) : SqlInt32	Returns the low-double-word (SqlInt32) from a quad-word (SqlInt64). On little-endian architectures (e.g., Intel platforms), this will be the word value whose in-memory representation is the same as the left-most, least-significant-word of the integer value.
MakeQuadWord ( SqlInt32 high, SqlInt32 low ) : SqlInt64	Makes a quad-word (SqlInt64) from two double-words (SqlInt32).

Private Methods

Method	Description
GetHistorianData ( SqlString historianServer, SqlString instanceName, DateTime startTime, DateTime stopTime, [ MaxSize = -1)]SqlStringmeasurementIDs ) : IEnumerable
GetHistorianDataSampled ( SqlString historianServer, SqlString instanceName, DateTime startTime, DateTime stopTime, TimeSpan interval, [ MaxSize = -1)]SqlStringmeasurementIDs ) : IEnumerable

Method Details

GetHistorianData_FillRow() public static method

Used to fill table columns with enumerable data returned from GetHistorianData.

public static GetHistorianData_FillRow ( object source, SqlInt64 &id, DateTime &time, SqlSingle &value ) : void
source	object	Source data, i.e., a .
id	System.Data.SqlTypes.SqlInt64	Measurement ID
time	DateTime	Measurement timestamp
value	System.Data.SqlTypes.SqlSingle	Measurement value
return	void

HighDoubleWord() public static method

Returns the unsigned high-double-word (SqlInt32) from a quad-word (SqlInt64).

On little-endian architectures (e.g., Intel platforms), this will be the word value whose in-memory representation is the same as the right-most, most-significant-word of the integer value.

public static HighDoubleWord ( SqlInt64 quadWord ) : SqlInt32
quadWord	System.Data.SqlTypes.SqlInt64	8-byte, 64-bit integer value.
return	System.Data.SqlTypes.SqlInt32

LowDoubleWord() public static method

Returns the low-double-word (SqlInt32) from a quad-word (SqlInt64).

On little-endian architectures (e.g., Intel platforms), this will be the word value whose in-memory representation is the same as the left-most, least-significant-word of the integer value.

public static LowDoubleWord ( SqlInt64 quadWord ) : SqlInt32
quadWord	System.Data.SqlTypes.SqlInt64	8-byte, 64-bit integer value.
return	System.Data.SqlTypes.SqlInt32

MakeQuadWord() public static method

Makes a quad-word (SqlInt64) from two double-words (SqlInt32).

public static MakeQuadWord ( SqlInt32 high, SqlInt32 low ) : SqlInt64
high	System.Data.SqlTypes.SqlInt32	High double-word.
low	System.Data.SqlTypes.SqlInt32	Low double-word.
return	System.Data.SqlTypes.SqlInt64