dbm.cmd2('CREATE TABLE IF NOT EXISTS [USER_LIST] ( [id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,[companyname] TEXT,[department] TEXT,[field] TEXT,[manager] TEXT,[phone] TEXT );')
def updateUserList(tableObj) :
tableObj.clearGridData()
lstUserList = dbm.cmd2('SELECT * FROM USER_LIST')
dataRow = 1
rowIndexPerPage = 1
allData = list()
for userInfo in lstUserList :
userId = userInfo.value('id')
companyName = userInfo.value('companyname')
department = userInfo.value('department')
field = userInfo.value('field')
manager = userInfo.value('manager')
phone = userInfo.value('phone')
page = (dataRow / tableObj.rowCount()) + 1
data = list()
data.append(companyName)
data.append(department)
data.append(field)
data.append(manager)
data.append(phone)
allData.append(data)
if tableObj.rowCount()-1 == rowIndexPerPage :
rowIndexPerPage = 0
dataRow += 1
rowIndexPerPage += 1
tableObj.setGridData(1, 0, tableObj.rowCount()-1, 5, allData)
pageInfo = canvas.getObject('rectTotalPage')
pageInfo.setProperty('FaceText', str(tableObj.currentPage()) + ' / ' + str(tableObj.totalPage()))
updateUserList(canvas.getObject('TextTable_1'))
|