void SelectClicked(object sender, EventArgs e) { //Userテーブルの行データを取得 var query = UserModel.selectUser(); //中身はSELECT * FROM [User] var layout = new StackLayout { HorizontalOptions = LayoutOptions.Center, Margin = new Thickness { Top = 100 } }; foreach (var user in query) { //Userテーブルの名前列をLabelに書き出す layout.Children.Add(new Label { Text = user.ISBN }); layout.Children.Add(new Label { Text = user.Title }); layout.Children.Add(new Label { Text = user.TitleKana }); layout.Children.Add(new Label { Text = user.ItemCaption }); //layout.Children.Add(new Label { Text = user.No.ToString() }); // LOL.Text = user.Name; } Content = layout; }
void SelectClicked(object sender, EventArgs e) { //Userテーブルの行データを取得 var query = UserModel.selectUser(); //中身はSELECT * FROM [User] //var layout = new StackLayout { HorizontalOptions = LayoutOptions.Center, Margin = new Thickness { Top = 100 } }; foreach (var user in query) { //Userテーブルの名前列をLabelに書き出す //layout.Children.Add(new Label { Text = user.Name }); LOL.Text = user.Name; } }
/// <summary> /// リフレッシュ時に呼ばれる /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private async void OnRefreshing(object sender, EventArgs e) { //2秒処理を待つ await Task.Delay(2000); items.Clear(); if (UserModel.selectUser() != null) { var query = UserModel.selectUser(); var List1 = new List <String>(); //*をリストにぶち込んで個数分addするのでもいいのでは foreach (var user in query) { List1.Add(user.Title); } for (var j = 0; j < query.Count; j++) { items.Add(new Book { Name = List1[j], /*Value = 2.5*/ }); } } else { items.Add(new Book { Name = "空やで" }); } BookListView.ItemsSource = items; //リフレッシュを止める this.BookListView.IsRefreshing = false; }
//--------------------------------Serchボタンイベントハンドラ----------------------------------- private async void Serch(object sender, EventArgs e) { //2秒処理を待つ await Task.Delay(2000); items.Clear(); var query = UserModel.selectUser(); var ListTitle = new List <String>(); var ListReview = new List <double>(); requestUrl = url + "&booksGenreId=001" + genreid; //URLにISBNコードを挿入 //HTTPアクセスメソッドを呼び出す string APIdata = await GetApiAsync(); //jsonをstringで受け取る //HTTPアクセス失敗処理(404エラーとか名前解決失敗とかタイムアウトとか) if (APIdata is null) { await DisplayAlert("接続エラー", "接続に失敗しました", "OK"); } /* * //レスポンス(JSON)をstringに変換-------------->しなくていい * Stream s = GetMemoryStream(APIdata); //GetMemoryStreamメソッド呼び出し * StreamReader sr = new StreamReader(s); * string json = sr.ReadToEnd(); */ /* * //デシリアライズ------------------>しなくていい * var rakutenBooks = JsonConvert.DeserializeObject<RakutenBooks>(json.ToString()); */ //パースする *重要* パースとは、文法に従って分析する、品詞を記述する、構文解析する、などの意味を持つ英単語。 var json = JObject.Parse(APIdata); //stringのAPIdataをJObjectにパース var Items = JArray.Parse(json["Items"].ToString()); //Itemsは配列なのでJArrayにパース //結果を出力 foreach (JObject jobj in Items) { //↓のように取り出す JValue titleValue = (JValue)jobj["title"]; string title = (string)titleValue.Value; JValue reviewAverageValue = (JValue)jobj["reviewAverage"]; double reviewAverage = (double)reviewAverageValue.Value; JValue titleKanaValue = (JValue)jobj["titleKana"]; string titleKana = (string)titleKanaValue.Value; JValue itemCaptionValue = (JValue)jobj["itemCaption"]; string itemCaption = (string)itemCaptionValue.Value; JValue gazoValue = (JValue)jobj["largeImageUrl"]; string gazo = (string)gazoValue.Value; ListTitle.Add(title); ListReview.Add(reviewAverage); } ; for (var j = 0; j < 30; j++) { items.Add(new Book2 { Name = ListTitle[j], Value = ListReview[j] }); } for (var i = 0; i < items.Count; i++) { if (items[i].Value <= 0.25) { items[i].ValueImage = "value_0.gif"; } else if (items[i].Value <= 0.75) { items[i].ValueImage = "value_0.5.gif"; } else if (items[i].Value <= 1.25) { items[i].ValueImage = "value_1.gif"; } else if (items[i].Value <= 1.75) { items[i].ValueImage = "value_1.5.gif"; } else if (items[i].Value <= 2.25) { items[i].ValueImage = "value_2.gif"; } else if (items[i].Value <= 2.75) { items[i].ValueImage = "value_2.5.gif"; } else if (items[i].Value <= 3.25) { items[i].ValueImage = "value_3.gif"; } else if (items[i].Value <= 3.75) { items[i].ValueImage = "value_3.5.gif"; } else if (items[i].Value <= 4.25) { items[i].ValueImage = "value_4.gif"; } else if (items[i].Value <= 4.75) { items[i].ValueImage = "value_4.5.gif"; } else { items[i].ValueImage = "value_5.gif"; } } RankListView.ItemsSource = items; //リフレッシュを止める this.RankListView.IsRefreshing = false; }
public BookPage() { InitializeComponent(); if (UserModel.selectUser() != null) { var query = UserModel.selectUser(); var List1 = new List <String>(); //*をリストにぶち込んで個数分addするのでもいいのでは foreach (var user in query) { List1.Add(user.Title); } for (var j = 0; j < query.Count; j++) { items.Add(new Book { Name = List1[j], /*Value = 2.5*/ }); } } else { items.Add(new Book { Name = "空やで" }); } /*for (var j = 1; j == query2.Count; j++) * { * foreach (var user in UserModel.countUser(j)) * { * items.Add(new Book { Name = user.Name, Value = 2.5 }); * } * }*/ /*foreach (var user in query2) * { * List1[0] = user.Name; * }List1.Add = List1[0];*/ /*for (var i = 0; i < items.Count; i++) * { * if (items[i].Value <= 0.25) * { * items[i].ValueImage = "value_0.gif"; * } * else if (items[i].Value <= 0.75) * { * items[i].ValueImage = "value_0.5.gif"; * } * else if (items[i].Value <= 1.25) * { * items[i].ValueImage = "value_1.gif"; * } * else if (items[i].Value <= 1.75) * { * items[i].ValueImage = "value_1.5.gif"; * } * else if (items[i].Value <= 2.25) * { * items[i].ValueImage = "value_2.gif"; * } * else if (items[i].Value <= 2.75) * { * items[i].ValueImage = "value_2.5.gif"; * } * else if (items[i].Value <= 3.25) * { * items[i].ValueImage = "value_3.gif"; * } * else if (items[i].Value <= 3.75) * { * items[i].ValueImage = "value_3.5.gif"; * } * else if (items[i].Value <= 4.25) * { * items[i].ValueImage = "value_4.gif"; * } * else if (items[i].Value <= 4.75) * { * items[i].ValueImage = "value_4.5.gif"; * } * else * { * items[i].ValueImage = "value_5.gif"; * } * if (items[i].RedStar == true) * { * items[i].RedStar2 = "red_star_72.png"; * } * if (items[i].BlueBook == true) * { * items[i].BlueBook2 = "blue_book_72.png"; * } * }*/ BookListView.ItemsSource = items; }
public BookPage() { InitializeComponent(); if (UserModel.selectUser() != null) { var query = UserModel.selectUser(); var titleList = new List <String>(); var isbnList = new List <String>(); var RedList = new List <int>(); var BlueList = new List <int>(); var RedList2 = new List <string>(); var BlueList2 = new List <string>(); //*をリストにぶち込んで個数分addするのでもいいのでは foreach (var user in query) { titleList.Add(user.Title); isbnList.Add(user.ISBN); RedList.Add(user.RedStar); BlueList.Add(user.BlueBook); } for (var h = 0; h < query.Count; h++) { if (RedList[h] == 1) { RedList2.Add("red_star_72.png"); } else { RedList2.Add(""); } if (BlueList[h] == 1) { BlueList2.Add("blue_book_72.png"); } else { BlueList2.Add(""); } } for (var j = 0; j < query.Count; j++) { items.Add(new Book { Name = titleList[j], ISBN = isbnList[j], RedStar = RedList[j], BlueBook = BlueList[j], RedStar2 = RedList2[j], BlueBook2 = BlueList2[j] }); } } else { items.Add(new Book { Name = "空やで" }); } BookListView.ItemsSource = items; }
/// <summary> /// リフレッシュ時に呼ばれる /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private async void OnRefreshing(object sender, EventArgs e) { //2秒処理を待つ await Task.Delay(2000); items.Clear(); if (UserModel.selectUser() != null) { var query = UserModel.selectUser(); var titleList = new List <String>(); var isbnList = new List <String>(); var RedList = new List <int>(); var BlueList = new List <int>(); var RedList2 = new List <string>(); var BlueList2 = new List <string>(); //*をリストにぶち込んで個数分addするのでもいいのでは foreach (var user in query) { titleList.Add(user.Title); isbnList.Add(user.ISBN); RedList.Add(user.RedStar); BlueList.Add(user.BlueBook); } for (var h = 0; h < query.Count; h++) { if (RedList[h] == 1) { RedList2.Add("red_star_72.png"); } else { RedList2.Add(""); } if (BlueList[h] == 1) { BlueList2.Add("blue_book_72.png"); } else { BlueList2.Add(""); } } for (var j = 0; j < query.Count; j++) { items.Add(new Book { Name = titleList[j], ISBN = isbnList[j], RedStar = RedList[j], BlueBook = BlueList[j], RedStar2 = RedList2[j], BlueBook2 = BlueList2[j] }); } } else { items.Add(new Book { Name = "空やで" }); } BookListView.ItemsSource = items; //リフレッシュを止める this.BookListView.IsRefreshing = false; }