// GET: BookManage
public ActionResult Index(string bookName, long searchselectedID = 0, bool? isAvaliable = null, Int32 pageIndex = 0)
{
if (!string.IsNullOrEmpty(bookName))
{
bookName = bookName.Trim();
}
BookManageIndexModel model = new BookManageIndexModel();
BookInfoCondition condition = new BookInfoCondition();
condition.BookName = bookName;
condition.CategoryID = searchselectedID;
condition.IsAvaliable = isAvaliable;
IEnumerable<BookInfo> books = this.IBookInfoDataProvider.GetBookList(condition);
PagingContentFormat2<BookInfo> paging = new PagingContentFormat2<BookInfo>(books, pageIndex, 6);
foreach (var item in paging.EntityList)
{
model.BookModelList.Add(BookModel.GetViewModel(item, this.LoginUser()));
}
model.SearchBookName = bookName;
model.SearchCategoryList = DropDownListHelper.GetCategorySelectListBySelectedID(searchselectedID);
model.PagingContent = paging;
return View(model);
}
// GET: BooksServer
public JsonResult Index(string bookName, int pageIndex = 0)
{
List<BookServerModel> modelList = new List<BookServerModel>();
BookInfoCondition condition = new BookInfoCondition();
condition.BookName = bookName;
IEnumerable<BookInfo> books = this.IBookInfoDataProvider.GetBookList(condition);
PagingContent<BookInfo> paging = new PagingContent<BookInfo>(books, pageIndex);
foreach (var item in paging.EntityList)
{
modelList.Add(BookServerModel.GetServerModel(item));
}
return Json(modelList, JsonRequestBehavior.AllowGet);
}
public static PublisherModel GetViewModel(PublisherInfo publisher)
{
PublisherModel model = new PublisherModel();
model.ID = publisher.ID;
model.PublisherName = publisher.PublisherName;
model.PublisherIntroduction = publisher.PublisherIntroduction;
IBookInfoDataProvider iBookInfoDataProvider = new BookInfoDataProvider();
BookInfoCondition condition = new BookInfoCondition();
condition.Publisher = publisher;
if ( iBookInfoDataProvider.GetBookList(condition).Count() > 0)
{
model.IsUse = true;
}
return model;
}
public IEnumerable<BookInfo> GetBookList(BookInfoCondition condition)
{
IEnumerable<BookInfo> bookList = this.DataSource.BookInfos;
if (condition.CategoryID > 0)
{
var bcr = this.DataSource.BookAndCategoryRelation;
var categorys = this.DataSource.CategoryInfos;
bookList = from r in bcr
join b in bookList on r.Book_ID equals b.ID
join c in categorys on r.Category_ID equals c.ID
where c.ID == condition.CategoryID
select b;
}
if (!String.IsNullOrEmpty(condition.BookName))
{
bookList = bookList.Where(b => b.BookName.Contains(condition.BookName));
}
if (condition.Publisher != null)
{
bookList = bookList.Where(b => b.PublisherInfo.ID == condition.Publisher.ID);
}
if (condition.IsAvaliable.HasValue)
{
if (condition.IsAvaliable.Value)
{
bookList = bookList.Where(b => b.Avaliable_Inventory > 0);
}
}
bookList = bookList.OrderByDescending(b => b.Publish_Date);
return bookList;
}