private List <OPCClientItemEntity> GetEntities(List <OPCItemData> itemDataList)
{
List <OPCClientItemEntity> itemEntities = new List <OPCClientItemEntity>();
try
{
List <OPCClientDBFieldMapping> dbFieldMappingList;
foreach (OPCItemData itemData in itemDataList)
{
OPCClientItemEntity itemEntity = new OPCClientItemEntity();
//如果是特殊的OPC项，则使用配置的映射
OPCItemMappingInfo opcItemMappingInfo = null;
if (OPCItemMapping != null)
{
opcItemMappingInfo = OPCItemMapping.GetOPCItemMappingInfo(itemData.ItemID);
}
if (opcItemMappingInfo != null)
{
dbFieldMappingList = opcItemMappingInfo.DBFieldMappingList;
}
else
{
dbFieldMappingList = this.DBFieldMappings;
}
#region 设置数据项实体的各属性
string[] ItemIDCol = itemData.ItemID.Split('.');
foreach (OPCClientDBFieldMapping fieldMapping in dbFieldMappingList)
{
OPCClientItemProperty itemProp = new OPCClientItemProperty();
//字段名称
itemProp.Name = fieldMapping.FieldName;
//数据类型
itemProp.DataType = (OPCClientDBFieldMapping.EnumDataType)fieldMapping.DataType;
//从自定义数据源获取字段值
if (fieldMapping.SourceCustom.Trim() != string.Empty)
{
//以":"开头为变量，否则为常量
//当为变量时，以":[0]"开头，为系统变量，不依赖当前程序和数据，如:[0]:GUID，:[0]:DateTime等。
//以":[1]"开头，根据同一传感器的其他值按规则获取相应值
//以":[2]"开头，根据同一个站点的其他传感器的数据按规则获取相应值
string prefix = string.Empty;
string prefix2 = string.Empty;
string varStr = string.Empty;
if (fieldMapping.SourceCustom.Length >= 4)
{
prefix = fieldMapping.SourceCustom.Substring(0, 4);
varStr = fieldMapping.SourceCustom.Substring(4, fieldMapping.SourceCustom.Length - 4);
}
if (fieldMapping.SourceCustom.Length >= 1)
{
prefix2 = fieldMapping.SourceCustom.Substring(0, 1);
}
string itemValue = string.Empty;
switch (prefix)
{
case ":[0]": //如":[0]:GUID"可以获取系统生成的GUID，":[0]:NOW"可以获取当前时间。
itemValue = OPCUtils.GetCustomSystemValue(varStr);
break;
case ":[1]": //如":[1]:SENSOR_NAME"，可以从数据实体中获取属性"SENSOR_NAME"的值，然后根据规则返回所需的值。
string fieldName = varStr.Substring(1, varStr.Length - 1);
IEnumerable <OPCClientItemProperty> tempProps =
itemEntity.Properties.Where(x => x.Name.ToUpper() == fieldName.ToUpper());
if (tempProps != null && tempProps.Count() > 0)
{
itemValue = OPCUtils.GetCustomValueByItemProperty(fieldName, tempProps.First().Value);
}
break;
case ":[2]": //如":[2]:更新时间"，可以从数据列表中找到"local.x02.更新时间"，从中获取Item Value.
string itemName = varStr.Substring(1, varStr.Length - 1);
if (ItemIDCol.Length > 0)
{
string queryItemID = string.Empty;
for (int i = 0; i < ItemIDCol.Length - 1; i++)
{
if (queryItemID == string.Empty)
{
queryItemID = ItemIDCol[i];
}
else
{
queryItemID = queryItemID + "." + ItemIDCol[i];
}
}
if (queryItemID == string.Empty)
{
queryItemID = itemName;
}
else
{
queryItemID = queryItemID + "." + itemName;
}
IEnumerable <OPCItemData> tempItemDataList =
itemDataList.Where(x => x.ItemID.ToUpper() == queryItemID.ToUpper());
if (tempItemDataList != null && tempItemDataList.Count() > 0)
{
itemValue = tempItemDataList.First().Value;
}
}
break;
default:
if (prefix2 == ":")
{
//如果是变量，默认获取系统变量
itemValue = OPCUtils.GetCustomSystemValue(fieldMapping.SourceCustom);
}
else
{
//常量
itemValue = fieldMapping.SourceCustom;
}
break;
}
itemProp.Value = itemValue;
}
//从OPCItem属性获取字段值
if (fieldMapping.SourceOPCItem > 0 && (itemProp.Value == null || itemProp.Value.Trim() == string.Empty))
{
switch ((OPCClientDBFieldMapping.EnumOPCItem)fieldMapping.SourceOPCItem)
{
case OPCClientDBFieldMapping.EnumOPCItem.未设置:
itemProp.Value = string.Empty;
break;
case OPCClientDBFieldMapping.EnumOPCItem.ITEM_VALUE:
itemProp.Value = itemData.Value;
break;
case OPCClientDBFieldMapping.EnumOPCItem.ITEM_QUALITY:
itemProp.Value = itemData.Quality;
break;
case OPCClientDBFieldMapping.EnumOPCItem.ITEM_TIMESTAMP:
itemProp.Value = itemData.Timestamp;
break;
case OPCClientDBFieldMapping.EnumOPCItem.ITEM_SERVERHANDLE:
itemProp.Value = itemData.ServerHandle;
break;
case OPCClientDBFieldMapping.EnumOPCItem.ITEM_CLIENTHANDLE:
itemProp.Value = itemData.ClientHandle;
break;
case OPCClientDBFieldMapping.EnumOPCItem.ITEM_ID:
itemProp.Value = itemData.ItemID;
break;
case OPCClientDBFieldMapping.EnumOPCItem.ITEM_ID_0:
if (ItemIDCol.Length > 0)
{
itemProp.Value = ItemIDCol[0];
}
break;
case OPCClientDBFieldMapping.EnumOPCItem.ITEM_ID_1:
if (ItemIDCol.Length > 1)
{
itemProp.Value = ItemIDCol[1];
}
break;
case OPCClientDBFieldMapping.EnumOPCItem.ITEM_ID_2:
if (ItemIDCol.Length > 2)
{
itemProp.Value = ItemIDCol[2];
}
break;
case OPCClientDBFieldMapping.EnumOPCItem.ITEM_ID_3:
if (ItemIDCol.Length > 3)
{
itemProp.Value = ItemIDCol[3];
}
break;
default:
itemProp.Value = string.Empty;
break;
}
}
//取值序列
itemProp.SEQ_Name = fieldMapping.SeqName;
//是否自增
itemProp.AutoInc = Convert.ToBoolean(fieldMapping.AutoInc);
//是否标识，用于判断是否同一个站点、传感器
itemProp.IsEntityIdentity = Convert.ToBoolean(fieldMapping.IsEntityIdentity);
bool propIsValid = false;
switch (itemProp.DataType)
{
case OPCClientDBFieldMapping.EnumDataType.INT:
int checkInt;
propIsValid = int.TryParse(itemProp.Value, out checkInt);
break;
case OPCClientDBFieldMapping.EnumDataType.NUMERIC:
double checkDouble;
propIsValid = double.TryParse(itemProp.Value, out checkDouble);
break;
case OPCClientDBFieldMapping.EnumDataType.CHAR:
propIsValid = true;
break;
case OPCClientDBFieldMapping.EnumDataType.NCHAR:
propIsValid = true;
break;
case OPCClientDBFieldMapping.EnumDataType.DATETIME:
DateTime checkDateTime;
propIsValid = DateTime.TryParse(itemProp.Value, out checkDateTime);
break;
case OPCClientDBFieldMapping.EnumDataType.BINARY:
propIsValid = true;
break;
default:
propIsValid = false;
break;
}
if (!propIsValid)
{
itemEntity = null;
break;
}
else
{
itemEntity.Properties.Add(itemProp);
}
}
#endregion
if (itemEntity != null)
{
itemEntities.Add(itemEntity);
}
}
} catch (Exception e)
{
OPCLog.Error(string.Format("获取OPC数据项映射配置时发生错误：{0}", e.Message));
}
return(itemEntities);
}
private void LoadConfiguration()
{
m_OPCItemMappingList.Clear();
XmlNodeList serverHostNodes = this.m_xmlDoc.SelectNodes("OPCItemMapping/serverhost");
foreach (XmlNode serverHostNode in serverHostNodes)
{
string serverHost = serverHostNode.Attributes["hostname"].Value;
foreach (XmlNode OPCServerNode in serverHostNode.ChildNodes)
{
if (OPCServerNode.LocalName.ToLower() == "opcserver")
{
string opcServerName = OPCServerNode.Attributes["servername"].Value;
OPCItemMapping opcItemMapping = new OPCItemMapping();
opcItemMapping.ServerHost = serverHost;
opcItemMapping.OPCServerName = opcServerName;
foreach (XmlNode opcItemNode in OPCServerNode.ChildNodes)
{
if (opcItemNode.LocalName.ToLower() == "opcitem")
{
XmlNode mappingNode = opcItemNode.SelectSingleNode("Mapping");
if (mappingNode != null)
{
//string opcItemID = opcItemNode.Attributes["name"].Value;
OPCItemMappingInfo opcItemMappingInfo = new OPCItemMappingInfo();
opcItemMappingInfo.OPCItemID = opcItemNode.Attributes["name"].Value;
foreach (XmlNode fieldNode in mappingNode.ChildNodes)
{
if (fieldNode.LocalName == "field")
{
OPCGroupDatabaseFieldConfig field = new OPCGroupDatabaseFieldConfig();
//
field.FieldName = fieldNode.Attributes["fieldname"].Value;
//
int sourceOPCItem = 0;
field.SourceOPCItem = int.TryParse(fieldNode.Attributes["sourceopcitem"].Value, out sourceOPCItem) &&
Enum.IsDefined(typeof(OPCClientDBFieldMapping.EnumOPCItem), sourceOPCItem)
? sourceOPCItem : (int)OPCClientDBFieldMapping.EnumOPCItem.未设置;
//
field.SourceCustom = fieldNode.Attributes["sourcecustom"].Value;
//
int dataType = 0;
field.DataType = int.TryParse(fieldNode.Attributes["datatype"].Value, out dataType) &&
Enum.IsDefined(typeof(OPCClientDBFieldMapping.EnumDataType), dataType)
? dataType : (int)OPCClientDBFieldMapping.EnumDataType.CHAR;
//
field.SEQName = fieldNode.Attributes["seqname"].Value;
//
int autoInc = 0;
field.AutoInc = int.TryParse(fieldNode.Attributes["autoinc"].Value, out autoInc) &&
Enum.IsDefined(typeof(OPCClientDBFieldMapping.EnumAutoInc), autoInc)
? autoInc : (int)OPCClientDBFieldMapping.EnumAutoInc.NO;
//
int isEntityId = 0;
field.IsEntityIdentity = int.TryParse(fieldNode.Attributes["isentityidentity"].Value, out isEntityId) &&
Enum.IsDefined(typeof(OPCClientDBFieldMapping.EnumIsEntityIdentity), isEntityId)
? isEntityId : (int)OPCClientDBFieldMapping.EnumIsEntityIdentity.NO;
if (field.FieldName != null & field.FieldName.Trim() != string.Empty)
{
opcItemMappingInfo.DBFieldConfigList.Add(field);
}
}
}
opcItemMapping.OPCItemList.Add(opcItemMappingInfo);
}
}
}
m_OPCItemMappingList.Add(opcItemMapping);
}
}
}
}