/// <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());
}
