public void Initializa() { test = new BookDao(); iBook = new Books() { //BOOK_ID = 0, BookName = "ibook", BookAuthor = "ia", BookPublisher = "ip", BookNote = "insert_test", BookBoughtDate = "2018-08-01", BookClassId = "BK" }; argI = new BookSearchArg() { BookName = "ibook", BookClassId = "BK", BookKeeper = "", BookCodeId = "A" }; argEmpty = new BookSearchArg() { BookName = "", BookClassId = "", BookKeeper = "", BookCodeId = "" }; bookUpdateData = new BookUpdateData() { BookName = "ubook", BookAuthor = "ua", BookPublisher = "up", BookNote = "update_test", BookBoughtDate = "2018-08-01", BookCodeId = "A", BookKeeper = "0003" }; }
/// <summary> /// 編輯書籍 /// </summary> /// <param name="book"></param> /// <returns></returns> public bool UpdateBookData(eLibrary.Model.BookUpdateData book) { string sql = @" BEGIN TRY BEGIN TRANSACTION UPDATE dbo.BOOK_DATA SET BOOK_NAME = @BookName, BOOK_AUTHOR = @BookAuthor, BOOK_PUBLISHER = @BookPublisher, BOOK_NOTE = @BookNote, BOOK_BOUGHT_DATE =CONVERT( varchar(12), @BookBoughtDate, 111) , BOOK_CLASS_ID = @BookClass, BOOK_STATUS = @BookStatus, BOOK_KEEPER = @BookKeeper WHERE BOOK_ID = @BookId COMMIT TRANSACTION END TRY BEGIN CATCH ROLLBACK TRANSACTION END CATCH" ; //not sure the usage of BookId var result = 0; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@BookId", book.BookId)); cmd.Parameters.Add(new SqlParameter("@BookName", book.BookName)); cmd.Parameters.Add(new SqlParameter("@BookAuthor", book.BookAuthor)); cmd.Parameters.Add(new SqlParameter("@BookPublisher", book.BookPublisher)); cmd.Parameters.Add(new SqlParameter("@BookNote", book.BookNote)); cmd.Parameters.Add(new SqlParameter("@BookBoughtDate", book.BookBoughtDate)); cmd.Parameters.Add(new SqlParameter("@BookClass", book.BookClassId)); cmd.Parameters.Add(new SqlParameter("@BookStatus", book.BookCodeId)); cmd.Parameters.Add(new SqlParameter("@BookKeeper", book.BookKeeper == null ? string.Empty : book.BookKeeper)); result = cmd.ExecuteNonQuery(); conn.Close(); } return(result == 1); }
/// <summary> /// 編輯書籍 /// </summary> /// <param name="book"></param> /// <returns></returns> public bool UpdateBookData(eLibrary.Model.BookUpdateData book) { return(bookDao.UpdateBookData(book)); }