/// <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 JsonResult Createdetials(Models.createbook insert) { int createdetials = new int(); Models.service create = new Models.service(); createdetials = create.Insertbook(insert); if (ModelState.IsValid) { Models.service insertsevice = new Models.service(); insertsevice.Insertbook(insert); } return(Json(createdetials)); }
public ActionResult Create(Models.createbook INSERT) { Models.createbook test = new Models.createbook(); ViewBag.BOOK_CLASS_NAME = this.codeservice.GetBOOK_CLASS_NAME(); if (ModelState.IsValid) { Models.service insertsevice = new Models.service(); if (INSERT.buydate != null) { INSERT.buydate = INSERT.buydate.Replace(",", ""); } insertsevice.Insertbook(INSERT); TempData["message"] = "存檔成功"; } return(View()); }
/// <summary> /// 新增bf /// </summary> /// <returns></returns> public ActionResult create() { Models.createbook test = new Models.createbook(); ViewBag.BOOK_CLASS_NAME = this.codeservice.GetBOOK_CLASS_NAME(); return(View()); }