public ActionResult Create(BookInfo book, HttpPostedFileBase file)
 {
     if (_bManager.Add(book))
         return Content("<script>alert('添加成功!');location.href='/home/bookinfo'</script>");
     else
         return Content("<script>alert('添加失败!');location.href='/home/bookinfo'</script>");
 }
        public BookInfo SearchById(int id)
        {
            BookInfo b = new BookInfo(); ;
            string sql = "select * from dbo.Books where Id = @id";
            SqlParameter para = new SqlParameter("id", id);
            using (SqlDataReader reader = ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, sql, para))
            {
                if (reader.Read())
                {
                    b.Id = (int)reader["Id"];
                    b.Title = (string)reader["Title"];
                    b.Author = (string)reader["Author"];
                    b.PublisherId = (int)reader["PublisherId"];
                    b.PublishDate = reader["PublishDate"].ToString();
                    b.ISBN = (string)reader["ISBN"];
                    b.UnitPrice = (double)reader["UnitPrice"];
                    b.ContentDescription = (string)reader["UnitPrice"];
                    b.TOC = (string)reader["TOC"];
                    b.CategoryId = (int)reader["CategoryId"];
                    b.Clicks = (int)reader["Clicks"];

                    reader.Close();
                }
            }
            return b;
        }
        public List<BookInfo> GetBookList(int cateId)
        {
            List<BookInfo> list = new List<BookInfo>();

               string sql = "select * from dbo.Books where CategoryId = @cateid";
               SqlParameter[] para = {
                                      new SqlParameter("cateid", cateId)
                                 };
               DataTable dt = ExecuteDataset(ConnectionString, CommandType.Text, sql, para).Tables[0];

               if(dt != null)
               {
               for (int i = 0; i < dt.Rows.Count; i++)
               {
                   BookInfo book = new BookInfo();

                   book.Id = (int)dt.Rows[i]["Id"];
                   book.Title = dt.Rows[i]["Title"].ToString();
                   book.Author = dt.Rows[i]["Author"].ToString();
                   book.PublisherId = (int)dt.Rows[i]["PublisherId"];
                   book.PublishDate = dt.Rows[i]["PublishDate"].ToString();
                   book.ISBN = dt.Rows[i]["ISBN"].ToString();
                   book.UnitPrice = Convert.ToDouble(dt.Rows[i]["UnitPrice"]);
                   book.ContentDescription = dt.Rows[i]["ContentDescription"].ToString();
                   book.TOC = dt.Rows[i]["TOC"].ToString();
                   book.CategoryId = (int)dt.Rows[i]["CategoryId"];
                   book.Clicks = (int)dt.Rows[i]["Clicks"];

                   list.Add(book);
               }
               }

               return list;
        }
        public bool S_Add(BookInfo b)
        {
            string sql = "insert into dbo.Books (Title, Author, PubliserId, PublishDate, ISBN, UnitPrice, ContentDescrption, TOC, CategoryId, Clicks) "
               + "values(@title, @author, @publisherId, @publishDate, @isbn, @unitPrice, @contentDescrption, @tOC, @categoryId)";

               SqlParameter[] para = {
                                      new SqlParameter("title", b.Title),
                                      new SqlParameter("author", b.Author),
                                      new SqlParameter("publisherId", b.PublisherId),
                                      new SqlParameter("publishDate", b.PublishDate),
                                      new SqlParameter("isbn", b.ISBN),
                                      new SqlParameter("unitPrice", b.UnitPrice),
                                      new SqlParameter("contentDescrption", b.ContentDescription),
                                      new SqlParameter("tOC", b.TOC),
                                      new SqlParameter("categoryId", b.CategoryId),
                                  };

               return ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.Text, sql, para) == 1;
        }
 public bool Add(BookInfo book)
 {
     return bis.S_Add(book);
 }
 public bool S_Update(BookInfo b)
 {
     string sql = "UPDATE dbo.Books " +
         "SET " +
             "Title = @title, " + //FK
             "Author = @author, " + //FK
             "PublisherId = @publisherId, " +
             "PublishDate = @publishDate, " +
             "ISBN = @isbn, " +
             "Unitprice = @unitprice, " +
             "ContentDescription = @Pcontentdescription, " +
             "TOC = @toc, " +
             "CategoryId = @categoryid, " +
             "WHERE Id = @Id";
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@title", b.Title),
         new SqlParameter("@author", b.Author),
         new SqlParameter("@publisherId", b.PublisherId),
         new SqlParameter("@publishDate", b.PublishDate),
         new SqlParameter("@isbn", b.ISBN),
         new SqlParameter("@unitprice", b.UnitPrice),
         new SqlParameter("@contentdescription", b.ContentDescription),
         new SqlParameter("@toc", b.TOC),
         new SqlParameter("@categoryidail", b.CategoryId),
         new SqlParameter("@Id", b.Id),
     };
     return ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.Text, sql, para) == 1;
 }