/// <summary> /// 注册球星启示录npc /// </summary> private void ReBuildRevelationNpc() { BuildCache(); var allnpcTemp = ConfigRevelationnpctempMgr.GetAll(); SqlHelper.ExecuteNonQuery(_connection, CommandType.Text, "Delete From Dic_Npc Where Type=3;Truncate table Config_RevelationNpcLink"); int index = 0; foreach (var item in allnpcTemp) { index++; DicNpcEntity entity = new DicNpcEntity(); entity.Idx = ShareUtil.GenerateComb(); entity.Type = 3; entity.Name = item.OpponentTeamName; entity.Logo = 1; entity.FormationId = item.FormationID; entity.FormationLevel = item.PlayerLevel; entity.TeammemberLevel = item.PlayerLevel; entity.PlayerCardStrength = item.PlayerCardStrength; entity.CoachId = 0; entity.DoTalent = GetDoTalent(); //主动天赋 entity.ManagerSkill = GetNodoManagerSkill(); //被动天赋和意志 int comb = 0; entity.DoWill = GetDoWill(ref comb); //主动意志 entity.CombLevel = item.PlayerLevel; entity.Buff = item.Buff; entity.TP1 = item.P1; entity.TP2 = item.P2; entity.TP3 = item.P3; entity.TP4 = item.P4; entity.TP5 = item.P5; entity.TP6 = item.P6; entity.TP7 = item.P7; entity.TE1 = 211071; entity.TE2 = 211076; entity.TE3 = 211072; entity.TE4 = 211073; entity.TE5 = 211074; entity.TE6 = 211075; entity.TE7 = 211077; entity.TS1 = "A031_40"; entity.TS2 = "A033_40"; entity.TS3 = "A027_40"; entity.TS4 = "A034_40"; entity.TS5 = "A030_40"; entity.TS6 = "A032_40"; entity.TS7 = "A028_40"; DicNpcMgr.Insert(entity); ConfigRevelationnpclinkMgr.Insert(new ConfigRevelationnpclinkEntity(index, item.MarkId, item.Schedule, entity.Idx)); m_curCount++; ProgressBar1.Value = m_curCount; lblProcess.Content = string.Format("进度:{0}/{1}", m_curCount, m_totalCount); } }
/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/1/18 14:25:07</remarks> public bool Update(DicNpcEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_DicNpc_Update"); database.AddInParameter(commandWrapper, "@Idx", DbType.Guid, entity.Idx); database.AddInParameter(commandWrapper, "@Type", DbType.Int32, entity.Type); database.AddInParameter(commandWrapper, "@Name", DbType.String, entity.Name); database.AddInParameter(commandWrapper, "@Logo", DbType.Int32, entity.Logo); database.AddInParameter(commandWrapper, "@FormationId", DbType.Int32, entity.FormationId); database.AddInParameter(commandWrapper, "@FormationLevel", DbType.Int32, entity.FormationLevel); database.AddInParameter(commandWrapper, "@TeammemberLevel", DbType.Int32, entity.TeammemberLevel); database.AddInParameter(commandWrapper, "@PlayerCardStrength", DbType.Int32, entity.PlayerCardStrength); database.AddInParameter(commandWrapper, "@CoachId", DbType.Int32, entity.CoachId); database.AddInParameter(commandWrapper, "@DoTalent", DbType.AnsiString, entity.DoTalent); database.AddInParameter(commandWrapper, "@DoWill", DbType.AnsiString, entity.DoWill); database.AddInParameter(commandWrapper, "@ManagerSkill", DbType.AnsiString, entity.ManagerSkill); database.AddInParameter(commandWrapper, "@CombLevel", DbType.Int32, entity.CombLevel); database.AddInParameter(commandWrapper, "@Buff", DbType.Int32, entity.Buff); database.AddInParameter(commandWrapper, "@PropertyPoint", DbType.Int32, entity.PropertyPoint); database.AddInParameter(commandWrapper, "@TP1", DbType.Int32, entity.TP1); database.AddInParameter(commandWrapper, "@TE1", DbType.Int32, entity.TE1); database.AddInParameter(commandWrapper, "@TS1", DbType.AnsiString, entity.TS1); database.AddInParameter(commandWrapper, "@TP2", DbType.Int32, entity.TP2); database.AddInParameter(commandWrapper, "@TE2", DbType.Int32, entity.TE2); database.AddInParameter(commandWrapper, "@TS2", DbType.AnsiString, entity.TS2); database.AddInParameter(commandWrapper, "@TP3", DbType.Int32, entity.TP3); database.AddInParameter(commandWrapper, "@TE3", DbType.Int32, entity.TE3); database.AddInParameter(commandWrapper, "@TS3", DbType.AnsiString, entity.TS3); database.AddInParameter(commandWrapper, "@TP4", DbType.Int32, entity.TP4); database.AddInParameter(commandWrapper, "@TE4", DbType.Int32, entity.TE4); database.AddInParameter(commandWrapper, "@TS4", DbType.AnsiString, entity.TS4); database.AddInParameter(commandWrapper, "@TP5", DbType.Int32, entity.TP5); database.AddInParameter(commandWrapper, "@TE5", DbType.Int32, entity.TE5); database.AddInParameter(commandWrapper, "@TS5", DbType.AnsiString, entity.TS5); database.AddInParameter(commandWrapper, "@TP6", DbType.Int32, entity.TP6); database.AddInParameter(commandWrapper, "@TE6", DbType.Int32, entity.TE6); database.AddInParameter(commandWrapper, "@TS6", DbType.AnsiString, entity.TS6); database.AddInParameter(commandWrapper, "@TP7", DbType.Int32, entity.TP7); database.AddInParameter(commandWrapper, "@TE7", DbType.Int32, entity.TE7); database.AddInParameter(commandWrapper, "@TS7", DbType.AnsiString, entity.TS7); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } entity.Idx = (System.Guid)database.GetParameterValue(commandWrapper, "@Idx"); return(Convert.ToBoolean(results)); }
public static Match_FightManagerinfo GetFightinfo(DicNpcEntity npcEntity, DTOBuffMemberView buffView = null, bool isNpc = false) { if (null == buffView) { buffView = NpcDataHelper.GetMemberView(npcEntity); } return(GetFightinfo(npcEntity.Idx, npcEntity.Name, npcEntity.FormationId, npcEntity.Level, npcEntity.Logo.ToString(), npcEntity.CoachId , buffView, "", isNpc)); }
public static ManagerInput BuildTransferNpc(DicNpcEntity npcEntity, DTOBuffMemberView buffView) { var dstData = new ManagerInput(); dstData.Mid = npcEntity.Idx; dstData.Logo = npcEntity.Logo.ToString(); dstData.Name = npcEntity.Name; dstData.FormId = npcEntity.FormationId; dstData.FormLv = npcEntity.FormationLevel; BuildManagerData(dstData, buffView, 0, npcEntity.Buff); return(dstData); }
public Match_FightinfoResponse GetLeagueFightInfo(Guid matchId, Guid managerId) { LeagueEncounterEntity matchInfo = LeagueEncounterMgr.GetById(matchId); DicNpcEntity homeNpc = null; DicNpcEntity awayNpc = null; if (matchInfo.HomeIsNpc) { homeNpc = CacheFactory.NpcdicCache.GetNpc(matchInfo.HomeId); } if (matchInfo.AwayIsNpc) { awayNpc = CacheFactory.NpcdicCache.GetNpc(matchInfo.AwayId); } DTOBuffMemberView homeView, awayView; BuffDataCore.Instance().GetMembers(out homeView, out awayView, "", matchInfo.HomeId, matchInfo.HomeIsNpc, "", matchInfo.AwayId, matchInfo.AwayIsNpc, true, false); Match_FightManagerinfo home, away; if (matchInfo.HomeIsNpc) { home = MatchDataHelper.GetFightinfo(homeNpc, homeView); } else { home = MatchDataHelper.GetFightinfo(matchInfo.HomeId, false, homeView, ""); } if (matchInfo.AwayIsNpc) { away = MatchDataHelper.GetFightinfo(awayNpc, awayView); } else { away = MatchDataHelper.GetFightinfo(matchInfo.AwayId, false, awayView, ""); } if (home == null || away == null) { return(ResponseHelper.Create <Match_FightinfoResponse>(MessageCode.NbParameterError)); } var response = ResponseHelper.CreateSuccess <Match_FightinfoResponse>(); response.Data = new Match_Fightinfo(); response.Data.Home = home; response.Data.Away = away; return(response); }
DicNpcEntity BuildBasicData(int playerLevel, int strengthenLevel, int eqLevel) { //阵型 int formationId = RandomHelper.GetInt32(1, 17); //获取阵型 var formationList = CacheFactory.FormationCache.GetFormationDetail(formationId); DicNpcEntity entity = new DicNpcEntity(); entity.Idx = ShareUtil.GenerateComb(); entity.Type = 2; entity.Name = GetName(); entity.Logo = 1; entity.FormationId = formationId; entity.FormationLevel = playerLevel; entity.TeammemberLevel = playerLevel; entity.PlayerCardStrength = strengthenLevel; entity.CoachId = 0; entity.DoTalent = GetDoTalent(); //主动天赋 entity.ManagerSkill = GetNodoManagerSkill(); //被动天赋和意志 int comb = 0; entity.DoWill = GetDoWill(ref comb);//主动意志 entity.CombLevel = playerLevel; entity.Buff = 100 + playerLevel; entity.TP1 = GetPlayer(1, formationList.Values.ToList()); entity.TP2 = GetPlayer(2, formationList.Values.ToList()); entity.TP3 = GetPlayer(3, formationList.Values.ToList()); entity.TP4 = GetPlayer(4, formationList.Values.ToList()); entity.TP5 = GetPlayer(5, formationList.Values.ToList()); entity.TP6 = GetPlayer(6, formationList.Values.ToList()); entity.TP7 = GetPlayer(7, formationList.Values.ToList()); entity.TE1 = GetEquipment(eqLevel); entity.TE2 = GetEquipment(eqLevel); entity.TE3 = GetEquipment(eqLevel); entity.TE4 = GetEquipment(eqLevel); entity.TE5 = GetEquipment(eqLevel); entity.TE6 = GetEquipment(eqLevel); entity.TE7 = GetEquipment(eqLevel); entity.TS1 = ""; entity.TS2 = ""; entity.TS3 = ""; entity.TS4 = ""; entity.TS5 = ""; entity.TS6 = ""; entity.TS7 = ""; return(entity); }
/// <summary> /// 将IDataReader的当前记录读取到DicNpcEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public DicNpcEntity LoadSingleRow(IDataReader reader) { var obj = new DicNpcEntity(); obj.Idx = (System.Guid)reader["Idx"]; obj.Type = (System.Int32)reader["Type"]; obj.Name = (System.String)reader["Name"]; obj.Logo = (System.Int32)reader["Logo"]; obj.FormationId = (System.Int32)reader["FormationId"]; obj.FormationLevel = (System.Int32)reader["FormationLevel"]; obj.TeammemberLevel = (System.Int32)reader["TeammemberLevel"]; obj.PlayerCardStrength = (System.Int32)reader["PlayerCardStrength"]; obj.CoachId = (System.Int32)reader["CoachId"]; obj.DoTalent = (System.String)reader["DoTalent"]; obj.DoWill = (System.String)reader["DoWill"]; obj.ManagerSkill = (System.String)reader["ManagerSkill"]; obj.CombLevel = (System.Int32)reader["CombLevel"]; obj.Buff = (System.Int32)reader["Buff"]; obj.PropertyPoint = (System.Int32)reader["PropertyPoint"]; obj.TP1 = (System.Int32)reader["TP1"]; obj.TE1 = (System.Int32)reader["TE1"]; obj.TS1 = (System.String)reader["TS1"]; obj.TP2 = (System.Int32)reader["TP2"]; obj.TE2 = (System.Int32)reader["TE2"]; obj.TS2 = (System.String)reader["TS2"]; obj.TP3 = (System.Int32)reader["TP3"]; obj.TE3 = (System.Int32)reader["TE3"]; obj.TS3 = (System.String)reader["TS3"]; obj.TP4 = (System.Int32)reader["TP4"]; obj.TE4 = (System.Int32)reader["TE4"]; obj.TS4 = (System.String)reader["TS4"]; obj.TP5 = (System.Int32)reader["TP5"]; obj.TE5 = (System.Int32)reader["TE5"]; obj.TS5 = (System.String)reader["TS5"]; obj.TP6 = (System.Int32)reader["TP6"]; obj.TE6 = (System.Int32)reader["TE6"]; obj.TS6 = (System.String)reader["TS6"]; obj.TP7 = (System.Int32)reader["TP7"]; obj.TE7 = (System.Int32)reader["TE7"]; obj.TS7 = (System.String)reader["TS7"]; return(obj); }
/// <summary> /// GetById /// </summary> /// <param name="idx">idx</param> /// <returns>DicNpcEntity</returns> /// <remarks>2016/1/18 14:25:07</remarks> public DicNpcEntity GetById(System.Guid idx) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_DicNpc_GetById"); database.AddInParameter(commandWrapper, "@Idx", DbType.Guid, idx); DicNpcEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
public static DTOBuffMemberView GetMemberView(DicNpcEntity npcEntity) { if (npcEntity.Type == 1 || npcEntity.Type == 2 || npcEntity.Type == 3 || npcEntity.Type == 4 || npcEntity.Type == 5 || npcEntity.Type == 6)//球星启示录计算真实kpi { npcEntity.KpiBuff = npcEntity.Buff; npcEntity.Buff = 100;// npcEntity.Buff; } else { npcEntity.KpiBuff = 100; } var data = new DTOBuffMemberView(); //TODO: CombLevel var managerSBMList = new List <string>(); //套装字典 套装id->数量 var suitDic = new Dictionary <int, List <int> >(); //套装id->套装类型 var suitTypeDic = new Dictionary <int, int>(); var formationDetails = CacheFactory.FormationCache.GetFormationDetail(npcEntity.FormationId); int i = 0; var buffPlayers = new Dictionary <Guid, DTOBuffPlayer>(PLAERCOUNT); buffPlayers.Add(Guid.NewGuid(), BuildPlayer(npcEntity, npcEntity.TP1, npcEntity.TE1, npcEntity.TS1, formationDetails[i++].Position, npcEntity.KpiBuff, ref suitDic, ref suitTypeDic)); buffPlayers.Add(Guid.NewGuid(), BuildPlayer(npcEntity, npcEntity.TP2, npcEntity.TE2, npcEntity.TS2, formationDetails[i++].Position, npcEntity.KpiBuff, ref suitDic, ref suitTypeDic)); buffPlayers.Add(Guid.NewGuid(), BuildPlayer(npcEntity, npcEntity.TP3, npcEntity.TE3, npcEntity.TS3, formationDetails[i++].Position, npcEntity.KpiBuff, ref suitDic, ref suitTypeDic)); buffPlayers.Add(Guid.NewGuid(), BuildPlayer(npcEntity, npcEntity.TP4, npcEntity.TE4, npcEntity.TS4, formationDetails[i++].Position, npcEntity.KpiBuff, ref suitDic, ref suitTypeDic)); buffPlayers.Add(Guid.NewGuid(), BuildPlayer(npcEntity, npcEntity.TP5, npcEntity.TE5, npcEntity.TS5, formationDetails[i++].Position, npcEntity.KpiBuff, ref suitDic, ref suitTypeDic)); buffPlayers.Add(Guid.NewGuid(), BuildPlayer(npcEntity, npcEntity.TP6, npcEntity.TE6, npcEntity.TS6, formationDetails[i++].Position, npcEntity.KpiBuff, ref suitDic, ref suitTypeDic)); buffPlayers.Add(Guid.NewGuid(), BuildPlayer(npcEntity, npcEntity.TP7, npcEntity.TE7, npcEntity.TS7, formationDetails[i++].Position, npcEntity.KpiBuff, ref suitDic, ref suitTypeDic)); //套装 TeammemberDataHelper.FillSuitData(suitDic, suitTypeDic, ref managerSBMList); //阵型加成 TeammemberDataHelper.FillFormationData(npcEntity.FormationId, npcEntity.FormationLevel, ref managerSBMList); //TODO:球员组合 BuffDataCore.Instance().FillBuffView(data, buffPlayers, true, 1, npcEntity.FormationId); data.BuffPlayers = buffPlayers; return(data); }
static DTOBuffPlayer BuildPlayer(DicNpcEntity npcEntity, int tp, int te, string ts, int position, int buffScale, ref Dictionary <int, List <int> > suitDic, ref Dictionary <int, int> suitTypeDic) { return(BuildPlayer(npcEntity.TeammemberLevel, npcEntity.PropertyPoint, npcEntity.PlayerCardStrength, tp, te, ts, position, buffScale, ref suitDic, ref suitTypeDic)); }
//public Match_FightinfoResponse GetCrowdFightInfo(Guid matchId, Guid managerId) //{ // var match = MemcachedFactory.CrowdMatchClient.Get<CrowdMatchEntity>(matchId); // if (match == null) // return ResponseHelper.InvalidParameter<Match_FightinfoResponse>(); // if (managerId == match.HomeId) // { // return GetFightInfo(managerId, match.AwayId); // } // else if (managerId == match.AwayId) // { // return GetFightInfo(managerId, match.HomeId); // } // else // { // return ResponseHelper.InvalidParameter<Match_FightinfoResponse>(); // } //} /// <summary> /// 获取竞技场对阵 /// </summary> /// <param name="matchId"></param> /// <returns></returns> public Match_FightinfoResponse GetArenaFightInfo(Guid matchId) { var matchData = MemcachedFactory.ArenaMatchClient.Get <BaseMatchData>(matchId); if (matchData == null) { return(ResponseHelper.Create <Match_FightinfoResponse>(MessageCode.NbParameterError)); } DicNpcEntity homeNpc = null; DicNpcEntity awayNpc = null; ArenaTeammemberFrame homeFrame = null; ArenaTeammemberFrame awayFrame = null; if (matchData.Home.IsNpc) { homeNpc = CacheFactory.NpcdicCache.GetNpc(matchData.Home.ManagerId); } else { homeFrame = new ArenaTeammemberFrame(matchData.Home.ManagerId, (EnumArenaType)matchData.Home.ArenaType, matchData.Home.ZoneName); } if (matchData.Away.IsNpc) { awayNpc = CacheFactory.NpcdicCache.GetNpc(matchData.Away.ManagerId); } else { awayFrame = new ArenaTeammemberFrame(matchData.Away.ManagerId, (EnumArenaType)matchData.Away.ArenaType, matchData.Away.ZoneName); } DTOBuffMemberView homeView, awayView; ArenaBuffDataCore.Instance().GetMembers(out homeView, out awayView, matchData.Home.ZoneName, matchData.Home.ManagerId, matchData.Home.IsNpc, matchData.Away.ZoneName, matchData.Away.ManagerId, homeFrame, awayFrame, matchData.Away.IsNpc, true, false); Match_FightManagerinfo home, away; if (matchData.Home.IsNpc) { home = MatchDataHelper.GetFightinfo(homeNpc, homeView); } else { home = MatchDataHelper.GetFightinfoArena(homeFrame, false, homeView, matchData.Home.ZoneName); } if (matchData.Away.IsNpc) { away = MatchDataHelper.GetFightinfo(awayNpc, awayView); } else { away = MatchDataHelper.GetFightinfoArena(awayFrame, false, awayView, matchData.Away.ZoneName); } if (home == null || away == null) { return(ResponseHelper.Create <Match_FightinfoResponse>(MessageCode.NbParameterError)); } var response = ResponseHelper.CreateSuccess <Match_FightinfoResponse>(); response.Data = new Match_Fightinfo(); response.Data.Home = home; response.Data.Away = away; return(response); }
public static bool Update(DicNpcEntity dicNpcEntity, DbTransaction trans = null, string zoneId = "") { var provider = new DicNpcProvider(zoneId); return(provider.Update(dicNpcEntity, trans)); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2016/1/18 14:25:07</remarks> public bool Update(DicNpcEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/1/18 14:25:07</remarks> public bool Insert(DicNpcEntity entity) { return(Insert(entity, null)); }