public string Recharge(UserRechargeParameterModel para)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
db_AssetRecord assetRecord = new db_AssetRecord();
assetRecord.UserID = para.UserID;
assetRecord.VirtualMoney = para.VirtualMoney;
assetRecord.TrueMoney = para.VirtualMoney / 10;
assetRecord.GainWay = ASSET.GAINWAY_RECHARGE;
assetRecord.GainTime = DateTime.Now;
assetRecord.State = ASSET.MONEYSTATE_YES;
//时间+操作+收入支出金额
assetRecord.Remark = assetRecord.GainTime + " " +
assetRecord.GainWay + " "
+ ASSET.PAY_IN +
assetRecord.VirtualMoney.ToString();
//将充值记录加入资产记录表
context.db_AssetRecord.Add(assetRecord);
context.SaveChanges();
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public static List <TeamUserModel> GetTeamUserByUserID(int teamID)
{
List <db_TeamUser> teamUser;
List <TeamUserModel> teamUserList = new List <TeamUserModel>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
teamUser = context.db_TeamUser.Where(c => c.TeamID == teamID).ToList();
if (teamUser != null)
{
for (int i = 0; i < teamUser.Count; i++)
{
TeamUserModel teamUserModel = new TeamUserModel();
var user = User.GetUserModelByUserID(Convert.ToInt32(teamUser[i].UserID));
teamUserModel.UserPicture = user.UserWebPicture; //人像
teamUserModel.UserID = user.UserID; //性别
teamUserModel.PhoneNumber = user.PhoneNumber;
teamUserModel.UserNickName = user.UserWebNickName;
teamUserModel.Sex = user.Sex;
teamUserModel.RegDate = user.RegDate;
teamUserModel.Address = user.Address;
teamUserModel.Birthday = user.Birthday;
teamUserModel.Hobby = user.Hobby;
teamUserModel.Asset = User.GetAssetByUserID(user.UserID);
teamUserModel.FightScore = User.GetGamePowerByUserID(user.UserID);
teamUserModel.HeroImage = User.GetHeroImgeByUserID(user.UserID);
teamUserList.Add(teamUserModel);
}
}
}
return(teamUserList);
}
public string MakeChallenge(ChallengeParameterModel para)
{
string result = "";
MessageModel message = new MessageModel();
List <FightStateModel> fightStateList = new List <FightStateModel>();
HashSet <object> returnResult = new HashSet <object>();
JavaScriptSerializer jss = new JavaScriptSerializer();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//发起约战前提条件判断
message = Fight.IsChallenge(para.UserID, para.STeamID, para.Money);
if (message.MessageCode == 0)
{
//向约战记录表插入一条数据
db_DateFight dateFight = new db_DateFight();
dateFight.CurrentState = "发起挑战";
dateFight.STeamID = para.STeamID;
dateFight.ETeamID = para.ETEamID;
dateFight.Money = para.Money;
dateFight.FightTime = para.FightTime;
context.db_DateFight.Add(dateFight);
//资产表插入一条数据
db_AssetRecord assetRecord = new db_AssetRecord();
assetRecord.UserID = para.UserID;
assetRecord.VirtualMoney = -para.Money;
assetRecord.TrueMoney = 0;
assetRecord.GainWay = ASSET.GAINWAY_CHALLENGE;
assetRecord.GainTime = DateTime.Now;
assetRecord.State = ASSET.MONEYSTATE_YES;
//时间+操作+收入支出金额
assetRecord.Remark = assetRecord.GainTime + " " +
assetRecord.GainWay + " "
+ ASSET.PAY_OUT +
assetRecord.VirtualMoney.ToString();
context.db_AssetRecord.Add(assetRecord);
//向信息表插入一条数据
context.SaveChanges();
//向约战状态表插入一条数据
var fight = context.db_DateFight.Where(c => c.STeamID == para.STeamID)
.Where(c => c.ETeamID == para.ETEamID)
.OrderByDescending(c => c.FightTime).FirstOrDefault();
db_FightState fightState = new db_FightState();
fightState.DateID = fight.DateID;
fightState.State = "发起挑战";
fightState.StateTime = DateTime.Now;
context.db_FightState.Add(fightState);
context.SaveChanges();
}
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public string UserInfoByUserID(UserParameterModel user)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//获取用户
UserModel userInfo = User.GetUserModelByUserID(user.UserID);
if (userInfo != null)
{
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
}
else
{
message.Message = MESSAGE.NOUSER;
message.MessageCode = MESSAGE.NOUSER_CODE;
}
returnResult.Add(message);
returnResult.Add(userInfo);
}
result = jss.Serialize(returnResult);
return(result);
}
public string MyAssetList(UserParameterModel user)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
//获取我的资产
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//获取用户资产列表
var sql = "SELECT t1.VirtualMoney,CONVERT(varchar(100), t1.GainTime, 23) as GainTime,t1.GainWay,t1.Remark" +
" FROM db_AssetRecord t1" +
" WHERE t1.UserID = " + user.UserID + "ORDER BY t1.GainTime DESC";
var assetList = context.Database.SqlQuery <AssetList>(sql)
.Skip((user.StartPage - 1) * user.PageCount)
.Take(user.PageCount).ToList();
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
returnResult.Add(message);
returnResult.Add(assetList);
}
result = jss.Serialize(returnResult);
return(result);
}
public string ResetPassWord(SimpleUserModel user)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
// 判断手机号是否存在
db_User dbUser = context.db_User.Where(c => c.PhoneNumber == user.PhoneNumber.Trim()).FirstOrDefault();
if (dbUser == null)
{
//手机号不存在
message.MessageCode = MESSAGE.NOUSER_CODE;
message.Message = MESSAGE.NOUSER;
}
else
{
//修改密码
MD5 md5Hash = MD5.Create();
dbUser.UserPassWord = Common.GetMd5Hash(md5Hash, user.PassWord);
context.SaveChanges();
//修改成功
message.MessageCode = MESSAGE.OK_CODE;
message.Message = MESSAGE.OK;
}
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public string SendRecruit(RecruitParameterModel para)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//db_Recruit表插入或更新一条数据
var recruit = context.db_Recruit.Where(c => c.TeamID == para.TeamID).FirstOrDefault();
if (recruit == null)
{
db_Recruit record = new db_Recruit();
record.TeamID = para.TeamID;
record.Content = para.Content;
record.RecruitTime = DateTime.Now;
context.db_Recruit.Add(record);
}
else
{
recruit.Content = para.Content;
recruit.RecruitTime = DateTime.Now;
}
context.SaveChanges();
}
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public static int GetGamePowerByUserID(int userID)
{
GameModel gameInfo = new GameModel();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//
// 获取用户游戏数据
var sql = "select t1.UserID,t1.GameID,t1.CertifyState,t2.GamePower,t1.CertifyName" +
" from db_GameIDofUser t1" +
" left join db_GameInfoofPlatform t2" +
" on t1.UGID = t2.UGID" +
" where t1.UserID = " + userID + " and t1.GameType = 'DOTA2'";
gameInfo = context.Database.SqlQuery <GameModel>(sql)
.FirstOrDefault();
if (gameInfo == null)
{
//无游戏数据
return(0);
}
}
return(Convert.ToInt32(gameInfo.GamePower));
}
public string MatchList()
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
List <MatchModel> matchList = new List <MatchModel>();
//赛事列表信息
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
var sql = "SELECT" +
" t1.GameID as MatchID," +
" t1.GameName as MatchName," +
" t1.Introduce as Introduce," +
" t1.ShowPicture" +
" FROM db_Game t1" +
" WHERE t1.State =0";
matchList = context.Database.SqlQuery <MatchModel>(sql)
.ToList();
}
message.MessageCode = MESSAGE.OK_CODE;
message.Message = MESSAGE.OK;
returnResult.Add(message);
returnResult.Add(matchList);
result = jss.Serialize(returnResult);
return(result);
}
public string IsSignIn(UserParameterModel para)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
db_AssetRecord asset = context.db_AssetRecord.
Where(c => c.UserID == para.UserID)
.Where(c => c.GainWay == ASSET.GAINWAY_SIGN)
.Where(c => c.GainTime.Value.Year == DateTime.Now.Year &&
c.GainTime.Value.Month == DateTime.Now.Month &&
c.GainTime.Value.Day == DateTime.Now.Day).FirstOrDefault();
if (asset == null)
{
message.Message = MESSAGE.NOTSIGN;
message.MessageCode = MESSAGE.NOTSIGN_CODE;
}
else
{
//今日已签到
message.Message = MESSAGE.SIGN;
message.MessageCode = MESSAGE.SIGN_CODE;
}
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public string UpdateGameID(FightParameter2Model fight)
{
string result = "";
MessageModel message = new MessageModel();
List <FightStateModel> fightStateList = new List <FightStateModel>();
HashSet <object> returnResult = new HashSet <object>();
JavaScriptSerializer jss = new JavaScriptSerializer();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//datefight表更改当前状态
db_DateFight fightRecord = new db_DateFight();
fightRecord = context.db_DateFight.Where(c => c.DateID == fight.DateID).FirstOrDefault();
if (fight.SFightAddress == null)
{
fightRecord.FightAddress1 = fight.EFightAddress;
fightRecord.EFightPic = Common.Base64ToFightImage(fight.EFightPic, fight.DateID.ToString());
}
else
{
fightRecord.FightAddress = fight.SFightAddress;
fightRecord.SFightPic = Common.Base64ToFightImage(fight.SFightPic, fight.DateID.ToString());
}
context.SaveChanges();
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public string MatchDateList(MatchParameterModel para)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
List <MatchDateModel> dateList = new List <MatchDateModel>();
//主播赛程列表
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
var sql = "SELECT" +
" CONVERT(varchar(100), t1.StartTime, 23) as StartTime" +
" FROM db_FightResult t1" +
" WHERE t1.BoBoID= " + para.BoBoID +
" AND t1.GameID=" + para.MatchID +
" GROUP BY CONVERT(varchar(100), t1.StartTime, 23)" +
" ORDER BY CONVERT(varchar(100), t1.StartTime, 23)";
dateList = context.Database.SqlQuery <MatchDateModel>(sql)
.ToList();
}
message.MessageCode = MESSAGE.OK_CODE;
message.Message = MESSAGE.OK;
returnResult.Add(message);
returnResult.Add(dateList);
result = jss.Serialize(returnResult);
return(result);
}
public string MyAllTeam(SimpleTeamModel team)
{
string result = "";
MessageModel message = new MessageModel();
List <TeamModel> teamInfo = new List <TeamModel>();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//三种情况：1.不属于任何战队，也没有自己的战队。2.是某战队的队员。 3.是某战队的队长
db_User user = context.db_User.Where(c => c.UserID == team.CreatUserID).FirstOrDefault();
if (user != null)
{
//获取用户的所有战队信息
teamInfo = Team.MyAllTeam(user.UserID);
}
else
{
//无此用户
message.Message = MESSAGE.NOUSER;
message.MessageCode = MESSAGE.NOUSER_CODE;
}
returnResult.Add(message);
returnResult.Add(teamInfo);
}
result = jss.Serialize(returnResult);
return(result);
}
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 static TeamModel GetTeambyID(int teamID)
{
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
TeamModel myTeam = new TeamModel();
db_Team team = context.db_Team.
Where(c => c.TeamID == teamID).
FirstOrDefault();
if (team != null)
{
myTeam.Asset = team.Asset;
myTeam.Creater = team.CreateUserID;
myTeam.TeamID = team.TeamID;
myTeam.CreateTime = ((DateTime)team.CreateTime).ToString("yyyy-MM-dd");
myTeam.FightScore = team.FightScore;
myTeam.FollowCount = team.FollowCount;
myTeam.IsDeault = team.IsDeault;
myTeam.LoseCount = team.LoseCount;
myTeam.Role = "teamcreater";
myTeam.TeamLogo = team.TeamPicture;
myTeam.TeamName = team.TeamName;
myTeam.TeamType = team.TeamType;
myTeam.TeamDescription = team.TeamDescription;
myTeam.WinCount = team.WinCount;
myTeam.RecruitContent = GetRecruitContentByTeamID(team.TeamID);
myTeam.CreaterPicture = GetUserPictureByUserID(team.CreateUserID);
myTeam.TeamUser = GetTeamUserByUserID(team.TeamID);
}
return(myTeam);
}
}
public string BoBoCount(MatchParameterModel match)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
BoBoCountModel joinCount = new BoBoCountModel();
//主播列表
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
var sql = "SELECT" +
" Count(t1.GameRecordID) as JoinCount" +
" FROM db_GameRecord t1" +
" LEFT JOIN db_Team t2 ON t1.TeamID=t2.TeamID" +
" WHERE t2.State=0 AND t1.GameID =" + match.MatchID + " AND t1.BoBoID=" + match.BoBoID;
joinCount = context.Database.SqlQuery <BoBoCountModel>(sql)
.FirstOrDefault();
}
message.MessageCode = MESSAGE.OK_CODE;
message.Message = MESSAGE.OK;
returnResult.Add(message);
returnResult.Add(joinCount);
result = jss.Serialize(returnResult);
return(result);
}
public string Bet(GuessRecordModel guess)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
//获取竞猜列表
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//判断氦气是否充足
bool isEnoughMoney = Asset.IsEnoughMoney(guess.UserID, guess.Money);
//氦气不足
if (isEnoughMoney == false)
{
message.Message = MESSAGE.NOMONEY;
message.MessageCode = MESSAGE.NOMONEY_CODE;
}
else
{
//向db_GuessRecord表插入数据
db_GuessRecord guessInsert = new db_GuessRecord();
guessInsert.BetMoney = guess.Money;
guessInsert.GuessID = guess.GuessID;
guessInsert.GuessTime = DateTime.Now;
guessInsert.GuessType = 0;
guessInsert.Odds = guess.Odds;
guessInsert.OptionID = guess.TeamID;
guessInsert.UserID = guess.UserID;
context.db_GuessRecord.Add(guessInsert);
//向Asset表插入数据
db_AssetRecord assetRecord = new db_AssetRecord();
assetRecord.UserID = guess.UserID;
assetRecord.VirtualMoney = -guess.Money;
assetRecord.TrueMoney = 0;
assetRecord.GainWay = ASSET.GAINWAY_QUIZ;
assetRecord.GainTime = DateTime.Now;
assetRecord.State = ASSET.MONEYSTATE_YES;
//时间+操作+收入支出金额
assetRecord.Remark = assetRecord.GainTime + " " +
assetRecord.GainWay + " "
+ ASSET.PAY_OUT +
assetRecord.VirtualMoney.ToString();
//将充值记录加入资产记录表
context.db_AssetRecord.Add(assetRecord);
context.SaveChanges();
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
}
returnResult.Add(message);
}
result = jss.Serialize(returnResult);
return(result);
}
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);
}
public string Accept(FightParameter2Model fight)
{
string result = "";
MessageModel message = new MessageModel();
List <FightStateModel> fightStateList = new List <FightStateModel>();
HashSet <object> returnResult = new HashSet <object>();
JavaScriptSerializer jss = new JavaScriptSerializer();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//判断氦气是否充足
bool isEnoughMoney = Asset.IsEnoughMoney(fight.UserID, fight.Money);
//氦气不足
if (isEnoughMoney == false)
{
message.Message = MESSAGE.NOMONEY;
message.MessageCode = MESSAGE.NOMONEY_CODE;
}
else
{
//dategight表更改当前状态
var fightRecord = context.db_DateFight.Where(c => c.DateID == fight.DateID).FirstOrDefault();
fightRecord.CurrentState = "已应战";
//fightstate表新增状态
db_FightState fightState = new db_FightState();
fightState.DateID = fight.DateID;
fightState.State = "已应战";
fightState.StateTime = DateTime.Now;
context.db_FightState.Add(fightState);
//扣除约战氦气，资产表插入一条数据
db_AssetRecord assetRecord = new db_AssetRecord();
assetRecord.UserID = fight.UserID;
assetRecord.VirtualMoney = -fight.Money;
assetRecord.TrueMoney = 0;
assetRecord.GainWay = ASSET.GAINWAY_ACCEPT;
assetRecord.GainTime = DateTime.Now;
assetRecord.State = ASSET.MONEYSTATE_YES;
//时间+操作+收入支出金额
assetRecord.Remark = assetRecord.GainTime + " " +
assetRecord.GainWay + " "
+ ASSET.PAY_OUT +
assetRecord.VirtualMoney.ToString();
context.db_AssetRecord.Add(assetRecord);
context.SaveChanges();
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
}
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public static db_User GetUserByPhoneNumber(string phoneNumber)
{
db_User user;
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
user = context.db_User.Where(c => c.PhoneNumber == phoneNumber).FirstOrDefault();
}
return(user);
}
public string AllFightList(RankParameterModel rank)
{
string result = "";
MessageModel message = new MessageModel();
List <FightStateModel> fightStateList = new List <FightStateModel>();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
//获取约战平台约战记录的当前状态
//个人排行：昵称，签名，氦气，战斗力，大神系数
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//联合查询
var sql = "SELECT" +
" t1.DateID,t1.STeamID,t1.ETeamID,t1.Money,t1.FightAddress,t1.CurrentState," +
" t2.StateTime,t3.TeamName as STeamName,t4.TeamName as ETeamName" +
" 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 ORDER BY t2.StateTime DESC";
var fightStateDetailList = context.Database.SqlQuery <FightStateDetailModel>(sql)
.Skip((rank.StartPage - 1) * rank.PageCount)
.Take(rank.PageCount).ToList();
if (fightStateDetailList == null)
{
//无游戏数据
message.Message = MESSAGE.NOGAMEDATA;
message.MessageCode = MESSAGE.NOGAMEDATA_CODE;
}
else
{
foreach (FightStateDetailModel fight in fightStateDetailList)
{
//拼接返回字段信息
FightStateModel fightState = new FightStateModel();
fightState.FightAsset = fight.Money;
fightState.FightTime = Common.DateDiff(fight.StateTime, DateTime.Now);
fightState.Description = Fight.FightState(fight);
fightStateList.Add(fightState);
}
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
}
returnResult.Add(message);
returnResult.Add(fightStateList);
}
result = jss.Serialize(returnResult);
return(result);
}
public static int?GetAssetByUserID(int userID)
{
int?asset;
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//获取用户总资产
asset = context.db_AssetRecord.Where(c => c.UserID == userID).Sum(c => c.VirtualMoney);
}
return(asset);
}
public static int GetTeamUserCountByTeamID(int teamID)
{
int teamUserCount;
List <TeamUserModel> teamUserList = new List <TeamUserModel>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
teamUserCount = context.db_TeamUser.Where(c => c.TeamID == teamID).ToList().Count;
}
return(teamUserCount);
}
public string Reject(FightParameter2Model fight)
{
string result = "";
MessageModel message = new MessageModel();
List <FightStateModel> fightStateList = new List <FightStateModel>();
HashSet <object> returnResult = new HashSet <object>();
JavaScriptSerializer jss = new JavaScriptSerializer();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//1.dategight表更改当前状态
var fightRecord = context.db_DateFight.Where(c => c.DateID == fight.DateID).FirstOrDefault();
fightRecord.CurrentState = "已认怂";
//2.fightstate表新增状态
db_FightState fightState = new db_FightState();
fightState.DateID = fight.DateID;
fightState.State = "已认怂";
fightState.StateTime = DateTime.Now;
context.db_FightState.Add(fightState);
//3.扣取一认怂金，资产表插入一条数据
db_AssetRecord assetRecord = new db_AssetRecord();
assetRecord.UserID = fight.UserID;
assetRecord.VirtualMoney = -1;
assetRecord.TrueMoney = 0;
assetRecord.GainWay = ASSET.GAINWAY_REJECT;
assetRecord.GainTime = DateTime.Now;
assetRecord.State = ASSET.MONEYSTATE_YES;
assetRecord.Remark = assetRecord.GainTime + " " +
assetRecord.GainWay + " "
+ ASSET.PAY_OUT +
assetRecord.VirtualMoney.ToString();
context.db_AssetRecord.Add(assetRecord);
//4.本方Team表认怂数+1,挑战方Team表胜利数+1，归还扣押挑战金
Fight.UpdateTeamByDateID(fight, context);
//5.认怂表新增数据
db_Follow follow = new db_Follow();
follow.DateID = fight.DateID;
follow.FollowMoney = 1;
follow.FollowTime = DateTime.Now;
context.db_Follow.Add(follow);
context.SaveChanges();
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public string MyMessage(UserParameterModel para)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
List <MyMessageModel> messageInfo;
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//单发消息
var sql = "SELECT" +
" t1.MID as MessageID,t1.Title,t1.Content," +
" (CASE WHEN t1.State = 0 then '未读' else '已读' end) as State," +
" CONVERT(varchar(100), t1.SendTime, 20) as Time" +
" FROM" +
" db_Message t1" +
" WHERE t1.State in (0,99) AND t1.ReceiveID =" + para.UserID +
" ORDER BY t1.State ,t1.SendTime DESC";
//" union" +
////群发消息
//" SELECT" +
//" t1.MID as MessageID,t1.Title,t1.Content," +
//" (CASE WHEN t2.SysState IS NULL then '未读' else '已读' end) as State," +
//" CONVERT(varchar(100), t1.SendTime, 20) as Time" +
//" FROM" +
//" db_Message t1" +
//" left JOIN db_SysMessage t2 ON t1.MID = t2.MID" +
//" WHERE t1.SendID = 0";
messageInfo = context.Database.SqlQuery <MyMessageModel>(sql)
.Skip((para.StartPage - 1) * para.PageCount)
.Take(para.PageCount).ToList();
var sqlCount = "SELECT" +
" t1.MID as MessageID,t1.Title,t1.Content," +
" (CASE WHEN t1.State = 0 then '未读' else '已读' end) as State," +
" CONVERT(varchar(100), t1.SendTime, 20) as Time" +
" FROM" +
" db_Message t1" +
" WHERE t1.State =0 AND t1.ReceiveID =" + para.UserID;
var messageInfoCount = context.Database.SqlQuery <MyMessageModel>(sqlCount)
.ToList().Count;
message.Message = messageInfoCount.ToString();
message.MessageCode = MESSAGE.OK_CODE;
}
returnResult.Add(message);
returnResult.Add(messageInfo);
result = jss.Serialize(returnResult);
return(result);
}
public static bool IsEnoughMoney(int userID, int Money)
{
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
int asset = Convert.ToInt32(context.db_AssetRecord.Where(c => c.UserID == userID).Sum(c => c.VirtualMoney));
//氦气不足
if (asset < Money)
{
return(false);
}
}
return(true);
}
public string GuessList()
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
List <GuessModel> guessList = new List <GuessModel>();
//获取竞猜列表
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//联合查询
var sql = "SELECT" +
" t1.GuessID as GuessID," +
" t2.GameStage as GuessName," +
" t2.HomeTeamID as STeamID," +
" t2.CustomerTeamID as ETeamID," +
" t3.TeamName as STeamName," +
" t3.TeamPicture as STeamLogo," +
" t4.TeamName as ETeamName," +
" t4.TeamPicture as ETeamLogo," +
" CONVERT(varchar(100), t2.EndTime, 20) as MatchTime," +
" t1.GuessName as GuessType," +
" t1.STeamOdds as STeamOdds," +
" t1.ETeamOdds as ETeamOdds," +
" (SELECT COUNT(s.GuessRecordID) FROM db_GuessRecord s WHERE s.GuessID = t1.GuessID) as AllUser," +
" ((CASE WHEN (SELECT SUM(s.BetMoney) FROM db_GuessRecord s WHERE s.GuessID = t1.GuessID) IS NUll THEN 0 ELSE (SELECT SUM(s.BetMoney) FROM db_GuessRecord s WHERE s.GuessID = t1.GuessID) END)) as AllMoney" +
" FROM" +
" db_MatchGuess t1" +
" LEFT JOIN db_FightResult t2 ON t1.ResultID = t2.ResultID" +
" LEFT JOIN db_Team t3 ON t2.HomeTeamID = t3.TeamID" +
" LEFT JOIN db_Team t4 ON t2.CustomerTeamID = t4.TeamID" +
" WHERE t1.State=0";
try
{
guessList = context.Database.SqlQuery <GuessModel>(sql)
.ToList();
}
catch (Exception ex)
{
}
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
returnResult.Add(message);
returnResult.Add(guessList);
}
result = jss.Serialize(returnResult);
return(result);
}
public static string GetUserPictureByUserID(int?userID)
{
string userPicture = "";
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
var user = context.db_User.Where(c => c.UserID == userID).FirstOrDefault();
if (user != null)
{
userPicture = user.UserWebPicture;
}
}
return(userPicture);
}
public static string GetRecruitContentByTeamID(int teamID)
{
string RecruitContent = "";
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
var Recruit = context.db_Recruit.Where(c => c.TeamID == teamID).FirstOrDefault();
if (Recruit != null)
{
RecruitContent = Recruit.Content;
}
}
return(RecruitContent);
}
public string GetTeambyPhone(string phoneNumber)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//判断战队名称是否存在
//判断是否有权限创建
}
result = jss.Serialize(message);
return(result);
}
