/// <summary>
/// 获取金币
/// </summary>
/// <param name="playerId"></param>
/// <param name="dataId"></param>
/// <returns></returns>
public IPlayerCurrency GetCurrency(string playerId, string dataId)
{
var currencies = GameInstance.dbDataUtils.ExecuteReader(@"SELECT * FROM playerCurrency WHERE playerId=@playerId AND Guid=@Guid LIMIT 1",
new SqliteParameter("@playerId", playerId),
new SqliteParameter("@Guid", dataId));
IPlayerCurrency currency = null;
if (!currencies.Read())
{
currency = new IPlayerCurrency();
currency.guid = IPlayerCurrency.GetId(playerId, dataId);
currency.playerId = playerId;
//GameInstance.dbDataUtils.ExecuteNonQuery(@"INSERT INTO playerCurrency (id, playerId, Guid, amount, purchasedAmount) VALUES (@id, @playerId, @Guid, @amount, @purchasedAmount)",
// new SqliteParameter("@id", currency.Id),
// new SqliteParameter("@playerId", currency.PlayerId),
// new SqliteParameter("@Guid", currency.DataId),
// new SqliteParameter("@amount", currency.Amount),
// new SqliteParameter("@purchasedAmount", currency.PurchasedAmount));
}
else
{
//currency = new IPlayerCurrency();
//currency.Id = currencies.GetString(0);
//currency.PlayerId = currencies.GetString(1);
//currency.DataId = currencies.GetString(2);
//currency.Amount = currencies.GetInt32(3);
//currency.PurchasedAmount = currencies.GetInt32(4);
}
return(currency);
}
public void Init()
{
ConfigSQLite3Operate = SQLite3Factory.OpenToRead("Database.db");
LocalSQLite3Operate = SQLite3Factory.OpenToWrite("Dynamic.db");
CheckTable();
IPlayer.Init();
IPlayerBattle.Init();
ICharacter.Init();
IEquipment.Init();
IPlayerBattle.Init();
IPlayerClearStage.Init();
IPlayerCurrency.Init();
IPlayerFormation.Init();
IPlayerHasCharacters.Init();
IPlayerHasEquips.Init();
IPlayerOtherItem.Init();
IPlayerStamina.Init();
IPlayerUnlockItem.Init();
//IPlayerHasEquips.InsertNewEquips("2001");
//IPlayerHasCharacters.InsertNewCharacter("1001");
}
