public ActionResult Edit(Models.BOOK_DATA b_data) { if (this.ModelState.IsValid) { using (Models.BooksManagementEntities db = new Models.BooksManagementEntities()) { var l_result = (from m in db.BOOK_DATA where m.BOOK_ID == b_data.BOOK_ID select m).FirstOrDefault(); l_result.BOOK_NAME = b_data.BOOK_NAME; l_result.BOOK_AUTHOR = b_data.BOOK_AUTHOR; l_result.BOOK_PUBLISHER = b_data.BOOK_PUBLISHER; l_result.BOOK_NOTE = b_data.BOOK_NOTE; l_result.BOOK_BOUGHT_DATE = b_data.BOOK_BOUGHT_DATE; l_result.BOOK_CLASS_ID = b_data.BOOK_CLASS_ID; l_result.BOOK_STATUS = b_data.BOOK_STATUS; l_result.BOOK_KEEPER = b_data.BOOK_KEEPER; db.SaveChanges(); TempData["ResultMessage"] = string.Format("書籍[{0}]修改成功", b_data.BOOK_NAME); } } else { ViewBag.ResultMessage = string.Format("資料有誤,請檢查", b_data.BOOK_NAME); } return(RedirectToAction("Index")); }
public ActionResult InsertBook(Models.BOOK_DATA book) { ///後端驗證 if (ModelState.IsValid) { book.CREATE_DATE = DateTime.Now; book.CREATE_USER = "******"; book.MODIFY_DATE = DateTime.Now; book.MODIFY_USER = "******"; Models.BookService.bookData.Add(book); } return(RedirectToAction("Index", "Book", null)); }
public ActionResult Create(Models.BOOK_DATA b_data) { if (this.ModelState.IsValid) { using (Models.BooksManagementEntities db = new Models.BooksManagementEntities()) { b_data.BOOK_STATUS = "v"; db.BOOK_DATA.Add(b_data); db.SaveChanges(); TempData["ResultMessage"] = string.Format("書籍[{0}]建立成功", b_data.BOOK_NAME); } } else { ViewBag.ResultMessage = string.Format("資料有誤,請檢查", b_data.BOOK_NAME); } return(RedirectToAction("Index")); }
public ActionResult UpdateBook(Models.BOOK_DATA book) { var books = Models.BookService.bookData; if (ModelState.IsValid) { var changeBook = books.Find(x => x.BOOK_ID == book.BOOK_ID); books.Remove(changeBook); changeBook.BOOK_NAME = book.BOOK_NAME; changeBook.BOOK_CLASS_ID = book.BOOK_CLASS_ID; changeBook.BOOK_AUTHOR = book.BOOK_AUTHOR; changeBook.BOOK_NOTE = book.BOOK_NOTE; changeBook.BOOK_KEEPER = book.BOOK_KEEPER; changeBook.BOOK_BOUGHT_DATE = book.BOOK_BOUGHT_DATE; changeBook.BOOK_PUBLISHER = book.BOOK_PUBLISHER; changeBook.BOOK_STATUS = book.BOOK_STATUS; changeBook.MODIFY_DATE = DateTime.Now; changeBook.MODIFY_USER = "******"; books.Add(changeBook); } return(RedirectToAction("Index", "Book", null)); }
/// <summary> /// 新增書籍 /// </summary> /// <param name="book"></param> /// <returns>員工編號</returns> public int InsertEmployee(Models.BOOK_DATA book) { string sql = @" INSERT INTO [dbo].[BOOK_DATA] ( BOOK_NAME, BOOK_CLASS_ID, BOOK_AUTHOR, BOOK_BOUGHT_DATE, BOOK_PUBLISHER, BOOK_NOTE BOOK_STATUS, BOOK_KEEPER, CREATE_DATE, CREATE_USER, MODIFY_DATE, MODIFY_USER ) VALUES ( @BOOK_NAME, @BOOK_CLASS_ID, @BOOK_AUTHOR, @BOOK_BOUGHT_DATE, @BOOK_PUBLISHER, @BOOK_NOTE @BOOK_STATUS, @BOOK_KEEPER, @CREATE_DATE, @CREATE_USER, @MODIFY_DATE, @MODIFY_USER ) Select SCOPE_IDENTITY()" ; int BOOK_ID; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@BOOK_NAME", book.BOOK_NAME)); cmd.Parameters.Add(new SqlParameter("@BOOK_CLASS_ID", book.BOOK_CLASS_ID)); cmd.Parameters.Add(new SqlParameter("@BOOK_AUTHOR", book.BOOK_AUTHOR)); cmd.Parameters.Add(new SqlParameter("@BOOK_BOUGHT_DATE", book.BOOK_BOUGHT_DATE)); cmd.Parameters.Add(new SqlParameter("@BOOK_PUBLISHER", book.BOOK_PUBLISHER)); cmd.Parameters.Add(new SqlParameter("@BOOK_NOTE", book.BOOK_NOTE)); cmd.Parameters.Add(new SqlParameter("@BOOK_STATUS", book.BOOK_STATUS)); cmd.Parameters.Add(new SqlParameter("@BOOK_KEEPER", book.BOOK_KEEPER)); cmd.Parameters.Add(new SqlParameter("@CREATE_DATE", book.CREATE_DATE)); cmd.Parameters.Add(new SqlParameter("@CREATE_USER", book.CREATE_USER)); cmd.Parameters.Add(new SqlParameter("@MODIFY_DATE", book.MODIFY_DATE)); cmd.Parameters.Add(new SqlParameter("@MODIFY_USER", book.MODIFY_USER)); BOOK_ID = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); } return(BOOK_ID); }