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