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