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