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