def __init__(self,
dataBaseType: JPDbType = JPDbType.MySQL,
*args,
**kwargs):
super(JPMainWindow, self).__init__(*args, **kwargs)
try:
db = JPDb()
db.setDatabaseType(dataBaseType)
JPPub().MainForm = self
except Exception as e:
QMessageBox.warning(self, "提示", str(e))
self.ui = Ui_MainWindow()
self.ui.setupUi(self)
self.ui.label_Title.setText("")
self.commandDict = {}
self.logoPixmap = None
self.addOneButtonIcon(self.ui.ChangeUser, "changeuser.png")
self.addOneButtonIcon(self.ui.ChangePassword, "changepassword.png")
# self.addLogoToLabel(self.ui.label_logo)
# 用户及密码修改功能
objUser = JPUser()
objUser.INIT() # 程序开始时只初始化一次
objUser.userChange.connect(self.onUserChanged)
objUser.currentUserID()
self.ui.ChangeUser.clicked.connect(objUser.changeUser)
self.ui.ChangePassword.clicked.connect(objUser.changePassword)
# 堆叠布局
self.ui.stackedWidget.removeWidget(self.ui.page)
self.ui.stackedWidget.removeWidget(self.ui.page_2)
# 隐藏树标题
self.ui.label_FunPath.setText('')
self.ui.treeWidget.setHeaderHidden(True)
# 设置状态条中的进度条及标签
self.Label = QLabel(" ")
self.ProgressBar = QProgressBar()
self.statusBar = self.statusBar()
self.statusBar.addPermanentWidget(self.Label)
self.statusBar.addPermanentWidget(self.ProgressBar)
self.ProgressBar.setGeometry(0, 0, 100, 5)
self.ProgressBar.hide()
self.statusBar.hide()
self.ui.splitter.setStretchFactor(0, 2)
self.ui.splitter.setStretchFactor(1, 11)
# 连接点击了功能树中的节点到函数
self.ui.treeWidget.itemClicked[QTreeWidgetItem,
int].connect(self.treeViewItemClicked)
sql = f"""
select
fID as `序号NO.`,
fProductName as `产品名称Descrição do produto`,
fCurrentQuantity as 当前库存Quantidade ,
fSpesc as `规格Especificação`,
fWidth as 宽Largura,
fLength as 长Longo,
fUint 单位Unidade,
fNote as 备注Observações
from t_product_information
where fCancel=0 and fProductName like '%{key}%'
order by fID
"""
self.tab = JPQueryFieldInfo(sql)
self.mod = JPTableViewModelReadOnly(self.ui.tableView, self.tab)
self.ui.tableView.setModel(self.mod)
self.ui.tableView.resizeColumnsToContents()
if __name__ == "__main__":
import sys
db = JPDb()
db.setDatabaseType(JPDbType.MySQL)
app = QApplication(sys.argv)
ps = ProductSelecter()
ps.show()
sys.exit(app.exec_())
r = index.row()
tp = self.tab.DataRows[r].Datas[3][1][2]
fieldname = self.tab.DataRows[r].Datas[3][1][1]
dic = data[1]
temp_de = self.des[fieldname] if tp == 9999 else self.des[tp]
if dic["En1"]:
self.tv.setItemDelegateForColumn(5, temp_de)
if dic["En2"]:
self.tv.setItemDelegateForColumn(6, temp_de)
self.setDelegate127(index.row())
if __name__ == "__main__":
import sys
db = JPDb()
db.setDatabaseType(1)
app = QApplication(sys.argv)
sql_0 = """
SELECT fOrderID as 订单号码OrderID,
fOrderDate as 日期OrderDate,
fCustomerName as 客户名Cliente,
fCity as 城市City,
fSubmited1 as 提交Submited,
fSubmit_Name as 提交人Submitter,
fRequiredDeliveryDate as 交货日期RequiredDeliveryDate,
fAmount as 金额SubTotal,
fDesconto as 折扣Desconto,
fTax as 税金IVA,
fPayable as `应付金额Valor a Pagar`,
fContato as 联系人Contato,
fCelular as 手机Celular,
