private void Start()
{
itemDataBase = GameObject.Find("ItemDB").GetComponent <ListItemDB>();
}
/// <summary>
/// 在将要挂起应用程序执行时调用。 在不知道应用程序
/// 无需知道应用程序会被终止还是会恢复，
/// 并让内存内容保持不变。
/// </summary>
/// <param name="sender">挂起的请求的源。</param>
/// <param name="e">有关挂起请求的详细信息。</param>
private void OnSuspending(object sender, SuspendingEventArgs e)
{
isSuspend = true;
var deferral = e.SuspendingOperation.GetDeferral();
//TODO: 保存应用程序状态并停止任何后台活动
//Get the frame navigation state serialized as a string and save in settings
Frame frame = Window.Current.Content as Frame;
ApplicationData.Current.LocalSettings.Values["NavigationState"] = frame.GetNavigationState();
/*
* using (var conn = ScheduleDB.GetDbConnection())
* {
* var listItemDBs = conn.Table<ListItemDB>();
*
* foreach (ListItem listitem in MainPage.ViewModel1.AllItems)
* {
* bool flag = true;
* foreach(ListItemDB listitemDB in listItemDBs)
* if (listitemDB.Id == listitem.Id)
* {
* listitemDB.ImgPath = listitem.ImgPath;
* listitemDB.Size = listitem.Size;
* listitemDB.Title = listitem.Title;
* listitemDB.Detail = listitem.Detail;
* listitemDB.Date = listitem.Date;
* listitemDB.Finish = listitem.Finish;
* conn.Update(listitemDB);
* flag = false;
* break;
* }
* if (flag)
* {
* ListItemDB listItemDB = new ListItemDB(listitem.Id, listitem.ImgPath, listitem.Size, listitem.Title, listitem.Detail, listitem.Date, listitem.Finish);
* conn.Insert(listItemDB);
* }
* }
*
* foreach (ListItemDB listitemDB in listItemDBs)
* {
* bool flag = false;
* foreach (ListItem listitem in MainPage.ViewModel1.AllItems)
* {
* if (listitem.Id == listitemDB.Id)
* {
* flag = true;
* break;
* }
* }
* if (flag == false)
* conn.Delete(listitemDB);
* }
* }
*/
using (var conn = ScheduleDB.GetDbConnection())
{
conn.DeleteAll <ListItemDB>();
foreach (ListItem listitem in MainPage.ViewModel1.AllItems)
{
//System.Diagnostics.Debug.WriteLine("!!!!!!!!!!!!!!!!!!!!" + listitem.Date.ToLocalTime().ToString() + "!!!!!!!!!!!!!!!!!\n");
ListItemDB listItemDB = new ListItemDB(listitem.Id, listitem.ImgPath, listitem.Size, listitem.Title, listitem.Detail, listitem.Date, listitem.Finish);
conn.Insert(listItemDB);
}
}
deferral.Complete();
}
