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); }