private void managebySortButton_Click(object sender, EventArgs e)//改为按分类管理图书
{
isNormal = false;
shelfBindingSource.DataSource = BookShelfService.GetAllShelfs();
bookBindingSource.DataMember = null;
bookBindingSource.DataSource = BookShelfService.AllBooks();
}
private void addButton_Click(object sender, EventArgs e)//增加图书
{
if (nameTextBox.Text != null && authorTextBox.Text != null && sortTextBox.Text != null && introductionTextBox.Text != null)
{
int k = Convert.ToInt32(BookShelfService.AllBooks().Max(i => i.BookId)) + 1;
string bookId = k + "";
string name = this.nameTextBox.Text;
string author = this.authorTextBox.Text;
string bookShelfId = currentShelf.BookShelfId;
string lendTime = null;
string clientName = null;
string sort = this.sortTextBox.Text;
string appointers = "";
string description = this.introductionTextBox.Text;
Book newBook = new Book(bookId, name, bookShelfId, author, description, lendTime, clientName, sort, appointers)
{
State = "可正常使用"
};
if (path != null)
{
File.Copy(path, resPath + @"\" + newBook.Name + ".jpg");
newBook.imagePath = path;
}
currentShelf.AddBook(newBook);
BookShelfService.UpdateShelf(currentShelf);
MessageBox.Show("已添加新书！");
this.addButton.Enabled = false;
this.addButton.Visible = false;
}
else
{
MessageBox.Show("没有输入完整的信息！");
}
}
private void Search(int i, string key)//查询方法，i表示具体的排序规则，完成
{
List <Book> searchBooks = new List <Book>();
using (var db = new BookShelfContext())
{
switch (i)
{
case 1: //按书号查询
foreach (var book in BookShelfService.AllBooks().Where(o => o.BookId.Contains(key) == true))
{
searchBooks.Add(book);
}
break;
case 2: //书名
foreach (var book in BookShelfService.AllBooks().Where(o => o.Name.Contains(key) == true))
{
searchBooks.Add(book);
}
break;
case 3: //作者
foreach (var book in BookShelfService.AllBooks().Where(o => o.Author.Contains(key) == true))
{
searchBooks.Add(book);
}
break;
case 4: //分类
foreach (var book in BookShelfService.AllBooks().Where(o => o.Sort == key))
{
searchBooks.Add(book);
}
break;
case 5: //书架号
foreach (var book in BookShelfService.AllBooks().Where(o => o.BookShelfId == key))
{
searchBooks.Add(book);
}
break;
}
booksBindingSource.DataSource = new List <Book>();
booksBindingSource.ResetBindings(false);
booksBindingSource.DataSource = searchBooks;
}
}
private void Query(int i)//排序方法，i表示具体的排序规则，完成
{
List <Book> queryBooks = new List <Book>();
using (var db = new BookShelfContext())
{
switch (i)
{
case 1: //默认的按推荐数排序
var query1 = BookShelfService.AllBooks();
var list1 = from t in query1 orderby t.Recommend descending select t;
queryBooks = list1.ToList();
break;
case 2: //书号
var query2 = BookShelfService.AllBooks();
var list2 = from t in query2 orderby t.BookId ascending select t;
queryBooks = list2.ToList();
break;
case 3: //作者
var query3 = BookShelfService.AllBooks();
var list3 = from t in query3 orderby t.Author ascending select t;
queryBooks = list3.ToList();
break;
case 4: //分类
var query4 = BookShelfService.AllBooks();
var list4 = from t in query4 orderby t.BookId ascending select t;
queryBooks = list4.ToList();
break;
case 5: //书架号
var query5 = BookShelfService.AllBooks();
var list5 = from t in query5 orderby t.BookId ascending select t;
queryBooks = list5.ToList();
break;
}
booksBindingSource.DataSource = new List <Book>();
booksBindingSource.ResetBindings(false);
booksBindingSource.DataSource = queryBooks;
}
}
private void renewButton_Click(object sender, EventArgs e)//续借，完成
{
Book book = lendBindingSource.Current as Book;
if (book == null)
{
MessageBox.Show("请选择一本书进行操作！");
return;
}
else
{
if (yearComboBox.Text != "" && monthComboBox.Text != "" && dayComboBox.Text != "")//monthComboBox之前打快了打成了monthhComboBox
{
string year = yearComboBox.Text;
string month = monthComboBox.Text;
string day = dayComboBox.Text;
if (book.reNewNum < 3)
{
BookShelfService.ReNewLending(book, currentClient, year, month, day);
}
else
{
MessageBox.Show("该书续借次数太多，不允许继续续借！");
}
}
else
{
MessageBox.Show("没有输入正确的日期！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
lendBooks = new List <Book>();
lendBindingSource.DataSource = lendBooks;
lendBooks = BookShelfService.GetAllLentBooks(currentClient);
lendBindingSource.ResetBindings(false);
lendBindingSource.DataSource = lendBooks;
Books = new List <Book>();
booksBindingSource.DataSource = Books;
Books = BookShelfService.AllBooks();
booksBindingSource.ResetBindings(false);
booksBindingSource.DataSource = Books;
Query(1);
}
public FormMain()
{
InitializeComponent();
administrator.Id = "1";
user1.Id = "2";
user2.Id = "3";
user3.Id = "4";
if (currentClient == null)
{
this.signOutButton.Visible = false;
this.signOutButton.Enabled = false;
}
if (ClientService.AllClients().Count == 0)
{
ClientService.AddAdministrator(administrator);
ClientService.AddAdministrator(user1);
ClientService.AddAdministrator(user2);
ClientService.AddAdministrator(user3);
}
this.managePictureBox.Visible = false;
this.managePictureBox.Enabled = false;
this.manageLabel.Visible = false;
this.manageLabel.Enabled = false;
if (BookShelfService.AllBooks().Count == 0)//设置初始值
{
Test.Test1();
Test.Test2();
}
//MessageBox.Show("1");
Year = DateTime.Now.Year;
Month = DateTime.Now.Month;
String time = DateTime.Now.ToLongDateString().ToString();
int m = time.IndexOf("月");
int d = time.IndexOf("日");
Day = DateTime.Now.Day;
BookShelfService.Check(Year, Month, Day);
Books = BookShelfService.AllBooks();
booksBindingSource.DataSource = Books;
Query(1);
//MessageBox.Show(Year+"年"+Month+"月"+Day+"日");
}
private void returnButton_Click(object sender, EventArgs e)//还书，完成
{
Book book = lendBindingSource.Current as Book;
if (book == null)
{
MessageBox.Show("请选择一本书进行操作！");
return;
}
BookShelfService.ReturnBooks(book, currentClient);//问题
lendBooks = new List <Book>();
lendBindingSource.DataSource = lendBooks;
lendBooks = BookShelfService.GetAllLentBooks(currentClient);
lendBindingSource.ResetBindings(false);
lendBindingSource.DataSource = lendBooks;
Books = new List <Book>();
booksBindingSource.DataSource = Books;
Books = BookShelfService.AllBooks();
booksBindingSource.ResetBindings(false);
booksBindingSource.DataSource = Books;
Query(1);
}
private void cancellButton_Click(object sender, EventArgs e)//取消预约，完成
{
Book book = appointBindingSource.Current as Book;
if (book == null)
{
MessageBox.Show("请选择一本书进行操作！");
return;
}
BookShelfService.CancellAppoint(book, currentClient);
appointBooks = new List <Book>();
appointBindingSource.DataSource = appointBooks;
appointBooks = BookShelfService.GetAllAppointedBooks(currentClient);
appointBindingSource.ResetBindings(false);
appointBindingSource.DataSource = appointBooks;
Books = new List <Book>();
booksBindingSource.DataSource = Books;
Books = BookShelfService.AllBooks();
booksBindingSource.ResetBindings(false);
booksBindingSource.DataSource = Books;
Query(1);
}
private void searchButton_Click(object sender, EventArgs e)//查询图书
{
if (searchTextBox.Text == null)
{
MessageBox.Show("没有输入用于查询的关键词！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
String key = searchTextBox.Text;
List <Book> searchBooks = new List <Book>();
switch (searchComboBox.Text)
{
case "书号":
if (!isNormal)
{
foreach (var book in BookShelfService.AllBooks().Where(o => o.BookId.Contains(key) == true))
{
searchBooks.Add(book);
}
}
else
{
BookShelf shelf = shelfBindingSource.Current as BookShelf;
foreach (var book in BookShelfService.AllBooks().Where(o => o.BookId.Contains(key) == true).Where(i => i.BookShelfId == shelf.BookShelfId))
{
searchBooks.Add(book);
}
}
break;
case "书名":
if (!isNormal)
{
foreach (var book in BookShelfService.AllBooks().Where(o => o.Name.Contains(key) == true))
{
searchBooks.Add(book);
}
}
else
{
BookShelf shelf = shelfBindingSource.Current as BookShelf;
foreach (var book in BookShelfService.AllBooks().Where(o => o.Name.Contains(key) == true).Where(i => i.BookShelfId == shelf.BookShelfId))
{
searchBooks.Add(book);
}
}
break;
case "作者":
if (!isNormal)
{
foreach (var book in BookShelfService.AllBooks().Where(o => o.Author.Contains(key) == true))
{
searchBooks.Add(book);
}
}
else
{
BookShelf shelf = shelfBindingSource.Current as BookShelf;
foreach (var book in BookShelfService.AllBooks().Where(o => o.Author.Contains(key) == true).Where(i => i.BookShelfId == shelf.BookShelfId))
{
searchBooks.Add(book);
}
}
break;
case "分类":
if (!isNormal)
{
foreach (var book in BookShelfService.AllBooks().Where(o => o.Sort.Contains(key) == true))
{
searchBooks.Add(book);
}
}
else
{
BookShelf shelf = shelfBindingSource.Current as BookShelf;
foreach (var book in BookShelfService.AllBooks().Where(o => o.Sort.Contains(key) == true).Where(i => i.BookShelfId == shelf.BookShelfId))
{
searchBooks.Add(book);
}
}
break;
default:
MessageBox.Show("没有选择正确的查询方式！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
break;
}
bookBindingSource.DataMember = null;
bookBindingSource.DataSource = searchBooks;
}
}