public static List <TeamModel> TeamListByCreateDate(TeamListParameterModel para)
{
List <TeamModel> teamList = new List <TeamModel>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
// 获取战队列表
var sql = "SELECT" +
" t1.CreateUserID as Creater," +
" t1.TeamID," +
" t1.TeamName," +
" t1.TeamPicture as TeamLogo," +
" t1.TeamDescription," +
" t1.TeamType," +
" (CASE WHEN t1.FightScore IS NULL THEN 0 ELSE t1.FightScore END) as FightScore," +
" (CASE WHEN t1.Asset IS NULL THEN 0 ELSE t1.Asset END) as Asset," +
" t1.IsDeault," +
" (CASE WHEN t1.WinCount IS NULL THEN 0 ELSE t1.WinCount END) as WinCount," +
" (CASE WHEN t1.LoseCount IS NULL THEN 0 ELSE t1.LoseCount END) as LoseCount," +
" (CASE WHEN t1.FollowCount IS NULL THEN 0 ELSE t1.FollowCount END) as FollowCount," +
" CONVERT(varchar(100), t1.CreateTime, 23) as CreateTime" +
" FROM" +
" db_Team t1" +
" ORDER BY t1.CreateTime " + para.Sort;
teamList = context.Database.SqlQuery <TeamModel>(sql)
.Skip((para.StartPage - 1) * para.PageCount)
.Take(para.PageCount).ToList();
}
return(teamList);
}
public string TeamList(TeamListParameterModel para)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
List <TeamModel> teamList = new List <TeamModel>();
HashSet <object> returnResult = new HashSet <object>();
//不同参数类型返回不同结果
switch (para.Type.ToLower())
{
case "userfightscore":
teamList = Team.TeamListByUserFightScore(para);
break;
case "teamfightscore":
teamList = Team.TeamListByTeamFightScore(para);
break;
case "createdate":
teamList = Team.TeamListByCreateDate(para);
break;
}
returnResult.Add(message);
returnResult.Add(teamList);
result = jss.Serialize(returnResult);
return(result);
}
public HttpResponseMessage TeamList([FromBody] TeamListParameterModel para)
{
TeamLogic teamLogic = new TeamLogic();
jsonResult = teamLogic.TeamList(para);
returnResult.Content = new StringContent(jsonResult, Encoding.UTF8, "application/json");
return(returnResult);
}
public static List <TeamModel> TeamListByTeamFightScore(TeamListParameterModel para)
{
List <TeamModel> teamList = new List <TeamModel>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
// 根据战队战斗力获取战队列表
// 查询条件：1.战队状态=0 2.战队满5人 3.剔除自己的战队
var sql = "SELECT" +
" t1.CreateUserID as Creater," +
" t1.TeamID," +
" (SELECT count(t2.UserID) FROM db_TeamUser t2 WHERE t2.TeamID=t1.TeamID) as UserCount," +
" t1.TeamName," +
" t1.TeamPicture as TeamLogo," +
" t1.TeamDescription," +
" t1.TeamType," +
" (CASE WHEN t1.FightScore IS NULL THEN 0 ELSE t1.FightScore END) as FightScore," +
" (CASE WHEN t1.Asset IS NULL THEN 0 ELSE t1.Asset END) as Asset," +
" t1.IsDeault," +
" (CASE WHEN t1.WinCount IS NULL THEN 0 ELSE t1.WinCount END) as WinCount," +
" (CASE WHEN t1.LoseCount IS NULL THEN 0 ELSE t1.LoseCount END) as LoseCount," +
" (CASE WHEN t1.FollowCount IS NULL THEN 0 ELSE t1.FollowCount END) as FollowCount," +
" CONVERT(varchar(100), t1.CreateTime, 23) as CreateTime" +
" FROM" +
" db_Team t1" +
" WHERE t1.State=0 AND" +
" (SELECT count(t2.UserID) FROM db_TeamUser t2 WHERE t2.TeamID=t1.TeamID)>=4" +
" AND t1.CreateUserID!=" + para.createUserID +
" ORDER BY t1.CreateTime " + para.Sort;
teamList = context.Database.SqlQuery <TeamModel>(sql)
.Skip((para.StartPage - 1) * para.PageCount)
.Take(para.PageCount).ToList();
}
return(teamList);
}
