// 更新 UserAccount 資料
private bool UpdateUserAccount()
{
bool ret = false;
try
{
List <UserAccount> accountList = db.GetSql().Queryable <UserAccount>().With(SqlSugar.SqlWith.RowLock).ToList();
SaveLog($"[Info] Update User Account , Total Count: {accountList.Count}");
for (int idx = 0; idx < accountList.Count; idx++)
{
UserAccount info = accountList[idx];
redis.GetRedis((int)Connect.RedisDB.emRedisDB_User).HashSet($"UserAccount_" + info.Email, hashTransfer.TransToHashEntryArray(info));
SaveLog($"[Info] Update User Account , User: {info.Email}");
}
ret = true;
}
catch (Exception ex)
{
SaveLog($"[Error] Update User Account Catch Error, Msg:{ex.Message}");
}
return(ret);
}
// 更新 RideData 資料
private bool UpdateRideData()
{
bool ret = false;
try
{
List <RideData> rideList = db.GetSql().Queryable <RideData>().With(SqlSugar.SqlWith.RowLock).ToList();
SaveLog($"[Info] Update Ride Data , Total Count: {rideList.Count}");
for (int idx = 0; idx < rideList.Count; idx++)
{
RideData info = rideList[idx];
redis.GetRedis((int)Connect.RedisDB.emRedisDB_Ride).HashSet($"RideData_" + info.MemberID, hashTransfer.TransToHashEntryArray(info));
SaveLog($"[Info] Update Ride Data, User: {info.MemberID}");
}
ret = true;
}
catch (Exception ex)
{
SaveLog($"[Error] Update Ride Data 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);
}