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