public List <EAccount> ListAllAIUser() { List <EAccount> allaiuser = DBBase.Query <EAccount>("IsAI=1"); if (allaiuser.Count == 0) { List <EAccount> maxidlist = DBBase.QueryCustom <EAccount>("SELECT MAX(ID) as ID from account"); int maxid = 1; if (maxidlist.Count > 0) { EAccount maxAccount = maxidlist.FirstOrDefault(); maxid = maxAccount.ID + 1; } StringBuilder createBuilder = new StringBuilder(); for (int i = 0; i < 1000; i++) { createBuilder.Append(string.Format("INSERT INTO `account` VALUES('{0}', null, null, '{1}', '{2}', '{3}', null, '2017-06-29 09:31:47', '2017-07-06 10:28:28', '0', '9728', '9820', '0', 'WindowsPlayer', 'QQ', '106.522762', '29.505817', '重庆市九龙坡区杨家坪直港大道天鹅堡别墅旁', '0', '', '', '', '0', '2017-06-29 09:31:47', 1,0,'2017-06-29 09:31:47','2017-06-29 09:31:47','');", maxid++, AIUserRandomAttr.getRandomName(), AIUserRandomAttr.GetRandomFace(), "aiopenid" + i)); } DBBase.ExcuteCustom(createBuilder.ToString()); allaiuser = DBBase.Query <EAccount>("IsAI=1"); } return(allaiuser); }
public MyResult ClearMyTips(MessageType par0, int par1) { DBBase.ExcuteCustom(string.Format("delete from newtips where UserID={0} and `Type`={1} and OwnerID={2}", MySession.UserID, (int)par0, par1)); List <ENewTips> plist = DBBase.Query <ENewTips>("UserID=" + MySession.UserID); return(ServiceResult(plist)); }
public MyResult ConfirmConnect(int par0, bool par1) { EPeople people = DBBase.Get <EPeople>(par0); if (par1) { people.State = Entity.Enum.PeopleState.Normal; EPeople other = DBBase.Query <EPeople>(string.Format("UserID={0} and PeopleID={1}", people.PeopleID, people.UserID)).FirstOrDefault(); if (other != null) { other.State = Entity.Enum.PeopleState.Normal; DBBase.Change(other); } DBBase.Change(people); } else { EPeople other = DBBase.Query <EPeople>(string.Format("UserID={0} and PeopleID={1}", people.PeopleID, people.UserID)).FirstOrDefault(); if (other != null) { DBBase.Delete <EPeople>(other.ID); } DBBase.Delete <EPeople>(people.ID); } return(ServiceResult("ok")); }
public void RecordBattle(Battle battle, List <Battle> log) { EBattleRecord record = DBBase.Query <EBattleRecord>("BattleCode='" + battle.Code + "' and GameNum=" + battle.CurGameNum).FirstOrDefault(); if (record == null) { return; } record.EndTime = DateTime.Now; record.IsFinished = true; record.BattleContent = JsonConvert.SerializeObject(log); foreach (var s in battle.Sides) { if (s.AccountID == record.Sider1ID.ToString()) { record.Sider1Score = s.TotalScore; } else if (s.AccountID == record.Sider2ID.ToString()) { record.Sider2Score = s.TotalScore; } else if (s.AccountID == record.Sider3ID.ToString()) { record.Sider3Score = s.TotalScore; } else if (s.AccountID == record.Sider4ID.ToString()) { record.Sider4Score = s.TotalScore; } } DBBase.Change(record); }
public MyResult Create(string par0) { EPeople p = JsonConvert.DeserializeObject <EPeople>(par0); DBBase.Create(p); List <EUser> alluser = DBBase.Query <EUser>(); return(ServiceResult(alluser)); }
public MyResult GetPlan(int par0) { EPlan plan = DBBase.Query <EPlan>("ProjectID=" + par0).FirstOrDefault(); MyResult ret = ServiceResult(plan); EProject project = DBBase.Get <EProject>(par0); ret.ServiceReturn.AddData("ProjectName", project.Name); return(ret); }
public void JoinBattle(string ip, string port, int accountID, int curGameNum, string battleCode, int takeGold, int taleDiamon) { try { EAccount account = DBBase.Get <EAccount>(accountID); account.BattleIP = ip; account.BattlePort = port; account.BattleCode = battleCode.ToString(); if (curGameNum == 1) { account.Gold += takeGold; account.Diamond += taleDiamon; } DBBase.Change(account); EBattleRecord record = DBBase.Query <EBattleRecord>("BattleCode='" + battleCode + "' and GameNum=" + curGameNum).FirstOrDefault(); if (record == null) { //创建记录 record = new EBattleRecord() { BeginTime = DateTime.Now, EndTime = DateTime.Now, BattleCode = battleCode, Sider1ID = accountID, IsFinished = false, GameNum = curGameNum }; DBBase.Create(record); } else { if (record.Sider1ID == 0) { record.Sider1ID = accountID; } else if (record.Sider2ID == 0) { record.Sider2ID = accountID; } else if (record.Sider3ID == 0) { record.Sider3ID = accountID; } else if (record.Sider4ID == 0) { record.Sider4ID = accountID; } DBBase.Change(record); } } catch (Exception ex) { Console.Write(ex.Message + " " + ex.StackTrace); } }
public MyResult GetValue(string par0) { EConfigure obj = DBBase.Query <EConfigure>("`Key`='" + par0 + "'").FirstOrDefault(); if (obj == null) { return(ServiceErrorResult("未找到数据")); } else { return(ServiceResult(obj)); } }
public MyResult SearchUser(string par0) { List <EUser> retUserList = null; if (!string.IsNullOrEmpty(par0)) { retUserList = DBBase.Query <EUser>("ID<>" + MySession.UserID + " and Name like '%" + par0 + "%' order by ID desc limit 20"); } else { retUserList = DBBase.Query <EUser>("ID<>" + MySession.UserID + " order by ID desc limit 20"); } return(ServiceResult(retUserList)); }
public MyResult DisConnect(int par0) { EPeople people = DBBase.Query <EPeople>(string.Format("UserID={0} and PeopleID={1}", MySession.UserID, par0)).FirstOrDefault(); EPeople other = DBBase.Query <EPeople>(string.Format("UserID={0} and PeopleID={1}", par0, MySession.UserID)).FirstOrDefault(); if (people != null) { DBBase.Delete <EPeople>(people.ID); } if (other != null) { DBBase.Delete <EPeople>(other.ID); } return(ServiceResult("ok")); }
public EAccount Login(string userName, string password, string pushClientID) { EAccount user = DBBase.Query <EAccount>("UserName='******'").FirstOrDefault(); if (user == null) { throw new Exception("用户名或密码不正确"); } if (user.Password != password) { throw new Exception("用户名或密码不正确"); } //修改客户端推送ID user.PushClientID = pushClientID; DBBase.Change(user); return(user); }
public MyResult SetDefault(int par0) { List <EUserSearch> plist = DBBase.Query <EUserSearch>("UserID=" + MySession.UserID); foreach (var s in plist) { if (s.ID == par0) { s.IsDefault = true; } else { s.IsDefault = false; } DBBase.Change(s); } return(ServiceResult("ok")); }
public EAccount Get(int accountid) { EAccount user = DBBase.Get <EAccount>(accountid); if (user == null) { throw new Exception("用户不存在"); } List <EBattleServers> serverList = DBBase.Query <EBattleServers>(); EBattleServers server = serverList.FirstOrDefault(c => c.ID == 1); user.CurBattleIP = server.IP; user.CurBattlePort = server.Port; int referrerCount = DBBase.Query <EAccount>("ReferrerID=" + user.ID + "").Count(); user.CurTaskProcess = referrerCount; return(user); }
public MyResult PlatformLogin(string par0, string par1, string par2, string par3) { EUser user = DBBase.Query <EUser>("OpenID='" + par0 + "'").FirstOrDefault(); if (user == null) { user = new EUser() { OpenID = par0, Name = par1, Face = par2, PushClientID = par3 }; user = (EUser)DBBase.Create(user); InitUser(user); } else { //修改客户端推送ID user.PushClientID = par3; DBBase.Change(user); } return(ServiceResult(user)); }
public int AddFriends(int accountid, int friendid) { EAccount friendAoount = DBBase.Get <EAccount>(friendid); if (friendAoount == null) { return(-1); } List <EFriends> oldFriends = DBBase.Query <EFriends>(string.Format("AccountID={0} and FriendID={1}", accountid, friendid)); if (oldFriends.Count > 0) { return(-1); } EFriends friend = new EFriends() { AccountID = accountid, FriendID = friendid }; DBBase.Create(friend); return(0); }
public MyResult Regist(string par0) { EUser obj = JsonConvert.DeserializeObject(par0, typeof(EUser)) as EUser; if (string.IsNullOrEmpty(obj.Phone) || string.IsNullOrEmpty(obj.Password)) { return(ServiceErrorResult("账号密码不能为空")); } else { EUser olduser = DBBase.Query <EUser>("Phone='" + obj.Phone + "'").FirstOrDefault(); if (olduser != null) { return(ServiceErrorResult("账号已存在")); } else { EUser newObj = DBBase.Create(obj) as EUser; InitUser(newObj); return(ServiceResult(newObj.ID)); } } }
/// <summary> /// 用户登录 /// </summary> /// <param name="par0">账号</param> /// <param name="par1">密码</param> /// <returns></returns> public MyResult Login(string par0, string par1, string par2) { EUser user = DBBase.Query <EUser>("Phone='" + par0 + "'").FirstOrDefault(); if (user == null) { return(ServiceErrorResult("用户名或密码不正确")); } else { if (user.Password != par1) { return(ServiceErrorResult("用户名或密码不正确")); } else { //修改客户端推送ID user.PushClientID = par2; DBBase.Change(user); return(ServiceResult(user)); } } }
public List <EStore> AllProps(int accountid) { return(DBBase.Query <EStore>()); }
public MyResult ListByProjectID(int par0) { List <EProjectTaskStep> steps = DBBase.Query <EProjectTaskStep>("ProjectID=" + par0); return(ServiceResult(steps)); }
public MyResult StartData() { List <EUser> allUser = DBBase.Query <EUser>(); return(ServiceResult(allUser)); }
public EAccount PlatformLogin(string userInfo) { LogHelper.DebugLog("PlatformLogin:"******"\p{Cs}", ""); string iconUrl = pars[3]; string longitude = pars[4]; string latitude = pars[5]; string address = pars[6]; string systemName = pars[7]; if (platform == "WX" && !iconUrl.Contains("http:")) { string json = HttpService.Get(WXHelper.getCodeRequestUrl(iconUrl)); TokenAndOpenID tokenAndOpenID = JsonConvert.DeserializeObject <TokenAndOpenID>(json); if (tokenAndOpenID != null) { openID = tokenAndOpenID.openid; string json2 = HttpService.Get(WXHelper.getUserInfoUrl(tokenAndOpenID.access_token, tokenAndOpenID.openid)); UserInfo userinfo = JsonConvert.DeserializeObject <UserInfo>(json2); if (userinfo != null) { nickName = userinfo.nickname; iconUrl = userinfo.headimgurl; } } } EAccount user = DBBase.Query <EAccount>("OpenID='" + openID + "'").FirstOrDefault(); if (user == null) { user = new EAccount() { OpenID = openID, NickName = nickName, Face = iconUrl, Longitude = longitude, Latitude = latitude, Address = address, PlatformName = platform, CreateTime = DateTime.Now, LastLoginTime = DateTime.Now, SystemName = systemName, LastGetGoldTime = DateTime.Now, Gold = 1000, Diamond = 0 }; user = (EAccount)DBBase.Create(user); } else { //修改客户端推送ID user.Longitude = longitude; user.Latitude = latitude; user.Address = address; user.SystemName = systemName; user.LastLoginTime = DateTime.Now; double dayNum = (DateTime.Now - user.LastGetGoldTime).TotalDays; user.Gold += user.Vip * (int)dayNum * 10; user.LastGetGoldTime = DateTime.Now; DBBase.Change(user); } //创建登录记录 ELoginRecord loginRecord = new ELoginRecord() { AccountID = user.ID, LoginTime = DateTime.Now }; DBBase.Create(loginRecord); int referrerCount = DBBase.Query <EAccount>("ReferrerID=" + user.ID + "").Count(); if (referrerCount > user.TaskProcess) { user.TaskProcess = referrerCount; int taskGetDiamon = 0; if (user.TaskProcess == 1) { taskGetDiamon = 10; } else if (user.TaskProcess == 10) { taskGetDiamon = 100; } else if (user.TaskProcess == 20) { taskGetDiamon = 200; } else if (user.TaskProcess == 50) { taskGetDiamon = 500; } user.Diamond += taskGetDiamon; DBBase.Change(user); } List <EBattleServers> serverList = DBBase.Query <EBattleServers>(); EBattleServers server = serverList.FirstOrDefault(c => c.ID == 1); user.CurBattleIP = server.IP; user.CurBattlePort = server.Port; user.CurTaskProcess = referrerCount; return(user); }
public MyResult ListMyTips() { List <ENewTips> plist = DBBase.Query <ENewTips>("UserID=" + MySession.UserID); return(ServiceResult(plist)); }
public MyResult ListMyProject() { List <EProject> plist = DBBase.Query <EProject>("CreaterID=" + MySession.UserID); return(ServiceResult(plist)); }
public MyResult ListTeamProject() { List <EProject> plist = DBBase.Query <EProject>("ID in (select ProjectID from projectteam where UserID=" + MySession.UserID + ")"); return(ServiceResult(plist)); }
public MyResult ListMyProjectID(int par0) { List <EPlan> plist = DBBase.Query <EPlan>("ProjectID=" + par0); return(ServiceResult(plist)); }