public void Adddatatosqlite(List <string> _datas) { Sqlitehelper helper = new Sqlitehelper("data source=skbrowser.db"); helper.InsertInto("histroy", _datas.ToArray()); helper.CloseSqlConnection(); }
private void Adddatatofavoritedb() { Sqlitehelper helper = new Sqlitehelper("data source=skbrowser.db"); SqliteDataReader sdr = helper.Readfromid("favorite_test", "id", item.id.ToString()); if (sdr.HasRows) { Uimanager.Getinstance().Showtips("已取消收藏"); helper.Delete("favorite_test", "id", item.id.ToString()); helper.CloseSqlConnection(); favorite.GetComponent <Image>().sprite = Resources.Load <Sprite>("Ui/btn_like_nor"); Favoriteview favoriteview = FindObjectOfType <Favoriteview>(); if (!favoriteview.favoritegameobjects.ContainsKey(item.id)) { return; } Destroy(favoriteview.favoritegameobjects[item.id]); favoriteview.favoritegameobjects.Remove(item.id); if (!favoriteview.favoriteoperation.favorite.ContainsKey(item.id)) { return; } favoriteview.favoriteoperation.favorite.Remove(item.id); return; } string itemjson = JsonUtility.ToJson(item); helper.InsertInto("favorite_test", new string[] { item.id.ToString(), item.itemname, itemjson }); Uimanager.Getinstance().Showtips("已添加至收藏"); favorite.GetComponent <Image>().sprite = Resources.Load <Sprite>("Ui/btn_like_sel"); }