def __find_sale(self): pdt = ProductDao() selectionIdxs = self.ui.tableWidget_2.selectedIndexes()[0] code = self.ui.tableWidget_2.item(selectionIdxs.row(), 1).text() res = pdt.select(code) find_res = str(res[0][1]) QMessageBox.information(self, '검색완료', find_res, QMessageBox.Ok)
def init_item(self): pdt = ProductDao() res = pdt.select() self.ui.le_code.clear() self.ui.le_name.clear() row_res = self.ui.tableWidget.rowCount() [self.ui.tableWidget.removeRow(i) for i in reversed(range(row_res))] self.load_data(res)
def __init__(self): super().__init__() pf = Product_form() sf = Sale_form() pdt = ProductDao() sdt = SaleDao() sdd = Sale_Detail_Dao() self.ui = uic.loadUi("ui/application.ui") # create table self.table = create_table(table=self.ui.tableWidget, data=['code', 'name']) self.table_sale = create_table( table=self.ui.tableWidget_2, data=['no', 'code', 'price', 'saleCnt', 'marginRate']) self.table_sdd = create_table( table=self.ui.table_sd, data=['no', 'sale_price', 'addTax', 'supply_price', 'marginPrice']) self.table_sdd_proc = create_table(table=self.ui.table_proc, data=[ 'rank', 'code', 'name', 'price', 'saleCnt', 'supply_price', 'addTax', 'sale_price', 'marginRate', 'marginPrice' ]) # select data res = pdt.select() res2 = sdt.select_item() res3 = sdd.select_item() self.load_data(res) self.load_data_sale(res2) self.load_data_sale_detail(res3) # product 버튼 연결 self.ui.btn_insert.clicked.connect(self.add_item) self.ui.btn_update.clicked.connect(self.update_item) self.ui.btn_delete.clicked.connect(self.del_item) self.ui.btn_init.clicked.connect(self.init_item) self.ui.btn_pd_explain.clicked.connect(self.explain_pd) # sale 버튼 연결 self.ui.btn_insert_2.clicked.connect(self.add_item_sale) self.ui.btn_update_2.clicked.connect(self.update_item_sale) self.ui.btn_delete_2.clicked.connect(self.del_item_sale) self.ui.btn_init_2.clicked.connect(self.init_item_sale) self.ui.btn_explain.clicked.connect(self.explain_sale) # sale_detail_proc 버튼 연결 self.ui.rdbtn_sp.clicked.connect(self.call_proc_sp) self.ui.rdbtn_mp.clicked.connect(self.call_proc_mp) # 마우스 우클릭시 메뉴 pf.set_context_menu(self.ui.tableWidget, self.__update, self.__delete, self.__find) sf.set_context_menu_sale(self.ui.tableWidget_2, self.__update_sale, self.__delete_sale, self.__find_sale) self.ui.show()