public List <CreateTaskLogInfo> GetList(int publishmentSystemId, int totalNum)
{
var list = new List <CreateTaskLogInfo>();
if (publishmentSystemId > 0)
{
//string sqlString =
// $"SELECT TOP {totalNum} ID, CreateType, PublishmentSystemID, TaskName, TimeSpan, IsSuccess, ErrorMessage, AddDate FROM siteserver_CreateTaskLog WHERE PublishmentSystemID = @PublishmentSystemID";
string sqlString = SqlUtils.GetTopSqlString("siteserver_CreateTaskLog", "ID, CreateType, PublishmentSystemID, TaskName, TimeSpan, IsSuccess, ErrorMessage, AddDate", "WHERE PublishmentSystemID = @PublishmentSystemID", totalNum);
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId)
};
using (var rdr = ExecuteReader(sqlString, parms))
{
while (rdr.Read())
{
var i = 0;
var info = new CreateTaskLogInfo(GetInt(rdr, i++), ECreateTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetBool(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i));
list.Add(info);
}
rdr.Close();
}
}
else
{
//string sqlString =
// $"SELECT TOP {totalNum} ID, CreateType, PublishmentSystemID, TaskName, TimeSpan, IsSuccess, ErrorMessage, AddDate FROM siteserver_CreateTaskLog";
var sqlString = SqlUtils.GetTopSqlString("siteserver_CreateTaskLog", "ID, CreateType, PublishmentSystemID, TaskName, TimeSpan, IsSuccess, ErrorMessage, AddDate", string.Empty, totalNum);
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
var i = 0;
var info = new CreateTaskLogInfo(GetInt(rdr, i++), ECreateTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetBool(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i));
list.Add(info);
}
rdr.Close();
}
}
return(list);
}
public void Insert(CreateTaskLogInfo log)
{
DeleteExcess90Days();
var sqlString = "INSERT INTO siteserver_CreateTaskLog(CreateType, PublishmentSystemID, TaskName, TimeSpan, IsSuccess, ErrorMessage, AddDate) VALUES (@CreateType, @PublishmentSystemID, @TaskName, @TimeSpan, @IsSuccess, @ErrorMessage, @AddDate)";
var parms = new IDataParameter[]
{
GetParameter(ParmCreateType, EDataType.NVarChar, 50, ECreateTypeUtils.GetValue(log.CreateType)),
GetParameter(ParmPublishmentSystemId, EDataType.Integer, log.PublishmentSystemID),
GetParameter(ParmTaskName, EDataType.NVarChar, 50, log.TaskName),
GetParameter(ParmTimeSpan, EDataType.NVarChar, 50, log.TimeSpan),
GetParameter(ParmIsSuccess, EDataType.VarChar, 18, log.IsSuccess.ToString()),
GetParameter(ParmErrorMessage, EDataType.NVarChar, 255, log.ErrorMessage),
GetParameter(ParmAddDate, EDataType.DateTime, log.AddDate)
};
ExecuteNonQuery(sqlString, parms);
}
