public void Getdataformsqlite(Action _action)
{
Sqlitehelper helper = new Sqlitehelper("data source=skbrowser.db");
SqliteDataReader sdr = helper.ReadFullTable("histroy");
while (sdr.Read())
{
Item item = new Item();
item.id = sdr.GetInt16(MappingSqlitedatareader("id", sdr));
item.bunletype =
(Bundletype)Enum.Parse(typeof(Bundletype), sdr.GetString(MappingSqlitedatareader("bundletype", sdr)));
item.bundleurlandroid = sdr.GetString(MappingSqlitedatareader("bundleurlandroid", sdr));
item.bundleurlios = sdr.GetString(MappingSqlitedatareader("bundleurlios", sdr));
item.category = sdr.GetString(MappingSqlitedatareader("category", sdr));
item.description = sdr.GetString(MappingSqlitedatareader("description", sdr));
item.thumbnails = sdr.GetString(MappingSqlitedatareader("thumbnails", sdr));
item.itemname = sdr.GetString(MappingSqlitedatareader("itemname", sdr));
item.trackerid = sdr.GetString(MappingSqlitedatareader("trackerid", sdr));
item.trackerurl = sdr.GetString(MappingSqlitedatareader("trackerurl", sdr));
item.tutorthumbnail = sdr.GetString(MappingSqlitedatareader("tutorthumbnail", sdr));
item.tutourl = sdr.GetString(MappingSqlitedatareader("tutourl", sdr));
item.visiblc = bool.Parse(sdr.GetString(MappingSqlitedatareader("visible", sdr)));
histroy.Add(item);
}
helper.CloseSqlConnection();
if (_action != null)
{
_action.Invoke();
}
}
public void Getdataformsqlite(Action _action)
{
Sqlitehelper helper = new Sqlitehelper("data source=skbrowser.db");
SqliteDataReader sdr = helper.ReadFullTable("favorite_test");
while (sdr.Read())
{
Item item = new Item();
int id = sdr.GetInt16(MappingSqlitedatareader("id", sdr));
//不重复为已存在收藏表（数据库）中的数据进行解析
if (favorite.ContainsKey(id))
{
continue;
}
Debug.Log(sdr.GetString(MappingSqlitedatareader("jsondata", sdr)));
item = JsonUtility.FromJson <Item>(sdr.GetString(MappingSqlitedatareader("jsondata", sdr)));
favorite.Add(item.id, item);
}
helper.CloseSqlConnection();
if (_action != null)
{
_action.Invoke();
}
}
