def __init__(self, parent=None):
"""
Constructor
@param parent reference to the parent widget
@type QWidget
"""
super(Dialog_loadtemplate, self).__init__(parent)
self.setupUi(self)
self.curIndexData=None
gtreeView(self.treeView, 'pricetemplateh')
def deleteCurItem(self):
deletestr=u'您将永久删除类别'+' '+self.curEditData[0]+' ,'+u'请确认是否执行.'
if QMessageBox.question(self, u'删除提醒', deletestr, QMessageBox.Ok, QMessageBox.Cancel)==QMessageBox.Ok:
if self.curEditData[2]-self.curEditData[1]>1:
QMessageBox.warning(self, u'警告', u'请删除所有当前类别的子类别后，再删除本类别')
return
query=QSqlQuery()
query.prepare(u"select count(*) from routingtemplate where `产品系列名`=:seriesname")
query.bindValue(":seriesname", self.curIndexData[0])
query.exec_()
while query.next():
print('test', query.value(0))
if query.value(0)>0:
QMessageBox.warning(self, u'警告', u'当前类别下有数据，不能删除')
return
else:
query.clear()
query.prepare("DELETE FROM pricetemplateh WHERE `name`=:curname")
query.bindValue(":curname", self.curEditData[0])
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'删除类别失败，请检查数据')
return
query.clear()
query.prepare(u"UPDATE pricetemplateh SET rgt=rgt-2 WHERE rgt>=:currgt")
query.bindValue(':currgt', self.curEditData[2])
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'更新类别失败，请检查数据')
return
query.clear()
query.prepare(u"UPDATE pricetemplateh SET lft=lft-2 WHERE lft>=:currgt")
query.bindValue(':currgt', self.curEditData[2])
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'更新类别失败，请检查数据')
return
gtreeView(self.treeView, 'pricetemplateh')
self.viewmodel.clear()
self.viewmodel.setTable('routingtemplate')
self.viewmodel.setFilter(u"`产品系列名`='产品'")
self.viewmodel.select()
def addSameLayerItem(self):
# print(self.curEditData)
text, ok=QInputDialog.getText(self,u'新增类别', u"名称：")
if ok:
inputname=text
if len(inputname)==0:
QMessageBox.warning(self, u'警告', u'没有输入任何内容')
return
else:
return
query=QSqlQuery()
query.prepare("select count(*) from pricetemplateh where `name`=:inputname")
query.bindValue(':inputname', inputname)
query.exec_()
while query.next():
if query.value(0)>0:
QMessageBox.warning(self, u'错误提醒', u'名字重复，请重新输入')
return
query.clear()
query.prepare(u"UPDATE pricetemplateh SET rgt=rgt+2 WHERE rgt>:currgt")
query.bindValue(':currgt', self.curEditData[2])
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'更新类别失败，请检查数据')
return
query.clear()
query.prepare(u"UPDATE pricetemplateh SET lft=lft+2 WHERE lft>:currgt")
query.bindValue(':currgt', self.curEditData[2])
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'更新类别失败，请检查数据')
return
query.clear()
query.prepare("INSERT INTO pricetemplateh(name,lft,rgt) VALUES (:name,:lft,:rgt)")
query.bindValue(':name', inputname)
query.bindValue(':lft', self.curEditData[2]+1)
query.bindValue(':rgt', self.curEditData[2]+2)
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'插入类别失败，请检查数据')
return
gtreeView(self.treeView, 'pricetemplateh')
def renameCurItem(self):
str=u'更换类别：'+' '+self.curEditData[0]+' '+u'为:'
text, ok=QInputDialog.getText(self,u'更名', str)
if ok:
inputname=text
else:
return
query=QSqlQuery()
query.prepare("select count(*) from pricetemplateh where `name`=:inputname")
query.bindValue(':inputname', inputname)
query.exec_()
while query.next():
if query.value(0)>0:
QMessageBox.warning(self, u'错误提醒', u'名字重复，请重新输入')
return
query.clear()
query.prepare("UPDATE pricetemplateh SET `name`=:newname where `name`=:oldname")
query.bindValue(':newname', inputname)
query.bindValue(':oldname',self.curEditData[0] )
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'更名失败，请检查数据')
return
query.clear()
query.prepare(u"UPDATE routingtemplate SET `产品系列名`=:newname where `产品系列名`=:oldname")
query.bindValue(":newname", inputname)
query.bindValue(":oldname", self.curEditData[0])
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'更名模板数据库失败，请检查数据')
return
gtreeView(self.treeView, 'pricetemplateh')
self.viewmodel.clear()
self.viewmodel.setTable('routingtemplate')
self.viewmodel.setFilter("`产品系列名`={name}".format(name=self.curEditData[0]))
self.viewmodel.select()
def __init__(self, parent=None, data={}):
"""
Constructor
@param parent reference to the parent widget
@type QWidget
"""
QDialog.__init__(self, parent)
self.data=data
self.picturemodifyFlag=['False' for x in range(5)]
self.picturedata=['' for x in range(5)]
self.setupUi(self)
self.lineEdit_MID.setEnabled(False)
self.lineEdit_MID.setFocus()
self._createcombosize()
self._createcombounit()
self.gtreeview=gtreeView(self.treeView, 'materialtype')
self.treeView.hide()
self._initdata()
def __init__(self, parent=None):
"""
Constructor
@param parent reference to the parent widget
@type QWidget
"""
super(MainWindow_PriceTemplete, self).__init__(parent)
self.parent=parent
self.curIndexData=None
self.setupUi(self)
self.setPriceTempleteToolbar()
connectdb()
self.viewmodel=QSqlTableModel()
self.treeviewshow=gtreeView(self.treeView, 'pricetemplateh')
self.closeview.triggered.connect(self.viewclose)
self.treeView.customContextMenuRequested[QPoint].connect(self.setPopMenu)
self.newview.triggered.connect(self.viewnew)
self.modifyview.triggered.connect(self.viewmodify)
self.deleteview.triggered.connect(self.viewdelete)
def addNextLayerItem(self):
text, ok=QInputDialog.getText(self,u'新增下级类别', u"名称：")
if ok:
inputname=text
if len(inputname)==0:
QMessageBox.warning(self, u'警告', u'没有输入任何内容')
return
else:
return
query=QSqlQuery()
query.prepare("select count(*) from pricetemplateh where `name`=:inputname")
query.bindValue(':inputname', inputname)
query.exec_()
while query.next():
if query.value(0)>0:
QMessageBox.warning(self, u'错误提醒', u'名字重复，请重新输入')
return
print(self.curEditData[2], self.curEditData[1])
if self.curEditData[2]-self.curEditData[1]==1:
query.clear()
query.prepare(u"select count(*) from routingtemplate where `产品系列名`=:serisname")
query.bindValue(":serisname", self.curEditData[0])
if query.exec_()==True:
while query.next():
count=query.value(0)
if count>0:
if QMessageBox.question(self, u'错误提醒', u'类别:{name} \n下已有模板，是否将该模板转入新的系列名之下'.format(name=self.curEditData[0]), QMessageBox.Ok, QMessageBox.Cancel)==QMessageBox.Cancel:
return
else:
break
print("end")
query.clear()
query.prepare(u"UPDATE pricetemplateh SET rgt=rgt+2 WHERE rgt>=:currgt")
query.bindValue(':currgt', self.curEditData[2])
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'更新类别失败，请检查数据')
return
query.clear()
query.prepare(u"UPDATE pricetemplateh SET lft=lft+2 WHERE lft>=:currgt")
query.bindValue(':currgt', self.curEditData[2])
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'更新类别失败，请检查数据')
return
query.clear()
query.prepare("INSERT INTO pricetemplateh(name,lft,rgt) VALUES (:name,:lft,:rgt)")
query.bindValue(':name', inputname)
query.bindValue(':lft', self.curEditData[2])
query.bindValue(':rgt', self.curEditData[2]+1)
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'插入类别失败，请检查数据')
return
query.clear()
query.prepare(u"UPDATE routingtemplate SET `产品系列名`=:newname where `产品系列名`=:oldname")
query.bindValue(":newname", inputname)
query.bindValue(":oldname", self.curEditData[0])
if query.exec_()!=True:
QMessageBox.warning(self, u'警告', u'更名模板数据库失败，请检查数据')
return
gtreeView(self.treeView, 'pricetemplateh')