public string InviteUser(InviteUserParameterModel para) { string result = ""; MessageModel message = new MessageModel(); JavaScriptSerializer jss = new JavaScriptSerializer(); HashSet <object> returnResult = new HashSet <object>(); using (HiGame_V1Entities context = new HiGame_V1Entities()) { //判断用户是否已经加入战队 var isJoinOther = context.db_TeamUser.Where(c => c.UserID == para.UserID) .FirstOrDefault(); if (isJoinOther != null) { message.MessageCode = MESSAGE.USERJOINOTHERTEAM_CODE; message.Message = MESSAGE.USERJOINOTHERTEAM; } else { //判断是否发出过邀请 int inviteCount = context.db_Message.Where(c => c.SendID == para.TeamID) .Where(c => c.ReceiveID == para.UserID) .Where(c => c.State == 2) .ToList().Count; if (inviteCount > 0) { message.MessageCode = MESSAGE.INVITEUSER_CODE; message.Message = MESSAGE.INVITEUSER; } else { //db_Message表插入一条数据 db_Message mes = new db_Message(); mes.SendID = para.TeamID; mes.ReceiveID = para.UserID; mes.State = 2; mes.MessageType = "招募队员"; mes.SendTime = DateTime.Now; context.db_Message.Add(mes); context.SaveChanges(); message.Message = MESSAGE.OK; message.MessageCode = MESSAGE.OK_CODE; } } } returnResult.Add(message); result = jss.Serialize(returnResult); return(result); }
/// <summary> /// 添加数据 /// </summary> /// <param name="msg"></param> /// <returns></returns> public static int InsertMsg(MessageInfo msg) { db_Message dbmsg = new db_Message { Name = msg.Name, Target = msg.Target, Message = msg.Message, Bmp = msg.Bmp, Time = msg.Time }; var count = con.Insert(dbmsg); return(count); }
public string ApplyTeam(ApplyTeamParameterModel para) { string result = ""; MessageModel message = new MessageModel(); JavaScriptSerializer jss = new JavaScriptSerializer(); HashSet <object> returnResult = new HashSet <object>(); using (HiGame_V1Entities context = new HiGame_V1Entities()) { //判断角色是否是队长,队长不可申请加入其它战队 //判断是否参加其它战队,每个队员只可以参加一只战队 if (Team.IsCreateOrJoinTeam(para.UserID, context) == false) { //判断是否向该战队发出过申请 int applyCount = context.db_Message.Where(c => c.SendID == para.UserID) .Where(c => c.ReceiveID == para.TeamID) .Where(c => c.State == 1) .ToList().Count; //申请加入 if (applyCount > 0) { message.MessageCode = MESSAGE.JIONEDTEAM_CODE; message.Message = MESSAGE.JIONEDTEAM; } else { db_Message applyMessage = new db_Message(); applyMessage.SendID = para.UserID; applyMessage.ReceiveID = para.TeamID; applyMessage.SendTime = DateTime.Now; applyMessage.State = 1; applyMessage.MessageType = "加入战队"; context.db_Message.Add(applyMessage); context.SaveChanges(); message.Message = MESSAGE.OK; message.MessageCode = MESSAGE.OK_CODE; } } else { message.MessageCode = MESSAGE.JIONTEAM_CODE; message.Message = MESSAGE.JIONTEAM; } } returnResult.Add(message); result = jss.Serialize(returnResult); return(result); }
public string RemoveUser(ApplyTeamParameter2Model para) { string result = ""; MessageModel message = new MessageModel(); JavaScriptSerializer jss = new JavaScriptSerializer(); HashSet <object> returnResult = new HashSet <object>(); using (HiGame_V1Entities context = new HiGame_V1Entities()) { //获取战队信息 db_Team team = context.db_Team.Where(c => c.TeamID == para.TeamID).FirstOrDefault(); if (team != null) { //删除TeamUser表记录 db_TeamUser teamUser = context.db_TeamUser. Where(c => c.TeamID == para.TeamID). Where(c => c.UserID == para.UserID). FirstOrDefault(); context.db_TeamUser.Remove(teamUser); //Message表添加记录 db_Message msg = new db_Message(); msg.SendID = para.TeamID; msg.ReceiveID = para.UserID; msg.SendName = team.TeamName; msg.Title = "移出战队"; msg.MessageType = "移出战队"; msg.SendTime = DateTime.Now; msg.State = 0; msg.Content = "你已被移出战队【" + team.TeamName + "】,感谢一起战斗的岁月"; context.db_Message.Add(msg); //TeamRemoveUser表添加记录 db_TeamRemoveUser teamRemoveUser = new db_TeamRemoveUser(); teamRemoveUser.RemoveTime = DateTime.Now; teamRemoveUser.TeamID = para.TeamID; teamRemoveUser.UserID = para.UserID; context.db_TeamRemoveUser.Add(teamRemoveUser); context.SaveChanges(); //重新计算战队战斗力 db_Team joinTeam = context.db_Team.Where(c => c.TeamID == para.TeamID).FirstOrDefault(); joinTeam.FightScore = Team.GetFightScoreByTeamID(joinTeam.TeamID); //message表删除申请记录 var applyMessage = context.db_Message.Where(c => c.SendID == para.UserID) .Where(c => c.ReceiveID == para.TeamID) .Where(c => c.State == 1) .FirstOrDefault(); if (applyMessage != null) { context.db_Message.Remove(applyMessage); } context.SaveChanges(); message.MessageCode = MESSAGE.OK_CODE; message.Message = MESSAGE.OK; } } returnResult.Add(message); result = jss.Serialize(returnResult); return(result); }
public string Delete(SimpleTeamModel team) { string result = ""; MessageModel message = new MessageModel(); JavaScriptSerializer jss = new JavaScriptSerializer(); HashSet <object> returnResult = new HashSet <object>(); using (HiGame_V1Entities context = new HiGame_V1Entities()) { //判断是否有权解散战队 var deleteTeam = context.db_Team.Where(c => c.CreateUserID == team.CreatUserID) .Where(c => c.TeamName == team.TeamName) .Where(c => c.State == 0). FirstOrDefault(); if (deleteTeam == null) { //无权解散战队 message.Message = MESSAGE.DELETETEAM; message.MessageCode = MESSAGE.DELETETEAM_CODE; } else { //db_Team表状态修改为1(已解散) deleteTeam.State = 1; //如果还有其他战队,将注册时间最晚的战队设为默认战队 var otherTeam = context.db_Team.Where(c => c.CreateUserID == team.CreatUserID) .Where(c => c.TeamName != team.TeamName) .Where(c => c.State == 0) .OrderByDescending(c => c.CreateTime) .FirstOrDefault(); if (otherTeam != null) { otherTeam.IsDeault = 0; } //删除teamuser表数据 var teamUsers = context.db_TeamUser.Where(c => c.TeamID == deleteTeam.TeamID) .ToList(); if (teamUsers != null) { for (int i = 0; i < teamUsers.Count; i++) { //移出队员 context.db_TeamUser.Remove(teamUsers[i]); //向队员发送解散信息 //Message表添加记录 db_Message msg = new db_Message(); msg.SendID = teamUsers[i].TeamID; msg.ReceiveID = teamUsers[i].UserID; msg.SendName = team.TeamName; msg.Title = "解散战队"; msg.MessageType = "解散战队"; msg.SendTime = DateTime.Now; msg.State = 0; msg.Content = "战队【" + team.TeamName + "】已解散,感谢一起战斗的岁月"; context.db_Message.Add(msg); } } context.SaveChanges(); } } returnResult.Add(message); result = jss.Serialize(returnResult); return(result); }