public IList<Signal> SelectAll()
{
var returns = new List<Signal>();
var dt = SqlDbAccess.GetInstance().GetTable("select * from SZ01_TUnitIOC ");
foreach (DataRow dr in dt.Rows)
{
var g = new Signal();
g.FromDataRow(dr, "SZ01");
returns.Add(g);
}
return returns;
}
public IList<Signal> SelectAll(String hostCode, String siteIdx)
{
var returns = new List<Signal>();
var dt = SqlDbAccess.GetInstance().GetTable("select * from " + hostCode + "_TUnitIOC WHERE DACIdx = " + siteIdx);
foreach (DataRow dr in dt.Rows)
{
var g = new Signal();
g.FromDataRow(dr, hostCode);
returns.Add(g);
}
return returns;
}
public Signal Select(String hostCode, int idx)
{
var returns = new Signal();
var dt = SqlDbAccess.GetInstance().GetTable("select * from " + hostCode + "_TUnitIOC WHERE Idx = " + idx);
foreach (DataRow dr in dt.Rows)
{
returns.FromDataRow(dr, hostCode);
}
return returns;
}
