private ObservableCollection <ActivityListViewItem> SelectAll()
{
ObservableCollection <ActivityListViewItem> list = new ObservableCollection <ActivityListViewItem>();
using (var db = MySQLiteHelper.CreateSQLiteConnection())
{
List <object> query = db.Query(new TableMapping(typeof(ActivityInfo)), "select * from ActivityInfo");
foreach (ActivityInfo mem in query)
{
ActivityInfo ai = mem;
//删除已过期的日子
if ((int)(ai.Date - DateTime.Now.Date).TotalDays < 0)
{
db.Delete(mem);
}
else
{
ActivityListViewItem info = new ActivityListViewItem()
{
ID = ai.ID,
Theme = ai.Theme,
Date = (int)(ai.Date - DateTime.Now.Date).TotalDays
};
list.Add(info);
}
}
db.Close();
}
return(list);
}
private void editButton_Click(object sender, RoutedEventArgs e)
{
if (MyListView.SelectedItems.Count > 0)
{
ActivityListViewItem temp = new ActivityListViewItem();
temp = (ActivityListViewItem)MyListView.SelectedItems[0];
Frame.Navigate(typeof(Scenario2), temp.ID);
}
}
private void deleteButton_Click(object sender, RoutedEventArgs e)
{
if (MyListView.SelectedItems.Count > 0)
{
ActivityListViewItem temp = new ActivityListViewItem();
temp = (ActivityListViewItem)MyListView.SelectedItems[0];
var db = MySQLiteHelper.CreateSQLiteConnection();
db.Delete <ActivityInfo>(temp.ID);
init();
}
}
private ObservableCollection <ActivityListViewItem> SelectTop()
{
ObservableCollection <ActivityListViewItem> list = new ObservableCollection <ActivityListViewItem>();
using (var db = MySQLiteHelper.CreateSQLiteConnection())
{
List <object> query = db.Query(new TableMapping(typeof(ActivityInfo)), "select * from ActivityInfo");
if (query.Count == 0)
{
return(list);
}
ActivityInfo nearest = (ActivityInfo)query[0];
foreach (ActivityInfo mem in query)
{
ActivityInfo ai = mem;
if (ai.isTop == true)
{
ActivityListViewItem info = new ActivityListViewItem()
{
ID = ai.ID,
Theme = ai.Theme,
Date = (int)(ai.Date - DateTime.Now.Date).TotalDays
};
list.Add(info);
db.Close();
return(list);
}
else
{
//选取不过期，但最近的日子
if ((int)(ai.Date - DateTime.Now.Date).TotalDays > 0 && (int)(ai.Date - nearest.Date).TotalDays < 0)
{
nearest = ai;
}
}
}
ActivityListViewItem near = new ActivityListViewItem()
{
ID = nearest.ID,
Theme = nearest.Theme,
Date = (int)(nearest.Date - DateTime.Now.Date).TotalDays
};
list.Add(near);
db.Close();
return(list);
}
}
private ObservableCollection<ActivityListViewItem> SelectTop()
{
ObservableCollection<ActivityListViewItem> list = new ObservableCollection<ActivityListViewItem>();
using (var db = MySQLiteHelper.CreateSQLiteConnection())
{
List<object> query = db.Query(new TableMapping(typeof(ActivityInfo)), "select * from ActivityInfo");
if (query.Count == 0)
{
return list;
}
ActivityInfo nearest = (ActivityInfo)query[0];
foreach (ActivityInfo mem in query)
{
ActivityInfo ai = mem;
if (ai.isTop == true)
{
ActivityListViewItem info = new ActivityListViewItem()
{
ID = ai.ID,
Theme = ai.Theme,
Date = (int)(ai.Date - DateTime.Now.Date).TotalDays
};
list.Add(info);
db.Close();
return list;
}
else
{
//选取不过期，但最近的日子
if ((int)(ai.Date - DateTime.Now.Date).TotalDays > 0 && (int)(ai.Date - nearest.Date).TotalDays < 0)
nearest = ai;
}
}
ActivityListViewItem near = new ActivityListViewItem()
{
ID = nearest.ID,
Theme = nearest.Theme,
Date = (int)(nearest.Date - DateTime.Now.Date).TotalDays
};
list.Add(near);
db.Close();
return list;
}
}
private void editButton_Click(object sender, RoutedEventArgs e)
{
if (MyListView.SelectedItems.Count > 0)
{
ActivityListViewItem temp = new ActivityListViewItem();
temp = (ActivityListViewItem)MyListView.SelectedItems[0];
Frame.Navigate(typeof(Scenario2), temp.ID);
}
}
private void deleteButton_Click(object sender, RoutedEventArgs e)
{
if (MyListView.SelectedItems.Count > 0)
{
ActivityListViewItem temp = new ActivityListViewItem();
temp = (ActivityListViewItem)MyListView.SelectedItems[0];
var db = MySQLiteHelper.CreateSQLiteConnection();
db.Delete<ActivityInfo>(temp.ID);
init();
}
}
private ObservableCollection<ActivityListViewItem> SelectAll()
{
ObservableCollection<ActivityListViewItem> list = new ObservableCollection<ActivityListViewItem>();
using (var db = MySQLiteHelper.CreateSQLiteConnection())
{
List<object> query = db.Query(new TableMapping(typeof(ActivityInfo)), "select * from ActivityInfo");
foreach (ActivityInfo mem in query)
{
ActivityInfo ai = mem;
//删除已过期的日子
if ((int)(ai.Date - DateTime.Now.Date).TotalDays < 0)
{
db.Delete(mem);
}
else
{
ActivityListViewItem info = new ActivityListViewItem()
{
ID = ai.ID,
Theme = ai.Theme,
Date = (int)(ai.Date - DateTime.Now.Date).TotalDays
};
list.Add(info);
}
}
db.Close();
}
return list;
}
