public bool TryLogin(int account, int password) { if (!CheckTable(userTableName)) { return(false); } string[] items = { "Account", "Password", }; string[] selectKeys = { "UserId", }; string[] selectValues = { $"'{account}'", }; var dr = SelectWhereEqual(userTableName, items, selectKeys, selectValues); while (dr.Read()) { string drAccount = dr.GetString(dr.GetOrdinal("Account")); string drPassword = dr.GetString(dr.GetOrdinal("Password")); if (account.ToString() == drAccount && password.ToString() == drPassword) { if (!m_UserTable.HasDBRow(account)) { DBUser dbUser = new DBUser(account, password); dbUser.Load(); m_UserTable.AddDBRow(account, dbUser); } m_DBTableManager.Init(account); m_UserData = GetDBRow <DBUser>(account); //CloseSqlConnection(); return(true); } } return(false); }
/// <summary> /// 添加数据行当数据表 /// </summary> /// <typeparam name="T">数据行类型</typeparam> /// <param name="dbTable">数据表</param> /// <param name="id">编号</param> /// <param name="dbRow">数据行</param> public void AddDBRow <T>(int id, IDBRow dbRow) where T : IDBRow { IDBTable <T> dbTable = GetDBTable <T>(); dbTable.AddDBRow(id, (T)dbRow); }