//新增借閱紀錄到資料庫 public void InsertLendRecord(Models.LendRecordInsert insertdata) { string sql = @" BEGIN TRY BEGIN TRANSACTION INSERT INTO BOOK_LEND_RECORD ( BOOK_ID,KEEPER_ID,LEND_DATE,CRE_DATE,CRE_USR,MOD_DATE,MOD_USR ) VALUES ( @BookId,@KeeperId, GETDATE(), GETDATE(), '123', GETDATE(), '123' ) 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("@BookId", insertdata.BookID)); cmd.Parameters.Add(new SqlParameter("@KeeperId", insertdata.BookKeeperId)); //ExecuteScalar 執行一個SQL命令返回結果集的第一列的第一行即id cmd.ExecuteNonQuery(); conn.Close(); } }
public ActionResult UpdateBook(Models.BookUpdate updatedata) { ViewBag.BookClass = bookservice.GetDropdownList("GetClass"); ViewBag.BookKeeper = bookservice.GetDropdownList("GetUpdateKeeper"); ViewBag.BookStatus = bookservice.GetDropdownList("GetStatus"); //顯示DropDownList bool relation = ((updatedata.BookStatusId == "B" || updatedata.BookStatusId == "C") && (updatedata.BookKeeperId == "" || updatedata.BookKeeperId == null)); if (ModelState.IsValid && !relation) { string LaterBookStatus = updatedata.BookStatusId; string IniBookStatus = updatedata.IniStatus; if ((IniBookStatus == "A" || IniBookStatus == "U") && (LaterBookStatus == "B" || LaterBookStatus == "C")) { Models.LendRecordInsert lendRecordInsert = new Models.LendRecordInsert(); lendRecordInsert.BookKeeperId = updatedata.BookKeeperId; lendRecordInsert.BookID = Convert.ToInt32(updatedata.BookID); bookservice.InsertLendRecord(lendRecordInsert); } bookservice.UpdateBook(Convert.ToInt32(updatedata.BookID), updatedata); return(RedirectToAction("Index")); } return(View()); }