/*根据查询条件对图书信息进行查询*/
        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;
        }