public bool SaveWishRecord(int wishWeek, KuaFuRoleMiniData from, int wishType, string wishTxt, int toDbCoupleId, KuaFuRoleMiniData toMan, KuaFuRoleMiniData toWife) { bool result; try { string sql = string.Format("INSERT INTO t_couple_wish_wish_log(`week`,`from_rid`,`from_zoneid`,`from_rname`,`to_couple_id`,`to_man_rid`,`to_man_zoneid`,`to_man_rname`,`to_wife_rid`,`to_wife_zoneid`,`to_wife_rname`,`time`,`wish_txt`,`wish_type`) VALUES({0},{1},{2},'{3}',{4},{5},{6},'{7}',{8},{9},'{10}','{11}','{12}',{13});", new object[] { wishWeek, from.RoleId, from.ZoneId, from.RoleName, toDbCoupleId, toMan.RoleId, toMan.ZoneId, toMan.RoleName, toWife.RoleId, toWife.ZoneId, toWife.RoleName, TimeUtil.NowDateTime().ToString("yyyy-MM-dd HH:mm:ss"), wishTxt, wishType }); DbHelperMySQL.ExecuteSql(sql); result = true; } catch (Exception ex) { LogManager.WriteException(ex.Message); result = false; } return(result); }
/// <summary> /// 增加缓存的祝福记录 /// </summary> /// <param name="from"></param> /// <param name="wishType"></param> /// <param name="wishTxt"></param> /// <param name="toMan"></param> /// <param name="toWife"></param> private void AddCachedWishOther(KuaFuRoleMiniData from, int wishType, string wishTxt, KuaFuRoleMiniData toMan, KuaFuRoleMiniData toWife) { lock (Mutex) { Queue <CoupleWishWishRecordData> fromRecords = null; if (RoleWishRecords.TryGetValue(from.RoleId, out fromRecords)) { var rec = new CoupleWishWishRecordData(); rec.FromRole = from; rec.TargetRoles = new List <KuaFuRoleMiniData>(); if (toMan.RoleId != from.RoleId) { rec.TargetRoles.Add(toMan); } if (toWife.RoleId != from.RoleId) { rec.TargetRoles.Add(toWife); } rec.WishType = wishType; rec.WishTxt = wishTxt; fromRecords.Enqueue(rec); while (fromRecords.Count > CoupleWishConsts.MaxWishRecordNum) { fromRecords.Dequeue(); } } } }
/// <summary> /// 增加缓存的被祝福记录 /// </summary> /// <param name="from"></param> /// <param name="wishType"></param> /// <param name="wishTxt"></param> /// <param name="toMan"></param> /// <param name="toWife"></param> private void AddCachedBeWished(KuaFuRoleMiniData to, KuaFuRoleMiniData toSpouse, int wishType, string wishTxt, KuaFuRoleMiniData from) { lock (Mutex) { if (to.RoleId == from.RoleId) { return; } Queue <CoupleWishWishRecordData> toRecords = null; if (RoleWishRecords.TryGetValue(to.RoleId, out toRecords)) { var rec = new CoupleWishWishRecordData(); rec.FromRole = from; rec.TargetRoles = new List <KuaFuRoleMiniData>(); rec.TargetRoles.Add(to); if (toSpouse.RoleId != from.RoleId) { rec.TargetRoles.Add(toSpouse); } rec.WishType = wishType; rec.WishTxt = wishTxt; toRecords.Enqueue(rec); while (toRecords.Count > CoupleWishConsts.MaxWishRecordNum) { toRecords.Dequeue(); } } } }
public void AddWishRecord(KuaFuRoleMiniData from, int wishType, string wishTxt, int toDbCoupleId, KuaFuRoleMiniData toMan, KuaFuRoleMiniData toWife) { lock (this.Mutex) { if (this.Persistence.SaveWishRecord(this.ThisWeek, from, wishType, wishTxt, toDbCoupleId, toMan, toWife)) { this.AddCachedWishOther(from, wishType, wishTxt, toMan, toWife); this.AddCachedBeWished(toMan, toWife, wishType, wishTxt, from); this.AddCachedBeWished(toWife, toMan, wishType, wishTxt, from); } } }