ATMLDataAccessLibrary.db.daos.SignalDAO.getRootSignals C# (CSharp) Метод

        public List<dbSignal> getRootSignals()
        {
            XmlDocument doc = new XmlDocument();
            List<dbSignal> signals = new List<dbSignal>();

            String sql = "SELECT * FROM signal_master WHERE parent_signal_id=? ORDER BY signal_name";
            OleDbParameter[] dbParams = { CreateParameter("@parent_signal_id", 1) };
            using (OleDbDataReader reader = ExecuteSqlQuery( sql, dbParams ))
            {
                if (reader != null)
                {
                    while (reader.Read())
                    {
                        dbSignal signal = new dbSignal();
                        signal.load( reader );
                        signal.ChildSignals = getChildSignals( signal.signalId );
                        signal.Attributes = getSignalAttributes( signal.signalId );
                        signals.Add( signal );
                    }
                    reader.Close();
                    reader.Dispose();
                }
            }
            return signals;
        }