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