/// <summary> /// Method to get the specified node /// </summary> /// <param name="lscId">lscId</param> /// <param name="nodeId">nodeId</param> /// <param name="nodeType">nodeType</param> /// <returns>node information</returns> public NodeInfo GetNode(int lscId, int nodeId, EnmNodeType nodeType) { try { SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int), new SqlParameter("@NodeID", SqlDbType.Int), new SqlParameter("@NodeType", SqlDbType.Int) }; parms[0].Value = lscId; parms[1].Value = nodeId; parms[2].Value = (int)nodeType; NodeInfo node = null; using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_NODE_GETNODE, parms)) { if (rdr.Read()) { node = new NodeInfo(); node.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]); node.NodeID = ComUtility.DBNullInt32Handler(rdr["NodeID"]); node.NodeType = ComUtility.DBNullNodeTypeHandler(rdr["NodeType"]); node.Value = ComUtility.DBNullFloatHandler(rdr["Value"]); node.Status = ComUtility.DBNullStateHandler(rdr["Status"]); node.DateTime = ComUtility.DBNullDateTimeHandler(rdr["DateTime"]); node.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["UpdateTime"]); } } return(node); } catch { throw; } }