private async void SaveEditRemind_Tapped(object sender, TappedRoutedEventArgs e) { if (TitleTextBox.Text == "") { new ErrorNotification("标题不能为空").Show(); return; } else { if (SelectedTimeTextBlock.Text == "") { new ErrorNotification("请选择提醒时间").Show(); return; } else { if (SelectedWeekNumTextBlock.Text == "") { new ErrorNotification("请选择提醒周数").Show(); return; } else { if (SelectedRemindTextBlock.Text == "") { new ErrorNotification("请选择提前时间").Show(); return; } else { string resource = "ZSCY"; PasswordCredential userCredential = GetCredential.getCredential(resource); string stuNum, idNum; stuNum = userCredential.UserName; idNum = userCredential.Password; Debug.WriteLine("{0},{1}", stuNum, idNum); MyRemind myRemind = new MyRemind(); myRemind.DateItems = new List<DateItemModel>(); myRemind.Id = tempID; for (int i = 0; i < 7; i++) { for (int j = 0; j < 6; j++) if (App.timeSet[j, i].IsCheck) { //dateItem.Class += j.ToString() + ","; //dateItem.Day += i.ToString() + ","; DateItemModel dateItem = new DateItemModel(); dateItem.Class = j.ToString(); dateItem.Day = i.ToString(); for (int k = 0; k < App.selectedWeekNumList.Count; k++) { dateItem.Week += App.selectedWeekNumList[k].WeekNum + ","; } dateItem.Week = dateItem.Week.Remove(dateItem.Week.Length - 1); myRemind.DateItems.Add(dateItem); } } if (SelRemindListView.SelectedIndex == 0) { myRemind.Time = null; } else { myRemind.Time = beforeTime[SelRemindListView.SelectedIndex].BeforeTime.TotalMinutes.ToString(); } myRemind.Title = TitleTextBox.Text; myRemind.Content = ContentTextBox.Text; string databaseJson = JsonConvert.SerializeObject(myRemind); myRemind.IdNum = idNum; myRemind.StuNum = stuNum; try { string content = await NetWork.httpRequest(ApiUri.editRemindApi, NetWork.editRemind(myRemind)); } catch { Debug.WriteLine("网络问题请求失败"); } string id_system = ""; RemindListDB temp = new RemindListDB(); if (beforeTime[SelRemindListView.SelectedIndex].isRemind) { TimeSpan time = beforeTime[SelRemindListView.SelectedIndex].BeforeTime; //设置通知 temp = DatabaseMethod.ToModel(myRemind.Id); string[] TagArray = temp.Id_system.Split(','); var notifier = ToastNotificationManager.CreateToastNotifier(); for (int i = 0; i < TagArray.Count(); i++) { var scheduledNotifs = notifier.GetScheduledToastNotifications() .Where(n => n.Tag.Equals(TagArray[i])); // Remove all of those from the schedule foreach (var n in scheduledNotifs) { notifier.RemoveFromSchedule(n); } } //重新添加 id_system = await RemindHelp.AddAllRemind(myRemind, time); } else { } DatabaseMethod.EditDatabase(temp.Num,myRemind.Id, databaseJson, id_system); DatabaseMethod.ReadDatabase(Visibility.Visible); App.isLoad = false; App.selectedWeekNumList.Clear(); } } } } this.NavigationCacheMode = NavigationCacheMode.Disabled; this.Visibility = Visibility.Collapsed; }
public static void EditDatabase(int num,string id, string json, string id_system) { var conn = new SQLiteConnection(new SQLitePlatformWinRT(), App.RemindListDBPath); 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 == id); //else if (isfound_id_system) // up.Delete(x => x.Id_system == id_system); //else if (isfound_id_system && isfound_id) // up.Delete(x => x.Id == id && x.Id_system == id_system); //else //{ //} up.Delete(x => x.Num == num); //if (id != null && id_system == null) // up.Delete(x => x.Id == id); //else if (id == null && id_system != null) // up.Delete(x => x.Id_system == id_system); //else if (id != null && id_system != null) // up.Delete(x => x.Id == id && x.Id_system == id_system); RemindListDB temp = new RemindListDB() { Id = id, Id_system = id_system, json = json }; conn.Insert(temp); }