/// <summary>
/// 还书后根据借阅 ID 查询是否超期，若超期则扣信用分
/// </summary>
/// <param name="borrowId"></param>
public void ReturnResult(int borrowId)
{
try
{
GlobalFunc.RefreshBookState();
var state = DbContext.DBstatic.Queryable <Borrows>()
.Where(br => br.Borrow_id == borrowId)
.Select(br => br.State)
.First();
if (state == -1)
{
var userId = DbContext.DBstatic.Queryable <Borrows>()
.Where(br => br.Borrow_id == borrowId)
.Select(rd => rd.Reader_id)
.First();
var score = DbContext.DBstatic.Queryable <ReaderInfo>()
.Where(rd => rd.ID == userId)
.Select(rd => rd.Credit_Score)
.First();
var setScore = score - 30;
if (setScore < 0)
{
setScore = 0;
}
DbContext.DBstatic.Updateable <Reader>()
.SetColumns(rd => new Reader
{
credit_score = setScore
})
.Where(rd => rd.id == userId)
.ExecuteCommand();
}
}
catch
{
throw new Exception("Credit modification failed");
}
}
public void Do()
{
GlobalFunc.RefreshBookState();
}
