/// <summary> /// 新增員工 /// </summary> /// <param name="employee"></param> /// <returns></returns> public int Insertbook(Models.Createbook insert) { string sql = @" INSERT INTO BOOK_DATA ( BOOK_NAME, BOOK_AUTHOR, BOOK_PUBLISHER, BOOK_NOTE, BOOK_BOUGHT_DATE, BOOK_CLASS_ID,BOOK_STATUS,BOOK_KEEPER ) VALUES ( @BOOK_NAME, @BOOK_AUTHOR, @BOOK_PUBLISHER, @BOOK_NOTE, @BOOK_BOUGHT_DATE, @BOOK_CLASS_ID,'A',' ' ) Select SCOPE_IDENTITY()" ; int add; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@BOOK_NAME", insert.BookName)); cmd.Parameters.Add(new SqlParameter("@BOOK_AUTHOR", insert.Author)); cmd.Parameters.Add(new SqlParameter("@BOOK_PUBLISHER", insert.Publisher)); cmd.Parameters.Add(new SqlParameter("@BOOK_NOTE", insert.Introduction)); cmd.Parameters.Add(new SqlParameter("@BOOK_BOUGHT_DATE", insert.BuyDate)); cmd.Parameters.Add(new SqlParameter("@BOOK_CLASS_ID", insert.BookCatorory)); add = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); } return(add); }
public ActionResult Create(Models.Createbook insertdata) { Models.Createbook test = new Models.Createbook(); ViewBag.BOOK_CLASS_NAME = this.codeService.GetBookClassName("BOOK_CLASS_NAME"); if (ModelState.IsValid) { Models.Service insertsevice = new Models.Service(); if (insertdata.BuyDate != null) { insertdata.BuyDate = insertdata.BuyDate.Replace(",", ""); } insertsevice.Insertbook(insertdata); TempData["message"] = "存檔成功"; } return(View()); }
/// <summary> /// 新增前 /// </summary> /// <returns></returns> public ActionResult Create() { Models.Createbook test = new Models.Createbook(); ViewBag.BOOK_CLASS_NAME = this.codeService.GetBookClassName("BOOK_CLASS_NAME"); return(View()); }