public static void EditDatabase(int num, string id, string json, string id_system)
{
var conn = new SQLiteConnection(new SQLitePlatformWinRT(), Path.Combine(ApplicationData.Current.LocalFolder.Path, "RemindList.db"));
var up = conn.Table <RemindListDB>();
//机智的我，删除和插入替换了update
//bool isfound_id, isfound_id_system;
//isfound_id = isfound_id_system = true;
//if (id == null)
// isfound_id = false;
//if (id_system == null)
// isfound_id_system = false;
//if (isfound_id)
// up.Delete(x => x.Id.Equals(id));
//else if (isfound_id_system)
// up.Delete(x => x.Id_system.Equals(id_system));
//else if (isfound_id_system && isfound_id)
// up.Delete(x => x.Id .Equals( id) && x.Id_system.Equals( id_system));
//else
//{
//}
up.Delete(x => x.Num == num);
RemindListDB temp = new RemindListDB()
{
Id = id, Id_system = id_system, json = json
};
conn.Insert(temp);
conn.Dispose();
}
public static RemindListDB ToModel(string id)
{
RemindListDB item = new RemindListDB();
using (var conn = new SQLiteConnection(new SQLitePlatformWinRT(), Path.Combine(ApplicationData.Current.LocalFolder.Path, "RemindList.db")))
{
item = (from p in conn.Table <RemindListDB>()
where p.Id == id
select p).FirstOrDefault();
}
return(item);
}
public static void EditDatabase(int num, string id, string json, string id_system)
{
var conn = new SQLiteConnection(new SQLitePlatformWinRT(), Path.Combine(ApplicationData.Current.LocalFolder.Path, "RemindList.db"));
var up = conn.Table<RemindListDB>();
//机智的我，删除和插入替换了update
//bool isfound_id, isfound_id_system;
//isfound_id = isfound_id_system = true;
//if (id == null)
// isfound_id = false;
//if (id_system == null)
// isfound_id_system = false;
//if (isfound_id)
// up.Delete(x => x.Id.Equals(id));
//else if (isfound_id_system)
// up.Delete(x => x.Id_system.Equals(id_system));
//else if (isfound_id_system && isfound_id)
// up.Delete(x => x.Id .Equals( id) && x.Id_system.Equals( id_system));
//else
//{
//}
up.Delete(x => x.Num == num);
RemindListDB temp = new RemindListDB() { Id = id, Id_system = id_system, json = json };
conn.Insert(temp);
}
