/// <summary>
/// 表:Book (查询最大的BID
/// </summary>
/// <returns>查询结果</returns>
public static int Select_MaxBID()
{
return(Convert.ToInt32(DBHelp.ExecuteScalar(
"select Max(bid) from book",
null)));
}
/// <summary>
/// 表:Book (查询总行数
/// </summary>
/// <returns>查询结果</returns>
public static int RowCount()
{
return(Convert.ToInt32(DBHelp.ExecuteScalar("select count(*) from Book", null)));
}
/// <summary>
/// 表:Book (查询最大的BISBN
/// </summary>
/// <returns>查询结果</returns>
public static ulong Select_MaxBISBN()
{
return(Convert.ToUInt64(DBHelp.ExecuteScalar(
"select Max(bisbn) from book",
null).ToString().Trim()));
}
/// <summary>
/// 表：Order （获取新产生列OID
/// </summary>
/// <returns>新产生列OID</returns>
public static string ObtainOID()
{
return(DBHelp.ExecuteScalar("select dbo.ObtainOID()", null).ToString());
}