/// <summary>
/// ExecuteLogを作成する
/// </summary>
/// <param name="calendarModel"></param>
internal void CreateExecuteLog(ExecuteLogModel execModel)
{
try
{
OnExecute = (SQLiteConnection con, SQLiteTransaction tran) => {
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO EXECUTE_LOG (");
sql.Append("ID,");
sql.Append("CDATE,");
sql.Append("EXECID,");
sql.Append("EXECTYPE,");
sql.Append("EXECNAME,");
sql.Append("STARTTIME,");
sql.Append("ENDTIME,");
sql.Append("EXECTIME,");
sql.Append("DESCRIPTION,");
sql.Append("RESULT");
sql.Append(")VALUES(");
sql.Append("@ID,");
sql.Append("@CDATE,");
sql.Append("@EXECID,");
sql.Append("@EXECTYPE,");
sql.Append("@EXECNAME,");
sql.Append("@STARTTIME,");
sql.Append("@ENDTIME,");
sql.Append("@EXECTIME,");
sql.Append("@DESCRIPTION,");
sql.Append("@RESULT");
sql.Append(")");
using (SQLiteCommand command = new SQLiteCommand(sql.ToString(), con))
{
try
{
command.Parameters.Add(new SQLiteParameter("@ID", execModel.Id));
command.Parameters.Add(new SQLiteParameter("@CDATE", execModel.Cdate));
command.Parameters.Add(new SQLiteParameter("@EXECID", execModel.ExecId));
command.Parameters.Add(new SQLiteParameter("@EXECTYPE", execModel.ExecType));
command.Parameters.Add(new SQLiteParameter("@EXECNAME", execModel.ExecName));
command.Parameters.Add(new SQLiteParameter("@STARTTIME", execModel.StartTime));
command.Parameters.Add(new SQLiteParameter("@ENDTIME", execModel.EndTime));
command.Parameters.Add(new SQLiteParameter("@EXECTIME", execModel.ExecTime));
command.Parameters.Add(new SQLiteParameter("@DESCRIPTION", execModel.Description));
command.Parameters.Add(new SQLiteParameter("@RESULT", execModel.Result));
command.ExecuteNonQuery();
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
}
};
Execute(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 実行ログデータを取得する
/// </summary>
/// <param name="fromDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
internal List <ExecuteLogModel> GetExecuteLog(DateTime fromDate, DateTime endDate)
{
try
{
List <ExecuteLogModel> resultList = new List <ExecuteLogModel>();
OnExecute = (SQLiteConnection con, SQLiteTransaction tran) => {
try
{
StringBuilder sql = new StringBuilder();
sql.Append("SELECT");
sql.Append(" ID,");
sql.Append(" CDATE,");
sql.Append(" EXECID,");
sql.Append(" EXECTYPE,");
sql.Append(" EXECNAME,");
sql.Append(" STARTTIME,");
sql.Append(" ENDTIME,");
sql.Append(" EXECTIME,");
sql.Append(" DESCRIPTION,");
sql.Append(" RESULT");
sql.Append(" FROM EXECUTE_LOG");
sql.Append(" WHERE CDATE BETWEEN @FROMDATE AND @TODATE");
sql.Append(" ORDER BY CDATE");
using (SQLiteCommand command = new SQLiteCommand(sql.ToString(), con))
{
command.Parameters.Add(new SQLiteParameter("@FROMDATE", fromDate.ToString("yyyy/MM/dd 00:00:00")));
command.Parameters.Add(new SQLiteParameter("@TODATE", endDate.ToString("yyyy/MM/dd 23:59:59")));
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ExecuteLogModel data = new ExecuteLogModel();
data.Id = "" + reader.GetValue(0);
data.Cdate = "" + reader.GetValue(1);
data.ExecId = "" + reader.GetValue(2);
data.ExecType = "" + reader.GetValue(3);
data.ExecName = "" + reader.GetValue(4);
data.StartTime = "" + reader.GetValue(5);
data.EndTime = "" + reader.GetValue(6);
data.ExecTime = int.Parse("" + reader.GetValue(7));
data.Description = "" + reader.GetValue(8);
data.Result = int.Parse("" + reader.GetValue(9));
resultList.Add(data);
}
}
}
}
catch (Exception ex)
{
throw Program.ThrowException(ex);
}
};
Execute(false);
return(resultList);
}
catch (Exception ex)
{
throw Program.ThrowException(ex);
}
}
