def GetBorrowRecordByField(self, obj):
# 拼接
Seq = []
Val = []
if obj.get_borrowid() != '':
Seq.append('borrowid')
Val.append(obj.get_borrowid())
if obj.get_userid() != '':
Seq.append('userid')
Val.append(obj.get_userid())
if obj.get_bookid() != '':
Seq.append('bookid')
Val.append(obj.get_bookid())
if obj.get_borrowdate() != '':
Seq.append('borrowdate')
Val.append(obj.get_borrowdate())
if obj.get_presretdate() != '':
Seq.append('presretdate')
Val.append(obj.get_presretdate())
if obj.get_actretdate() != '':
Seq.append('actretdate')
Val.append(obj.get_actretdate())
Dict = dict(zip(Seq, Val))
mysql = Mysql()
sql = "select * from borrow where "
keys = tuple(Dict.keys())
vals = tuple(Dict.values())
Len = len(Dict)
for i in range(Len):
if (i != Len - 1):
sql = sql + keys[i] + "='" + str(vals[i]) + "' and "
else:
sql = sql + keys[i] + "='" + str(vals[i]) + "'"
Bor = mysql.getAll(sql)
if Bor == False:
print('no record')
# Book = mysql.getAll(sql)
# if Book == False:
# print('no record')
# if len(Book) == 0:
# print("No borrow record found!")
# else:
# print("The borrow record you found:")
# if Book:
# for row in Book:
# print("%s\t%s\t%s\t%s\t%s\t%s" % (row[0], row[1], row[2], row[3], row[4], row[5]))
mysql.dispose()
show = MiddleLayer()
tums = show.ShowBorrow(Bor)
return tums
def RetureIllegalRecord(self):
mysql = Mysql()
# 获取系统时间
systime = datetime.datetime.now().strftime('%Y-%m-%d')
# 返回超过系统时间还未还的图书借阅记录
# sql = "select * from borrow where actretdate < '" + systime + "' and presretdate = '0000-00-00'"
sql = "select * from borrow where actretdate < '" + "1996-01-01" + "' and presretdate = '0000-00-00'"
result = mysql.getAll(sql)
mysql.dispose()
if (result == False):
print('no record')
return 0
show = MiddleLayer()
tums = show.ShowBorrow(result)
return tums
def GetBorrowRecord(self, num=0):
mysql = Mysql()
if (str(num) == '0'):
sqlAll = "select * from borrow"
else:
sqlAll = "select * from borrow limit " + str(num)
result = mysql.getAll(sqlAll)
print("borrowid\tuserid\tbookid\tborrowdate\tpresretdate\tactretdate")
if result:
for row in result:
print("%s\t%s\t%s\t%s\t%s\t%s" % \
(row[0], row[1], row[2], row[3], row[4], row[5]))
mysql.dispose()
if result == False:
print('no record')
return 0
show = MiddleLayer()
tums = show.ShowBorrow(result)
return tums