public Remove ( string Name, string Channel, int hour, int minute ) : string | ||
Name | string | |
Channel | string | |
hour | int | |
minute | int | |
리턴 | string |
private void CalendarTimeRemove() { var time = DateTime.Now; var db = SchumixBase.DManager.Query("SELECT Id, Name, Channel, Message, Loops, Year, Month, Day, Hour, Minute FROM calendar WHERE ServerName = '{0}'", _servername); if (!db.IsNull()) { foreach (DataRow row in db.Rows) { if (row["Loops"].ToBoolean()) { string name0 = row["Name"].ToString(); string channel0 = row["Channel"].ToString(); string message0 = row["Message"].ToString(); int hour = row["Hour"].ToInt32(); if (time.Hour > hour) { continue; } else if (time.Hour < hour) { continue; } else { if (time.Hour == hour) { int minute = row["Minute"].ToInt32(); if (time.Minute > minute) { continue; } else if (time.Minute < minute) { continue; } else { if (time.Minute == minute) { sCalendarFunctions.Write(name0, channel0, message0); } } } } continue; } int id = row["Id"].ToInt32(); string name = row["Name"].ToString(); string channel = row["Channel"].ToString(); string message = row["Message"].ToString(); int year = row["Year"].ToInt32(); if (time.Year > year) { sCalendarFunctions.Remove(id); } else if (time.Year < year) { continue; } else if (time.Year == year) { int month = row["Month"].ToInt32(); if (time.Month > month) { sCalendarFunctions.Remove(id); } else if (time.Month < month) { continue; } else { int day = row["Day"].ToInt32(); if (time.Month == month) { if (time.Day > day) { sCalendarFunctions.Remove(id); } else if (time.Day < day) { continue; } else { if (time.Day == day) { int hour = row["Hour"].ToInt32(); if (time.Hour > hour) { sCalendarFunctions.Remove(id); } else if (time.Hour < hour) { continue; } else { if (time.Hour == hour) { int minute = row["Minute"].ToInt32(); if (time.Minute > minute) { sCalendarFunctions.Remove(id); } else if (time.Minute < minute) { continue; } else { if (time.Minute == minute) { sCalendarFunctions.Write(name, channel, message); } } } } } } } } } } } }