private void button16_Click(object sender, EventArgs e)
{
int.TryParse(textBox8.Text, out int brn);
int.TryParse(textBox1.Text, out int mId);
RentManager.ReturnBook(brn, mId);
}
private void button1_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = "";
string selected = "";
if (comboBox1.SelectedItem != null)
{
selected = comboBox1.SelectedItem.ToString();
}
Console.WriteLine(selected);
string tableName = "books";
string search = "";
string keyword = textBox1.Text;
switch (selected)
{
case "등록번호":
search = "BookRegisterNumber";
break;
case "서명":
search = "BookName";
break;
case "총서명":
search = "BookFullName";
break;
case "저자":
search = "BookAuthor";
break;
default:
break;
}
DataTable table = new DataTable();
/*
* 순번 books
* 도서상태 books
* 등록번호 books
* 도서명 books
* 저자 books
* 청구기호 books
* 대출일자 ? - rent
* 반납일자 ? - rent
* 대출자 members
* 예약자 members - 미사용
* 소장위치 books
* 반입구분 books
* 등록일 books
*
*/
//book
table.Columns.Add("순번", typeof(int));
table.Columns.Add("도서상태", typeof(string));
table.Columns.Add("등록번호", typeof(int));
table.Columns.Add("도서명", typeof(string));
table.Columns.Add("저자", typeof(string));
// table.Columns.Add("청구기호", typeof(string));//미사용
//rent
table.Columns.Add("대출일자", typeof(string));
table.Columns.Add("반납일자", typeof(string));
table.Columns.Add("대출자", typeof(string));
// table.Columns.Add("예약자", typeof(string));//미사용
table.Columns.Add("소장위치", typeof(string));
// table.Columns.Add("반입구분", typeof(string));// 임시 해제
table.Columns.Add("등록일", typeof(string));
/*
* 수정 중
*/
foreach (var item in BookManager.Load(SearchQueryManager.makeSearchQuery(tableName, search, keyword)))
{
Rent r = null;
Member m = null;
if (RentManager.Load("select * from bookmanagement.rent where BookRegisterNumber=" + item.BookRegisterNumber + ";").Count > 0)
{
r = RentManager.Load("select * from bookmanagement.rent where BookRegisterNumber=" + item.BookRegisterNumber + ";")[0];
m = MemberManager.Load(SearchQueryManager.makeSearchQuery("members", "MemberId", r.MemberId.ToString()))[0];
}
if (r != null)
{
table.Rows.Add(item.Num, item.BookState, item.BookRegisterNumber, item.BookName, item.BookAuthor, r.Rent_Date, r.Rent_Date_Last, m.MemberName, item.BookLocation, item.BookPublishDate);
}
else
{
table.Rows.Add(item.Num, item.BookState, item.BookRegisterNumber, item.BookName, item.BookAuthor, "-", "-", "-", item.BookLocation, item.BookPublishDate);
}
}
/*
*
*/
dataGridView1.DataSource = table;
}
