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

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

            var sql = new StringBuilder();
            sql.Append("SELECT a.* FROM ")
                .Append(SignalMasterBean._TABLE_NAME)
                .Append(" a, ")
                .Append(TestSignalLibraryBean._TABLE_NAME)
                .Append(" b WHERE a.")
                .Append(SignalMasterBean._XMLNS)
                .Append(" = b.")
                .Append(TestSignalLibraryBean._TARGET_NAMESPACE)
                .Append(" ORDER BY ")
                .Append(SignalMasterBean._SIGNAL_NAME);
            OleDbParameter[] dbParams = { CreateParameter("@parent_signal_id", 1) };
            using (OleDbDataReader reader = ExecuteSqlQuery( sql.ToString(), dbParams ))
            {
                if (reader != null)
                {
                    while (reader.Read())
                    {
                        var 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;
        }