public HttpResponseMessage ApplyUserList([FromBody] ApplyTeamParameterModel para) { TeamLogic teamLogic = new TeamLogic(); jsonResult = teamLogic.ApplyUserList(para); returnResult.Content = new StringContent(jsonResult, Encoding.UTF8, "application/json"); return(returnResult); }
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 ApplyUserList(ApplyTeamParameterModel para) { string result = ""; MessageModel message = new MessageModel(); JavaScriptSerializer jss = new JavaScriptSerializer(); HashSet <object> returnResult = new HashSet <object>(); List <User2Model> userInfo; using (HiGame_V1Entities context = new HiGame_V1Entities()) { //从Message表取数据,发出申请条件:state=1 and ReceiveID=TeamID。 var sql = "SELECT" + " t1.MID as MessageID," + " t2.UserID,t2.PhoneNumber,t2.UserWebNickName," + " t2.UserWebPicture,t2.UserName,t2.Address," + " t1.MessageType as State," + " CONVERT(varchar(100), t1.SendTime, 20) as SendTime," + " t2.Sex,CONVERT(varchar(100), t2.Birthday, 23) as Birthday,CONVERT(varchar(100), t2.RegisterDate, 23) as RegDate,t2.Hobby" + " FROM" + " db_Message t1" + " LEFT JOIN db_User t2 ON t1.SendID = t2.UserID" + " WHERE state=1 AND t1.ReceiveID =" + para.TeamID + " ORDER BY t1.SendTime DESC"; userInfo = context.Database.SqlQuery <User2Model>(sql) .Skip((para.StartPage - 1) * para.PageCount) .Take(para.PageCount).ToList(); //循环user,添加擅长英雄图标 for (int i = 0; i < userInfo.Count; i++) { //氦气 userInfo[i].Asset = User.GetAssetByUserID(userInfo[i].UserID); //战斗力 userInfo[i].GamePower = User.GetGamePowerByUserID(userInfo[i].UserID); userInfo[i].HeroImage = User.GetHeroImgeByUserID(userInfo[i].UserID); } } returnResult.Add(message); returnResult.Add(userInfo); result = jss.Serialize(returnResult); return(result); }
public string InvitedTeamList(ApplyTeamParameterModel para) { string result = ""; MessageModel message = new MessageModel(); JavaScriptSerializer jss = new JavaScriptSerializer(); HashSet <object> returnResult = new HashSet <object>(); List <MyApplyTeamModel> teamList; using (HiGame_V1Entities context = new HiGame_V1Entities()) { //从Message表取数据,我的申请条件:state=1 and UserID=我的ID。2.申请加入条件:state=1 and TeamID=我的默认战队ID。 //战队名称,战队logo,申请日期,战斗力,氦气,状态 var sql = "SELECT" + " t1.MID as MessageID," + " t1.SendID as TeamID," + " t1.MessageType as State," + " t2.TeamName as TeamName," + " t2.TeamPicture as TeamLogo," + " t2.TeamDescription as TeamDescription," + " (CASE WHEN t2.FightScore IS NULL THEN 0 ELSE t2.FightScore END) as FightScore," + " CONVERT(varchar(100), t1.SendTime, 20) as SendTime," + " t2.Asset" + " FROM db_Message t1 " + " LEFT JOIN db_Team t2 on t1.SendID = t2.TeamID" + " WHERE t1.State = 2 AND t1.ReceiveID=" + para.UserID + " ORDER BY t1.SendTime DESC "; teamList = context.Database.SqlQuery <MyApplyTeamModel>(sql) .Skip((para.StartPage - 1) * para.PageCount) .Take(para.PageCount).ToList(); } returnResult.Add(message); returnResult.Add(teamList); result = jss.Serialize(returnResult); return(result); }
public string RecruitList(ApplyTeamParameterModel para) { string result = ""; MessageModel message = new MessageModel(); JavaScriptSerializer jss = new JavaScriptSerializer(); HashSet <object> returnResult = new HashSet <object>(); List <RecruitModel> recruitList; using (HiGame_V1Entities context = new HiGame_V1Entities()) { string sql; if (para.UserID == 0) { sql = "SELECT" + " t2.TeamID as TeamID," + " t2.TeamName as TeamName," + " t2.TeamPicture as TeamLogo," + " t2.TeamDescription as TeamDescription," + " t2.FightScore," + " CONVERT(varchar(100), t1.RecruitTime, 20) as RecruitTime," + " t1.Content as RecruitContent" + " FROM db_Recruit t1 " + " LEFT JOIN db_Team t2 on t1.TeamID = t2.TeamID" + " WHERE t2.State = 0" + " ORDER BY t1.RecruitTime DESC "; } else { //string teamID = Team.MyAllTeamID(para.UserID); //战队名称,战队logo,申请日期,战斗力,氦气,状态 //sql = "SELECT" + // " t2.TeamID as TeamID," + // " t2.TeamName as TeamName," + // " t2.TeamPicture as TeamLogo," + // " t2.TeamDescription as TeamDescription," + // " t2.FightScore," + // " CONVERT(varchar(100), t1.RecruitTime, 20) as RecruitTime," + // " t1.Content as RecruitContent" + // " FROM db_Recruit t1 " + // " LEFT JOIN db_Team t2 on t1.TeamID = t2.TeamID" + // " WHERE t2.State = 0 AND t1.TeamID NOT IN " + teamID + // " ORDER BY t1.RecruitTime DESC "; sql = "SELECT" + " t2.TeamID as TeamID," + " t2.TeamName as TeamName," + " t2.TeamPicture as TeamLogo," + " t2.TeamDescription as TeamDescription," + " t2.FightScore," + " CONVERT(varchar(100), t1.RecruitTime, 20) as RecruitTime," + " t1.Content as RecruitContent" + " FROM db_Recruit t1 " + " LEFT JOIN db_Team t2 on t1.TeamID = t2.TeamID" + " WHERE t2.State = 0 " + " ORDER BY t1.RecruitTime DESC "; } recruitList = context.Database.SqlQuery <RecruitModel>(sql) .Skip((para.StartPage - 1) * para.PageCount) .Take(para.PageCount).ToList(); } returnResult.Add(message); returnResult.Add(recruitList); result = jss.Serialize(returnResult); return(result); }