public static int AddSubmitDiaryTask(ZentaoDiaryTask diaryTask)
{
string sqlcmd = string.Format(
"insert into t_zentaodiary(username, password, department, worktype, project, startdate, workhours, content, frequency, updatetime) values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}');",
diaryTask.UserName, diaryTask.Password, diaryTask.Department, diaryTask.WorkType, diaryTask.Project, diaryTask.StartDate, diaryTask.WorkHours, diaryTask.Content, diaryTask.Frequency, DateTime.Now);
int id = MariaDBHelper.ExecuteNonQuery(
sqlcmd,
CommandType.Text);
return(id);
}
public void SubmitDiary()
{
ZentaoDiaryTask DiaryTask = new ZentaoDiaryTask();
MariaDBHelper.ExecuteReader(
"select username, password, department, worktype, project, startdate, workhours, content, frequency, updatetime from t_zentaodiary;" +
"update t_zentaodiary set updatetime='" + DateTime.Now.ToString() + "';",
CommandType.Text,
(MySqlDataReader dataReader) =>
{
while (dataReader.Read())
{
DiaryTask = new ZentaoDiaryTask
{
UserName = MariaDBHelper.GetData(dataReader, "username"),
Password = MariaDBHelper.GetData(dataReader, "password"),
Department = MariaDBHelper.GetData(dataReader, "department"),
WorkType = MariaDBHelper.GetData(dataReader, "worktype"),
Project = MariaDBHelper.GetData(dataReader, "project"),
StartDate = DateTime.Now.Date,
WorkHours = Convert.ToInt32(MariaDBHelper.GetData(dataReader, "workhours")),
Content = MariaDBHelper.GetData(dataReader, "content"),
Frequency = MariaDBHelper.GetData(dataReader, "frequency"),
UpdateTime = Convert.ToDateTime(MariaDBHelper.GetData(dataReader, "updatetime"))
};
}
if (DiaryTask.UpdateTime.Date < DateTime.Now.Date && !string.IsNullOrEmpty(DiaryTask.UserName))
{
if (DateTime.Now.Date.DayOfWeek != DayOfWeek.Sunday && DateTime.Now.Date.DayOfWeek != DayOfWeek.Saturday)
{
Zentao.SubmitDiary(DiaryTask, "zh-cn");
}
}
}
);
return;
}
