public HttpResponseMessage MyFight([FromBody] FightParameterModel fight)
{
FightLogic fightLogic = new FightLogic();
jsonResult = fightLogic.MyFight(fight);
returnResult.Content = new StringContent(jsonResult, Encoding.UTF8, "application/json");
return(returnResult);
}
public string MyFight(FightParameterModel fight)
{
if (fight.FightType.ToLower() == "send")
{
return(MySendFight(fight));
}
else
{
return(MyReceiveFight(fight));
}
}
public static string MyReceiveFight(FightParameterModel fight)
{
string result = "";
MessageModel message = new MessageModel();
List <FightStateModel> fightStateList = new List <FightStateModel>();
HashSet <object> returnResult = new HashSet <object>();
JavaScriptSerializer jss = new JavaScriptSerializer();
List <FightStateDetailModel> fightReceiveList;
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
string teamID = "()";
db_User userInfo = context.db_User.Where(c => c.PhoneNumber == fight.PhoneNumber).FirstOrDefault();
if (userInfo != null)
{
teamID = Team.MyAllTeamID(userInfo.UserID);
}
var sql = "SELECT" +
" t1.DateID,t1.STeamID,t1.ETeamID,t1.Money,t1.FightAddress as SFightAddress,t1.FightAddress1 as EFightAddress,t1.CurrentState," +
" CONVERT(varchar(100), t1.FightTime, 20) as FightTime," +
" t5.PhoneNumber," +
" CONVERT(varchar(100), t2.StateTime, 20) as StateTimeStr," +
" t3.TeamName as STeamName,t4.TeamName as ETeamName," +
" t1.SFightPic as SFightPic,t1.EFightPic as EFightPic" +
" FROM" +
" db_DateFight t1 join db_FightState t2" +
" ON t1.DateID = t2.DateID and t1.CurrentState = t2.State" +
" LEFT JOIN db_Team t3" +
" ON t1.STeamID = t3.TeamID" +
" LEFT JOIN db_Team t4" +
" ON t1.ETeamID = t4.TeamID" +
" LEFT JOIN db_User t5" +
" ON t3.CreateUserID = t5.UserID" +
" WHERE t3.State=0 AND t4.State=0 AND t1.ETeamID IN" + teamID +
" ORDER BY t2.StateTime DESC";
fightReceiveList = context.Database.SqlQuery <FightStateDetailModel>(sql)
.Skip((fight.StartPage - 1) * fight.PageCount)
.Take(fight.PageCount).ToList();
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
}
returnResult.Add(message);
returnResult.Add(fightReceiveList);
result = jss.Serialize(returnResult);
return(result);
}
