public List <ActivityDyUserEntity> GetManagerIdDyStrength(string zoneId = "") { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("B_Statistic_ActivityDouyuStrength"); database.AddInParameter(commandWrapper, "@Zone", DbType.String, zoneId); using (IDataReader reader = database.ExecuteReader(commandWrapper)) { List <ActivityDyUserEntity> list = new List <ActivityDyUserEntity>(); while (reader.Read()) { var entity = new ActivityDyUserEntity(); entity.ZoneName = (System.String)reader["ZoneName"]; entity.ZoneId = (System.String)reader["ZoneId"]; entity.Account = (System.String)reader["Account"]; entity.ManagerId = (Guid)reader["ManagerId"]; entity.ExcitingId = Convert.ToInt32(reader["ExcitingId"]); entity.Curdata = Convert.ToInt32(reader["Curdata"]); entity.Status = Convert.ToInt32(reader["Status"]); list.Add(entity); } return(list); } }
//void UpdateActivitystatisticsDouyuEntity(ActivityDyUserEntity user, // ActivitystatisticsDouyuEntity adEntity) //{ // if (adEntity == null) // { // adEntity = new ActivitystatisticsDouyuEntity(); // adEntity.ManagerId = user.ManagerId; // adEntity.ZoneName = user.ZoneName; // adEntity.ZoneId = user.ZoneId; // adEntity.Account = user.Account; // adEntity.ExctingId = user.ExcitingId; // adEntity.CurData = user.Curdata; // adEntity.Status = user.Status; // adEntity.Strength7 = user.Strength7; // adEntity.Strength9 = user.Strength9; // adEntity.UpdateTime = DateTime.Now; // adEntity.RowTime = DateTime.Now; // ActivitystatisticsDouyuMgr.Insert(adEntity); // } // else // { // adEntity.CurData = user.Curdata; // adEntity.Status = user.Status; // adEntity.Strength7 = user.Strength7; // adEntity.Strength9 = user.Strength9; // adEntity.UpdateTime = DateTime.Now; // ActivitystatisticsDouyuMgr.Update(adEntity); // } //} void CreateActivityDyUserStrength(string zoneId, ActivityDyUserEntity entity) { var mod = ShareUtil.GetTableMod(entity.ManagerId); var list = TeammemberMgr.GetByManager(entity.ManagerId, mod, zoneId); if (list.Count > 0) { foreach (var teammemberEntity in list) { var playercardEntity = SerializationHelper.FromByte <PlayerCardUsedEntity>(teammemberEntity.UsedPlayerCard); if (playercardEntity != null) { if (playercardEntity.Property.Strength >= 7) { entity.Strength7++; if (playercardEntity.Property.Strength == 9) { entity.Strength9++; } } } } } var package = ItemCore.Instance.GetPackageWithoutShadow(entity.ManagerId, zoneId); var items = package.GetItemsByType((int)EnumItemType.PlayerCard); foreach (var item in items) { int strength = item.GetStrength(); if (strength >= 7) { entity.Strength7++; if (strength == 9) { entity.Strength9++; } } } }