/// <summary>
/// 创建新的 AchievementTrendTable 对象。
/// </summary>
/// <param name="id">Id 属性的初始值。</param>
/// <param name="userId">UserId 属性的初始值。</param>
/// <param name="achievement">Achievement 属性的初始值。</param>
/// <param name="time">Time 属性的初始值。</param>
public static AchievementTrendTable CreateAchievementTrendTable(global::System.Int32 id, global::System.Int32 userId, global::System.String achievement, global::System.String time)
{
AchievementTrendTable achievementTrendTable = new AchievementTrendTable();
achievementTrendTable.Id = id;
achievementTrendTable.UserId = userId;
achievementTrendTable.Achievement = achievement;
achievementTrendTable.Time = time;
return achievementTrendTable;
}
private void dealWithAchievement(UserTable user)
{
// List<int> list_FriendId = db.FriendTables.Where(c => c.UserId == userId).Select(c => c.FriendId).ToList<int>();
// list_FriendId.Add(userId);
//foreach (int j in list_FriendId) Console.WriteLine(j);
int[] Num=new int[10];
//foreach (int friendId in list_FriendId)
// {
// {
// // if (user.Id == friendId)
// {
if (user.NowRank<=8 && user.LastRank > 8)
{
AchievementTrendTable achievementTable = new AchievementTrendTable()
{
Achievement="rise to NO."+user.NowRank,
Time=DateTime.Now.ToShortDateString(),
UserId=user.Id
};
db.AchievementTrendTables.AddObject(achievementTable);
}
if (user.NowRank == 1 && user.LastRank != 1)
{
foreach (ItemTable item in db.ItemTables.Where(c=>c.UserId==user.Id))
{
Num[item.CategoryId]+=item.Amount;
}
int max=0;
int categotyId=0;
for(int j=1;j<=6;j++)
{
if(Num[j]>max)
{
max=Num[j];
categotyId=j;
}
}
string categoryName=db.CategoryTables.SingleOrDefault(c=>c.Id==categotyId).Name;
AchievementTrendTable achievementTable = new AchievementTrendTable()
{
Achievement = categoryName,
Time = DateTime.Now.ToShortDateString(),
UserId = user.Id
};
db.AchievementTrendTables.AddObject(achievementTable);
}
db.SaveChanges();
}
/// <summary>
/// 用于向 AchievementTrendTables EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddToAchievementTrendTables(AchievementTrendTable achievementTrendTable)
{
base.AddObject("AchievementTrendTables", achievementTrendTable);
}
