//添加借书请求
public ActionResult BringListAdd(int id)
{
电商.Areas.Admin.Models.Entities4 db = new Models.Entities4();
电商.Areas.Admin.Models.bookstatus b = db.bookstatus.Find(id);
ViewBag.b = b;
ViewBag.id = id;
return(View());
}
public ActionResult BringListAddSave(int bookid, string time, string user)
{
int userId = Convert.ToInt32(user);
电商.Areas.Admin.Models.Entities4 db = new Models.Entities4();
电商.Areas.Admin.Models.bookstatus bookstaus = db.bookstatus.Find(bookid);
if (bookstaus.num - bookstaus.bringnum <= 0)
{
return(Content("余量不足"));
}
List <电商.Areas.Admin.Models.person> list = db.person.Where(m => m.id == userId).ToList();
if (list.Count >= 1)
{
try
{
电商.Areas.Admin.Models.person this_people = list[0];
电商.Areas.Admin.Models.bring b = new Models.bring();
b.book_id = bookid;
b.person_id = this_people.id;
b.bringtime = time;
bookstaus.num--;
db.bring.Add(b);
db.SaveChanges();
return(Content("借阅成功"));
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
var msg = string.Empty;
var errors = (from u in ex.EntityValidationErrors select u.ValidationErrors).ToList();
foreach (var item in errors)
{
msg += item.FirstOrDefault().ErrorMessage;
}
return(Content(msg));
}
}
else
{
return(Content("用户不存在"));
}
}
public ActionResult AddtoLibrarySave(int orderId, string location, string finishtime)
{
电商.Areas.Admin.Models.Entities4 db = new Models.Entities4();
电商.Areas.Admin.Models.order order = db.order.Find(orderId);
order.isFinish = 1;
order.endtime = finishtime;
List <电商.Areas.Admin.Models.bookstatus> bs = db.bookstatus.Where(m => m.book_id == order.book_id && m.location == location).ToList();
if (bs.Count >= 1)
{
电商.Areas.Admin.Models.bookstatus b = bs[0];
b.num += order.num;
}
else
{
电商.Areas.Admin.Models.bookstatus b = new Models.bookstatus();
b.num = order.num;
b.location = location;
b.book_id = order.book_id;
db.bookstatus.Add(b);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
