def setupUi(self, Dialog): Dialog.setObjectName(_fromUtf8("Dialog")) Dialog.resize(556, 478) self.widget = MyTable(Dialog) self.widget.setGeometry(QtCore.QRect(30, 40, 431, 211)) self.widget.setObjectName(_fromUtf8("widget")) self.retranslateUi(Dialog) QtCore.QMetaObject.connectSlotsByName(Dialog)
def __init__(self): super().__init__() self.guild = Guild() self.guild.load_as_file() self.setting_wg = SettingWidget(self.guild, self) self.search_wg = SearchWidget(self.guild) self.updating = False # 닉네임 검색용 self.le = QLineEdit() # 클립보드용 self.le2 = QLineEdit() # 캐릭터 표시 self.lb = QLabel() # 길드 이름 표시 self.lb2 = QLabel("길드 : %s" % self.guild.name) self.lb3 = [QLabel() for i in range(3)] # 닉네임 검색 self.cb = QComboBox() # 닉네임 검색 self.tb = QTextBrowser() self.tb2 = QTextBrowser() self.tb3 = QTextBrowser() self.tb4 = QTextBrowser() # 업데이트 버튼 self.btn = QPushButton("길드원 정보 가져오기") # 비우기 self.btn2 = QPushButton("clear") #닉네임 복사 self.btn3 = QPushButton("닉네임 복사") #정렬 self.btn4 = [QPushButton() for i in range(7)] self.btn5 = QPushButton("↑") # 클립보드 self.copy_btn = QPushButton("복사") # 길드 표시 self.tw = MyTable() self.step = 0 # 표시 범위 self.chb = [QCheckBox() for i in range(7)] #프로그레스 self.pbar = QProgressBar() self.pbar.setMaximum(100) self.pbar.setValue(0) self.worker = None self.initUI()
class Ui_Dialog(object): def setupUi(self, Dialog): Dialog.setObjectName(_fromUtf8("Dialog")) Dialog.resize(556, 478) self.widget = MyTable(Dialog) self.widget.setGeometry(QtCore.QRect(30, 40, 431, 211)) self.widget.setObjectName(_fromUtf8("widget")) self.retranslateUi(Dialog) QtCore.QMetaObject.connectSlotsByName(Dialog) def retranslateUi(self, Dialog): Dialog.setWindowTitle(QtGui.QApplication.translate("Dialog", "Dialog", None, QtGui.QApplication.UnicodeUTF8))
class Ui_Dialog(object): def setupUi(self, Dialog): Dialog.setObjectName(_fromUtf8("Dialog")) Dialog.resize(556, 478) self.widget = MyTable(Dialog) self.widget.setGeometry(QtCore.QRect(30, 40, 431, 211)) self.widget.setObjectName(_fromUtf8("widget")) self.retranslateUi(Dialog) QtCore.QMetaObject.connectSlotsByName(Dialog) def retranslateUi(self, Dialog): Dialog.setWindowTitle( QtGui.QApplication.translate("Dialog", "Dialog", None, QtGui.QApplication.UnicodeUTF8))
def __init__(self, mylist, extension): super(Table, self).__init__() self.ui = MyTable() self.ui.setupUi(self, mylist, extension)
from MyTable import MyTable tt=MyTable() tt.createtable("aa,bb,cc,dd") print "begin insert" for i in range(1000000,-1,-1): tt.insert("aa,bb,cc,dd",str(i)+"|11|22|zhou") print "end insert" print "begin sort" tt.Sort() print "end sort" print "begin select" for i in range(100): tt.selectwhere("aa","3456") print "end select" #tt.updatewhere("aa,cc","1111|2222","dd,aa","1|2") #tt.Print() #print '' #i=tt.halffind(['aa','bb'],['2','3']) #print i #tt.deletewhere("dd,cc","zhou|") #tt.Print()
class MyWidget(QWidget): def __init__(self): super().__init__() self.guild = Guild() self.guild.load_as_file() self.setting_wg = SettingWidget(self.guild, self) self.search_wg = SearchWidget(self.guild) self.updating = False # 닉네임 검색용 self.le = QLineEdit() # 클립보드용 self.le2 = QLineEdit() # 캐릭터 표시 self.lb = QLabel() # 길드 이름 표시 self.lb2 = QLabel("길드 : %s" % self.guild.name) self.lb3 = [QLabel() for i in range(3)] # 닉네임 검색 self.cb = QComboBox() # 닉네임 검색 self.tb = QTextBrowser() self.tb2 = QTextBrowser() self.tb3 = QTextBrowser() self.tb4 = QTextBrowser() # 업데이트 버튼 self.btn = QPushButton("길드원 정보 가져오기") # 비우기 self.btn2 = QPushButton("clear") #닉네임 복사 self.btn3 = QPushButton("닉네임 복사") #정렬 self.btn4 = [QPushButton() for i in range(7)] self.btn5 = QPushButton("↑") # 클립보드 self.copy_btn = QPushButton("복사") # 길드 표시 self.tw = MyTable() self.step = 0 # 표시 범위 self.chb = [QCheckBox() for i in range(7)] #프로그레스 self.pbar = QProgressBar() self.pbar.setMaximum(100) self.pbar.setValue(0) self.worker = None self.initUI() def initUI(self): useful = ["닉네임", "직위", "레벨", "직업", "무릉", "활동일", "기여도"] self.le.textChanged.connect(self.search) self.lb.resize(100, 100) self.le2.textChanged.connect(self.divide_str) self.lb.setStyleSheet("color: blue;" "background-color: #87CEFA;" "border-style: dashed;" "border-width: 3px;" "border-color: #1E90FF") self.lb2.setStyleSheet("border-style: dashed;" "border-width: 2px;" "border-radius: 3px") self.lb.setAlignment(Qt.AlignCenter) self.lb2.setAlignment(Qt.AlignCenter) self.btn.pressed.connect(self.update) self.btn2.pressed.connect(self.tw_clear) self.btn3.pressed.connect(self.copy) [self.btn4[i].setText(useful[i] + self.btn5.text()) for i in range(7)] [ self.btn4[i].pressed.connect( lambda button=self.btn4[i]: self.sort_guild(button)) for i in range(7) ] self.btn5.pressed.connect(self.up_down) self.btn5.setMaximumWidth(20) self.cb.currentIndexChanged.connect(self.combo) self.reset_tw() #self.update() #self.guild_info() hbox1_1_1 = QHBoxLayout() hbox1_1_1.addWidget(self.le, 1) hbox1_1_1.addWidget(self.cb, 1) hbox1_1_2 = QHBoxLayout() hbox1_1_2.addWidget(self.tb, 1) hbox1_1_2.addWidget(self.lb, 1) vbox1_1 = QVBoxLayout() vbox1_1.addLayout(hbox1_1_1, 1) vbox1_1.addLayout(hbox1_1_2, 1) vbox1_2 = QVBoxLayout() vbox1_2.addWidget(self.lb2, 1) [vbox1_2.addWidget(i) for i in self.lb3] hbox1 = QHBoxLayout() hbox1.addLayout(vbox1_1, 2) hbox1.addLayout(vbox1_2, 1) hbox4 = QHBoxLayout() hbox4.addWidget(self.btn3, 1) hbox4.addWidget(self.le2, 1) hbox4.addWidget(self.btn2, 2) hbox5 = QHBoxLayout() [hbox5.addWidget(self.btn4[i], 4) for i in range(7)] hbox5.addWidget(self.btn5, 1) vbox = QVBoxLayout() vbox.addLayout(hbox1, 2) vbox.addWidget(self.btn, 3) vbox.addWidget(self.pbar, 1) vbox.addLayout(hbox5, 1) vbox.addWidget(self.tw, 3) vbox.addLayout(hbox4) vbox.addWidget(self.tb2, 1) self.setLayout(vbox) self.setGeometry(700, 300, 732, 700) self.show() def search(self): self.cb.clear() text = self.le.text() text = text.replace(" ", "") if text in self.guild.member_names() and text != "": self.cb.addItem(text) elif text != "": for i in self.guild.member_names(): if text in i: self.cb.addItem(i) elif i in text: self.cb.addItem(i) else: rate = 0 max_num = min([len(i), len(text)]) for j in range(max_num): if text[j] == i[j]: rate += 1 if (rate / max_num) * 100 > 50: self.cb.addItem(i) def image(self): self.worker = worker(self.guild) self.worker.perpose = "img" self.worker.name = self.cb.currentText() self.worker.finished.connect(self.lb_set) self.worker.start() @pyqtSlot(list) def lb_set(self, data): self.lb.setPixmap(data[0]) def copy(self): text = "" for i in self.guild.member_names(): text += i + '\n' clipboard.copy(text) def reset_tw(self): useful = ["직위", "레벨", "직업", "무릉", "활동일", "기여도"] self.tw.clear() self.tw.setColumnCount(6) self.tw.setHorizontalHeaderLabels(useful) if self.guild.member: self.tw.setRowCount(len(self.guild)) self.tw.setVerticalHeaderLabels(self.guild.member_names()) for i in range(len(self.guild)): if self.guild[i].position_id is not None and type( self.guild[i].position_id) == int: self.tw.setItem( i, 0, QTableWidgetItem(self.guild.position_name[ self.guild[i].position_id])) else: self.tw.setItem(i, 0, QTableWidgetItem("None")) for j in range(1, 6): self.tw.setItem( i, j, QTableWidgetItem(str(self.guild[i].get_list()[j + 1]))) def divide_str(self): if self.le2.text() != "" and "\\" not in self.le2.text(): split_text = self.le2.text() elif "\\" in self.le2.text(): split_text = self.le2.text().replace("\\n", "\n").replace( "\\t", "\t").replace("\\\\", '\\') else: split_text = "\t" self.tw.divide_str = split_text def combo(self): self.tb.clear() useful = ["닉네임", "직위", "레벨", "직업", "무릉", "활동일", "기여도"] text = self.cb.currentText() if text in self.guild.member_names(): self.image() member = self.guild[text] self.tb.append("%s : %s" % (useful[0], member.get_list()[0])) self.tb.append( "%s : %s" % (useful[1], self.guild.position_name[member.position_id])) for i in range(2, 7): self.tb.append("%s : %s" % (useful[i], member.get_list()[i])) else: self.lb.clear() def tw_clear(self): self.tw.clear() self.tw.setRowCount(0) self.tw.setColumnCount(0) def update(self): if not self.guild.server: self.tb2.append("서버 이름을 적어주세요.") return if not self.guild.name: self.tb2.append("길드 이름을 적어주세요.") return self.updating = True self.pbar.setValue(0) self.worker = worker(self.guild) self.worker.perpose = "update" self.worker.finished.connect(self.updated) self.worker.progress.connect(self.progress) self.worker.start() @pyqtSlot(list) def updated(self): self.guild.save_as_file() self.reset_tw() self.updating = False def progress(self): self.reset_tw() self.pbar.setValue(self.pbar.value() + 25) def guild_info(self): self.worker = worker(self.guild) self.worker.perpose = "guild_info" self.worker.finished.connect(self.set_guild_info) self.worker.start() @pyqtSlot(list) def set_guild_info(self, data): self.lb3[0].setText("%s등 플래그 : %s" % (str(data[3]), str(data[0]))) self.lb3[1].setText("%s등 명성치 : %s" % (str(data[4]), str(data[1]))) self.lb3[2].setText("%s등 지하수로 : %s" % (str(data[5]), str(data[2]))) def search_widget_set_po(self): self.search_wg.reset_position() def sort_guild(self, button): up = False if self.btn5.text() == "↑": up = True self.guild.sort_guild(button.text().strip(self.btn5.text()), up) self.reset_tw() def up_down(self): useful = ["닉네임", "직위", "레벨", "직업", "무릉", "활동일", "기여도"] if self.btn5.text() == "↑": self.btn5.setText('↓') elif self.btn5.text() == '↓': self.btn5.setText('↑') [self.btn4[i].setText(useful[i] + self.btn5.text()) for i in range(7)] def set_font(self, font): self.le.setFont(font) self.le2.setFont(font) self.lb.setFont(font) self.lb2.setFont(font) [self.lb3[i].setFont(font) for i in range(3)] self.cb.setFont(font) self.tb.setFont(font) self.tb2.setFont(font) self.tb3.setFont(font) self.tb4.setFont(font) self.btn.setFont(font) self.btn2.setFont(font) self.btn3.setFont(font) [self.btn4[i].setFont(font) for i in range(7)] self.copy_btn.setFont(font) self.tw.setFont(font) [self.chb[i].setFont(font) for i in range(7)] self.pbar.setFont(font) self.search_wg.set_font(font) self.setting_wg.set_font(font)
def setupUi(self, MainWindow): MainWindow.setObjectName(_fromUtf8("MainWindow")) MainWindow.resize(1227, 806) self.centralWidget = QtGui.QWidget(MainWindow) self.centralWidget.setObjectName(_fromUtf8("centralWidget")) self.gridLayout_2 = QtGui.QGridLayout(self.centralWidget) self.gridLayout_2.setObjectName(_fromUtf8("gridLayout_2")) self.splitter_2 = QtGui.QSplitter(self.centralWidget) self.splitter_2.setOrientation(QtCore.Qt.Horizontal) self.splitter_2.setObjectName(_fromUtf8("splitter_2")) self.splitter = QtGui.QSplitter(self.splitter_2) self.splitter.setOrientation(QtCore.Qt.Horizontal) self.splitter.setOpaqueResize(True) self.splitter.setObjectName(_fromUtf8("splitter")) self.gridLayout_2.addWidget(self.splitter_2, 0, 0, 1, 1) self.splitter_3 = QtGui.QSplitter(self.centralWidget) self.splitter_3.setOrientation(QtCore.Qt.Horizontal) self.splitter_3.setObjectName(_fromUtf8("splitter_3")) self.widget = QtGui.QWidget(self.splitter_3) self.widget.setObjectName(_fromUtf8("widget")) self.horizontalLayout_20 = QtGui.QHBoxLayout(self.widget) self.horizontalLayout_20.setMargin(0) self.horizontalLayout_20.setObjectName( _fromUtf8("horizontalLayout_20")) self.listWidget = QtGui.QListWidget(self.widget) self.listWidget.setMaximumSize(QtCore.QSize(150, 16777215)) self.listWidget.setObjectName(_fromUtf8("listWidget")) item = QtGui.QListWidgetItem() self.listWidget.addItem(item) item = QtGui.QListWidgetItem() self.listWidget.addItem(item) self.horizontalLayout_20.addWidget(self.listWidget) self.tabWidget = QtGui.QTabWidget(self.widget) self.tabWidget.setDocumentMode(False) self.tabWidget.setObjectName(_fromUtf8("tabWidget")) self.tab = QtGui.QWidget() self.tab.setObjectName(_fromUtf8("tab")) self.gridLayout_3 = QtGui.QGridLayout(self.tab) self.gridLayout_3.setObjectName(_fromUtf8("gridLayout_3")) self.groupBox_4 = QtGui.QGroupBox(self.tab) self.groupBox_4.setMaximumSize(QtCore.QSize(16777215, 90)) self.groupBox_4.setObjectName(_fromUtf8("groupBox_4")) self.gridLayout = QtGui.QGridLayout(self.groupBox_4) self.gridLayout.setObjectName(_fromUtf8("gridLayout")) self.horizontalLayout_13 = QtGui.QHBoxLayout() self.horizontalLayout_13.setObjectName( _fromUtf8("horizontalLayout_13")) self.horizontalLayout_11 = QtGui.QHBoxLayout() self.horizontalLayout_11.setObjectName( _fromUtf8("horizontalLayout_11")) self.label_2 = QtGui.QLabel(self.groupBox_4) self.label_2.setObjectName(_fromUtf8("label_2")) self.horizontalLayout_11.addWidget(self.label_2) self.startDateEdit_1 = QtGui.QDateEdit(self.groupBox_4) self.startDateEdit_1.setDate(QtCore.QDate(2000, 1, 1)) self.startDateEdit_1.setCalendarPopup(True) self.startDateEdit_1.setObjectName(_fromUtf8("startDateEdit_1")) self.horizontalLayout_11.addWidget(self.startDateEdit_1) self.label_3 = QtGui.QLabel(self.groupBox_4) self.label_3.setObjectName(_fromUtf8("label_3")) self.horizontalLayout_11.addWidget(self.label_3) self.endDateEdit_1 = QtGui.QDateEdit(self.groupBox_4) self.endDateEdit_1.setDate(QtCore.QDate(2014, 12, 30)) self.endDateEdit_1.setCalendarPopup(True) self.endDateEdit_1.setObjectName(_fromUtf8("endDateEdit_1")) self.horizontalLayout_11.addWidget(self.endDateEdit_1) self.horizontalLayout_13.addLayout(self.horizontalLayout_11) self.queryBtn = QtGui.QPushButton(self.groupBox_4) self.queryBtn.setObjectName(_fromUtf8("queryBtn")) self.horizontalLayout_13.addWidget(self.queryBtn) spacerItem = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum) self.horizontalLayout_13.addItem(spacerItem) self.gridLayout.addLayout(self.horizontalLayout_13, 0, 0, 1, 1) self.gridLayout_3.addWidget(self.groupBox_4, 0, 0, 1, 1) self.groupBox = QtGui.QGroupBox(self.tab) self.groupBox.setObjectName(_fromUtf8("groupBox")) self.verticalLayout_3 = QtGui.QVBoxLayout(self.groupBox) self.verticalLayout_3.setObjectName(_fromUtf8("verticalLayout_3")) self.srcTableWidget = MyTable(self.groupBox) self.srcTableWidget.setObjectName(_fromUtf8("srcTableWidget")) self.verticalLayout_3.addWidget(self.srcTableWidget) self.gridLayout_3.addWidget(self.groupBox, 1, 0, 1, 1) self.tabWidget.addTab(self.tab, _fromUtf8("")) self.tab_3 = QtGui.QWidget() self.tab_3.setObjectName(_fromUtf8("tab_3")) self.gridLayout_6 = QtGui.QGridLayout(self.tab_3) self.gridLayout_6.setObjectName(_fromUtf8("gridLayout_6")) self.groupBox_6 = QtGui.QGroupBox(self.tab_3) self.groupBox_6.setMaximumSize(QtCore.QSize(16777215, 90)) self.groupBox_6.setObjectName(_fromUtf8("groupBox_6")) self.formLayout = QtGui.QFormLayout(self.groupBox_6) self.formLayout.setObjectName(_fromUtf8("formLayout")) self.horizontalLayout_19 = QtGui.QHBoxLayout() self.horizontalLayout_19.setObjectName( _fromUtf8("horizontalLayout_19")) self.horizontalLayout_18 = QtGui.QHBoxLayout() self.horizontalLayout_18.setObjectName( _fromUtf8("horizontalLayout_18")) self.label_11 = QtGui.QLabel(self.groupBox_6) self.label_11.setObjectName(_fromUtf8("label_11")) self.horizontalLayout_18.addWidget(self.label_11) self.startDateEdit_2 = QtGui.QDateEdit(self.groupBox_6) self.startDateEdit_2.setDate(QtCore.QDate(2000, 1, 1)) self.startDateEdit_2.setCalendarPopup(True) self.startDateEdit_2.setObjectName(_fromUtf8("startDateEdit_2")) self.horizontalLayout_18.addWidget(self.startDateEdit_2) self.label_12 = QtGui.QLabel(self.groupBox_6) self.label_12.setObjectName(_fromUtf8("label_12")) self.horizontalLayout_18.addWidget(self.label_12) self.endDateEdit_2 = QtGui.QDateEdit(self.groupBox_6) self.endDateEdit_2.setDate(QtCore.QDate(2014, 12, 30)) self.endDateEdit_2.setCalendarPopup(True) self.endDateEdit_2.setObjectName(_fromUtf8("endDateEdit_2")) self.horizontalLayout_18.addWidget(self.endDateEdit_2) self.horizontalLayout_19.addLayout(self.horizontalLayout_18) self.horizontalLayout_12 = QtGui.QHBoxLayout() self.horizontalLayout_12.setObjectName( _fromUtf8("horizontalLayout_12")) self.verticalLayout_2 = QtGui.QVBoxLayout() self.verticalLayout_2.setObjectName(_fromUtf8("verticalLayout_2")) self.daySumRadio = QtGui.QRadioButton(self.groupBox_6) self.daySumRadio.setChecked(True) self.daySumRadio.setObjectName(_fromUtf8("daySumRadio")) self.verticalLayout_2.addWidget(self.daySumRadio) self.weekSumRadio = QtGui.QRadioButton(self.groupBox_6) self.weekSumRadio.setObjectName(_fromUtf8("weekSumRadio")) self.verticalLayout_2.addWidget(self.weekSumRadio) self.monthSumRadio = QtGui.QRadioButton(self.groupBox_6) self.monthSumRadio.setObjectName(_fromUtf8("monthSumRadio")) self.verticalLayout_2.addWidget(self.monthSumRadio) self.horizontalLayout_12.addLayout(self.verticalLayout_2) self.typeCombo = QtGui.QComboBox(self.groupBox_6) self.typeCombo.setObjectName(_fromUtf8("typeCombo")) self.horizontalLayout_12.addWidget(self.typeCombo) self.numCombo = QtGui.QComboBox(self.groupBox_6) self.numCombo.setObjectName(_fromUtf8("numCombo")) self.horizontalLayout_12.addWidget(self.numCombo) self.horizontalLayout_19.addLayout(self.horizontalLayout_12) self.sumTypeCombo = QtGui.QComboBox(self.groupBox_6) self.sumTypeCombo.setObjectName(_fromUtf8("sumTypeCombo")) self.horizontalLayout_19.addWidget(self.sumTypeCombo) self.queryBtn_2 = QtGui.QPushButton(self.groupBox_6) self.queryBtn_2.setObjectName(_fromUtf8("queryBtn_2")) self.horizontalLayout_19.addWidget(self.queryBtn_2) spacerItem1 = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum) self.horizontalLayout_19.addItem(spacerItem1) self.formLayout.setLayout(0, QtGui.QFormLayout.LabelRole, self.horizontalLayout_19) self.gridLayout_6.addWidget(self.groupBox_6, 0, 0, 1, 1) self.groupBox_2 = QtGui.QGroupBox(self.tab_3) self.groupBox_2.setObjectName(_fromUtf8("groupBox_2")) self.verticalLayout_7 = QtGui.QVBoxLayout(self.groupBox_2) self.verticalLayout_7.setObjectName(_fromUtf8("verticalLayout_7")) self.sumTableWidget = MyTable(self.groupBox_2) self.sumTableWidget.setObjectName(_fromUtf8("sumTableWidget")) self.verticalLayout_7.addWidget(self.sumTableWidget) self.gridLayout_6.addWidget(self.groupBox_2, 1, 0, 1, 1) self.tabWidget.addTab(self.tab_3, _fromUtf8("")) self.tab_2 = QtGui.QWidget() self.tab_2.setObjectName(_fromUtf8("tab_2")) self.gridLayout_4 = QtGui.QGridLayout(self.tab_2) self.gridLayout_4.setObjectName(_fromUtf8("gridLayout_4")) self.groupBox_3 = QtGui.QGroupBox(self.tab_2) self.groupBox_3.setObjectName(_fromUtf8("groupBox_3")) self.gridLayout_7 = QtGui.QGridLayout(self.groupBox_3) self.gridLayout_7.setObjectName(_fromUtf8("gridLayout_7")) self.calcTableWidget = MyTable(self.groupBox_3) self.calcTableWidget.setObjectName(_fromUtf8("calcTableWidget")) self.gridLayout_7.addWidget(self.calcTableWidget, 0, 0, 1, 1) self.gridLayout_4.addWidget(self.groupBox_3, 1, 0, 1, 1) self.groupBox_5 = QtGui.QGroupBox(self.tab_2) self.groupBox_5.setMaximumSize(QtCore.QSize(16777215, 90)) self.groupBox_5.setObjectName(_fromUtf8("groupBox_5")) self.gridLayout_5 = QtGui.QGridLayout(self.groupBox_5) self.gridLayout_5.setObjectName(_fromUtf8("gridLayout_5")) self.horizontalLayout_10 = QtGui.QHBoxLayout() self.horizontalLayout_10.setObjectName( _fromUtf8("horizontalLayout_10")) self.horizontalLayout_9 = QtGui.QHBoxLayout() self.horizontalLayout_9.setObjectName(_fromUtf8("horizontalLayout_9")) self.horizontalLayout_6 = QtGui.QHBoxLayout() self.horizontalLayout_6.setObjectName(_fromUtf8("horizontalLayout_6")) self.label_4 = QtGui.QLabel(self.groupBox_5) self.label_4.setObjectName(_fromUtf8("label_4")) self.horizontalLayout_6.addWidget(self.label_4) self.startDateEdit_3 = QtGui.QDateEdit(self.groupBox_5) self.startDateEdit_3.setCalendarPopup(True) self.startDateEdit_3.setObjectName(_fromUtf8("startDateEdit_3")) self.horizontalLayout_6.addWidget(self.startDateEdit_3) self.label_7 = QtGui.QLabel(self.groupBox_5) self.label_7.setObjectName(_fromUtf8("label_7")) self.horizontalLayout_6.addWidget(self.label_7) self.endDateEdit_3 = QtGui.QDateEdit(self.groupBox_5) self.endDateEdit_3.setDate(QtCore.QDate(2014, 1, 1)) self.endDateEdit_3.setCalendarPopup(True) self.endDateEdit_3.setObjectName(_fromUtf8("endDateEdit_3")) self.horizontalLayout_6.addWidget(self.endDateEdit_3) self.horizontalLayout_9.addLayout(self.horizontalLayout_6) self.horizontalLayout_5 = QtGui.QHBoxLayout() self.horizontalLayout_5.setObjectName(_fromUtf8("horizontalLayout_5")) self.label_6 = QtGui.QLabel(self.groupBox_5) self.label_6.setObjectName(_fromUtf8("label_6")) self.horizontalLayout_5.addWidget(self.label_6) self.cmpMethCombo = QtGui.QComboBox(self.groupBox_5) self.cmpMethCombo.setObjectName(_fromUtf8("cmpMethCombo")) self.horizontalLayout_5.addWidget(self.cmpMethCombo) self.horizontalLayout_9.addLayout(self.horizontalLayout_5) self.horizontalLayout_10.addLayout(self.horizontalLayout_9) self.horizontalLayout_8 = QtGui.QHBoxLayout() self.horizontalLayout_8.setObjectName(_fromUtf8("horizontalLayout_8")) self.horizontalLayout_7 = QtGui.QHBoxLayout() self.horizontalLayout_7.setObjectName(_fromUtf8("horizontalLayout_7")) self.label_5 = QtGui.QLabel(self.groupBox_5) self.label_5.setObjectName(_fromUtf8("label_5")) self.horizontalLayout_7.addWidget(self.label_5) self.cmpTypeCombo = QtGui.QComboBox(self.groupBox_5) self.cmpTypeCombo.setObjectName(_fromUtf8("cmpTypeCombo")) self.horizontalLayout_7.addWidget(self.cmpTypeCombo) self.horizontalLayout_8.addLayout(self.horizontalLayout_7) self.horizontalLayout_4 = QtGui.QHBoxLayout() self.horizontalLayout_4.setObjectName(_fromUtf8("horizontalLayout_4")) self.label_8 = QtGui.QLabel(self.groupBox_5) self.label_8.setObjectName(_fromUtf8("label_8")) self.horizontalLayout_4.addWidget(self.label_8) self.verticalLayout = QtGui.QVBoxLayout() self.verticalLayout.setObjectName(_fromUtf8("verticalLayout")) self.horizontalLayout_2 = QtGui.QHBoxLayout() self.horizontalLayout_2.setObjectName(_fromUtf8("horizontalLayout_2")) self.label_9 = QtGui.QLabel(self.groupBox_5) self.label_9.setObjectName(_fromUtf8("label_9")) self.horizontalLayout_2.addWidget(self.label_9) self.smallValueEdit = QtGui.QLineEdit(self.groupBox_5) self.smallValueEdit.setContextMenuPolicy(QtCore.Qt.DefaultContextMenu) self.smallValueEdit.setObjectName(_fromUtf8("smallValueEdit")) self.horizontalLayout_2.addWidget(self.smallValueEdit) self.verticalLayout.addLayout(self.horizontalLayout_2) self.horizontalLayout_3 = QtGui.QHBoxLayout() self.horizontalLayout_3.setObjectName(_fromUtf8("horizontalLayout_3")) self.label_10 = QtGui.QLabel(self.groupBox_5) self.label_10.setObjectName(_fromUtf8("label_10")) self.horizontalLayout_3.addWidget(self.label_10) self.bigValueEdit = QtGui.QLineEdit(self.groupBox_5) self.bigValueEdit.setText(_fromUtf8("")) self.bigValueEdit.setObjectName(_fromUtf8("bigValueEdit")) self.horizontalLayout_3.addWidget(self.bigValueEdit) self.verticalLayout.addLayout(self.horizontalLayout_3) self.horizontalLayout_4.addLayout(self.verticalLayout) self.horizontalLayout_8.addLayout(self.horizontalLayout_4) self.horizontalLayout_10.addLayout(self.horizontalLayout_8) self.calculateBtn = QtGui.QPushButton(self.groupBox_5) self.calculateBtn.setObjectName(_fromUtf8("calculateBtn")) self.horizontalLayout_10.addWidget(self.calculateBtn) spacerItem2 = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum) self.horizontalLayout_10.addItem(spacerItem2) self.gridLayout_5.addLayout(self.horizontalLayout_10, 0, 0, 1, 1) self.gridLayout_4.addWidget(self.groupBox_5, 0, 0, 1, 1) self.tabWidget.addTab(self.tab_2, _fromUtf8("")) self.tab_4 = QtGui.QWidget() self.tab_4.setObjectName(_fromUtf8("tab_4")) self.verticalLayout_4 = QtGui.QVBoxLayout(self.tab_4) self.verticalLayout_4.setObjectName(_fromUtf8("verticalLayout_4")) self.groupBox_8 = QtGui.QGroupBox(self.tab_4) self.groupBox_8.setMaximumSize(QtCore.QSize(16777215, 90)) self.groupBox_8.setObjectName(_fromUtf8("groupBox_8")) self.gridLayout_9 = QtGui.QGridLayout(self.groupBox_8) self.gridLayout_9.setObjectName(_fromUtf8("gridLayout_9")) self.horizontalLayout = QtGui.QHBoxLayout() self.horizontalLayout.setObjectName(_fromUtf8("horizontalLayout")) self.label_15 = QtGui.QLabel(self.groupBox_8) self.label_15.setObjectName(_fromUtf8("label_15")) self.horizontalLayout.addWidget(self.label_15) self.startDateEdit_4 = QtGui.QDateEdit(self.groupBox_8) self.startDateEdit_4.setCalendarPopup(True) self.startDateEdit_4.setObjectName(_fromUtf8("startDateEdit_4")) self.horizontalLayout.addWidget(self.startDateEdit_4) self.label_16 = QtGui.QLabel(self.groupBox_8) self.label_16.setObjectName(_fromUtf8("label_16")) self.horizontalLayout.addWidget(self.label_16) self.endDateEdit_4 = QtGui.QDateEdit(self.groupBox_8) self.endDateEdit_4.setDate(QtCore.QDate(2014, 1, 1)) self.endDateEdit_4.setCalendarPopup(True) self.endDateEdit_4.setObjectName(_fromUtf8("endDateEdit_4")) self.horizontalLayout.addWidget(self.endDateEdit_4) self.label_17 = QtGui.QLabel(self.groupBox_8) sizePolicy = QtGui.QSizePolicy(QtGui.QSizePolicy.Preferred, QtGui.QSizePolicy.Minimum) sizePolicy.setHorizontalStretch(0) sizePolicy.setVerticalStretch(0) sizePolicy.setHeightForWidth( self.label_17.sizePolicy().hasHeightForWidth()) self.label_17.setSizePolicy(sizePolicy) self.label_17.setObjectName(_fromUtf8("label_17")) self.horizontalLayout.addWidget(self.label_17) self.weightEdit = QtGui.QLineEdit(self.groupBox_8) self.weightEdit.setMaximumSize(QtCore.QSize(50, 16777215)) self.weightEdit.setObjectName(_fromUtf8("weightEdit")) self.horizontalLayout.addWidget(self.weightEdit) self.label_18 = QtGui.QLabel(self.groupBox_8) self.label_18.setObjectName(_fromUtf8("label_18")) self.horizontalLayout.addWidget(self.label_18) self.crossTypeCombo = QtGui.QComboBox(self.groupBox_8) self.crossTypeCombo.setObjectName(_fromUtf8("crossTypeCombo")) self.horizontalLayout.addWidget(self.crossTypeCombo) self.crossBtn = QtGui.QPushButton(self.groupBox_8) self.crossBtn.setObjectName(_fromUtf8("crossBtn")) self.horizontalLayout.addWidget(self.crossBtn) spacerItem3 = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum) self.horizontalLayout.addItem(spacerItem3) self.gridLayout_9.addLayout(self.horizontalLayout, 0, 0, 1, 1) self.verticalLayout_4.addWidget(self.groupBox_8) self.groupBox_7 = QtGui.QGroupBox(self.tab_4) self.groupBox_7.setObjectName(_fromUtf8("groupBox_7")) self.gridLayout_8 = QtGui.QGridLayout(self.groupBox_7) self.gridLayout_8.setObjectName(_fromUtf8("gridLayout_8")) self.crossTableWidget = MyTable(self.groupBox_7) self.crossTableWidget.setObjectName(_fromUtf8("crossTableWidget")) self.gridLayout_8.addWidget(self.crossTableWidget, 0, 0, 1, 1) self.verticalLayout_4.addWidget(self.groupBox_7) self.tabWidget.addTab(self.tab_4, _fromUtf8("")) self.horizontalLayout_20.addWidget(self.tabWidget) self.groupBox_9 = QtGui.QGroupBox(self.splitter_3) self.groupBox_9.setObjectName(_fromUtf8("groupBox_9")) self.gridLayout_10 = QtGui.QGridLayout(self.groupBox_9) self.gridLayout_10.setObjectName(_fromUtf8("gridLayout_10")) self.combineWidget = MyTable(self.groupBox_9) self.combineWidget.setObjectName(_fromUtf8("combineWidget")) self.gridLayout_10.addWidget(self.combineWidget, 0, 0, 1, 1) self.gridLayout_2.addWidget(self.splitter_3, 0, 1, 1, 1) self.horizontalLayout_17 = QtGui.QHBoxLayout() self.horizontalLayout_17.setSizeConstraint( QtGui.QLayout.SetMinimumSize) self.horizontalLayout_17.setObjectName( _fromUtf8("horizontalLayout_17")) self.showGroupBtn = QtGui.QPushButton(self.centralWidget) self.showGroupBtn.setMaximumSize(QtCore.QSize(100, 20)) self.showGroupBtn.setCheckable(True) self.showGroupBtn.setObjectName(_fromUtf8("showGroupBtn")) self.horizontalLayout_17.addWidget(self.showGroupBtn) self.classifyBtn = QtGui.QPushButton(self.centralWidget) self.classifyBtn.setMaximumSize(QtCore.QSize(100, 20)) self.classifyBtn.setCheckable(True) self.classifyBtn.setObjectName(_fromUtf8("classifyBtn")) self.horizontalLayout_17.addWidget(self.classifyBtn) spacerItem4 = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum) self.horizontalLayout_17.addItem(spacerItem4) self.gridLayout_2.addLayout(self.horizontalLayout_17, 1, 0, 1, 2) MainWindow.setCentralWidget(self.centralWidget) self.menuBar = QtGui.QMenuBar(MainWindow) self.menuBar.setGeometry(QtCore.QRect(0, 0, 1227, 23)) self.menuBar.setObjectName(_fromUtf8("menuBar")) self.menu = QtGui.QMenu(self.menuBar) self.menu.setObjectName(_fromUtf8("menu")) self.menu_2 = QtGui.QMenu(self.menuBar) self.menu_2.setObjectName(_fromUtf8("menu_2")) MainWindow.setMenuBar(self.menuBar) self.action = QtGui.QAction(MainWindow) self.action.setObjectName(_fromUtf8("action")) self.action_addGroup = QtGui.QAction(MainWindow) self.action_addGroup.setObjectName(_fromUtf8("action_addGroup")) self.action_editGroup = QtGui.QAction(MainWindow) self.action_editGroup.setObjectName(_fromUtf8("action_editGroup")) self.action_showGroupView = QtGui.QAction(MainWindow) self.action_showGroupView.setCheckable(True) self.action_showGroupView.setObjectName( _fromUtf8("action_showGroupView")) self.action_deleteGroup = QtGui.QAction(MainWindow) self.action_deleteGroup.setObjectName(_fromUtf8("action_deleteGroup")) self.menu_2.addAction(self.action) self.menuBar.addAction(self.menu.menuAction()) self.menuBar.addAction(self.menu_2.menuAction()) self.retranslateUi(MainWindow) self.tabWidget.setCurrentIndex(3) QtCore.QMetaObject.connectSlotsByName(MainWindow)
def setupUi(self, MainWindow): MainWindow.setObjectName(_fromUtf8("MainWindow")) MainWindow.resize(1227, 806) self.centralWidget = QtGui.QWidget(MainWindow) self.centralWidget.setObjectName(_fromUtf8("centralWidget")) self.gridLayout_2 = QtGui.QGridLayout(self.centralWidget) self.gridLayout_2.setObjectName(_fromUtf8("gridLayout_2")) self.splitter_2 = QtGui.QSplitter(self.centralWidget) self.splitter_2.setOrientation(QtCore.Qt.Horizontal) self.splitter_2.setObjectName(_fromUtf8("splitter_2")) self.splitter = QtGui.QSplitter(self.splitter_2) self.splitter.setOrientation(QtCore.Qt.Horizontal) self.splitter.setOpaqueResize(True) self.splitter.setObjectName(_fromUtf8("splitter")) self.gridLayout_2.addWidget(self.splitter_2, 0, 0, 1, 1) self.splitter_3 = QtGui.QSplitter(self.centralWidget) self.splitter_3.setOrientation(QtCore.Qt.Horizontal) self.splitter_3.setObjectName(_fromUtf8("splitter_3")) self.widget = QtGui.QWidget(self.splitter_3) self.widget.setObjectName(_fromUtf8("widget")) self.horizontalLayout_20 = QtGui.QHBoxLayout(self.widget) self.horizontalLayout_20.setMargin(0) self.horizontalLayout_20.setObjectName(_fromUtf8("horizontalLayout_20")) self.listWidget = QtGui.QListWidget(self.widget) self.listWidget.setMaximumSize(QtCore.QSize(150, 16777215)) self.listWidget.setObjectName(_fromUtf8("listWidget")) item = QtGui.QListWidgetItem() self.listWidget.addItem(item) item = QtGui.QListWidgetItem() self.listWidget.addItem(item) self.horizontalLayout_20.addWidget(self.listWidget) self.tabWidget = QtGui.QTabWidget(self.widget) self.tabWidget.setDocumentMode(False) self.tabWidget.setObjectName(_fromUtf8("tabWidget")) self.tab = QtGui.QWidget() self.tab.setObjectName(_fromUtf8("tab")) self.gridLayout_3 = QtGui.QGridLayout(self.tab) self.gridLayout_3.setObjectName(_fromUtf8("gridLayout_3")) self.groupBox_4 = QtGui.QGroupBox(self.tab) self.groupBox_4.setMaximumSize(QtCore.QSize(16777215, 90)) self.groupBox_4.setObjectName(_fromUtf8("groupBox_4")) self.gridLayout = QtGui.QGridLayout(self.groupBox_4) self.gridLayout.setObjectName(_fromUtf8("gridLayout")) self.horizontalLayout_13 = QtGui.QHBoxLayout() self.horizontalLayout_13.setObjectName(_fromUtf8("horizontalLayout_13")) self.horizontalLayout_11 = QtGui.QHBoxLayout() self.horizontalLayout_11.setObjectName(_fromUtf8("horizontalLayout_11")) self.label_2 = QtGui.QLabel(self.groupBox_4) self.label_2.setObjectName(_fromUtf8("label_2")) self.horizontalLayout_11.addWidget(self.label_2) self.startDateEdit_1 = QtGui.QDateEdit(self.groupBox_4) self.startDateEdit_1.setDate(QtCore.QDate(2000, 1, 1)) self.startDateEdit_1.setCalendarPopup(True) self.startDateEdit_1.setObjectName(_fromUtf8("startDateEdit_1")) self.horizontalLayout_11.addWidget(self.startDateEdit_1) self.label_3 = QtGui.QLabel(self.groupBox_4) self.label_3.setObjectName(_fromUtf8("label_3")) self.horizontalLayout_11.addWidget(self.label_3) self.endDateEdit_1 = QtGui.QDateEdit(self.groupBox_4) self.endDateEdit_1.setDate(QtCore.QDate(2014, 12, 30)) self.endDateEdit_1.setCalendarPopup(True) self.endDateEdit_1.setObjectName(_fromUtf8("endDateEdit_1")) self.horizontalLayout_11.addWidget(self.endDateEdit_1) self.horizontalLayout_13.addLayout(self.horizontalLayout_11) self.queryBtn = QtGui.QPushButton(self.groupBox_4) self.queryBtn.setObjectName(_fromUtf8("queryBtn")) self.horizontalLayout_13.addWidget(self.queryBtn) spacerItem = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum) self.horizontalLayout_13.addItem(spacerItem) self.gridLayout.addLayout(self.horizontalLayout_13, 0, 0, 1, 1) self.gridLayout_3.addWidget(self.groupBox_4, 0, 0, 1, 1) self.groupBox = QtGui.QGroupBox(self.tab) self.groupBox.setObjectName(_fromUtf8("groupBox")) self.verticalLayout_3 = QtGui.QVBoxLayout(self.groupBox) self.verticalLayout_3.setObjectName(_fromUtf8("verticalLayout_3")) self.srcTableWidget = MyTable(self.groupBox) self.srcTableWidget.setObjectName(_fromUtf8("srcTableWidget")) self.verticalLayout_3.addWidget(self.srcTableWidget) self.gridLayout_3.addWidget(self.groupBox, 1, 0, 1, 1) self.tabWidget.addTab(self.tab, _fromUtf8("")) self.tab_3 = QtGui.QWidget() self.tab_3.setObjectName(_fromUtf8("tab_3")) self.gridLayout_6 = QtGui.QGridLayout(self.tab_3) self.gridLayout_6.setObjectName(_fromUtf8("gridLayout_6")) self.groupBox_6 = QtGui.QGroupBox(self.tab_3) self.groupBox_6.setMaximumSize(QtCore.QSize(16777215, 90)) self.groupBox_6.setObjectName(_fromUtf8("groupBox_6")) self.formLayout = QtGui.QFormLayout(self.groupBox_6) self.formLayout.setObjectName(_fromUtf8("formLayout")) self.horizontalLayout_19 = QtGui.QHBoxLayout() self.horizontalLayout_19.setObjectName(_fromUtf8("horizontalLayout_19")) self.horizontalLayout_18 = QtGui.QHBoxLayout() self.horizontalLayout_18.setObjectName(_fromUtf8("horizontalLayout_18")) self.label_11 = QtGui.QLabel(self.groupBox_6) self.label_11.setObjectName(_fromUtf8("label_11")) self.horizontalLayout_18.addWidget(self.label_11) self.startDateEdit_2 = QtGui.QDateEdit(self.groupBox_6) self.startDateEdit_2.setDate(QtCore.QDate(2000, 1, 1)) self.startDateEdit_2.setCalendarPopup(True) self.startDateEdit_2.setObjectName(_fromUtf8("startDateEdit_2")) self.horizontalLayout_18.addWidget(self.startDateEdit_2) self.label_12 = QtGui.QLabel(self.groupBox_6) self.label_12.setObjectName(_fromUtf8("label_12")) self.horizontalLayout_18.addWidget(self.label_12) self.endDateEdit_2 = QtGui.QDateEdit(self.groupBox_6) self.endDateEdit_2.setDate(QtCore.QDate(2014, 12, 30)) self.endDateEdit_2.setCalendarPopup(True) self.endDateEdit_2.setObjectName(_fromUtf8("endDateEdit_2")) self.horizontalLayout_18.addWidget(self.endDateEdit_2) self.horizontalLayout_19.addLayout(self.horizontalLayout_18) self.horizontalLayout_12 = QtGui.QHBoxLayout() self.horizontalLayout_12.setObjectName(_fromUtf8("horizontalLayout_12")) self.verticalLayout_2 = QtGui.QVBoxLayout() self.verticalLayout_2.setObjectName(_fromUtf8("verticalLayout_2")) self.daySumRadio = QtGui.QRadioButton(self.groupBox_6) self.daySumRadio.setChecked(True) self.daySumRadio.setObjectName(_fromUtf8("daySumRadio")) self.verticalLayout_2.addWidget(self.daySumRadio) self.weekSumRadio = QtGui.QRadioButton(self.groupBox_6) self.weekSumRadio.setObjectName(_fromUtf8("weekSumRadio")) self.verticalLayout_2.addWidget(self.weekSumRadio) self.monthSumRadio = QtGui.QRadioButton(self.groupBox_6) self.monthSumRadio.setObjectName(_fromUtf8("monthSumRadio")) self.verticalLayout_2.addWidget(self.monthSumRadio) self.horizontalLayout_12.addLayout(self.verticalLayout_2) self.typeCombo = QtGui.QComboBox(self.groupBox_6) self.typeCombo.setObjectName(_fromUtf8("typeCombo")) self.horizontalLayout_12.addWidget(self.typeCombo) self.numCombo = QtGui.QComboBox(self.groupBox_6) self.numCombo.setObjectName(_fromUtf8("numCombo")) self.horizontalLayout_12.addWidget(self.numCombo) self.horizontalLayout_19.addLayout(self.horizontalLayout_12) self.sumTypeCombo = QtGui.QComboBox(self.groupBox_6) self.sumTypeCombo.setObjectName(_fromUtf8("sumTypeCombo")) self.horizontalLayout_19.addWidget(self.sumTypeCombo) self.queryBtn_2 = QtGui.QPushButton(self.groupBox_6) self.queryBtn_2.setObjectName(_fromUtf8("queryBtn_2")) self.horizontalLayout_19.addWidget(self.queryBtn_2) spacerItem1 = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum) self.horizontalLayout_19.addItem(spacerItem1) self.formLayout.setLayout(0, QtGui.QFormLayout.LabelRole, self.horizontalLayout_19) self.gridLayout_6.addWidget(self.groupBox_6, 0, 0, 1, 1) self.groupBox_2 = QtGui.QGroupBox(self.tab_3) self.groupBox_2.setObjectName(_fromUtf8("groupBox_2")) self.verticalLayout_7 = QtGui.QVBoxLayout(self.groupBox_2) self.verticalLayout_7.setObjectName(_fromUtf8("verticalLayout_7")) self.sumTableWidget = MyTable(self.groupBox_2) self.sumTableWidget.setObjectName(_fromUtf8("sumTableWidget")) self.verticalLayout_7.addWidget(self.sumTableWidget) self.gridLayout_6.addWidget(self.groupBox_2, 1, 0, 1, 1) self.tabWidget.addTab(self.tab_3, _fromUtf8("")) self.tab_2 = QtGui.QWidget() self.tab_2.setObjectName(_fromUtf8("tab_2")) self.gridLayout_4 = QtGui.QGridLayout(self.tab_2) self.gridLayout_4.setObjectName(_fromUtf8("gridLayout_4")) self.groupBox_3 = QtGui.QGroupBox(self.tab_2) self.groupBox_3.setObjectName(_fromUtf8("groupBox_3")) self.gridLayout_7 = QtGui.QGridLayout(self.groupBox_3) self.gridLayout_7.setObjectName(_fromUtf8("gridLayout_7")) self.calcTableWidget = MyTable(self.groupBox_3) self.calcTableWidget.setObjectName(_fromUtf8("calcTableWidget")) self.gridLayout_7.addWidget(self.calcTableWidget, 0, 0, 1, 1) self.gridLayout_4.addWidget(self.groupBox_3, 1, 0, 1, 1) self.groupBox_5 = QtGui.QGroupBox(self.tab_2) self.groupBox_5.setMaximumSize(QtCore.QSize(16777215, 90)) self.groupBox_5.setObjectName(_fromUtf8("groupBox_5")) self.gridLayout_5 = QtGui.QGridLayout(self.groupBox_5) self.gridLayout_5.setObjectName(_fromUtf8("gridLayout_5")) self.horizontalLayout_10 = QtGui.QHBoxLayout() self.horizontalLayout_10.setObjectName(_fromUtf8("horizontalLayout_10")) self.horizontalLayout_9 = QtGui.QHBoxLayout() self.horizontalLayout_9.setObjectName(_fromUtf8("horizontalLayout_9")) self.horizontalLayout_6 = QtGui.QHBoxLayout() self.horizontalLayout_6.setObjectName(_fromUtf8("horizontalLayout_6")) self.label_4 = QtGui.QLabel(self.groupBox_5) self.label_4.setObjectName(_fromUtf8("label_4")) self.horizontalLayout_6.addWidget(self.label_4) self.startDateEdit_3 = QtGui.QDateEdit(self.groupBox_5) self.startDateEdit_3.setCalendarPopup(True) self.startDateEdit_3.setObjectName(_fromUtf8("startDateEdit_3")) self.horizontalLayout_6.addWidget(self.startDateEdit_3) self.label_7 = QtGui.QLabel(self.groupBox_5) self.label_7.setObjectName(_fromUtf8("label_7")) self.horizontalLayout_6.addWidget(self.label_7) self.endDateEdit_3 = QtGui.QDateEdit(self.groupBox_5) self.endDateEdit_3.setDate(QtCore.QDate(2014, 1, 1)) self.endDateEdit_3.setCalendarPopup(True) self.endDateEdit_3.setObjectName(_fromUtf8("endDateEdit_3")) self.horizontalLayout_6.addWidget(self.endDateEdit_3) self.horizontalLayout_9.addLayout(self.horizontalLayout_6) self.horizontalLayout_5 = QtGui.QHBoxLayout() self.horizontalLayout_5.setObjectName(_fromUtf8("horizontalLayout_5")) self.label_6 = QtGui.QLabel(self.groupBox_5) self.label_6.setObjectName(_fromUtf8("label_6")) self.horizontalLayout_5.addWidget(self.label_6) self.cmpMethCombo = QtGui.QComboBox(self.groupBox_5) self.cmpMethCombo.setObjectName(_fromUtf8("cmpMethCombo")) self.horizontalLayout_5.addWidget(self.cmpMethCombo) self.horizontalLayout_9.addLayout(self.horizontalLayout_5) self.horizontalLayout_10.addLayout(self.horizontalLayout_9) self.horizontalLayout_8 = QtGui.QHBoxLayout() self.horizontalLayout_8.setObjectName(_fromUtf8("horizontalLayout_8")) self.horizontalLayout_7 = QtGui.QHBoxLayout() self.horizontalLayout_7.setObjectName(_fromUtf8("horizontalLayout_7")) self.label_5 = QtGui.QLabel(self.groupBox_5) self.label_5.setObjectName(_fromUtf8("label_5")) self.horizontalLayout_7.addWidget(self.label_5) self.cmpTypeCombo = QtGui.QComboBox(self.groupBox_5) self.cmpTypeCombo.setObjectName(_fromUtf8("cmpTypeCombo")) self.horizontalLayout_7.addWidget(self.cmpTypeCombo) self.horizontalLayout_8.addLayout(self.horizontalLayout_7) self.horizontalLayout_4 = QtGui.QHBoxLayout() self.horizontalLayout_4.setObjectName(_fromUtf8("horizontalLayout_4")) self.label_8 = QtGui.QLabel(self.groupBox_5) self.label_8.setObjectName(_fromUtf8("label_8")) self.horizontalLayout_4.addWidget(self.label_8) self.verticalLayout = QtGui.QVBoxLayout() self.verticalLayout.setObjectName(_fromUtf8("verticalLayout")) self.horizontalLayout_2 = QtGui.QHBoxLayout() self.horizontalLayout_2.setObjectName(_fromUtf8("horizontalLayout_2")) self.label_9 = QtGui.QLabel(self.groupBox_5) self.label_9.setObjectName(_fromUtf8("label_9")) self.horizontalLayout_2.addWidget(self.label_9) self.smallValueEdit = QtGui.QLineEdit(self.groupBox_5) self.smallValueEdit.setContextMenuPolicy(QtCore.Qt.DefaultContextMenu) self.smallValueEdit.setObjectName(_fromUtf8("smallValueEdit")) self.horizontalLayout_2.addWidget(self.smallValueEdit) self.verticalLayout.addLayout(self.horizontalLayout_2) self.horizontalLayout_3 = QtGui.QHBoxLayout() self.horizontalLayout_3.setObjectName(_fromUtf8("horizontalLayout_3")) self.label_10 = QtGui.QLabel(self.groupBox_5) self.label_10.setObjectName(_fromUtf8("label_10")) self.horizontalLayout_3.addWidget(self.label_10) self.bigValueEdit = QtGui.QLineEdit(self.groupBox_5) self.bigValueEdit.setText(_fromUtf8("")) self.bigValueEdit.setObjectName(_fromUtf8("bigValueEdit")) self.horizontalLayout_3.addWidget(self.bigValueEdit) self.verticalLayout.addLayout(self.horizontalLayout_3) self.horizontalLayout_4.addLayout(self.verticalLayout) self.horizontalLayout_8.addLayout(self.horizontalLayout_4) self.horizontalLayout_10.addLayout(self.horizontalLayout_8) self.calculateBtn = QtGui.QPushButton(self.groupBox_5) self.calculateBtn.setObjectName(_fromUtf8("calculateBtn")) self.horizontalLayout_10.addWidget(self.calculateBtn) spacerItem2 = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum) self.horizontalLayout_10.addItem(spacerItem2) self.gridLayout_5.addLayout(self.horizontalLayout_10, 0, 0, 1, 1) self.gridLayout_4.addWidget(self.groupBox_5, 0, 0, 1, 1) self.tabWidget.addTab(self.tab_2, _fromUtf8("")) self.tab_4 = QtGui.QWidget() self.tab_4.setObjectName(_fromUtf8("tab_4")) self.verticalLayout_4 = QtGui.QVBoxLayout(self.tab_4) self.verticalLayout_4.setObjectName(_fromUtf8("verticalLayout_4")) self.groupBox_8 = QtGui.QGroupBox(self.tab_4) self.groupBox_8.setMaximumSize(QtCore.QSize(16777215, 90)) self.groupBox_8.setObjectName(_fromUtf8("groupBox_8")) self.gridLayout_9 = QtGui.QGridLayout(self.groupBox_8) self.gridLayout_9.setObjectName(_fromUtf8("gridLayout_9")) self.horizontalLayout = QtGui.QHBoxLayout() self.horizontalLayout.setObjectName(_fromUtf8("horizontalLayout")) self.label_15 = QtGui.QLabel(self.groupBox_8) self.label_15.setObjectName(_fromUtf8("label_15")) self.horizontalLayout.addWidget(self.label_15) self.startDateEdit_4 = QtGui.QDateEdit(self.groupBox_8) self.startDateEdit_4.setCalendarPopup(True) self.startDateEdit_4.setObjectName(_fromUtf8("startDateEdit_4")) self.horizontalLayout.addWidget(self.startDateEdit_4) self.label_16 = QtGui.QLabel(self.groupBox_8) self.label_16.setObjectName(_fromUtf8("label_16")) self.horizontalLayout.addWidget(self.label_16) self.endDateEdit_4 = QtGui.QDateEdit(self.groupBox_8) self.endDateEdit_4.setDate(QtCore.QDate(2014, 1, 1)) self.endDateEdit_4.setCalendarPopup(True) self.endDateEdit_4.setObjectName(_fromUtf8("endDateEdit_4")) self.horizontalLayout.addWidget(self.endDateEdit_4) self.label_17 = QtGui.QLabel(self.groupBox_8) sizePolicy = QtGui.QSizePolicy(QtGui.QSizePolicy.Preferred, QtGui.QSizePolicy.Minimum) sizePolicy.setHorizontalStretch(0) sizePolicy.setVerticalStretch(0) sizePolicy.setHeightForWidth(self.label_17.sizePolicy().hasHeightForWidth()) self.label_17.setSizePolicy(sizePolicy) self.label_17.setObjectName(_fromUtf8("label_17")) self.horizontalLayout.addWidget(self.label_17) self.weightEdit = QtGui.QLineEdit(self.groupBox_8) self.weightEdit.setMaximumSize(QtCore.QSize(50, 16777215)) self.weightEdit.setObjectName(_fromUtf8("weightEdit")) self.horizontalLayout.addWidget(self.weightEdit) self.label_18 = QtGui.QLabel(self.groupBox_8) self.label_18.setObjectName(_fromUtf8("label_18")) self.horizontalLayout.addWidget(self.label_18) self.crossTypeCombo = QtGui.QComboBox(self.groupBox_8) self.crossTypeCombo.setObjectName(_fromUtf8("crossTypeCombo")) self.horizontalLayout.addWidget(self.crossTypeCombo) self.crossBtn = QtGui.QPushButton(self.groupBox_8) self.crossBtn.setObjectName(_fromUtf8("crossBtn")) self.horizontalLayout.addWidget(self.crossBtn) spacerItem3 = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum) self.horizontalLayout.addItem(spacerItem3) self.gridLayout_9.addLayout(self.horizontalLayout, 0, 0, 1, 1) self.verticalLayout_4.addWidget(self.groupBox_8) self.groupBox_7 = QtGui.QGroupBox(self.tab_4) self.groupBox_7.setObjectName(_fromUtf8("groupBox_7")) self.gridLayout_8 = QtGui.QGridLayout(self.groupBox_7) self.gridLayout_8.setObjectName(_fromUtf8("gridLayout_8")) self.crossTableWidget = MyTable(self.groupBox_7) self.crossTableWidget.setObjectName(_fromUtf8("crossTableWidget")) self.gridLayout_8.addWidget(self.crossTableWidget, 0, 0, 1, 1) self.verticalLayout_4.addWidget(self.groupBox_7) self.tabWidget.addTab(self.tab_4, _fromUtf8("")) self.horizontalLayout_20.addWidget(self.tabWidget) self.groupBox_9 = QtGui.QGroupBox(self.splitter_3) self.groupBox_9.setObjectName(_fromUtf8("groupBox_9")) self.gridLayout_10 = QtGui.QGridLayout(self.groupBox_9) self.gridLayout_10.setObjectName(_fromUtf8("gridLayout_10")) self.combineWidget = MyTable(self.groupBox_9) self.combineWidget.setObjectName(_fromUtf8("combineWidget")) self.gridLayout_10.addWidget(self.combineWidget, 0, 0, 1, 1) self.gridLayout_2.addWidget(self.splitter_3, 0, 1, 1, 1) self.horizontalLayout_17 = QtGui.QHBoxLayout() self.horizontalLayout_17.setSizeConstraint(QtGui.QLayout.SetMinimumSize) self.horizontalLayout_17.setObjectName(_fromUtf8("horizontalLayout_17")) self.showGroupBtn = QtGui.QPushButton(self.centralWidget) self.showGroupBtn.setMaximumSize(QtCore.QSize(100, 20)) self.showGroupBtn.setCheckable(True) self.showGroupBtn.setObjectName(_fromUtf8("showGroupBtn")) self.horizontalLayout_17.addWidget(self.showGroupBtn) self.classifyBtn = QtGui.QPushButton(self.centralWidget) self.classifyBtn.setMaximumSize(QtCore.QSize(100, 20)) self.classifyBtn.setCheckable(True) self.classifyBtn.setObjectName(_fromUtf8("classifyBtn")) self.horizontalLayout_17.addWidget(self.classifyBtn) spacerItem4 = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum) self.horizontalLayout_17.addItem(spacerItem4) self.gridLayout_2.addLayout(self.horizontalLayout_17, 1, 0, 1, 2) MainWindow.setCentralWidget(self.centralWidget) self.menuBar = QtGui.QMenuBar(MainWindow) self.menuBar.setGeometry(QtCore.QRect(0, 0, 1227, 23)) self.menuBar.setObjectName(_fromUtf8("menuBar")) self.menu = QtGui.QMenu(self.menuBar) self.menu.setObjectName(_fromUtf8("menu")) self.menu_2 = QtGui.QMenu(self.menuBar) self.menu_2.setObjectName(_fromUtf8("menu_2")) MainWindow.setMenuBar(self.menuBar) self.action = QtGui.QAction(MainWindow) self.action.setObjectName(_fromUtf8("action")) self.action_addGroup = QtGui.QAction(MainWindow) self.action_addGroup.setObjectName(_fromUtf8("action_addGroup")) self.action_editGroup = QtGui.QAction(MainWindow) self.action_editGroup.setObjectName(_fromUtf8("action_editGroup")) self.action_showGroupView = QtGui.QAction(MainWindow) self.action_showGroupView.setCheckable(True) self.action_showGroupView.setObjectName(_fromUtf8("action_showGroupView")) self.action_deleteGroup = QtGui.QAction(MainWindow) self.action_deleteGroup.setObjectName(_fromUtf8("action_deleteGroup")) self.menu_2.addAction(self.action) self.menuBar.addAction(self.menu.menuAction()) self.menuBar.addAction(self.menu_2.menuAction()) self.retranslateUi(MainWindow) self.tabWidget.setCurrentIndex(3) QtCore.QMetaObject.connectSlotsByName(MainWindow)
from MyTable import MyTable tt = MyTable() tt.createtable("aa,bb,cc,dd") print "begin insert" for i in range(1000000, -1, -1): tt.insert("aa,bb,cc,dd", str(i) + "|11|22|zhou") print "end insert" print "begin sort" tt.Sort() print "end sort" print "begin select" for i in range(100): tt.selectwhere("aa", "3456") print "end select" #tt.updatewhere("aa,cc","1111|2222","dd,aa","1|2") #tt.Print() #print '' #i=tt.halffind(['aa','bb'],['2','3']) #print i #tt.deletewhere("dd,cc","zhou|") #tt.Print()