public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(string siteid, string parameter) { var tbl = new AlarmDataSet.alarm_phone_queueDataTable(); string sql = "select * from alarm_phone_queue "; sql += " where siteid = '" + siteid + "' and parameter = '" + parameter + "' "; sql += " and status in ('new', 'unconfirmed')"; m_server.FillTable(tbl, sql); return(tbl); }
/// <summary> /// Gets list of active alarms. /// </summary> /// <param name="siteid"></param> /// <param name="parameter"></param> /// <returns></returns> public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(int alarm_definition_id) { var tbl = new AlarmDataSet.alarm_phone_queueDataTable(); string sql = "select * from alarm_phone_queue "; sql += " where alarm_definition_id = " + alarm_definition_id; sql += " and active=" + m_server.PortableWhereBool(true); m_server.FillTable(tbl, sql); return(tbl); }
public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(bool everything = false) { var tbl = new AlarmDataSet.alarm_phone_queueDataTable(); string sql = "select * from alarm_phone_queue "; if (!everything) { sql += " where status in ('new', 'unconfirmed')"; } m_server.FillTable(tbl, sql); return(tbl); }
public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(bool everything = false) { var tbl = new AlarmDataSet.alarm_phone_queueDataTable(); string sql = "select * from alarm_phone_queue "; if (!everything) { sql += " where active=" + m_server.PortableWhereBool(true); } m_server.FillTable(tbl, sql); return(tbl); }
public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(string siteid, string parameter) { var tbl = new AlarmDataSet.alarm_phone_queueDataTable(); string sql = "select * from alarm_phone_queue "; sql += " where siteid = '" + siteid + "' and parameter = '" + parameter + "' "; sql += " and status in ('new', 'unconfirmed')"; m_server.FillTable(tbl, sql); return tbl; }
public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(bool everything = false) { var tbl = new AlarmDataSet.alarm_phone_queueDataTable(); string sql = "select * from alarm_phone_queue "; if (!everything) { sql += " where status in ('new', 'unconfirmed')"; } m_server.FillTable(tbl, sql); return tbl; }