/// <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);
}
