public SqlDataReader SelectKaoJuanTop1() { string sql = "select top 1 * from KaoJuan order by KaoJuanID desc"; return(DBHelper.GetDataReader(sql)); }
/// <summary> /// 根据编号查询书本返回非断开式查询 /// </summary> /// <param name="id"></param> /// <returns></returns> public static SqlDataReader GetBooksReturnDataReaderByID(int id) { string sql1 = string.Format("select * from books where goodsid={0}", id); return(DBHelper.GetDataReader(sql1)); }