public bool EditDeviceAlert(Device dev, CarrierAlertE type) { string sql = string.Format("UPDATE `device` SET a_alert_track = {0} ,", dev.a_alert_track); switch (type) { case CarrierAlertE.PowerOff: sql += string.Format("`a_poweroff` = {0} ", dev.a_poweroff); break; case CarrierAlertE.GiveMissTrack: sql += string.Format("`a_givemisstrack` = {0}", dev.a_givemisstrack); break; case CarrierAlertE.TakeMissTrack: sql += string.Format("`a_takemisstrack` = {0}", dev.a_takemisstrack); break; default: sql += "1=1"; break; } sql += string.Format(" WHERE `id` = {0}", dev.id); int row = mSql.ExcuteSql(sql); return(row >= 1); }
public void SetCarrierAlert(uint carrierid, uint trackid, CarrierAlertE type, bool isalert) { if (Monitor.TryEnter(_obj, TimeSpan.FromSeconds(10))) { try { CarrierTask task = DevList.Find(c => c.ID == carrierid); if (task != null) { task.SetAlert(type, trackid, isalert); } } finally { Monitor.Exit(_obj); } } }