/// <summary>
/// 表:Book 根据BSID子查询所有信息
/// </summary>
/// <param name="BSID">BSID</param>
/// <returns>查询结果</returns>
public static List <Book> Select_BSID(int BSID)
{
return(Dal_Book.Select_BSID(BSID));
}
/// <summary>
/// 表:Book 根据BID分页
/// </summary>
/// <param name="PageSize">页大小</param>
/// <param name="PageIndex">当前页</param>
/// <param name="BSID">子查询所需BSID</param>
/// <returns>分页结果</returns>
public static List <Book> TopPaging_BSID(int PageSize, int PageIndex, int BSID)
{
return(Dal_Book.TopPaging_BSID(PageSize, PageIndex, BSID));
}
/// <summary>
/// 表:Book (判断单个BID是否存在
/// </summary>
/// <param name="BID">所需BID</param>
/// <returns>是否存在</returns>
public static bool Exists_BID(int BID)
{
return(Dal_Book.Exists_BID(BID));
}
/// <summary>
/// 表:Book 查询(倒序 BSaleCount 前 5)
/// </summary>
/// <returns>查询结果</returns>
public static List <Book> DOrderBy_BSaleCount()
{
return(Dal_Book.DOrderBy_BSaleCount());
}
// <summary>
/// 表:Book (根据BID删除
/// </summary>
/// <param name="BID">所需BID</param>
/// <returns>执行成功行数</returns>
public static int Delete_BID(int BID)
{
return(Dal_Book.Delete_BID(BID));
}
/// <summary>
/// 表:Book (根据BID修改数据
/// </summary>
/// <param name="book">修改的数据</param>
/// <returns>执行成功的行数</returns>
public static int Update_BID(Book book)
{
return(Dal_Book.Update_BID(book));
}
/// <summary>
/// 表:Book (查询最大的BISBN
/// </summary>
/// <returns>查询结果</returns>
public static ulong Select_MaxBISBN()
{
return(Dal_Book.Select_MaxBISBN());
}
/// <summary>
/// 表:Book (根据BName进行分页
/// </summary>
/// <param name="BName">所需参数BName</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageIndex">当前页</param>
/// <returns></returns>
public static List <Book> TopPaging_BName(string BName, int PageSize, int PageIndex)
{
return(Dal_Book.TopPaging_BName(BName, PageSize, PageIndex));
}
/// <summary>
/// 表:Book (添加一条数据
/// </summary>
/// <param name="book">添加的数据</param>
/// <returns>执行成功的行数</returns>
public static int Insert(Book book)
{
return(Dal_Book.Insert(book));
}
/// <summary>
/// 表:Book 查询(倒序 BDate 前 5)
/// </summary>
/// <returns>查询结果</returns>
public static List <Book> DOrderBy_BDate()
{
return(Dal_Book.DOrderBy_BDate());
}
/// <summary>
/// 表:Book (查询总行数
/// </summary>
/// <returns>查询结果</returns>
public static int RowCount_BName(string BName)
{
return(Dal_Book.RowCount_BName(BName));
}
/// <summary>
/// 表:Book (查询总行数
/// </summary>
/// <returns>查询结果</returns>
public static int RowCount()
{
return(Dal_Book.RowCount());
}
/// <summary>
/// 表:Book (Top分页处理
/// </summary>
/// <param name="PageSize">页大小</param>
/// <param name="PageIndex">当前页</param>
/// <returns>分页结果</returns>
public static List <Book> TopPaging(int PageSize, int PageIndex)
{
return(Dal_Book.TopPaging(PageSize, PageIndex));
}
/// <summary>
/// 表:Book 根据BID查询
/// </summary>
/// <param name="BID">BSID</param>
/// <returns>查询结果</returns>
public static Book Select_BID(int BID)
{
return(Dal_Book.Select_BID(BID));
}
/// <summary>
/// 表:Book (查询最大的BID
/// </summary>
/// <returns>查询结果</returns>
public static int Select_MaxBID()
{
return(Dal_Book.Select_MaxBID());
}
/// <summary>
/// 表:Book (根据BID修改BCount
/// </summary>
/// <param name="book">修改的数据</param>
/// <returns>执行成功的行数</returns>
public static int Update_BCountAndBSaleCount(Book book)
{
return(Dal_Book.Update_BCountAndBSaleCount(book));
}
/// <summary>
/// 表:Book (根据BID查找BCount
/// </summary>
/// <param name="BID">参数数据</param>
/// <returns>查询结果</returns>
public static int Select_BCount(int BID)
{
return(Dal_Book.Select_BCount(BID));
}
