private async void Button_Click(object sender, RoutedEventArgs e) { string account = accountBox.Text; string password = passwordbox.Password; using (SQLiteConnection conn = UserDatabase.GetDbConnection()) { TableQuery <UserAccount> t = conn.Table <UserAccount>(); var q = from s in t orderby s.user_id select s; if (q.Any(temp => account == temp.user_id && password == temp.password)) { await CoreApplication.MainView.CoreWindow.Dispatcher.RunAsync(Windows.UI.Core.CoreDispatcherPriority.Normal, () => { ((Frame)Window.Current.Content).Navigate(typeof(MainPage) , account); }); } else { accountBox.Text = ""; passwordbox.Password = ""; new MessageDialog("账户或密码错误").ShowAsync(); } } }
private void Usertest() //用户数据库测试 { using (SQLiteConnection conn = UserDatabase.GetDbConnection()) { Debug.WriteLine(conn.DatabasePath.ToString());//找出数据库位置 TableQuery <UserAccount> t = conn.Table <UserAccount>(); var q = from s in t.AsParallel <UserAccount>() orderby s.user_id select s; useracccount.Clear(); foreach (var temp in q) { useracccount.Add(temp); } //StringBuilder msg = new StringBuilder(); //msg.AppendLine($"数据库中总共 {useracccount.Count()} 个 user 对象。"); /////测试数据库出来的实例location转换 //foreach (var item in useracccount) //{ // msg.AppendLine($"Id:{item.user_id};Name:{item.name}"); //} //new MessageDialog(msg.ToString()).ShowAsync(); } }
private void reNameBox_Loaded(object sender, RoutedEventArgs e) { using (SQLiteConnection conn = UserDatabase.GetDbConnection()) { TableQuery <UserAccount> t = conn.Table <UserAccount>(); var q = from s in t.AsParallel <UserAccount>() orderby s.user_id where s.user_id == this_account select s; ///如何将用户登陆后的账户通信到这些页面呢??这个分支采用导航传参数 foreach (var item in q) { reNameBox.Text = item.nickname.ToString(); } } }
private void dataload() //用于打开页面加载路程数据等方法 { using (SQLiteConnection conn = UserDatabase.GetDbConnection()) { TableQuery <UserAccount> t = conn.Table <UserAccount>(); var q = from s in t.AsParallel <UserAccount>() orderby s.user_id where s.user_id == this_account select s; foreach (var item in q) { nicknameText.Text = item.nickname.ToString(); nameText.Text = item.name.ToString(); phoneText.Text = item.phonenumber.ToString(); //headpictureE 如何设置头像? } } }
//private void Ellipse_PointerPressed(object sender, PointerRoutedEventArgs e) //{ //} private void dataload() //用于打开页面加载路程数据等方法 { using (SQLiteConnection conn = UserDatabase.GetDbConnection()) { TableQuery <UserAccount> t = conn.Table <UserAccount>(); var q = from s in t.AsParallel <UserAccount>() orderby s.user_id where s.user_id == this_account select s; ///如何将用户登陆后的账户通信到这些页面呢??这个分支采用导航传参数 foreach (var item in q) { distanceText.Text = item.in_distance.ToString(); savecarbonText.Text = item.carbon_save.ToString(); calText.Text = item.calorie_cousume.ToString(); numberText.Text = item.phonenumber.ToString(); } } }
private void SaveB_Click(object sender, RoutedEventArgs e) { using (SQLiteConnection conn = UserDatabase.GetDbConnection()) { TableQuery <UserAccount> t = conn.Table <UserAccount>(); var q = (from s in t orderby s.user_id where s.user_id == this_account select s).SingleOrDefault(); q.nickname = reNameBox.Text; conn.Update(q); //q.First().nickname = reNameBox.Text; //conn.InsertOrReplace(q); } if (this.Frame.CanGoBack) { Frame.GoBack(); } }