[开发测试]MVC图书管理借书操作

这里是图书管理系统的一个借书操作，目的是点击借书的时候弹出借书模态框，

然后将筛选的数据做一个回填，再点保存时书籍的可用册数会减-1，这里只做控制器的操作。

public?ActionResult?modification(int?bookId)??//获取该书的Id

{

????try

????{

????????var?book = (from?tabook in?Model.S_book

????????????????????where?tabook.bookId == bookId??//是否与数据库书的Id一样

????????????????????select?new?BookVo??//new一个实体类

????????????????????{

????????????????????????bookId = tabook.bookId,

...

????????????????????????//筛选要回填的数据

????????????????????}).Single();??//返回唯一

????????return?Json(book, JsonRequestBehavior.AllowGet);

????}

????catch?(Exception?e)

????{

????????return?Json(null, JsonRequestBehavior.AllowGet);

????}

}

//这里数据库表没数据，通过上面回填的数据来给到下面的表

public?ActionResult?AddTheBox(B_Record?record,S_User?user,S_book?book)

{

RetuenJsonVo?rtJson = new?RetuenJsonVo();

????if?(user.userId > 0)

{

????//判断可用册数是否大于0

????????if(book.allowVolume > 0)

????????{

????????????//查询表是否有数据

????????????int?recordCount = (from?tbrecord in?Model.B_Record

???????????????????????????????select?tbrecord).Count();

????????????if?(recordCount > 0)??//有数据则 > 0

????????????{

????????????????//借书状态的新增

????????????????record.bookStateId = 1;

Model.B_Record.Add(record);

//可用册数-1的修改

????????????????book.allowVolume -= 1;

????????????????Model.Entry(book).State = System.Data.Entity.EntityState.Modified;

????????????????if?(Model.SaveChanges() > 0)

????????????????{

????????????????????rtJson.State = true;

????????????????????rtJson.Text = "借书成功！";

????????????????}

????????????????else

????????????????{

????????????????????rtJson.Text = "借书失败！";

????????????????}

????????????}

????????????else

????????????{

?????????????????rtJson.Text = "借书失败，请检查！";

????????????}

????????}

????????else

????????{

????????????rtJson.Text = "该书已借完！";

????????}

????}

????else

????{

?????????rtJson.Text = "请选择借书账号！";

????}

return?Json(rtJson, JsonRequestBehavior.AllowGet);

}