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