//public void AddGrounp(PubgSession session, string body, string grounpName,string playerTime, string userId,string area="shanxi") //{ // Logger.InfoFormat("创建队:{0}", grounpName); // DataResult dataResult = new DataResult(); // string sql = "select * from grounp where userId = @userId"; // List<Grounp> result = MySqlExecuteTools.GetObjectResult<Grounp>(sql, // new MySqlParameter[] { new MySqlParameter("@userId", userId) }); // if(result.Count>= createGrounpCount) // { // dataResult.result = 1; // dataResult.resean = "您的权限最多创建"+ createGrounpCount + "个分队,请检查后重试。"; // session.Send(GetSendData(dataResult, body)); // return; // } // sql = "select * from grounp where name = @name and userId = @userId"; // result = MySqlExecuteTools.GetObjectResult<Grounp>(sql, // // new MySqlParameter[] { new MySqlParameter("@name", roomName), new MySqlParameter("@area", room.area.Trim())}); // new MySqlParameter[] { new MySqlParameter("@name", grounpName), new MySqlParameter("@userId", userId) }); // if (result.Count >0) // { // dataResult.result = 1; // dataResult.resean = "队名称已存在,请检查后重试。"; // } // else // { // //创建房间 // sql = "insert into grounp(name,runState,playerTime,area,userId) " + // "values('" + grounpName + "','-1','" + playerTime + "','" + area + "','" + userId + "')"; // long roomid = MySqlExecuteTools.GetAddID(sql); // if(roomid!=-1) // { // //创建房间 // CreateRoom(roomCount, roomid); // dataResult.result = 0; // dataResult.data = null; // } // else // { // dataResult.result = 1; // dataResult.data ="创建失败,请重试!"; // } // } // if(dataResult.result == 0) // { // joinRoomDao.GetAllRoom(); // } // session.Send(GetSendData(dataResult, body)); //} /// <summary> /// Delete /// </summary> /// <param name="session"></param> /// <param name="body"></param> /// <param name="id">roomid</param> /// <param name="userId">用户id</param> //public void DeleteGrounp(PubgSession session, string body, string grounpId) //{ // DataResult dataResult = new DataResult(); // //查询能否删除 // List<Room> roomList = SearchRoomListByGrounp(grounpId); // if(roomList==null || roomList.Count==0) // { // dataResult.result = 1; // dataResult.resean = "非法操作,无法进行删除。"; // session.Send(GetSendData(dataResult, body)); // return; // } // foreach(Room item in roomList) // { // List<Room_User> roomUserList = SearchSingleGrounpCommon(item.id.ToString()); // if (roomUserList.Count > 0) // { // dataResult.result = 1; // dataResult.resean = "该房间下存在用户,无法进行删除。"; // session.Send(GetSendData(dataResult, body)); // return; // } // } // //开始删除队信息 // string sql = "delete from grounp where id = @grounpId"; // MySqlExecuteTools.GetCountResult(sql, new MySqlParameter[] { new MySqlParameter("@grounpId", grounpId) }); // dataResult.result = 0; // //删除房间的相关数据 // DeleteRoom(grounpId); // if (dataResult.result == 0) // { // joinRoomDao.GetAllRoom(); // } // session.Send(GetSendData(dataResult, body)); //} /// <summary> /// 更新房间 /// </summary> /// <param name="session"></param> /// <param name="body"></param> /// <param name="room"></param> public void UpdateGrounp(PubgSession session, string body, string grounpId, string grounpName, string checkCode, string playerTime) { DataResult dataResult = new DataResult(); Grounp p = SearchGrounpDao.GetGrounpById(grounpId); if (p != null && p.runState == 0) { dataResult.result = 1; dataResult.resean = "游戏运行中,无法修改游戏。"; session.Send(GetSendData(dataResult, body)); return; } //更新队 string sql = "update grounp set name = '" + grounpName + "', playerTime = '" + playerTime + "', checkCode = '" + checkCode + "', remainTime = '" + (int.Parse(playerTime) * 60) + "' where id = @grounpId"; MySqlExecuteTools.GetCountResult(sql, new MySqlParameter[] { new MySqlParameter("@grounpId", grounpId) }); //更新分队信息 dataResult.result = 0; session.Send(GetSendData(dataResult, body)); }
public void JoinRoom(PubgSession session, string body, string checkCode, string grounpId, string roomId, string userId, string userName) { Logger.InfoFormat("加入队:{0},{1}", roomId, userId); string sql = "select * from room_user where user_id = @user_id"; List <Room_User> grounp_UserList = MySqlExecuteTools.GetObjectResult <Room_User>(sql, new MySqlParameter[] { new MySqlParameter("@user_id", userId) }); DataResult dataResult = new DataResult(); if (grounp_UserList.Count > 0) { dataResult.result = 1; dataResult.resean = "您已经加入房间,不能重复。"; session.Send(GetSendData(dataResult, body)); return; } //校验checkcode是否正确 sql = "select * from room where id = @roomId and checkCode = @checkCode"; int countResult = MySqlExecuteTools.GetCountResult(sql, new MySqlParameter[] { new MySqlParameter("@roomId", roomId), new MySqlParameter("@checkCode", checkCode) }); if (countResult == 0) { dataResult.result = 1; dataResult.resean = "进入房间的密码不正确,请重试。"; session.Send(GetSendData(dataResult, body)); return; } Grounp p = SearchGrounpDao.GetGrounpById(grounpId); if (p != null && p.runState == 0) { dataResult.result = 1; dataResult.resean = "游戏运行中,无法加入战队。"; session.Send(GetSendData(dataResult, body)); return; } sql = "select * from room where id = @roomId"; List <Room> roomList = MySqlExecuteTools.GetObjectResult <Room>(sql, new MySqlParameter[] { new MySqlParameter("@roomId", roomId) }); if (roomList.Count == 1 && roomList[0].runState == 0) { dataResult.result = 1; dataResult.resean = "该战队已经准备就绪,无法加入,请重试。"; session.Send(GetSendData(dataResult, body)); return; } //grounp_UserList = SearchSingleGrounpCommon(roomId); //if (grounp_UserList.Count> maxNum) //{ // dataResult.result = 1; // dataResult.resean = "房间人数加入已满,请重试。"; //} //else //{ sql = "insert into room_user(room_id,user_id) " + "values('" + roomId + "','" + userId + "')"; MySqlExecuteTools.AddOrUpdate(sql); dataResult.result = 0; //推送数据 sql = "select name from room where id=" + roomId; string rommName = MySqlExecuteTools.GetSingleFieldResult(sql, null)[0].ToString(); publishTipsMessage.JoinAndExitLeader(userName, int.Parse(userId), rommName, true); // } session.Send(GetSendData(dataResult, body)); GetRoomUserData(); }