///<summary>
///insert bookInfos by excel about excel's path
///</summary>
public int insertBookInfosByExcel(string excelPath)
{
BookInfoDAL dal = new BookInfoDAL();
int success = 0;
return(success);
}
public static string AddBook(BookInfoModel book)
{
string msg = "图书添加失败";
if (BookInfoDAL.InsertBook(book) > 0)
{
msg = "图书添加成功";
}
return(msg);
}
/// <summary>
/// Delete
/// </summary>
/// <param name="id">ID</param>
/// <returns>int</returns>
public static int Del(int id)
{
try
{
return(BookInfoDAL.Del(id));
}
catch (Exception error)
{
throw error;
}
}
/// <summary>
/// Add
/// </summary>
/// <param name="bk">Class</param>
/// <returns>int</returns>
public static int Add(BookInfo bk)
{
try
{
return(BookInfoDAL.Add(bk));
}
catch (Exception error)
{
throw error;
}
}
/// <summary>
/// Find and by BkID/BkName/TypeID Find
/// </summary>
/// <param name="bkFilter">Model_BookIngo_View</param>
/// <returns>List</returns>
public static List <BookInfo_View> Find(BookInfo_View bkFilter)
{
try
{
return(BookInfoDAL.Find(bkFilter));
}
catch (Exception error)
{
throw error;
}
}
public static bool AddBookToIndent(string id, int num)
{
result = BookInfoDAL.AddToIndent(id, num);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool DeleteBook(string isbn)
{
result = BookInfoDAL.Delete(isbn);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool UpdateBook(BookInfo book)
{
result = BookInfoDAL.Update(book);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool AddBook(BookInfo book, int z)
{
result = BookInfoDAL.Add(book, z);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool DeleteIndent(string id)
{
result = BookInfoDAL.DeleteIndent(id);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public static string DelBook(int bookid, int delNew)
{
LayUIDelBook delBook = new LayUIDelBook();
if (BookInfoDAL.DelBook(bookid, delNew) == 1)
{
delBook.code = 0;
delBook.msg = "success";
}
else
{
delBook.code = 1;
delBook.msg = "failed";
}
return(JsonConvert.SerializeObject(delBook));
}
public static string GetAllBooks(int page, int limit)
{
LayUITable table = new LayUITable();
table.code = 0;
table.count = BookInfoDAL.SelectBookCount();
if (page == -1 || limit == -1)
{
table.data = BookInfoDAL.GetAllBooks();
}
else
{
table.data = BookInfoDAL.GetAllBooks((page - 1) * limit, limit);
}
table.msg = "success";
return(JsonConvert.SerializeObject(table));
}
public static List <BookInfo> FinfAllBooksBT(string sort)
{
List <BookInfo> lstBooks = BookInfoDAL.Select(sort);
return(lstBooks);
}
public static List <BookInfo> FinfAllBooks(int z)
{
List <BookInfo> lstBooks = BookInfoDAL.Select(z);
return(lstBooks);
}
///<summary>
///update bookInfo infomation
///</summary>
public int updateBookInfoModel(BookInfoModel model)
{
BookInfoDAL dal = new BookInfoDAL();
return(dal.updateBookInfoByModel(model));
}
public int getBookCount(string typeID)
{
BookInfoDAL dal = new BookInfoDAL();
return(dal.getBookCount(typeID));
}
/// <summary>
/// 根据图书类型和当前页数返回查询的图书
/// </summary>
/// <param name="typeID"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public List <BookInfoModel> getBookInfoByType(string typeID, int pageIndex)
{
BookInfoDAL dal = new BookInfoDAL();
return(dal.getBookInfoByPage(typeID, (pageIndex - 1) * 20 + 1, pageIndex * 20));
}
///<summary>
///delete bookInfo by model( many fields fuzzy query )
///</summary>
public int deleteBookInfo(BookInfoModel book)
{
BookInfoDAL dal = new BookInfoDAL();
return(dal.deleteBookInfo(book));
}
///<summary>
///update bookInfo borrowing status
///</summary>
public int updateBookInfoStatus(string bookID, bool status)
{
BookInfoDAL dal = new BookInfoDAL();
return(dal.updateBookInfoStatus(bookID, status));
}
///<summary>
///delete bookInfo By bookID
///</summary>
public int deleteBookInfo(string bookID)
{
BookInfoDAL dal = new BookInfoDAL();
return(dal.deleteBookInfo(bookID));
}
///<summary>
///insert one bookInfo by model
///</summary>
public int insertBookInfo(BookInfoModel book)
{
BookInfoDAL dal = new BookInfoDAL();
return(dal.insertBookInfo(book));
}
///<summary>
///get bookInfo by List like book's name
///</summary>
public List <BookInfoModel> getBookInfoLikeName(string name, int pageIndex)
{
BookInfoDAL dal = new BookInfoDAL();
return(dal.getBookInfoLikeName(name, (pageIndex - 1) * 20 + 1, pageIndex * 20));
}
///<summary>
///get all bookInfo by List
///</summary>
public List <BookInfoModel> getAllBookInfoList(int pageIndex)
{
BookInfoDAL dal = new BookInfoDAL();
return(dal.getAllBookInfoList((pageIndex - 1) * 20, pageIndex * 20));
}
public static List <BookInfo> FinfAllBooksIndent(Boolean a)
{
List <BookInfo> lstBooks = BookInfoDAL.Select(a);
return(lstBooks);
}
public static void SetBook(BookInfoModel book)
{
BookInfoDAL.UpdateBook(book);
}
public int getBookCountLike(string name)
{
BookInfoDAL dal = new BookInfoDAL();
return(dal.getBookCountLike(name));
}
public static string GetAllBook()
{
return(JsonConvert.SerializeObject(BookInfoDAL.SelectAllBook()));
}
public static int GetBookCount()
{
return(BookInfoDAL.SelectBookCount());
}
public static DataTable GetAllBookOfCategory(int id)
{
return(BookInfoDAL.SelectBookByCategory(id));
}
/// <summary>
/// get book's count
/// </summary>
/// <returns></returns>
public int getBookCount()
{
BookInfoDAL dal = new BookInfoDAL();
return(dal.getBookCount());
}
