public bool returnBook(Borrow b, User u)
{
int ret = 0;
String sql = string.Format("Update BorrowRecord set IsReturn = 1,ReturnOperator='{1}' where Id ={0}",
b.Id, u.code);
ret = conn.execNonSQL(sql);
if (ret == 1)
{
return(true);
}
return(false);
}
public bool addDays(Borrow b)
{
int ret = 0;
DateTime ReturnDate = b.ReturnDate;
int days = getReaderCate(b.ReaderCateId).ReBorrowDays;
ReturnDate = ReturnDate.AddDays(days);
String sql = string.Format("Update BorrowRecord set ReBorrowTimes = ReBorrowTimes-1,ReturnDate = '{1}' where Id ={0}",
b.Id, ReturnDate.ToString("yyyy-MM-dd"));
ret = conn.execNonSQL(sql);
if (ret == 1)
{
return(true);
}
return(false);
}