// 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); }
}