// 更新 TeamBulletin 資料
private bool UpdateTeamBulletin()
{
bool ret = false;
try
{
List <TeamBulletin> bulletinList = db.GetSql().Queryable <TeamBulletin>().With(SqlSugar.SqlWith.RowLock).ToList();
SaveLog($"[Info] Update Team Bulletin , Total Count: {bulletinList.Count}");
for (int idx = 0; idx < bulletinList.Count; idx++)
{
TeamBulletin info = bulletinList[idx];
redis.GetRedis((int)Connect.RedisDB.emRedisDB_Team).HashSet($"TeamBulletin_" + info.BulletinID, hashTransfer.TransToHashEntryArray(info));
redis.GetRedis((int)Connect.RedisDB.emRedisDB_Team).HashSet($"BulletinIdList_" + info.TeamID, info.BulletinID, info.BulletinID);
SaveLog($"[Info] Update Team Bulletin , Bulletin: {info.BulletinID}");
}
ret = true;
}
catch (Exception ex)
{
SaveLog($"[Error] Update Team Bulletin Catch Error, Msg:{ex.Message}");
}
return(ret);
}
// 檢查 TeamBulletin 資料
private bool CheckTeamBulletin()
{
bool ret = false;
try
{
List <TeamBulletin> bulletinList = db.GetSql().Queryable <TeamBulletin>().With(SqlSugar.SqlWith.RowLock).ToList();
SaveLog($"[Info] Check Team Bulletin , Total Count: {bulletinList.Count}");
for (int idx = 0; idx < bulletinList.Count; idx++)
{
TeamBulletin info = bulletinList[idx];
DateTime createDate = DateTime.Parse(info.CreateDate);
DateTime curDate = DateTime.UtcNow;
DateTime limitDate = createDate.AddDays(info.Day);
// 超過時間
if (curDate > limitDate)
{
// 刪除DB的資料
if (db.GetSql().Deleteable <TeamBulletin>().With(SqlSugar.SqlWith.TabLockX).Where(it => it.BulletinID == info.BulletinID).ExecuteCommand() > 0)
{
// 刪除Redis中的資料
if (redis.GetRedis((int)Connect.RedisDB.emRedisDB_Team).KeyExists($"TeamBulletin_" + info.BulletinID))
{
redis.GetRedis((int)Connect.RedisDB.emRedisDB_Team).KeyDelete($"TeamBulletin_" + info.BulletinID);
redis.GetRedis((int)Connect.RedisDB.emRedisDB_Team).HashDelete($"BulletinIdList_" + info.TeamID, info.BulletinID);
SaveLog($"[Info] Check Team Bulletin , Delete Bulletin: {info.BulletinID}");
}
else
{
SaveLog($"[Error] Check Team Bulletin , Delete Bulletin: {info.BulletinID} Fail, Can Not Find Redis Data");
}
}
else
{
SaveLog($"[Error] Check Team Bulletin , Delete Bulletin: {info.BulletinID} From DB Fail");
}
}
}
ret = true;
}
catch (Exception ex)
{
SaveLog($"[Error] Check Team Bulletin Catch Error, Msg:{ex.Message}");
}
return(ret);
}
