/// <summary> /// 新增書籍 /// </summary> public void InsertBook(BookSystem.Model.Books book) { string sql = @"INSERT INTO BOOK_DATA( BOOK_NAME, BOOK_AUTHOR, BOOK_PUBLISHER, BOOK_NOTE, BOOK_BOUGHT_DATE, BOOK_CLASS_ID, BOOK_STATUS ) VALUES ( @BOOK_NAME, @BOOK_AUTHOR, @BOOK_PUBLISHER, @BOOK_NOTE, @BOOK_BOUGHT_DATE, @BOOK_CLASS_ID, @BOOK_STATUS )" ; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@BOOK_NAME", book.BOOK_NAME)); cmd.Parameters.Add(new SqlParameter("@BOOK_AUTHOR", book.BOOK_AUTHOR)); cmd.Parameters.Add(new SqlParameter("@BOOK_PUBLISHER", book.BOOK_PUBLISHER)); cmd.Parameters.Add(new SqlParameter("@BOOK_NOTE", book.BOOK_NOTE)); cmd.Parameters.Add(new SqlParameter("@BOOK_BOUGHT_DATE", book.BOOK_BOUGHT_DATE)); cmd.Parameters.Add(new SqlParameter("@BOOK_CLASS_ID", book.BOOK_CLASS_ID)); cmd.Parameters.Add(new SqlParameter("@BOOK_STATUS", "A")); SqlTransaction tran = conn.BeginTransaction(); cmd.Transaction = tran; try { cmd.ExecuteNonQuery();//可以知道影響幾筆(int) tran.Commit(); } catch { tran.Rollback(); throw; } finally { conn.Close(); } } }
public JsonResult InsertBookInView(BookSystem.Model.Books book) { bookService.InsertBook(book); return(Json(true)); }
public void InsertBook(BookSystem.Model.Books book) { bookDao.InsertBook(book); }