//update public Book_Maintain_Ajax.Model.BookUpdate GetUpdateBook(int id) { string sql = @"SELECT bd.BOOK_ID AS BookID,bd.BOOK_NAME AS BookName,bd.BOOK_AUTHOR AS BookAuthor,bd.BOOK_PUBLISHER AS BookPublisher,bd.BOOK_NOTE AS Note, CONVERT(varchar, bd.BOOK_BOUGHT_DATE, 111) AS BoughtDate,bc.BOOK_CLASS_ID AS BookClassId, bcd.CODE_ID AS BookStatusId,mm.USER_ID AS BookKeeperId FROM BOOK_DATA bd INNER JOIN BOOK_CLASS bc ON bd.BOOK_CLASS_ID = bc.BOOK_CLASS_ID INNER JOIN BOOK_CODE bcd ON bd.BOOK_STATUS = bcd.CODE_ID AND bcd.CODE_TYPE = 'BOOK_STATUS' LEFT OUTER JOIN MEMBER_M mm ON bd.BOOK_KEEPER = mm.[USER_ID] WHERE BOOK_ID = @BOOK_ID" ; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { var TempUpdateBook = conn.Query <Book_Maintain_Ajax.Model.BookUpdate>(sql, new { BOOK_ID = id }); Book_Maintain_Ajax.Model.BookUpdate UpdateBook = new Model.BookUpdate(); foreach (var updateBook in TempUpdateBook) { UpdateBook = updateBook; } return(UpdateBook); } }
public JsonResult ShowBookDetail(string id) { if (bookService.IsIdExist(id)) { Model.BookUpdate bookdetail = bookService.GetBookDetail(Convert.ToInt32(id)); return(Json(bookdetail, JsonRequestBehavior.AllowGet)); } else { return(Json(null, JsonRequestBehavior.AllowGet)); } }
public JsonResult UpdateBook(Model.BookUpdate bookUpdate, string IniBookStatus, string LaterBookStatus) { //借閱人借閱狀態關係 if ((bookUpdate.BookStatusId == "B" || bookUpdate.BookStatusId == "C") && (bookUpdate.BookKeeperId == "" || bookUpdate.BookKeeperId == null)) { return(Json("此借閱狀態,借閱人不能為空")); } else { //insert 借閱紀錄 if ((IniBookStatus == "A" || IniBookStatus == "U") && (LaterBookStatus == "B" || LaterBookStatus == "C")) { Model.LendRecordInsert lendRecordInsert = new Model.LendRecordInsert(); lendRecordInsert.BookKeeperId = bookUpdate.BookKeeperId; bookService.InsertLendRecord(lendRecordInsert); } //update 書本資料 bookService.UpdateBook(bookUpdate); return(Json("編輯成功")); } }
public void Clean() { //Arrange Book_Maintain_Ajax.Model.BookUpdate bookUpdateClean = new Model.BookUpdate { BookName = "hello world", BookAuthor = "Marz", BookPublisher = "南一", Note = "112233", BoughtDate = "2019/03/15", BookClassId = "BK", BookStatusId = "A", BookKeeperId = "" }; //Act //bookDao.UpdateBook(InsertId, bookUpdate); bookDao.UpdateBook(InsertId, bookUpdateClean); string IfDelete = bookDao.DecideDelete(Convert.ToString(InsertId)); System.Diagnostics.Debug.WriteLine("TestClean:" + InsertId); System.Diagnostics.Debug.WriteLine("************TestClean SUCCESS*************"); //Alert Assert.AreEqual("刪除成功", IfDelete); }
public JsonResult GetUpdateData(string id) { Model.BookUpdate bookupdate = bookService.GetUpdateBook(Convert.ToInt32(id)); return(Json(bookupdate, JsonRequestBehavior.AllowGet)); }