private void DeleteBar_Click(object sender, RoutedEventArgs e) { if (ViewModles.SelectItem != null) { string sql = @"DELETE FROM MyTodo WHERE ID = ?"; try { using (var res = conn.Prepare(sql)) { res.Bind(1, ViewModles.SelectItem.id); res.Step(); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } ViewModles.DeleteItem(); ViewModles.SelectItem = null; ///Frame.Navigate(typeof(MainPage)); Frame rootFrame = Window.Current.Content as Frame; rootFrame.GoBack(); TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count); } }
private void Delete_Click(object sender, RoutedEventArgs e) { /*createButton.Content = "Create"; * CancelButton_Click(null, null); * string sql = @"DELETE FROM MyToDo WHERE ID=?"; * try * { * using (var cus = conn.Prepare(sql)) * { * cus.Bind(1, ViewModles.SelectItem.id); * cus.Step(); * //var data = (sender as FrameworkElement).DataContext; * //var item = MyListView.ContainerFromItem(data) as ListViewItem; * //ViewModles.SelectItem = item.Content as MyList; * * } * } * catch (Exception ex) * { * Debug.WriteLine(ex.Message); * } * ViewModles.DeleteItem(); * ViewModles.SelectItem = null; * TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count);*/ dynamic ori = e.OriginalSource; ViewModles.SelectItem = (Modle.MyList)ori.DataContext; if (ViewModles.SelectItem != null) { string sql = @"DELETE FROM MyTodo WHERE ID = ?"; try { using (var res = conn.Prepare(sql)) { res.Bind(1, ViewModles.SelectItem.id); res.Step(); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } ViewModles.DeleteItem(); ViewModles.SelectItem = null; // Frame.Navigate(typeof(MainPage), ViewModles); TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count); } }
public App() { this.InitializeComponent(); this.Suspending += OnSuspending; this.Resuming += OnResuming; loadDatebase(); ViewModles = ViewModle.MyItem.getinstance(); TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count); TileUpdateManager.CreateTileUpdaterForApplication().Clear(); for (int i = 0; i < ViewModles.AllItems.Count; i++) { UpdatePrimaryTile(ViewModles.AllItems[i].title, ViewModles.AllItems[i].detail); } TileUpdateManager.CreateTileUpdaterForApplication().EnableNotificationQueue(true); }
private void createButton_Click(object sender, RoutedEventArgs e) { ITextRange range = detials.Document.GetRange(0, TextConstants.MaxUnitCount); if (title.Text == "") { var i = new MessageDialog("Title不能为空!").ShowAsync(); } if (range.Text == "") { var i = new MessageDialog("Detial不能为空!").ShowAsync(); } if (date.Date < System.DateTime.Today) { var i = new MessageDialog("所选日期不能为今天以前!").ShowAsync(); } if (title.Text != "" && range.Text != "" && date.Date >= DateTime.Now.Date) { if (ViewModles.SelectItem != null) { try { string sql = @"UPDATE MyToDo SET DATA=?,TITLE=?,DETAIL=? WHERE ID=?"; using (var cus = conn.Prepare(sql)) { cus.Bind(1, date.Date.ToString()); cus.Bind(2, title.Text.Trim()); cus.Bind(3, range.Text.Trim()); cus.Bind(4, ViewModles.SelectItem.id); cus.Step(); ViewModles.UpdateItem("", title.Text.Trim(), range.Text.Trim(), date.Date.DateTime); } Frame.Navigate(typeof(MainPage)); circulationUpdate(); } catch (Exception ex) { Debug.WriteLine(ex.Message); } } if (createButton.Content.ToString() == "Create" && ViewModles.SelectItem == null) { try { string sql = @"INSERT INTO MyToDo(DATA,TITLE,DETAIL,FINISH) VALUES (?,?,?,?)"; using (var cus = conn.Prepare(sql)) { cus.Bind(1, date.Date.ToString()); cus.Bind(2, title.Text.Trim()); cus.Bind(3, range.Text.Trim()); cus.Bind(4, "false"); cus.Step(); ViewModles.AddTodoItem(conn.LastInsertRowId(), title.Text, range.Text, date.Date.DateTime, false); } title.Text = ""; range.Text = ""; date.Date = System.DateTime.Today; circulationUpdate(); TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count); }catch (Exception ex) { Debug.WriteLine(ex.Message); } } if (createButton.Content.ToString() == "Update" && ViewModles.SelectItem != null) { try { string sql = @"UPDATE MyToDo SET DATA=?,TITLE=?,DETAIL=? WHERE ID=?"; using (var cus = conn.Prepare(sql)) { cus.Bind(1, date.Date.ToString()); cus.Bind(2, title.Text.Trim()); cus.Bind(3, range.Text.Trim()); cus.Bind(4, ViewModles.SelectItem.id); cus.Step(); ViewModles.UpdateItem("", title.Text.Trim(), range.Text.Trim(), date.Date.DateTime); } Frame.Navigate(typeof(MainPage)); circulationUpdate(); }catch (Exception ex) { Debug.WriteLine(ex.Message); } } } }
private void Creat_Click(object sender, RoutedEventArgs e) { ITextRange range = b.Document.GetRange(0, TextConstants.MaxUnitCount); if (a.Text == "") { var i = new MessageDialog("Title不能为空!").ShowAsync(); } if (range.Text == "") { var i = new MessageDialog("Detail不能为空!").ShowAsync(); } if (date1.Date < System.DateTime.Today) { var i = new MessageDialog("请选择今天之后的日期!").ShowAsync(); } if (a.Text != "" && range.Text != "" && date1.Date >= DateTime.Now.Date) { ///Debug.Write("101"); if (ViewModles.SelectItem != null) { try { string sql = @"UPDATE MyToDo SET DATA=?,TITLE=?,DETAIL=? WHERE ID=?"; using (var cus = conn.Prepare(sql)) { cus.Bind(1, date1.Date.ToString()); cus.Bind(2, a.Text.Trim()); cus.Bind(3, range.Text.Trim()); cus.Bind(4, ViewModles.SelectItem.id); cus.Step(); ViewModles.UpdateItem("", a.Text, range.Text, date1.Date.DateTime); ///Debug.Write("111"); Frame rootFrame = Window.Current.Content as Frame; circulationUpdate(); rootFrame.GoBack(); } }catch (Exception ex) { Debug.WriteLine(ex.Message); } } else { ///Debug.Write("110"); try { string sql = @"INSERT INTO MyToDo(DATA,TITLE,DETAIL,FINISH) VALUES (?,?,?,?)"; using (var cus = conn.Prepare(sql)) { cus.Bind(1, date1.Date.ToString()); cus.Bind(2, a.Text.Trim()); cus.Bind(3, range.Text.Trim()); cus.Bind(4, "false"); cus.Step(); ViewModles.AddTodoItem(conn.LastInsertRowId(), a.Text, range.Text, date1.Date.DateTime, false); } Frame rootFrame = Window.Current.Content as Frame; rootFrame.GoBack(); circulationUpdate(); TitleService.setBadgeCountOnTile(ViewModles.AllItems.Count); }catch (Exception ex) { Debug.WriteLine(ex.Message); } } } }