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