Пример #1
0
 public IList<Affair> SelectAll(String hostCode, List<Int32> affairTags)
 {
     var returns = new List<Affair>();
     var dt = SqlDbAccess.GetInstance().GetTable("select * from " + hostCode + "_TPointAlarm where TagID in (" + String.Join(",", affairTags) + ")");
     foreach (DataRow dr in dt.Rows)
     {
         var g = new Affair();
         g.FromDataRow(dr, hostCode);
         returns.Add(g);
     }
     return returns;
 }
Пример #2
0
 public IList<Affair> SelectAll(String hostCode)
 {
     var returns = new List<Affair>();
     var dt = SqlDbAccess.GetInstance().GetTable("select * from " + hostCode + "_TPointAlarm ");
     foreach (DataRow dr in dt.Rows)
     {
         var g = new Affair();
         g.FromDataRow(dr, hostCode);
         returns.Add(g);
     }
     return returns;
 }