public JsonResult GetBookData(int bookID) { BookSystem.Model.BookUpdate bookData = new BookSystem.Model.BookUpdate(); if (bookService.findBook(bookID) != "") { bookData = bookService.GetEditById(bookID); return(Json(bookData)); } else { string alert = "BookIDNotExist"; return(Json(alert)); } }
/// <summary> /// Map資料 /// </summary> private BookSystem.Model.BookUpdate MapBookDataForUpdateToList(DataTable BookData) { BookSystem.Model.BookUpdate result = new BookSystem.Model.BookUpdate(); foreach (DataRow row in BookData.Rows) { result.BOOK_ID = (int)row["BookID"]; //result.BOOK_NAME = row["BookName"].ToString(); result.BOOK_NAME = Microsoft.Security.Application.Encoder.HtmlEncode(row["BookName"].ToString()); //result.BOOK_AUTHOR = row["Author"].ToString(); result.BOOK_AUTHOR = Microsoft.Security.Application.Encoder.HtmlEncode(row["Author"].ToString()); result.BOOK_PUBLISHER = row["Publisher"].ToString(); result.BOOK_NOTE = row["Note"].ToString(); result.BOOK_BOUGHT_DATE = row["BoughDate"].ToString(); result.BOOK_CLASS_NAME = row["BookClassName"].ToString(); result.BOOK_CLASS_ID = row["BookClassID"].ToString(); result.BOOK_STATUS = row["StatusName"].ToString(); result.BOOK_STATUS_ID = row["StatusID"].ToString(); result.USER_ENAME = row["UserName"].ToString(); result.KEEPER_ID = row["UserID"].ToString(); } return(result); }
/// <summary> /// 修改書籍資料 /// </summary> public void UpdateById(BookSystem.Model.BookUpdate arg) { string sql = @"UPDATE BOOK_DATA SET BOOK_NAME =@BOOK_NAME, BOOK_AUTHOR =@BOOK_AUTHOR, BOOK_PUBLISHER =@BOOK_PUBLISHER, BOOK_NOTE =@BOOK_NOTE, BOOK_BOUGHT_DATE =@BOOK_BOUGHT_DATE, BOOK_CLASS_ID=@BOOK_CLASS_ID, BOOK_STATUS=@BOOK_STATUS_ID, BOOK_KEEPER=@KEEPER_ID WHERE BOOK_ID=@BOOK_ID;"; string sqlAboutInsertLendRecord = @"INSERT INTO BOOK_LEND_RECORD( BOOK_ID, KEEPER_ID, LEND_DATE, CRE_DATE, MOD_DATE )VALUES( @BOOK_ID, @KEEPER_ID, @LEND_DATE, @CRE_DATE, @MOD_DATE) "; if (arg.KEEPER_ID != null) { sql = sql + sqlAboutInsertLendRecord; } using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@BOOK_NAME", arg.BOOK_NAME)); cmd.Parameters.Add(new SqlParameter("@BOOK_AUTHOR", arg.BOOK_AUTHOR)); cmd.Parameters.Add(new SqlParameter("@BOOK_PUBLISHER", arg.BOOK_PUBLISHER)); cmd.Parameters.Add(new SqlParameter("@BOOK_NOTE", arg.BOOK_NOTE)); cmd.Parameters.Add(new SqlParameter("@BOOK_BOUGHT_DATE", arg.BOOK_BOUGHT_DATE)); cmd.Parameters.Add(new SqlParameter("@BOOK_CLASS_ID", arg.BOOK_CLASS_ID)); cmd.Parameters.Add(new SqlParameter("@BOOK_STATUS_ID", arg.BOOK_STATUS_ID)); cmd.Parameters.Add(new SqlParameter("@KEEPER_ID", arg.KEEPER_ID == null ? string.Empty : arg.KEEPER_ID)); cmd.Parameters.Add(new SqlParameter("@BOOK_ID", arg.BOOK_ID)); cmd.Parameters.Add(new SqlParameter("@LEND_DATE", DateTime.Now.ToShortDateString())); cmd.Parameters.Add(new SqlParameter("@CRE_DATE", DateTime.Now.ToShortDateString())); cmd.Parameters.Add(new SqlParameter("@MOD_DATE", DateTime.Now.ToShortDateString())); SqlTransaction tran = conn.BeginTransaction(); cmd.Transaction = tran; try { cmd.ExecuteNonQuery();//可以知道影響幾筆(int) tran.Commit(); } catch { tran.Rollback(); throw; } finally { conn.Close(); } } }
public JsonResult UpdateBook(BookSystem.Model.BookUpdate book) { bookService.UpdateById(book); return(Json(true)); }
public void UpdateById(BookSystem.Model.BookUpdate arg) { bookDao.UpdateById(arg); }