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