public List<EventDuration> GetBlowings(int heatID) { string sql = "select h.eventtime,h.value1,h.type from heat_events h where heat_id =" + heatID.ToString() + " and type in ('BLOS','BLOE') order by eventtime"; OracleDataReader reader = Execute(sql); List<EventDuration> durations = new List<EventDuration>(); EventDuration dur = new EventDuration(); while (reader.Read()) { if (reader[2].ToString() == "BLOS") { dur.StartDate = DateTime.Parse(CheckDateForNull(reader[0].ToString())); } else { dur.EndDate = DateTime.Parse(CheckDateForNull(reader[0].ToString())); dur.Tag = int.Parse(CheckNubmerForNull(reader[1].ToString())); durations.Add(dur); dur = new EventDuration(); } } reader.Close(); return durations; }
public EventDuration GetTapsDuration(int heatID) { string sql = "select eventtime from heat_events where heat_id =" + heatID.ToString() + " and type in ('TAPS','TAPE') order by eventtime"; OracleDataReader reader = Execute(sql); EventDuration duration = new EventDuration(); if (reader.Read()) { duration.StartDate = DateTime.Parse(CheckDateForNull(reader[0].ToString())); } if (reader.Read()) { duration.EndDate = DateTime.Parse(CheckDateForNull(reader[0].ToString())); } reader.Close(); return duration; }