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