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"); }
/// <summary> /// 对按钮添加相应事件 /// </summary> public void OnEnable() { description.text = item.description; title.text = item.itemname; if (mediaplayer != null) { mediaplayer.Load(item.tutourl); mediaplayer.Pause(); } //设置下载按钮文字,若是已缓存至本地则为false,反之 if (!SKassetbundlehelper.instance.Checkcache(item.Getitemurl(), item.version)) { downloadtext.text = "<color=#3266BAFF>点击下载</color>"; downloadprogress.fillAmount = 0; } else { downloadtext.text = "<color=white>进入体验</color>"; downloadprogress.fillAmount = 1; } if (item != null) { Browser.Getinstance().GetMarkless(item.tutorthumbnail, Setuptutorthumbnail, null, videopayer); } #if VERSION2_0 Sqlitehelper helper = new Sqlitehelper("data source=skbrowser.db"); SqliteDataReader sdr = helper.Readfromid("favorite_test", "id", item.id.ToString()); if (sdr.HasRows) { favorite.GetComponent <Image>().sprite = Resources.Load <Sprite>("Ui/btn_like_sel"); } else { favorite.GetComponent <Image>().sprite = Resources.Load <Sprite>("Ui/btn_like_nor"); } helper.CloseSqlConnection(); #endif }