private void btnAddSchedule_Click(object sender, EventArgs e)
{
string job = SelectJobForm.Run();
if (job != null)
{
m_conn.ExecuteNonQuery(String.Format("insert into Job (JobFile, CreatedAt) values ('{0}', '{1}')", job.Replace("'", "''"), DateTime.Now.ToString("s")));
CheckServiceRunning();
ReloadData();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
m_conn.ExecuteNonQuery(String.Format(
"update Job set Minutes='{0}', Hours='{1}', DaysOfWeek='{2}', DaysOfMonth='{3}', Months='{4}' where id={5}",
tbxMinute.Text, tbxHour.Text, tbxDayOfWeek.Text, tbxDayOfMonth.Text, tbxMonth.Text, m_id));
}
internal void OnFinish()
{
Connection.ExecuteNonQuery(String.Format("update JobExecute set FinishedAt='{0}' where ID='{1}'",
DateTime.Now.ToString("s"), JobExeID));
}