///<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()); }