static public void Write(string SheetName, string TableKey, string TableValue, string DataKey, string DataValue) { IAPConfigData pIapConfigData = new IAPConfigData(); CocoSqliteDBHelper db = new CocoSqliteDBHelper(DBTool.LocalPath); int pTableCount = db.FindTable(SheetName, DBTool.LocalPath); if (pTableCount == 0) { db.CreateTable(SheetName, new string[] { TableKey, TableValue }, new string[] { "text", "text" }); } SqliteDataReader pDataReader = db.SelectWhere( SheetName, new string[] { TableValue }, new string[] { TableKey }, new string[] { "=" }, new string[] { DataKey }); if (pDataReader.Read()) { db.Delete( SheetName, new string[] { TableKey }, new string[] { "'" + DataKey + "'" } ); } pDataReader.Close(); db.InsertInto(SheetName, new string[] { "'" + DataKey + "'", "'" + DataValue + "'" }); db.CloseSqlConnection(); }
private void WriteAllItemsDataToItemConfig() { string pPath = "data source=" + Application.streamingAssetsPath + "/DB/game.db"; CocoSqliteDBHelper db = new CocoSqliteDBHelper(pPath); string pTableName = "item_config"; int pCount = db.FindTable(pTableName, pPath); int pTotalItem = 0; if (pCount != 0) { //首先清除之前所有的数据 db.DeleteContents(pTableName); List <CocoStoreItem> pAllStoreItems = CocoStoreData.Instance.allProductItems; foreach (var storeItem in pAllStoreItems) { string pKey = "'" + storeItem.itemIdString + "'"; ItemConfigData pData = new ItemConfigData(); pData.id = storeItem.itemIdString; pData.name = storeItem.productId.ToString(); pData.iapConfigId = storeItem.itemIdString; string pValue = "'" + JsonMapper.ToJson(pData) + "'"; db.InsertInto(pTableName, new[] { pKey, pValue }); Debug.LogWarning("Write Data For Item Config Success ! : ( " + pKey + "," + pValue + ")"); pTotalItem += 1; } } db.CloseSqlConnection(); //avoid to database is locked Debug.LogWarning("Write Item Config Data Success ! Total (写入成功!总共):" + pTotalItem.ToString()); }
private void WriteAllItemsDataToIapConfig() { string pPath = "data source=" + Application.streamingAssetsPath + "/DB/game.db"; CocoSqliteDBHelper db = new CocoSqliteDBHelper(pPath); string pTableName = "iap_config"; int pCount = db.FindTable(pTableName, pPath); int pTotalItem = 0; if (pCount != 0) { //首先清除之前所有的数据 db.DeleteContents(pTableName); List <CocoStoreItem> pAllStoreItems = CocoStoreData.Instance.allProductItems; foreach (var storeItem in pAllStoreItems) { string pKey = "'" + storeItem.itemIdString + "'"; IAPConfigData pData = new IAPConfigData(); pData.id = storeItem.itemIdString; pData.name = storeItem.productId.ToString(); pData.noAdsIap = storeItem.isNoAdsLap; switch (storeItem.productType) { case ProductType.Consumable: pData.consumable = true; break; case ProductType.Subscription: pData.isSubscription = true; break; } pData.iapData = new List <IAPData> (); if (!string.IsNullOrEmpty(storeItem.iosIapString)) { pData.iapData.Add(new IAPData { store = StoreType.iOS, iapId = storeItem.iosIapString }); } if (!string.IsNullOrEmpty(storeItem.gpIapString)) { pData.iapData.Add(new IAPData { store = StoreType.Google, iapId = storeItem.gpIapString }); } if (!string.IsNullOrEmpty(storeItem.amIapString)) { pData.iapData.Add(new IAPData { store = StoreType.Amazon, iapId = storeItem.amIapString }); } string pValue = "'" + JsonMapper.ToJson(pData) + "'"; db.InsertInto(pTableName, new[] { pKey, pValue }); Debug.LogWarning("Write Data For IAP Config Success ! : ( " + pKey + "," + pValue + ")"); pTotalItem += 1; } } db.CloseSqlConnection(); //avoid to database is locked Debug.LogWarning("Write IAP Config Data Success ! Total (写入成功!总共):" + pTotalItem.ToString()); }