public void TestEtyOPCDataNode01()
{
EtyOPCDataNode etyOPCDataNode = new EtyOPCDataNode();
bool b = etyOPCDataNode.Disabled;
etyOPCDataNode.Disabled = b;
string s = etyOPCDataNode.OPCDataNodeDesc;
etyOPCDataNode.OPCDataNodeDesc = s;
s = etyOPCDataNode.OPCDataNodeHost;
etyOPCDataNode.OPCDataNodeHost = s;
double d = etyOPCDataNode.OPCDataNodeId;
etyOPCDataNode.OPCDataNodeId = d;
s = etyOPCDataNode.OPCDataNodeName;
etyOPCDataNode.OPCDataNodeName = s;
s = etyOPCDataNode.OPCDataNodeServer;
etyOPCDataNode.OPCDataNodeServer = s;
d = etyOPCDataNode.OPCParentNodeId;
etyOPCDataNode.OPCParentNodeId = d;
}
/// <summary>
/// Returns all the Root Data Nodes.
/// </summary>
/// <returns>Root Data Nodes</returns>
public List <EtyOPCDataNode> GetAllOPCDataNode(string serverRootName, string opcServerName)
{
const string Function_Name = "GetAllOPCDataNode";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <EtyOPCDataNode> OPCDataNodeList = new List <EtyOPCDataNode>();
string localSQL = " SELECT KEYID,DT_NODE_NAME,DT_NODE_DESC " +
" FROM OPC_DT_NODE WHERE PKEYID IN (SELECT DISTINCT PKEY FROM ENTITY WHERE NAME = '" + serverRootName + "') AND DISABLE = 'N' AND DATA_PT_SERVER = '" + opcServerName
+ "' ORDER BY DT_NODE_NAME";
//sql for getting from entity table
/*string localSQL = " SELECT PKEY,NAME,DESCRIPTION" +
* " FROM ENTITY WHERE TYPEKEY = (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'DataNode')"+
* " AND PARENTKEY IN (SELECT DISTINCT PKEY FROM ENTITY WHERE TYPEKEY IN (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'SCADAROOT'))"+
* " ORDER BY NAME";*/
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
EtyOPCDataNode etyOPCDataNode = new EtyOPCDataNode();
if (!drReader.IsDBNull(drReader.GetOrdinal("KEYID")))
{
etyOPCDataNode.OPCDataNodeId = Convert.ToDouble(drReader["KEYID"]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DT_NODE_NAME")))
{
etyOPCDataNode.OPCDataNodeName = DAOHelper.convert8859P1ToGB2312(drReader["DT_NODE_NAME"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DT_NODE_DESC")))
{
etyOPCDataNode.OPCDataNodeDesc = DAOHelper.convert8859P1ToGB2312(drReader["DT_NODE_DESC"].ToString());
}
OPCDataNodeList.Add(etyOPCDataNode);
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(OPCDataNodeList);
}
/*public int GetTotalDataPointCount(string opcServerName, string filterString)
* {
* return OPCNodeNDataPointDAO.GetInstance().GetOPCDataPointCount(opcServerName, filterString);
* }*/
/// <summary>
/// Get all the DataNode from the Database of specified server root (Parent Entity)name .
/// </summary>
/// <param name="serverRootName">Root entity name</param>
/// <param name="opcServerName">Server name</param>
/// <returns>DataNode Entity List</returns>
/*public List<EtyOPCDataNode> GetAllOPCDataNodes(string serverRootName, string opcServerName)
* {
* return OPCNodeNDataPointDAO.GetInstance().GetAllOPCDataNode(serverRootName, opcServerName);
* }*/
public List <EtyOPCDataNode> GetAllOPCDataNodes(string serverRootName, string opcServerName)
{
List <EtyOPCDataNode> etyDataNodeList = new List <EtyOPCDataNode>();
EntityDAO entityDao = new EntityDAO();
Dictionary <ulong, EtyEntity> dataNodelist = entityDao.GetAllDataNodesByServerRootName(serverRootName);
foreach (KeyValuePair <ulong, EtyEntity> pair in dataNodelist)
{
EtyOPCDataNode etyDataNode = new EtyOPCDataNode();
etyDataNode.OPCDataNodeId = pair.Key;
EtyEntity etyEntity = pair.Value;
etyDataNode.OPCDataNodeName = etyEntity.Name;
etyDataNode.OPCDataNodeDesc = etyEntity.Description;
etyDataNodeList.Add(etyDataNode);
}
return(etyDataNodeList);
}
/// <summary>
/// Returns all Child Datanode of the specified parent Datanode
/// </summary>
/// <param name="parentNode">parent datanode name</param>
/// <param name="opcServerName">server name</param>
/// <returns>Datanode entity List</returns>
public List <EtyOPCDataNode> GetChildOPCDataNodes(string parentNode, string opcServerName)
{
// return OPCNodeNDataPointDAO.GetInstance().GetChildOPCDataNode(parentNode, opcServerName);
ulong parentkey = Convert.ToUInt64(parentNode);
List <EtyOPCDataNode> etyDataNodeList = new List <EtyOPCDataNode>();
EntityDAO entityDao = new EntityDAO();
Dictionary <ulong, EtyEntity> dataNodelist = entityDao.GetDataNodeChildrenByPkey(parentkey);
foreach (KeyValuePair <ulong, EtyEntity> pair in dataNodelist)
{
EtyOPCDataNode etyDataNode = new EtyOPCDataNode();
etyDataNode.OPCDataNodeId = pair.Key;
EtyEntity etyEntity = pair.Value;
etyDataNode.OPCDataNodeName = etyEntity.Name;
etyDataNode.OPCDataNodeDesc = etyEntity.Description;
etyDataNodeList.Add(etyDataNode);
}
return(etyDataNodeList);
}
