public List <dbSignal> getAllSignals()
{
XmlDocument doc = new XmlDocument();
List <dbSignal> signals = new List <dbSignal>();
String sql = "SELECT * FROM signal_master ORDER BY signal_name";
OleDbParameter[] dbParams = {};
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);
}
public dbSignal getSignal(string signalName, string nameSpace)
{
dbSignal signal = null;
if (signalName != null)
{
String sql = "SELECT * FROM signal_master WHERE signal_name = ?";
List <OleDbParameter> dbParams = new List <OleDbParameter>();
dbParams.Add(CreateParameter("@signal_name", signalName));
if (!string.IsNullOrEmpty(nameSpace))
{
sql += " AND xmlns = ? ";
dbParams.Add(CreateParameter("@xmlns", nameSpace));
}
OleDbDataReader reader = ExecuteSqlQuery(sql, dbParams.ToArray());
if (reader != null)
{
if (reader.Read())
{
signal = new dbSignal();
signal.load(reader);
signal.ChildSignals = getChildSignals(signal.signalId);
signal.Attributes = getSignalAttributes(signal.signalId);
if (signal.parentSignalId != null)
{
signal.ParentSignal = getSignal(signal.parentSignalId);
}
}
reader.Close();
reader.Dispose();
}
}
return(signal);
}
public dbSignal getSignal(int?signalId)
{
dbSignal signal = null;
if (signalId != null)
{
String sql = "SELECT * FROM signal_master WHERE signal_id = ?";
OleDbParameter[] dbParams = { CreateParameter("@signal_id", signalId) };
OleDbDataReader reader = ExecuteSqlQuery(sql, dbParams);
if (reader != null)
{
if (reader.Read())
{
signal = new dbSignal();
signal.load(reader);
signal.ChildSignals = getChildSignals(signal.signalId);
signal.Attributes = getSignalAttributes(signal.signalId);
if (signal.parentSignalId != null)
{
signal.ParentSignal = getSignal(signal.parentSignalId);
}
}
reader.Close();
reader.Dispose();
}
}
return(signal);
}
public List <dbSignal> getChildSignals(int?parentSignalId)
{
List <dbSignal> signals = new List <dbSignal>();
if (parentSignalId != null)
{
String sql = "SELECT * FROM signal_master WHERE parent_signal_id = ?";
OleDbParameter[] dbParams = { CreateParameter("@parent_signal_id", parentSignalId) };
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);
}
public dbSignal GetBaseBSCSignal()
{
dbSignal signal = null;
String sql = "SELECT * FROM signal_master WHERE parent_signal_id = 1 AND xmlns LIKE '%STDBSC'";
List <OleDbParameter> dbParams = new List <OleDbParameter>();
OleDbDataReader reader = ExecuteSqlQuery(sql, dbParams.ToArray());
if (reader != null)
{
if (reader.Read())
{
signal = new dbSignal();
signal.load(reader);
signal.ChildSignals = getChildSignals(signal.signalId);
signal.Attributes = getSignalAttributes(signal.signalId);
}
reader.Close();
reader.Dispose();
}
return(signal);
}
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);
}