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