private void Change1_Click(object sender, EventArgs e)//変更ボタンの処理 作品
{
string changequery;
string changetitle;
changetitle = Textbox1.Text;//変更する内容の取得
DialogResult res = MessageBox.Show(beforeListview1Title + "を" + changetitle + "に変更しますか？", "変更確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
changequery = "update t_origin set origin_title = '" + changetitle + "'"
+ "where origin_id = " + beforeListView1ID; //クエリ組み立て
SQLiteConnect.Excute(changequery); //SQL文実行
Listview1.Items.Clear();
SQLiteConnect.lording(ref Listview1, "select origin_ID,origin_title from t_origin", "origin_ID", "origin_title");
//リフレッシュ処理
}
}
private void Change2_Click(object sender, EventArgs e)//変更ボタンの処理 ジャンル
{
string changequery;
string changetitle;
changetitle = Textbox2.Text;//変更する内容の取得
DialogResult res = MessageBox.Show(beforeListview2Title + "を" + changetitle + "に変更しますか？", "変更確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
changequery = "update t_genre set genre_title = '" + changetitle + "'"
+ "where genre_id = " + beforeListview2ID;
SQLiteConnect.Excute(changequery);
Listview2.Items.Clear();
SQLiteConnect.lording(ref Listview2, "select genre_ID,genre_title from t_genre", "genre_ID", "genre_title");
//リフレッシュ処理
}
}
private void Change2_Click(object sender, EventArgs e)//要素変更 本棚の場所
{
string changequery;
string changetitle;
changetitle = Textbox2.Text;//変更する内容の取得
DialogResult res = MessageBox.Show(beforeListview2Title + "を" + changetitle + "に変更しますか？", "変更確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
changequery = "update t_house_shelf set shelf_name = '" + changetitle + "'"
+ "where place_ID = " + beforeListView1ID + " and bookShelf_ID = " + beforeListview2ID; //クエリ組み立て
SQLiteConnect.Excute(changequery); //SQL文実行
Listview2.Items.Clear();
SQLiteConnect.lording(ref Listview2, "select bookShelf_ID,shelf_name from t_house_shelf where place_ID = " + beforeListView1ID, "bookShelf_ID", "shelf_name");
//リフレッシュ処理
}
}
private void Delete1_Click(object sender, EventArgs e)//削除ボタンの処理 作品
{
string deletequery;
int counter = 0;
counter = SQLiteConnect.counterID("origin", beforeListView1ID);
if (counter != 0)
{
MessageBox.Show("データが" + counter + "件存在するため、削除できません。", "警告", MessageBoxButtons.OK);
return;
}
DialogResult res = MessageBox.Show(beforeListview1Title + "を削除しますか？", "削除確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
deletequery = "delete from t_origin where origin_id =" + beforeListView1ID;
SQLiteConnect.Excute(deletequery);
Listview1.Items.Clear();
SQLiteConnect.lording(ref Listview1, "select origin_ID,origin_title from t_origin", "origin_ID", "origin_title");
Textbox1.Clear();
}
}
private void Add1_Click(object sender, EventArgs e)//追加ボタンの処理 作品
{
string addquery;
string IDquery;
string addtitle;
int ID;
SQLiteDataReader reader = null; //リフレッシュ用
addtitle = Textbox1.Text; //textboxから追加したい文言の取得
DialogResult res = MessageBox.Show(addtitle + " を登録しますか？", //確認処理
"追加確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
IDquery = "select max(origin_ID) from t_origin";//現在のID最大値取得sql
//追加作業部分
if (SQLiteConnect.checkRecord("t_origin") == 0)//レコードない時の処理
{
ID = 1;
}
else
{
SQLiteConnect.Excute(IDquery, ref reader);
reader.Read();
ID = int.Parse(reader["max(origin_ID)"].ToString()) + 1; //追加用の新規ID生成
reader.Close();
SQLiteConnect.conn.Close();
}
addquery = "INSERT into t_origin(origin_ID,origin_title)VALUES(" + ID + ","
+ "'" + Textbox1.Text + "')"; //追加用sql組み立て
SQLiteConnect.Excute(addquery); //登録作業
Listview1.Items.Clear();
SQLiteConnect.lording(ref Listview1, "select origin_ID,origin_title from t_origin", "origin_ID", "origin_title");
}
}
private void Delete2_Click(object sender, EventArgs e)
{
int counter = 0;
counter = SQLiteConnect.counterID("genre", beforeListview2ID);
if (counter != 0)
{
MessageBox.Show("データが" + counter + "件存在するため、削除できません。", "警告", MessageBoxButtons.OK);
return;
}
string deletequery;
DialogResult res = MessageBox.Show(beforeListview2Title + "を削除しますか？", "削除確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
deletequery = "delete from t_genre where genre_id =" + beforeListview2ID;
SQLiteConnect.Excute(deletequery);
Listview2.Items.Clear();
SQLiteConnect.lording(ref Listview2, "select genre_ID,genre_title from t_genre", "genre_ID", "genre_title");
Textbox2.Clear(); //リフレッシュ処理
}
}
private void Add2_Click(object sender, EventArgs e)//新規追加 本棚の場所
{
string addquery;
string IDquery;
string addtitle;
int ID;
SQLiteDataReader reader = null; //リフレッシュ用
addtitle = Textbox2.Text; //textboxから追加したい文言の取得
DialogResult res = MessageBox.Show(addtitle + " を登録しますか？", //確認処理
"追加確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
IDquery = "select max(bookShelf_ID) from t_house_shelf where place_ID = " + beforeListView1ID;//現在のID最大値取得sql
//追加作業部分
if (SQLiteConnect.checkRecord2("t_house_shelf", "place_ID", beforeListView1ID) == 0)//レコードない時の処理
{
ID = 1;
}
else
{
SQLiteConnect.Excute(IDquery, ref reader);
reader.Read();
ID = int.Parse(reader["max(bookShelf_ID)"].ToString()) + 1; //追加用の新規ID生成
reader.Close();
SQLiteConnect.conn.Close();
}
addquery = "INSERT into t_house_shelf(place_ID,bookShelf_ID,shelf_name)VALUES(" + beforeListView1ID + ","
+ ID + "," + "'" + Textbox2.Text + "')"; //追加用sql組み立て
SQLiteConnect.Excute(addquery); //登録作業
Listview2.Items.Clear();
SQLiteConnect.lording(ref Listview2, "select bookShelf_ID,shelf_name from t_house_shelf where place_ID = " + beforeListView1ID, "bookShelf_ID", "shelf_name");
}
}
private void Delete2_Click(object sender, EventArgs e)//要素削除 本棚の場所
{
string deletequery;
int counter = 0;
counter = SQLiteConnect.counterID2("place", beforeListView1ID, "bookShelf", beforeListview2ID);
if (counter != 0)
{
MessageBox.Show("データが" + counter + "件存在するため、削除できません。", "警告", MessageBoxButtons.OK);
return;
}
DialogResult res = MessageBox.Show(beforeListview2Title + "を削除しますか？", "削除確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
deletequery = "delete from t_house_shelf where place_ID =" + beforeListView1ID
+ " and bookShelf_ID = " + beforeListview2ID;
SQLiteConnect.Excute(deletequery);
Listview2.Items.Clear();
SQLiteConnect.lording(ref Listview2, "select bookShelf_ID,shelf_name from t_house_shelf where place_ID = " + beforeListView1ID, "bookShelf_ID", "shelf_name");
Textbox2.Clear();
}
}
private void table_manage_Load(object sender, EventArgs e)//フォームロード時の処理
{
SQLiteConnect.lording(ref Listview1, "select origin_ID,origin_title from t_origin", "origin_ID", "origin_title");
SQLiteConnect.lording(ref Listview2, "select genre_ID,genre_title from t_genre", "genre_ID", "genre_title");
}
private void Listview1_SelectedIndexChanged_1(object sender, EventArgs e)
{
Listview2.Items.Clear();
SQLiteConnect.lording(ref Listview2, "select bookShelf_ID,shelf_name from t_house_shelf where place_ID = " + beforeListView1ID, "bookShelf_ID", "shelf_name");
}
private void shelf_manage_Load(object sender, EventArgs e)
{
SQLiteConnect.lording(ref Listview1, "select place_ID,place_name from t_storage", "place_ID", "place_name");
}