Related to Sort Order

Location: ZKDB.py

• def isAnySortOrderDuplicated(dbpath=””)
  • “SELECT SortOrder, COUNT(*) c FROM DataCenter GROUP BY SortOrder HAVING c > 1”
• def resortSortNumber(dbpath=””)
  • “SELECT SortOrder, IDBangou FROM DataCenter ORDER BY SortOrder ASC”
  • “UPDATE DataCenter SET SortOrder = ” + str(c) + ” WHERE IDBangou = ” + quote_idbangou
  • “Update DataCenter SET SortOrder = ” +str(newsortid[cn]) +” WHERE SortOrder = ” + str(cursortid[cn])
• def isIDBangouAlreadyExisted(idb)
  • “SELECT SortOrder FROM DataCenter WHERE IDBangou = ” + slash_idbangou
• def deleteFromDataCenter(idb, dbRow=None)
  • “SELECT SortOrder FROM DataCenter WHERE IDBangou = ” + slash_idbangou
  • “Update DataCenter Set SortOrder = SortOrder-1 WHERE SortOrder>”+str(rows[0][0])
  • “SELECT IDBangou FROM DataCenter WHERE SortOrder = ” + str(dbRow+1)
  • “DELETE FROM DataCenter WHERE SortOrder = ” + str(dbRow+1)
  • “Update DataCenter Set SortOrder = SortOrder-1 WHERE SortOrder>”+str(dbRow+1), True)
• def getBuhinType(conn, idbangou)
  • “Select * FROM DataCenter WHERE IDBangou =”+ idbangou + ” ORDER BY SortOrder”
• def calcAndSet_HacchuuChekku(autoconnect = True)
  • “SELECT IDBangou, Zaikosuu, HacchuuRain FROM DataCenter ORDER BY SortOrder”
• def getSortOrderBusho(kojinbangou)
  • “Select Busho, SortOrder FROM User WHERE KojinBangou =”+ kojinbangou
• …