private void save_Click(object sender, RoutedEventArgs e) { if (name.Text == "" || name.Text.Trim() == string.Empty || num.Text == "" || num.Text.Trim() == string.Empty) { var n = new MessageDialog("信息输入有误!").ShowAsync(); } else { ViewModel.AddTel(name.Text, num.Text, group.Text, image.Source); Frame.Navigate(typeof(ContactsPage), ViewModel); if (ViewModel.SelectTel != null) { ViewModel.Remove(); } ViewModel.SelectTel = null; var db = App.conn; using (var item = db.Prepare("INSERT INTO Tels (Name, Number, Group_By, head) VALUES(?, ?, ?, ?)")) { item.Bind(1, name.Text); item.Bind(2, num.Text); item.Bind(3, group.Text); string temp = "ms-appx://Todos/Assets/" + filename; item.Bind(4, temp); item.Step(); } var n = new MessageDialog("信息已经成功保存至通讯录!").ShowAsync(); } }
private void save_Click(object sender, RoutedEventArgs e) { if (name.Text == "" || name.Text.Trim() == string.Empty || num.Text == "" || num.Text.Trim() == string.Empty) { var n = new MessageDialog("信息输入有误!").ShowAsync(); } else { ViewModel.AddTel(name.Text, num.Text, group.Text, image.Source); Frame.Navigate(typeof(ContactsPage), ViewModel); if (ViewModel.SelectTel != null) { ViewModel.Remove(); } ViewModel.SelectTel = null; var db = App.conn; string q = "%" + name.Text + "%"; using (var statement = db.Prepare("SELECT Name, head FROM Tels WHERE Name LIKE ?")) { statement.Bind(1, q); if (statement.Step() != SQLiteResult.DONE) { oldfilepath = (string)statement[1]; } } using (var item = db.Prepare("UPDATE Tels SET Number = ?, Group_By = ?, head = ? WHERE Name = ?")) { item.Bind(1, num.Text); item.Bind(2, group.Text); if (temp != "") { item.Bind(3, temp); } else { item.Bind(3, oldfilepath); } item.Bind(4, name.Text); item.Step(); } var n = new MessageDialog("信息已经成功保存至通讯录!").ShowAsync(); } }