/// <summary>
/// 借书
/// </summary>
/// <param name="userId"></param>
/// <param name="bookId"></param>
/// <returns></returns>
public Borrows BorrowBook(int userId, int bookId)
{
if (!GetBookState(bookId))
{
throw new Exception("Books lent out");
}
if (!GlobalFunc.GetBorrowState(userId))
{
throw new Exception("Low credit score");
}
//修改书的状态，前端应该已经完成对book的状态的检测
DbContext.DBstatic.Updateable <Book>().SetColumns(it => new Book {
State = 1
}).Where(it => it.Id == bookId)
.ExecuteCommand();
//插入borrow表
var result = DbContext.DBstatic.Saveable(new Borrows
{
Reader_id = userId,
Book_id = bookId,
Renew = 0,
Borrow_Time = DateTime.Now.Date,
Expire_Time = DateTime.Now.Date.AddMonths(1),
State = 0
}).ExecuteReturnEntity();
return(result);
throw new NotImplementedException();
}
