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();
}
}
