/// <summary> /// 创建帐号 /// </summary> /// <param name="account">帐号</param> /// <param name="password">密码</param> public void Create(string account, string password) { AccountModle accountModle = new AccountModle(ID.Add_Get(), account, password); accDic.Add(account, accountModle); MysqlPeer.Instance.AddAccount(accountModle); }
/// <summary> /// 获取在线玩家的ID /// </summary> /// <param name="clientPeer">客户端连接对象</param> /// <returns></returns> public int GetOnlineID(ClientPeer clientPeer) { string account = Client_accDic[clientPeer]; AccountModle accountModle = accDic[account]; return(accountModle.ID); }
public AccountModle GetAccountModleByAcc(string account) { if (IsAccontExist(account) && OpenConnection()) { string query = string.Format("select * from account where account = '{0}';", account); AccountModle accountModle = null; MySqlCommand sqlCommand = new MySqlCommand(query, SqlConnection); MySqlDataReader mySqlDataReader = sqlCommand.ExecuteReader(); while (mySqlDataReader.Read()) { int id = AccountCache.Instance.ID.Add_Get(); string pwd = mySqlDataReader["password"] + ""; accountModle = new AccountModle(id, account, pwd); } mySqlDataReader.Close(); CloseConnection(); return(accountModle); } return(null); //throw new Exception("该帐号的数据在数据库中不存在GetAccountModleByAcc()"); }
/// <summary> /// 判断帐号是否已经存在 /// </summary> public bool IsExist(string account) { if (!accDic.ContainsKey(account)) { AccountModle accountModle = MysqlPeer.Instance.GetAccountModleByAcc(account); if (accountModle != null) { accDic.Add(account, accountModle); } } return(accDic.ContainsKey(account)); }
/// <summary> /// 增加账号数据 /// </summary> /// <param name="data"></param> public void AddAccount(AccountModle accountModle) { string query = string.Format("insert into account (account,password) values('{0}','{1}');", accountModle.Account, accountModle.PassWord); if (this.OpenConnection()) { //如果数据库打开成功 MySqlCommand sqlCommand = new MySqlCommand(query, SqlConnection); sqlCommand.ExecuteNonQuery(); CloseConnection(); } }
/// <summary> /// 判断帐号密码是否匹配 /// </summary> /// <param name="account"></param> /// <param name="password"></param> /// <returns></returns> public bool isMatch(string account, string password) { AccountModle accountModle = accDic[account]; return(accountModle.PassWord == password); }
/// <summary> /// 获取在线玩家的ID /// </summary> /// <param name="account">在线玩家帐号</param> /// <returns></returns> public int GetOnlineID(string account) { AccountModle accountModle = accDic[account]; return(accountModle.ID); }