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> /// 用于向 UserTables EntitySet 添加新对象的方法,已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。 /// </summary> public void AddToUserTables(UserTable userTable) { base.AddObject("UserTables", userTable); }
public string Register(RegisterUser user) { Console.WriteLine(user.UserName + "Register"); if (user.UserType == 0) { UserTable userTable = new UserTable() { UserName = user.UserName, Address = user.Address, City = getCity(user.Address), Latitude = user.Latitude, Longitude = user.Longitude, Password = user.Passwrod, Point = 10, Avatar = user.ImageFileData, LastRank = 200, CityLastRank=100, NowRank=200, NowCityRank=100, UserRank=100, CityRank=100 }; db.UserTables.AddObject(userTable); db.SaveChanges(); UserTable userTable1 = db.UserTables.SingleOrDefault(c => c.UserName == userTable.UserName && c.Password == userTable.Password); foreach (UserTable item in db.UserTables.Where(c=>c.City==userTable1.City)) { FriendTable Friend = new FriendTable() { UserId = userTable1.Id, FriendId=item.Id }; if (Friend.UserId != Friend.FriendId) { db.FriendTables.AddObject(Friend); // db.SaveChanges(); } FriendTable Friend1 = new FriendTable() { UserId = item.Id, FriendId = userTable1.Id }; if (Friend1.UserId != Friend1.FriendId) { db.FriendTables.AddObject(Friend1); // db.SaveChanges(); } } } if (user.UserType == 1) { AcquirerTable acquirer = new AcquirerTable() { UserName = user.UserName, Address = user.Address, City = getCity(user.Address), Latitude = user.Latitude, Longitude = user. Longitude, PassWord = user.Passwrod, Phone=user.Phone, BinName=user.StoreBinName, Avatar = user.ImageFileData, }; db.AcquirerTables.AddObject(acquirer); } if (user.UserType == 2) { MerChantTable merchant = new MerChantTable() { UserName = user.UserName, Address = user.Address, Latitude = user.Latitude, Longitude = user.Longitude, PassWord = user.Passwrod, Phone = user.Phone, StoreName = user.StoreBinName, Avatar = user.ImageFileData, }; db.MerChantTables.AddObject(merchant); } if (!db.CityTables.Select(c => c.Name).Contains(getCity(user.Address))) { CityTable city = new CityTable() { Name = user.City, LastRank = 100, Point = 10 }; db.CityTables.AddObject(city); } db.SaveChanges(); return "Register Success"; }
/// <summary> /// 创建新的 UserTable 对象。 /// </summary> /// <param name="id">Id 属性的初始值。</param> /// <param name="userName">UserName 属性的初始值。</param> /// <param name="latitude">Latitude 属性的初始值。</param> /// <param name="longitude">Longitude 属性的初始值。</param> /// <param name="point">Point 属性的初始值。</param> /// <param name="cityLastRank">CityLastRank 属性的初始值。</param> /// <param name="nowCityRank">NowCityRank 属性的初始值。</param> /// <param name="nowRank">NowRank 属性的初始值。</param> /// <param name="lastRank">LastRank 属性的初始值。</param> /// <param name="avatar">Avatar 属性的初始值。</param> /// <param name="address">Address 属性的初始值。</param> /// <param name="city">City 属性的初始值。</param> /// <param name="password">Password 属性的初始值。</param> public static UserTable CreateUserTable(global::System.Int32 id, global::System.String userName, global::System.Decimal latitude, global::System.Decimal longitude, global::System.Int32 point, global::System.Int32 cityLastRank, global::System.Int32 nowCityRank, global::System.Int32 nowRank, global::System.Int32 lastRank, global::System.Byte[] avatar, global::System.String address, global::System.String city, global::System.String password) { UserTable userTable = new UserTable(); userTable.Id = id; userTable.UserName = userName; userTable.Latitude = latitude; userTable.Longitude = longitude; userTable.Point = point; userTable.CityLastRank = cityLastRank; userTable.NowCityRank = nowCityRank; userTable.NowRank = nowRank; userTable.LastRank = lastRank; userTable.Avatar = avatar; userTable.Address = address; userTable.City = city; userTable.Password = password; return userTable; }