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;
}
