public HttpResponseMessage MyGuessList([FromBody] GuessParameterModel guess)
{
GuessLogic guessLogic = new GuessLogic();
jsonResult = guessLogic.MyGuessList(guess);
returnResult.Content = new StringContent(jsonResult, Encoding.UTF8, "application/json");
return(returnResult);
}
public string MyGuessList(GuessParameterModel guess)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
//获取竞猜列表
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
string where = "";
if (guess.GuessID == 0)
{
where = " WHERE t2.UserID=" + guess.UserID;
}
else
{
where = " WHERE t2.UserID=" + guess.UserID + " AND t2.GuessID=" + guess.GuessID;
}
//联合查询
var sql = "SELECT" +
" t3.GameStage as MatchName," +
" CONVERT(varchar(100), t3.EndTime, 20) as EndTime," +
" CONVERT(varchar(100), t2.GuessTime, 20) as GuessTime," +
" t2.BetMoney," +
" t2.Odds," +
" t3.Result as Result," +
" t4.TeamID as STeamID," +
" t4.TeamName as STeamName," +
" t4.TeamPicture as STeamLogo," +
" t5.TeamID as ETeamID," +
" t5.TeamName as ETeamName," +
" t5.TeamPicture as ETeamLogo," +
" t6.TeamID as BetTeamID," +
" t6.TeamName as BetTeamName," +
" t6.TeamPicture as BetTeamLogo" +
" FROM" +
" db_MatchGuess t1" +
" LEFT JOIN db_GuessRecord t2 ON t1.GuessID = t2.GuessID" +
" LEFT JOIN db_FightResult t3 ON t1.ResultID = t3.ResultID" +
" LEFT JOIN db_Team t4 ON t3.HomeTeamID = t4.TeamID" +
" LEFT JOIN db_Team t5 ON t3.CustomerTeamID = t5.TeamID" +
" LEFT JOIN db_Team t6 ON t2.OptionID = t6.TeamID" + where + "ORDER BY t2.GuessTime DESC";
var guessList = context.Database.SqlQuery <Guess2Model>(sql)
.Skip((guess.StartPage - 1) * guess.PageCount)
.Take(guess.PageCount).ToList();
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
returnResult.Add(message);
returnResult.Add(guessList);
}
result = jss.Serialize(returnResult);
return(result);
}
