public static List <Book> 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; } } return(searchBooks); }
public static List <Book> 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.Sort 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; } } return(queryBooks); }
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.accountButton.Visible = false; this.libraryButton.Visible = false; //this.managePictureBox.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); recommendBooks = BookShelfService.getRecommend(); recommendBindingSource.DataSource = recommendBooks; }