public SelectPage()
{
InitializeComponent();
//selectイベントハンドラ
//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)
{
//this.ListView.ItemsSource = user.Name;//listview
//Userテーブルの名前列をLabelに書き出す
this.ListView.ItemsSource = user.Name;//listview
layout.Children.Add(new Label {
Text = user.Name
});
}
Content = layout;
}
//insertイベントハンドラ
void InsertClicked(object sender, EventArgs e)
{
Navigation.PushAsync(new SubPage());
var InsertName = insertEntry.Text;
//Userテーブルに適当なデータを追加する
UserModel.insertUser(InsertName);
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
});
}
;
Content = layout;
/*
* var query = UserModel.selectUser(); //中身はSELECT * FROM [User]
* foreach (var user in query)
* {
* var sb = new Label { Text = user.Name };
* }
* var scrollView = new ScrollView
* {
* VerticalOptions = LayoutOptions.FillAndExpand,
* //ラベルを配置する
* Content = new Label
* {
* Text = sb.ToString(),
* FontSize = 20,
* TextColor = Color.Red,
* }
* };
* Content = scrollView;*/
}
public Subpage2()
{
InitializeComponent();
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
});
}
}
/*
* public MainPage()
* {
* InitializeComponent();
*
* var layout = new StackLayout { HorizontalOptions = LayoutOptions.Center, Margin = new Thickness { Top = 100 } };
*
* //Userテーブルに適当なデータを追加
* UserModel.insertUser("鈴木");
* UserModel.insertUser("田中");
* UserModel.insertUser("斎藤");
* //↑この辺をボタンに突っ込む
*
* //Userテーブルの行データを取得
* var query = UserModel.selectUser();
*
* foreach (var user in query)
* {
* //Userテーブルの名前列をLabelに書き出します
* layout.Children.Add(new Label { Text = user.Name });
* }
*
* Content = layout;
*
* }*/
public MainPage()
{
var layout = new StackLayout {
HorizontalOptions = LayoutOptions.Center, Margin = new Thickness {
Top = 100
}
};
/*
* //Userテーブルに適当なデータを追加する
* UserModel.insertUser("鈴木");
* UserModel.insertUser("田中");
* UserModel.insertUser("斎藤");*/
//Userテーブルの行データを取得
var query = UserModel.selectUser();
var Insert = new Button
{
WidthRequest = 60,
Text = "Insert!",
TextColor = Color.Red,
/*HorizontalOptions = LayoutOptions.Center,
* VerticalOptions = LayoutOptions.CenterAndExpand*/
};
layout.Children.Add(Insert);
Insert.Clicked += OnButtonClicked;
foreach (var user in query)
{
//Userテーブルの名前列をLabelに書き出す
layout.Children.Add(new Label {
Text = user.Name
});
}
Content = layout;
}
public SubPage()
{
InitializeComponent();
//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
});
}
var Delete = new Button
{
WidthRequest = 60,
Text = "削除",
TextColor = Color.Red,
};
layout.Children.Add(Delete);
Delete.Clicked += DeleteClicked;
Content = layout;
//deleteイベントハンドラ
void DeleteClicked(object sender, EventArgs e)
{
//UserModel.deleteUser(deleteId);
UserModel.deleteUser(1);
}
}
//selectメソッド
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 });
* }
* Content = layout;
*/
var query = UserModel.selectUser(); //中身はSELECT * FROM [User]
foreach (var user in query)
{
var sb = new Label {
Text = user.Name
};
}
var scrollView = new ScrollView
{
VerticalOptions = LayoutOptions.FillAndExpand,
//ラベルを配置する
Content = new Label
{
Text = sb.ToString(),
FontSize = 20,
TextColor = Color.Red,
}
};
Content = scrollView;
}
//selectイベントハンドラ
void SelectClicked(object sender, EventArgs e)
{
//Userテーブルの行データを取得
String x = selectEntry.Text; //入力された文字を習得
var layout2 = new StackLayout {
HorizontalOptions = LayoutOptions.CenterAndExpand, VerticalOptions = LayoutOptions.CenterAndExpand
};
var scroll = new ScrollView {
Orientation = ScrollOrientation.Vertical
};
layout2.Children.Add(scroll);
var layout = new StackLayout {
HorizontalOptions = LayoutOptions.CenterAndExpand, VerticalOptions = LayoutOptions.CenterAndExpand
};
scroll.Content = layout;
//--------------------ボタン再配置--------------------------
//selectボタン
var Select = new Button
{
WidthRequest = 60,
Text = "Select!",
TextColor = Color.Red,
};
selectEntry = new Entry
{
Placeholder = "Select",
PlaceholderColor = Color.Gray,
WidthRequest = 130
};
layout.Children.Add(Select);
Select.Clicked += SelectClicked;
layout.Children.Add(selectEntry);
//insertボタン
var Insert = new Button
{
WidthRequest = 60,
Text = "Insert!",
TextColor = Color.Red,
};
insertEntry = new Entry
{
Placeholder = "Insert",
PlaceholderColor = Color.Gray,
WidthRequest = 130
};
layout.Children.Add(Insert);
Insert.Clicked += InsertClicked;
layout.Children.Add(insertEntry);
//deleteボタン
var Delete = new Button
{
WidthRequest = 60,
Text = "Delete!",
TextColor = Color.Red,
};
deleteEntry = new Entry
{
Placeholder = "Delete",
PlaceholderColor = Color.Gray,
WidthRequest = 130
};
layout.Children.Add(Delete);
Delete.Clicked += DeleteClicked;
layout.Children.Add(deleteEntry);
//--------------------ボタン再配置--------------------------
if (x != null) //selectEntryが入力されてたら検索 nullなら全部表示
{
if (UserModel.selectUser(x) != null)
{
var query = UserModel.selectUser(x); //中身はSELECT * FROM [User] where [Name] like "% x %" limit 15
foreach (var user in query)
{
//Userテーブルの名前列をLabelに書き出します
layout.Children.Add(new Label {
Text = user.Id.ToString()
});
layout.Children.Add(new Label {
Text = user.Name
});
}
}
else
{
DisplayAlert("表がないエラー", "表がないよー", "OK");
}
}
else if (UserModel.selectUser() != null) //全部表示
{
var query = UserModel.selectUser(); //中身はSELECT * FROM [User] limit 15
foreach (var user in query)
{
//Userテーブルの名前列をLabelに書き出します
layout.Children.Add(new Label {
Text = user.Id.ToString()
});
layout.Children.Add(new Label {
Text = user.Name
});
}
}
else
{
DisplayAlert("表がないエラー", "表がないよー", "OK");
}
Content = layout2;
}
//selectイベントハンドラ
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
});
}
//selectする
var Select = new Button
{
WidthRequest = 60,
Text = "Select!",
TextColor = Color.Red,
};
layout.Children.Add(Select);
Select.Clicked += SelectClicked;
//insertする
var Insert = new Button
{
WidthRequest = 60,
Text = "Insert!",
TextColor = Color.Red,
};
insertEntry = new Entry
{
WidthRequest = 60
};
layout.Children.Add(Insert);
Insert.Clicked += InsertClicked;
layout.Children.Add(insertEntry);
Content = layout;
/*
* var query = UserModel.selectUser(); //中身はSELECT * FROM [User]
* foreach (var user in query)
* {
* var sb = new Label { Text = user.Name };
* }
* var scrollView = new ScrollView
* {
* VerticalOptions = LayoutOptions.FillAndExpand,
* //ラベルを配置する
* Content = new Label
* {
* Text = sb.ToString(),
* FontSize = 20,
* TextColor = Color.Red,
* }
* };
* Content = scrollView;*/
}
public ListViewPage()
{
if (UserModel.selectUser() != null)
{
ar = new ObservableCollection <UserModel>(UserModel.selectUser());
}
var listView = new ListView
{
//ItemsSource = UserModel.selectUser(),
//ItemTemplate = new DataTemplate(typeof(TextCell))
ItemsSource = ar,
ItemTemplate = new DataTemplate(() => new MyCell(this)),
};
//文字入力
var entry = new Entry
{
HorizontalOptions = LayoutOptions.FillAndExpand
};
//追加
var buttonAdd = new Button
{
WidthRequest = 60,
TextColor = Color.Black,
Text = "Add"
};
buttonAdd.Clicked += (s, a) =>
{//追加ボタンの処理
if (!String.IsNullOrEmpty(entry.Text))
{
UserModel.insertUser(entry.Text);
ar.Add(new UserModel {
Name = entry.Text
});
id++;
Application.Current.MainPage = new ListViewPage();
//entry.Text = "";
}
};
Content = new StackLayout
{
Padding = new Thickness(0, Device.OnPlatform(20, 0, 0), 0, 0),
Children =
{
new StackLayout
{
BackgroundColor = Color.LemonChiffon,
Padding = 5,
Orientation = StackOrientation.Horizontal,
Children = { entry, buttonAdd }//Entryコントロールとボタンコントロールを配置
},
listView //その下にリストボックス
}
};
}
