// time refresh. public void nextAlarmReadyRefresh() { try { isAlarmExist = false; sql = QueryList.nextAlarmImport(DateTime.Now.ToString("yyyy"), DateTime.Now.ToString("MM"), DateTime.Now.ToString("dd")); dbconnect.Open(); dbcommand = new SQLiteCommand(sql, dbconnect); reader = dbcommand.ExecuteReader(); while (reader.Read()) { alarm = new DateTime(); if ((bool)reader["active"] == true) { alarm = alarm.AddYears((int)reader["year"] - 1). AddMonths((int)reader["month"] - 1). AddDays((int)reader["day"] - 1). AddHours((int)reader["sethour"]). AddMinutes((int)reader["setminute"]); if (alarm < DateTime.Now) { continue; } isAlarmExist = true; alarm_text = reader["text"].ToString(); break; } } if (!isAlarmExist) { alarm = new DateTime(); alarm = alarm.AddYears(9997); alarm_text = "alarm disable."; } reader.Close(); dbconnect.Close(); todayAlarmChecked(); } catch (Exception exc) { MessageBox.Show(exc.Message); } }