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); }