def getISBN(self):
sqlRunner1 = M_SqlRunner()
selISBNSQL = [
'SELECT ISBN FROM t_bookinfo WHERE bookId = %d' % (self.__bookId)
]
ret = sqlRunner1.beginSql(selISBNSQL)
return ret
def searchReader(self):
creater = Acon_SearchReader()
runner = M_SqlRunner()
sql = creater.setSearch()
sqlList = [sql]
ret = runner.beginSql(sqlList)
return ret
class MC_UpBook:
def __init__(self):
self.creater = Acon_UpBook()
self.runner = M_SqlRunner()
def searchIfIsbnExist(self,infoList):
isbn = infoList[1]
sql = self.creater.searchIfIsbnExist(isbn)
sqlList = [sql]
ret = self.runner.beginSql(sqlList)
if ret : ##书籍存在
return '1'
else:
##不存在返回书架信息
sql = self.creater.getAvailableShelf()
sqlList = [sql]
ret = self.runner.beginSql(sqlList)
return ret
def getNextBookId(self):
sql = self.creater.getNextBookId()
sqlList = []
sqlList.append(sql)
ret = self.runner.beginSql(sqlList)[0][0]
return ret
def addNewBook_exist(self,infoList):
sqlList = []
isbn = infoList[0]
operId = infoList[1]
bookId = str(self.getNextBookId() +1)
sqlList.append(self.creater.changeBookStock(isbn))
sqlList += self.creater.upBook(operId, isbn, bookId)
status = self.runner.beginSql(sqlList)
if status is not '-1':
return bookId
else:
return '0'
def addNewBook_notexist(self,infoList):
creater = Acon_UpBook()
isbn = infoList[0]
bookName = infoList[1]
bookAuthor = infoList[2]
bookPublisher = infoList[3]
bookPrice = infoList[4]
bookCreateTime = infoList[5]
operId = infoList[6]
shelfId = infoList[7]
bookId = str(self.getNextBookId() +1 )
sqlList = creater.addNewIsbn(isbn, shelfId, bookName, bookAuthor, bookPublisher, bookPrice, bookCreateTime)
sqlList += self.creater.upBook(operId, isbn, bookId)
status = self.runner.beginSql(sqlList)
#添加成功 返回bookId
if status is not '-1':
return bookId
else:
return '0'
def devideWords(self, searchList):
sqlCreate = Acon_devideWordsOp()
sql = sqlCreate.setSearch(searchList)
sqlList = [sql]
sqlRunner = M_SqlRunner()
ret = sqlRunner.beginSql(sqlList)
return ret
def getPrice(self):
#动态SQL查询语句
isbn = self.getISBN()[0][0]
sqlRunner2 = M_SqlRunner()
selPriceSQL = [
'SELECT bookPrice FROM t_isbninfo WHERE ISBN = %s' % (isbn)
]
ret = sqlRunner2.beginSql(selPriceSQL)
return ret
def beginCompare(self, logKey):
userId = logKey[0]
userPwd = logKey[1]
creater = Acon_AdminLogin()
runner = M_SqlRunner()
sql = creater.setSql(userId, userPwd)
sqlList = [sql]
ret = runner.beginSql(sqlList)
if ret:
return '1'
else:
return '0'
def buybook(self):
sqlRunner = M_SqlRunner()
# 从界面中获取的书籍id不存在，则返回0
if self.getISBN() == ():
return '2'
else:
#若已支付成功，则进行数据库操作，返回数据库操作结果
if self.__payFlag == 1:
self.__sqlList.append(self.updateAmount())
self.__sqlList.append(self.addDeal())
self.__sqlList.append(self.delBookId())
ret = sqlRunner.beginSql(self.__sqlList)
return ret
else:
return '3'
class MC_downBook:
def __init__(self):
self.creater = Acon_downBook()
self.runner = M_SqlRunner()
def searchIfBookIdExist(self, infoList):
bookId = infoList[1]
sql1 = self.creater.searchIfBookIdExist(bookId)
sqlList = [sql1]
ret = self.runner.beginSql(sqlList)
return ret
def searchIsbn(self, infoList):
bookId = infoList[1]
sql2 = self.creater.searchIsbn(bookId)
sqlList = [sql2]
ret = self.runner.beginSql(sqlList)
return ret
def searchBorrowList(self, infoList):
bookId = infoList[1]
sql3 = self.creater.searchBorrowList(bookId)
sqlList = [sql3]
ret = self.runner.beginSql(sqlList)
return ret
def changeBookInfo(self, infoList):
ret1 = self.searchIfBookIdExist(infoList)
#如果Id存在
if ret1:
#查书籍id对应isbn
isbn = self.searchIsbn(infoList)
isbn = str(isbn[0][0])
#查书籍是否借出
ret2 = self.searchBorrowList(infoList)
bookId = infoList[1]
operId = infoList[2]
sqlList = self.creater.changeInfo(bookId, isbn, operId, ret2)
ret3 = self.runner.beginSql(sqlList)
if ret3 is '0':
return '1'
else:
return '0'
else:
return '0'
class MC_SearchBorrowMassage:
def __init__(self):
self.creater = Acon_SearchBorrowMassage()
self.runner = M_SqlRunner()
def getSearchBorrow(self):
sql = self.creater.setSearch()
sqlList = [sql]
borrowList = self.runner.beginSql(sqlList)
return borrowList
def __init__(self):
self.creater = Acon_downBook()
self.runner = M_SqlRunner()
def __init__(self):
self.creater = Acon_SearchBorrowMassage()
self.runner = M_SqlRunner()
def beginSql(self, sql):
sqlRunner = M_SqlRunner()
ret = sqlRunner.beginSql(sql)
return ret