public void AddFaction(Faction fan, User user) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { fan.CreateTime = DateTime.Now; dbcontext.Factions.AddObject(fan); dbcontext.SaveChanges(); User us = new Models.User() { UserName = "******", Name = user.Name, Password = "******", RoleID = 1, CreateTime = DateTime.Now, Type = (int)UserType.帮派玩家, FanctionID = fan.FactionID, UserID = user.OUserID, State = 0, }; dbcontext.Users.AddObject(us); dbcontext.SaveChanges(); UserRole urole = new UserRole() { FanctionID = fan.FactionID, OUserID = us.OUserID, RoleID = (int)RoleEnum.帮主, }; dbcontext.UserRoles.AddObject(urole); dbcontext.SaveChanges(); } }
public GetUser GetUserBuyID(int guid) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { return dbcontext.GetUsers.Where(u => u.GetUserID==guid).FirstOrDefault(); } }
public List<GetUser> GetUser(int facID) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { return dbcontext.GetUsers.Where(u => u.FactionID == facID).ToList(); } }
public Weapon GetWeaponByID(int id) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { return dbcontext.Weapons.Where(u => u.WeaponID == id).FirstOrDefault(); } }
public List<User> GetFactionUser(int facID) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { var user = dbcontext.Users.Where(u => u.FanctionID == facID && u.Type==(int)UserType.帮派玩家 && u.UserID!=0); return user.ToList(); } }
public void AddFactionNotice(FactionNotice fan) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { dbcontext.FactionNotices.AddObject(fan); dbcontext.SaveChanges(); } }
public void AddWeapon(Weapon weapon) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { dbcontext.Weapons.AddObject(weapon); dbcontext.SaveChanges(); } }
/// <summary> /// 添加用户积分 /// </summary> public void AddUserScore(UserScore score) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { dbcontext.UserScores.AddObject(score); dbcontext.SaveChanges(); } }
public void RemoveBindingUser(int userID) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { var user = dbcontext.Users.Where(u => u.OUserID == userID).FirstOrDefault(); user.UserID = 0; dbcontext.SaveChanges(); } }
public void DelGetUsers(int getUserID) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { var getuser = dbcontext.GetUsers.Where(u => u.GetUserID == getUserID).FirstOrDefault(); dbcontext.GetUsers.DeleteObject(getuser); dbcontext.SaveChanges(); } }
public void DelWeapon(int id) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { var wep = dbcontext.Weapons.Where(u => u.WeaponID == id).FirstOrDefault(); wep.State = 4; dbcontext.SaveChanges(); } }
public void EditWeapon(int id, Weapon weapon) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { var wep = dbcontext.Weapons.Where(u => u.WeaponID == id).FirstOrDefault(); wep.WeaponName = weapon.WeaponName; wep.Leve = weapon.Leve; wep.Type = weapon.Type; wep.Image = weapon.Image; wep.Description = weapon.Description; dbcontext.SaveChanges(); } }
public void AddMsg(string msg, Faction fan) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { FactionMsg msgobj = new FactionMsg { Msg = msg, FactionID = fan.FactionID, CreateTime = DateTime.Now }; dbcontext.FactionMsgs.AddObject(msgobj); dbcontext.SaveChanges(); } }
public List<Weapon> GetWaponList(int rows, int page, string sord, string sidx, string keyword, out int totalCount) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { IQueryable<Weapon> query = dbcontext.Weapons.Where(u => u.State != 4); if (!String.IsNullOrEmpty(keyword)) query = query.Where(w => w.WeaponName.Contains(keyword)); totalCount = query.Count(); if (sord == "desc") return query.SortingAndPaging<Weapon>(sidx, "DESC", rows, page).ToList(); else return query.SortingAndPaging<Weapon>(sidx, "ESC", rows, page).ToList(); } }
public void BacthAddUser(List<BacthUserItem> users, int facID) { List<User> userlist = new List<User>(); using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { foreach (var u in users) { User us = new Models.User() { UserName = "******", Name = u.UserName, Password = "******", RoleID = 1, CreateTime = DateTime.Now, Type=(int)UserType.帮派玩家, FanctionID=facID, UserID=0, State = 0, }; userlist.Add(us); dbcontext.Users.AddObject(us); } dbcontext.SaveChanges(); foreach (var u in userlist) { UserScore score = new UserScore() { Score = users.Where(j => j.UserName == u.Name).FirstOrDefault().Score, OUserID = u.OUserID, ScoreType = (int)ScoreTypeEnum.初始积分, CreatTime = DateTime.Now, Desciption = "初始积分", FanctionID = facID, CostType = (int)CostTypeEnum.加分 }; dbcontext.UserScores.AddObject(score); UserInfo.Instence.AddFactionMsg(u.Name + "加入帮派,初始积分" + score.Score); } dbcontext.SaveChanges(); } }
public User GetdbUser(User user) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { return dbcontext.Users.Where(u => u.UserName == user.UserName && u.Password == user.Password).FirstOrDefault(); } }
public void DelFactionByID(int id) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { var fan = dbcontext.Factions.Where(u => u.FactionID == id).FirstOrDefault(); fan.State = 4; dbcontext.SaveChanges(); } }
public List<Role> GetRoleList() { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { return dbcontext.Roles.ToList(); } }
public User GetUserByOID(int oid) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { return dbcontext.Users.Where(u => u.OUserID == oid).FirstOrDefault(); } }
public void SetUserRole(int userID, int facID, int role) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { //查找ID var roles = dbcontext.UserRoles.Where(u => u.OUserID == userID && u.FanctionID == facID).FirstOrDefault(); if (roles != null) { roles.RoleID = role; } else { dbcontext.UserRoles.AddObject(new UserRole { FanctionID = facID, RoleID = role, OUserID = userID }); } dbcontext.SaveChanges(); } }
public List<FactionNotice> GetFactionNoticeByCount(Faction fan,int count) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { List<FactionNotice> fand = dbcontext.FactionNotices.Where(u => u.FactionID == fan.FactionID && u.State == (int)StateEnum.正常).OrderByDescending(u=>u.CreatTime).Take(count).ToList(); return fand; } }
public List<FactionMsg> GetFactionMsg(Faction fan) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { List<FactionMsg> fand = dbcontext.FactionMsgs.Where(u => u.FactionID == fan.FactionID).OrderByDescending(u => u.CreateTime).Take(10).ToList(); return fand; } }
public List<FactionView> GetFactionList() { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { return dbcontext.FactionViews.Where(u => u.State != 4).ToList(); } }
public List<UserScorView> GetUserList(int facID) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { var users = dbcontext.Users.Where(u => u.FanctionID==facID && u.Type==(int)UserType.帮派玩家).ToList(); var userids = users.Select(u => u.OUserID); var userrole = dbcontext.UserRoles.Where(u => u.FanctionID == facID).ToList(); var rolelist = dbcontext.Roles.ToList(); List<UserScore> userscore = dbcontext.UserScores.Where(u => u.FanctionID == facID && userids.Contains(u.OUserID)).ToList(); var costgrop = from p in userscore group p by p.OUserID into g select new { g.Key, cost = g.Sum(p => p.Score) }; var totalgroup = from p in userscore where p.CostType == (int)CostTypeEnum.加分 group p by p.OUserID into g select new { g.Key, cost = g.Sum(p => p.Score) }; var usedgroup = from p in userscore where p.CostType == (int)CostTypeEnum.扣分 group p by p.OUserID into g select new { g.Key, cost = g.Sum(p => p.Score) }; List<UserScorView> listdata = new List<UserScorView>(); foreach (var u in users) { var cost = costgrop.Where(j => j.Key == u.OUserID).FirstOrDefault(); var usedcost = usedgroup.Where(j => j.Key == u.OUserID).FirstOrDefault(); var totalcost = totalgroup.Where(j => j.Key == u.OUserID).FirstOrDefault(); var urole = userrole.Where(j => j.OUserID == u.OUserID).FirstOrDefault(); var role = urole == null ? null : rolelist.Where(j => j.RoleID == urole.RoleID).FirstOrDefault(); UserScorView uv = new UserScorView { UserID = u.UserID, OUserID=u.OUserID, Name = u.Name, Score = cost == null ? 0 : cost.cost, UsedScore = usedcost == null ? 0 : usedcost.cost, TotalScore = totalcost == null ? 0 : totalcost.cost, RoleID = urole == null ? -1 : urole.RoleID, RoleName = urole == null ? "" : role.RoleName, Type = u.Type }; listdata.Add(uv); } return listdata; } }
/// <summary> /// 判断用户是否已经领取过用户 /// </summary> public bool CheckUserHasGet(int uid, int facid) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { return dbcontext.Users.Where(u => u.FanctionID == facid && u.UserID == uid && u.Type==(int)UserType.帮派玩家).Count() > 0; } }
public List<Role> GetUserRole(int userID, int facID) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { var roles = dbcontext.UserRoles.Where(u => u.OUserID == userID && u.FanctionID == facID).Select(u => u.RoleID).Distinct(); return dbcontext.Roles.Where(u => roles.Contains(u.RoleID)).ToList(); } }
public FactionNotice GetNotice(int id) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { List<FactionNotice> fand = dbcontext.FactionNotices.Where(u => u.NoticeID==id && u.State == (int)StateEnum.正常).ToList(); return fand.FirstOrDefault(); } }
public void Update(Faction fan) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { Faction fand = dbcontext.Factions.Where(u => u.FactionID == fan.FactionID).FirstOrDefault(); fand.FactionName = fan.FactionName; dbcontext.SaveChanges(); } }
public void DelFactionNotice(int noticeID) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { var notice = dbcontext.FactionNotices.Where(u => u.NoticeID == noticeID).FirstOrDefault(); notice.State = (int)StateEnum.删除; dbcontext.SaveChanges(); } }
public List<UserScore> GetUserScoreList(int rows, int page, string sord, string sidx, int ouserID, int facID, out int totalCount) { using (LdxyDBEntities dbcontext = new LdxyDBEntities()) { IQueryable<UserScore> query = dbcontext.UserScores.Where(u => u.OUserID == ouserID && u.FanctionID == facID); totalCount = query.Count(); if (sord == "desc") return query.SortingAndPaging<UserScore>(sidx, "DESC", rows, page).ToList(); else return query.SortingAndPaging<UserScore>(sidx, "ESC", rows, page).ToList(); } }