public SqlDataReader queryBySort(string sort)
{
string cmdText = "select * from book where b_sort='" + sort + "'";
return(DbHelper.ExecuteReader(cmdText));
}
public SqlDataReader queryByInventory(string inventory)
{
string cmdText = "select * from book where b_inventory='" + inventory + "'";
return(DbHelper.ExecuteReader(cmdText));
}
public SqlDataReader queryByIsbn(string isbn)
{
string cmdText = "select * from book where b_isbn='" + isbn + "'";
return(DbHelper.ExecuteReader(cmdText));
}
public SqlDataReader queryByPrice(string price)
{
string cmdText = "select * from book where b_price='" + price + "'";
return(DbHelper.ExecuteReader(cmdText));
}
public SqlDataReader querybyPager(string paper)
{
string cmdText = "select * from book where b_paper='" + paper + "'";
return(DbHelper.ExecuteReader(cmdText));
}
public SqlDataReader queryByPackaging(string packaging)
{
string cmdText = "select * from book where b_packaging='" + packaging + "'";
return(DbHelper.ExecuteReader(cmdText));
}
public SqlDataReader queryByWords(string words)
{
string cmdText = "select * from book where b_words='" + words + "'";
return(DbHelper.ExecuteReader(cmdText));
}
public SqlDataReader queryByFormat(string format)
{
string cmdText = "select * from book where b_format='" + format + "'";
return(DbHelper.ExecuteReader(cmdText));
}
public SqlDataReader queryByImpression(string impression)
{
string cmdText = "select * from book where b_impression='" + impression + "'";
return(DbHelper.ExecuteReader(cmdText));
}
public SqlDataReader queryByEdition(string edition)
{
string cmdText = "select * from book where b_edition='" + edition + "'";
return(DbHelper.ExecuteReader(cmdText));
}
public SqlDataReader queryByAuthor(string author)
{
string cmdText = "select * from book where b_author='" + author + "'";
return(DbHelper.ExecuteReader(cmdText));
}
public SqlDataReader queryByName(string name)
{
string cmdText = "select * from book where b_name='" + name + "'";
return(DbHelper.ExecuteReader(cmdText));
}
//根据id查询，以下多个函数均类似
public SqlDataReader queryById(string id)
{
string cmdText = "select * from book where b_id='" + id + "'";
return(DbHelper.ExecuteReader(cmdText));
}