在以下方法或属性之间的调用不明确
/*根据查询条件对图书信息进行查询*/
public DataSet QueryBooksInfo(string bookName, int bookTypeId, string author)
{
/*根据各个查询条件构造查询的sql语句*/
string sqlString = "select * from [booksView] where 1=1";
if(bookName != "")
sqlString += " and bookName like '%" + bookName + "%'";
if(bookTypeId != 0)
sqlString += " and bookTypeId=" + bookTypeId;
if (author != "")
sqlString += " and author like '%" + author + "%'";
/*调用数据层进行查询并返回结果集*/
DataSet ds = DBOperation.GetDataSet(DBOperation.CONN_STRING_NON_DTC, CommandType.Text, sqlString, null);
return ds;
}
/*根据图书编号得到某个图书对象的信息并返回该图书对象模型*/
public BooksModel GetBookInfo(int bookId)
{
string sqlString = "select * from [books] where bookId=" + bookId;
DataSet ds = DBOperation.GetDataSet(DBOperation.CONN_STRING_NON_DTC, CommandType.Text, sqlString, null);
if (ds.Tables[0].Rows.Count == 0) return null;
DataRow dr = ds.Tables[0].Rows[0];
BooksModel booksModel = new BooksModel();
booksModel.BookId = Convert.ToInt32(dr["bookId"]);
booksModel.BookName = dr["bookName"].ToString();
booksModel.BookTypeId = Convert.ToInt32(dr["bookTypeId"]);
booksModel.Author = dr["author"].ToString();
booksModel.Publishing = dr["publishing"].ToString();
booksModel.BookMoney = Convert.ToSingle(dr["bookMoney"]);
booksModel.BookNum = Convert.ToInt32(dr["bookNum"]);
booksModel.Introduction = dr["introduction"].ToString();
return booksModel;
}