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