private void SureButton_Click(object sender, RoutedEventArgs e)
{
SQLiteConnection db = MySQLiteHelper.CreateSQLiteConnection();
List <object> query = db.Query(new TableMapping(typeof(ActivityInfo)), "select * from ActivityInfo");
//如果出现置顶，将其他置顶设为false
if ((bool)isTopSwitch.IsOn == true)
{
foreach (ActivityInfo mem in query)
{
mem.isTop = false;
db.Update(mem);
}
}
foreach (ActivityInfo mem in query)
{
if (mem.ID == ID)
{
mem.Date = MyDate.Date.Date;
mem.isTop = (bool)isTopSwitch.IsOn;
if (Title.Text == String.Empty)
{
Title.Text = "某天";
}
mem.Theme = Title.Text;
mem.Content = TextSource.Text;
db.Update(mem);
}
}
db.Close();
Frame.Navigate(typeof(MainPage));
}
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 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);
}
}
//进入时注册DataRequested事件
protected override void OnNavigatedTo(NavigationEventArgs e)
{
ID = (int)e.Parameter;
dtm = DataTransferManager.GetForCurrentView();
SQLiteConnection db = MySQLiteHelper.CreateSQLiteConnection();
//初始化界面设置
List <object> query = db.Query(new TableMapping(typeof(ActivityInfo)), "select * from ActivityInfo");
foreach (ActivityInfo mem in query)
{
if (mem.ID == ID)
{
Title.Text = mem.Theme;
TextSource.Text = mem.Content;
MyDate.Date = mem.Date;
isTopSwitch.IsOn = mem.isTop;
}
}
db.Close();
}