/// <summary> /// 新增書籍 /// </summary> /// <param name="book"></param> /// <returns>員工編號</returns> public int InsertBook(Models.AddBook book) { string sql = @" INSERT INTO BOOK_DATA ( BookName,BookAuthor,BookPublisher,BookNote,BookBoughtDate,BookClassName ) VALUES ( @BookName,@BookAuthor,@BookPublisher,@BookNote,@BookBoughtDate,@BookClassName ) Select SCOPE_IDENTITY()" ; int EmployeeId; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@BookName", book.BookName == null ? (Object)DBNull.Value : book.BookName)); cmd.Parameters.Add(new SqlParameter("@BookAuthor", book.BookAuthor == null ? (Object)DBNull.Value : book.BookAuthor)); cmd.Parameters.Add(new SqlParameter("@BookPublisher", book.BookPublisher == null ? (Object)DBNull.Value : book.BookPublisher)); cmd.Parameters.Add(new SqlParameter("@BookNote", book.BookNote == null ? (Object)DBNull.Value : book.BookNote)); cmd.Parameters.Add(new SqlParameter("@BookBoughtDate", book.BookBoughtDate == null ? (Object)DBNull.Value : book.BookBoughtDate)); cmd.Parameters.Add(new SqlParameter("@BookClassName", book.BookClassName == null ? (Object)DBNull.Value : book.BookClassName)); EmployeeId = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); } return(EmployeeId); }
public ActionResult InsertBook(Models.AddBook book) { Models.BookService bookService = new Models.BookService(); ViewBag.AddBookItem = bookService.InsertBook(book); return(View()); }