// 更新 RideRecord 資料
private bool UpdateRideRecord()
{
bool ret = false;
try
{
List <RideRecord> recordList = db.GetSql().Queryable <RideRecord>().With(SqlSugar.SqlWith.RowLock).ToList();
SaveLog($"[Info] Update Ride Record, Total Count: {recordList.Count}");
for (int idx = 0; idx < recordList.Count; idx++)
{
RideRecord info = recordList[idx];
redis.GetRedis((int)Connect.RedisDB.emRedisDB_Ride).HashSet($"RideRecord_" + info.RideID, hashTransfer.TransToHashEntryArray(info));
SaveLog($"[Info] Update Ride Record, User: {info.MemberID}");
}
ret = true;
}
catch (Exception ex)
{
SaveLog($"[Error] Update Ride Info Record Error, Msg:{ex.Message}");
}
return(ret);
}
// 更新 RideIdList 資料
private bool UpdateRideIdList()
{
bool ret = false;
try
{
List <UserInfo> userList = db.GetSql().Queryable <UserInfo>().With(SqlSugar.SqlWith.RowLock).ToList();
SaveLog($"[Info] Update Ride ID List, Total User Count: {userList.Count}");
for (int idx = 0; idx < userList.Count; idx++)
{
UserInfo user = userList[idx];
List <RideRecord> recordList = db.GetSql().Queryable <RideRecord>().With(SqlSugar.SqlWith.RowLock).Where(it => it.MemberID == user.MemberID).ToList();
SaveLog($"[Info] Update Ride ID List, User: {user.MemberID} , Total Ride Record Count: {recordList.Count}");
for (int subIdx = 0; subIdx < recordList.Count; subIdx++)
{
RideRecord record = recordList[subIdx];
redis.GetRedis((int)Connect.RedisDB.emRedisDB_Ride).HashSet($"RideIdList_" + user.MemberID, record.RideID, record.RideID);
}
}
ret = true;
}
catch (Exception ex)
{
SaveLog($"[Error] Update Ride ID List Catch Error, Msg:{ex.Message}");
}
return(ret);
}
/// <summary>
/// 更新或插入一筆騎乘紀錄
/// </summary>
/// <param name="record"></param>
/// <returns></returns>
public static async ETTask UpsertRideRecord(RideRecord record)
{
await dbProxy.Save(record);
}
private static async void SaveRideRoadInfos(RideRecord rideRecord)
{
await UserDataHelper.UpsertRideRecord(rideRecord);
}
