public ActionResult InsertBook(Models.BookInsert insertdata)
{
ViewBag.BookClass = bookservice.GetDropdownList("GetClass");
if (ModelState.IsValid)
{
bookservice.InsertBook(insertdata);
return(RedirectToAction("Index"));
}
return(View());
}
public void InsertBook(Models.BookInsert insertdata)
{
string sql = @"
BEGIN TRY
BEGIN TRANSACTION
INSERT INTO BOOK_DATA
(
BOOK_NAME,BOOK_CLASS_ID,BOOK_AUTHOR,
BOOK_BOUGHT_DATE,BOOK_PUBLISHER,BOOK_NOTE,
BOOK_STATUS,BOOK_KEEPER,BOOK_AMOUNT,CREATE_DATE,
CREATE_USER,MODIFY_DATE,MODIFY_USER
)
VALUES
(
@BookName,@BookClass, @BookAuthor,
@BoughtDate, @BookPublisher, @Note,
'A','',0,GETDATE(),
'123',GETDATE(), '123'
)
Select SCOPE_IDENTITY()
COMMIT TRANSACTION
End TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() as ErrorState,
ERROR_PROCEDURE() as ErrorProcedure,
ERROR_LINE() as ErrorLine,
ERROR_MESSAGE() as ErrorMessage
ROLLBACK TRANSACTION
END CATCH " ;
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@BookName", insertdata.BookName));
cmd.Parameters.Add(new SqlParameter("@BookClass", insertdata.BookClass));
cmd.Parameters.Add(new SqlParameter("@BookAuthor", insertdata.BookAuthor));
cmd.Parameters.Add(new SqlParameter("@BoughtDate", insertdata.BoughtDate));
cmd.Parameters.Add(new SqlParameter("@BookPublisher", insertdata.BookPublisher));
cmd.Parameters.Add(new SqlParameter("@Note", insertdata.Note)); //ExecuteScalar 執行一個SQL命令返回結果集的第一列的第一行即id
cmd.ExecuteNonQuery();
conn.Close();
}
}
