public ActionResult edit(Models.editbook modify)
{
Models.editbook test = new Models.editbook();
ViewBag.BOOK_CLASS_NAME = this.codeService.GetBookClassName("BOOK_CLASS_NAME");
ViewBag.CODE_NAME = this.codeService.GetCodeName("CODE_NAME");
ViewBag.USER_ENAME = this.codeService.GetUerName("USER_ENAME");
return(View());
}
public ActionResult Edit(Models.editbook modify)
{
Models.editbook test = new Models.editbook();
ViewBag.BOOK_CLASS_NAME = this.codeservice.GetBOOK_CLASS_NAME();
ViewBag.CODE_NAME = this.codeservice.GetCODE_NAME();
ViewBag.USER_ENAME = this.codeservice.GetUSER_ENAME();
return(View());
}
/// <summary>
/// 修改
/// </summary>
public void EditBook(Models.editbook data)
{
string sql = @"UPDATE BOOK_DATA
SET BOOK_NAME = @BOOK_NAME ,BOOK_AUTHOR = @BOOK_AUTHOR,
BOOK_PUBLISHER = @BOOK_PUBLISHER, BOOK_NOTE = @BOOK_NOTE,
BOOK_BOUGHT_DATE = @BOOK_BOUGHT_DATE, BOOK_STATUS = @CODE_ID,
BOOK_CLASS_ID = @BOOK_CLASS_ID, BOOK_KEEPER = @BOOK_KEEPER
WHERE BOOK_ID = @BOOK_ID";
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@BOOK_NAME", data.bookname));
cmd.Parameters.Add(new SqlParameter("@BOOK_AUTHOR", data.author));
cmd.Parameters.Add(new SqlParameter("@BOOK_PUBLISHER", data.publisher));
cmd.Parameters.Add(new SqlParameter("@BOOK_NOTE", data.introduction));
cmd.Parameters.Add(new SqlParameter("@BOOK_BOUGHT_DATE", data.buydate));
cmd.Parameters.Add(new SqlParameter("@BOOK_CLASS_ID", data.bookcatorory));
cmd.Parameters.Add(new SqlParameter("@CODE_ID", data.status));
cmd.Parameters.Add(new SqlParameter("@BOOK_KEEPER", data.bookuser));
cmd.Parameters.Add(new SqlParameter("@BOOK_ID", data.bookid));
SqlTransaction trans = conn.BeginTransaction();
cmd.Transaction = trans;
try
{
cmd.ExecuteNonQuery();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
throw;
}
finally
{
conn.Close();
}
}
}
public JsonResult ModifyBook(Models.editbook data)
{
Models.service updatebookdata = new Models.service();
updatebookdata.EditBook(data);
return(Json(""));
}
