如何按最高编号对pyqt中的一列进行排序？目前，我setSortingEnabled(True)只能按最高数字（例如1,1,1,1,2,2,2,3,3）对它进行排序，例如，我想按最高数字（例如58,25 ，15,10）。谢谢！
setSortingEnabled(True)
资料更新：
def setmydata(self): for n, key in enumerate(self.data): for m, item in enumerate(self.data[key]): newitem = QtGui.QTableWidgetItem(item) self.setItem(m, n, newitem)
整个代码：
import sys from PyQt4.QtGui import QTableWidget from PyQt4 import QtGui,QtCore,Qt import MySQLdb as mdb from functools import partial import time class Window(QtGui.QDialog): process_column_signal = QtCore.pyqtSignal() def __init__(self,parent=None): super(Window, self).__init__() self.layout = QtGui.QVBoxLayout(self) self.db = mdb.connect('serv','user','pass','db') self.model = self.db.cursor() self.initialData = self.get_data_status() self.table1 = MyTableStatus(self.initialData, 145, 4) callback = partial(self.process_column,self.table1) self.process_column_signal.connect(callback) self.layout.addWidget(self.table1) self.timer_status = QtCore.QTimer() self.timer_status.timeout.connect(self.updateAllViews) self.timer_status.timeout.connect(self.some_method) # check every half-second self.timer_status.start(1000*5) def some_method(self): self.process_column_signal.emit() def get_data_status(self): self.model.execute("""SELECT cpu_juliet,cpu,cpu_julietleft FROM status WHERE date = (SELECT MAX(date) FROM status)""") rows_status_cpu = self.model.fetchone() self.listb1 = ['%s' % rows_status_cpu[0],'%s' % rows_status_cpu[2],'%s' % rows_status_cpu[1],'%s' % rows_status_cpu[1]]#['%s %s' % self.rows_status] self.model.execute("""SELECT disk_queue_juliet FROM status WHERE date = (SELECT MAX(date) FROM status)""") rows_status_disk_queue = self.model.fetchone() self.lista1 = 'Juliet','Julietleft','Pong','Hulk' self.listc1 = ['%s' % rows_status_disk_queue,'%s' % rows_status_disk_queue,'%s' % rows_status_disk_queue,'%s' % rows_status_disk_queue ] if self.listb1[0] >= '80' or self.listc1[0] >= '9': server_status_Juliet = 'WARNING' else: server_status_Juliet = 'Normal' if self.listb1[1] >= '80' or self.listc1[1] >= '9': server_status_Julietleft = 'WARNING' else: server_status_Julietleft = 'Normal' if self.listb1[2] >= '80' or self.listc1[2] >= '9': server_status_Pong = 'WARNING' else: server_status_Pong = 'Normal' if self.listb1[3] >= '80' or self.listc1[3] >= '9': server_status_Hulk = 'WARNING' else: server_status_Hulk = 'Normal' self.listd1 = ['%s' % server_status_Juliet,'%s' % server_status_Julietleft,'%s' % server_status_Pong,'%s' % server_status_Hulk] # if server_status_Hulk == "WARNING": #or server_status_Pong == "WARNING" or server_status_Julietleft == "WARNING" or server_status_Juliet == "WARNING": # self.serverstatus.setStyleSheet("QTabWidget {color: red}") #status label conditions self.mystruct1 = {'A':self.lista1, 'B':self.listb1, 'C':self.listc1, 'D':self.listd1} return self.mystruct1 def updateAllViews(self): _ = self.get_data_status() self.updateTable() def updateTable(self): self.table1.updateFromDict(self.mystruct1) def process_column(table1, processCol=1): colCount = table1.table1.rowCount() for row in xrange(table1.table1.rowCount()): for col in xrange(4): try: item = table1.table1.item(row, 3) text = item.text() if (float(text) >= 20.0 ): for col in xrange(colCount): print row item = table1.table1.item(row,col) item.setBackground(QtGui.QBrush(QtCore.Qt.yellow)) except: pass class MyTableStatus(QTableWidget): def __init__(self, thestruct, *args): QTableWidget.__init__(self, *args) self.setSizePolicy(QtGui.QSizePolicy.Fixed, QtGui.QSizePolicy.Preferred) self.setHorizontalHeaderLabels(['Server', 'Avg. Disk Queue','CPU Load',"Status"]) self.setSortingEnabled(False) self.data = {} self.setmydata() def updateFromDict(self, aDict): self.data.clear() self.data.update(aDict) self.setmydata() def setmydata(self): for n, key in enumerate(self.data): for m, item in enumerate(self.data[key]): newitem = QtGui.QTableWidgetItem(item) self.setItem(m, n, newitem) def main(): app = QtGui.QApplication(sys.argv) app.setStyle(QtGui.QStyleFactory.create("plastique")) main_window = Window() main_window.repaint() main_window.show() sys.exit(app.exec_()) if __name__ == '__main__': main()
它按字母数字排序（因此，按照字符串，“ 1”，“ 10”，“ 11”，“ 12”，“ 2”，“ 20”，“ 21”，“ 22”，“ 3”，“ 4’等是正确的排序顺序。对于QTableWidgetItem，如果您使用setData（Qt.EditRole，value）方法，则该排序顺序将起作用。根据您的Qt版本（我假设），您可能拥有重载表格小部件项的小于方法。
from PyQt4.QtCore import Qt, QVariant from PyQt4.QtGui import QApplication, QTableWidget, QTableWidgetItem class MyTableWidgetItem(QTableWidgetItem): def __lt__(self, other): if ( isinstance(other, QTableWidgetItem) ): my_value, my_ok = self.data(Qt.EditRole).toInt() other_value, other_ok = other.data(Qt.EditRole).toInt() if ( my_ok and other_ok ): return my_value < other_value return super(MyTableWidgetItem, self).__lt__(other) if ( __name__ == '__main__' ): app = None if ( QApplication.instance() is None ): app = QApplication([]) widget = QTableWidget() widget.setWindowFlags(Qt.Dialog) widget.setSortingEnabled(True) widget.setRowCount(50) widget.setColumnCount(3) for row in range(50): # create a normal QTableWidgetItem a = QTableWidgetItem() a.setText(str(row)) widget.setItem(row, 0, a) # create a proper sorted item b = QTableWidgetItem() b.setData(Qt.EditRole, QVariant(row)) widget.setItem(row, 1, b) # create a custom sorted item c = MyTableWidgetItem() c.setData(Qt.EditRole, QVariant(row)) widget.setItem(row, 2, c) widget.show() if ( app ): app.exec_()
