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