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++;
}
}
}
}
