def tabchange(self):
self.ui.prono.clear()
self.ui.comboBox.clear()
self.ui.comboBox_2.clear()
plist=dbconn.getprono()
self.ui.prono.addItems(plist)
self.ui.comboBox.addItems(plist)
self.ui.comboBox_2.addItems(plist)
def tabchange(self):
self.ui.prono.clear()
self.ui.comboBox.clear()
self.ui.comboBox_2.clear()
plist = dbconn.getprono()
self.ui.prono.addItems(plist)
self.ui.comboBox.addItems(plist)
self.ui.comboBox_2.addItems(plist)
def __init__(self,parent=None):
QtGui.QWidget.__init__(self,parent)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.model=QtSql.QSqlTableModel(self)
self.model.setTable('productlist')
self.model.setHeaderData(0,QtCore.Qt.Horizontal,u"编号")
self.model.setHeaderData(1,QtCore.Qt.Horizontal,u"名称")
self.model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)
self.model.select()
self.ui.tableView.setModel(self.model)
model1=QtSql.QSqlQueryModel(self)
sql=u'''
select prodctuno as 编号,time as 时间,prodtype as 良否,qty as 数量,\
place as 库位,recordman as 记录人, mark as 备注 from record
'''
model1.setQuery(sql)
self.ui.tableView_2.setModel(model1)
model=QtSql.QSqlQueryModel()
sql=u'''
select prodctuno as 编号,time as 时间,prodtype as 良否,qty as 数量,\
lingyongman as 领用人,
place as 库位,recordman as 记录人, mark as 备注 from outrecord
'''
model.setQuery(sql)
self.ui.tableView_5.setModel(model)
self.ui.radioButton.setChecked(True)
self.ui.radioButton_4.setChecked(True)
self.ui.radioButton_5.setChecked(True)
self.inall()
self.outall()
self.curall()
plist=dbconn.getprono()
self.ui.prono.addItems(plist)
self.ui.comboBox.addItems(plist)
self.ui.comboBox_2.addItems(plist)
pname=dbconn.getpronamebyno(self.ui.prono.currentText())
self.ui.lineEdit.setText(pname)
self.ui.lineEdit_3.setText(pname)
self.ui.lineEdit_11.setText(pname)
self.connect(self.ui.prono,QtCore.SIGNAL('currentIndexChanged(QString)'),self.updatelineedit)
self.connect(self.ui.comboBox,QtCore.SIGNAL('currentIndexChanged(QString)'),self.updateoutlineedit)
self.connect(self.ui.comboBox_2,QtCore.SIGNAL('currentIndexChanged(QString)'),self.querlineedit)
self.connect(self.ui.pushButton,QtCore.SIGNAL('clicked()'),self.insertdata)
self.connect(self.ui.pushButton_3,QtCore.SIGNAL('clicked()'),self.outdata)
self.connect(self.ui.lineEdit_2,QtCore.SIGNAL('textChanged(QString)'),self.checkint)
self.connect(self.ui.lineEdit_6,QtCore.SIGNAL('textChanged(QString)'),self.checkint)
#self.connect(self.ui.addButton,QtCore.SIGNAL("click()"),self.addinfo)
#self.connect(self.ui.cancelButton,QtCore.SIGNAL("click()"),QtCore.SLOT('close()'))
self.connect(self.ui.pushButton_2,QtCore.SIGNAL('clicked()'),self.cancledate)
self.connect(self.ui.pushButton_5,QtCore.SIGNAL('clicked()'),self.addproduct)
self.connect(self.ui.pushButton_6,QtCore.SIGNAL('clicked()'),self.updateproduct)
self.connect(self.ui.pushButton_7,QtCore.SIGNAL('clicked()'),self.delproduct)
self.connect(self.ui.pushButton_8,QtCore.SIGNAL('clicked()'),self.querproduct)
self.connect(self.ui.tableView,QtCore.SIGNAL('clicked(QModelIndex)'),self.selproductno)
self.connect(self.ui.tabWidget,QtCore.SIGNAL('currentChanged(int)'),self.tabchange)
self.connect(self.ui.pushButton_9,QtCore.SIGNAL('clicked()'),self.inall)
self.connect(self.ui.pushButton_10,QtCore.SIGNAL('clicked()'),self.outall)
self.connect(self.ui.pushButton_11,QtCore.SIGNAL('clicked()'),self.curall)
def __init__(self, parent=None):
QtGui.QWidget.__init__(self, parent)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.model = QtSql.QSqlTableModel(self)
self.model.setTable('productlist')
self.model.setHeaderData(0, QtCore.Qt.Horizontal, u"编号")
self.model.setHeaderData(1, QtCore.Qt.Horizontal, u"名称")
self.model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)
self.model.select()
self.ui.tableView.setModel(self.model)
model1 = QtSql.QSqlQueryModel(self)
sql = u'''
select prodctuno as 编号,time as 时间,prodtype as 良否,qty as 数量,\
place as 库位,recordman as 记录人, mark as 备注 from record
'''
model1.setQuery(sql)
self.ui.tableView_2.setModel(model1)
model = QtSql.QSqlQueryModel()
sql = u'''
select prodctuno as 编号,time as 时间,prodtype as 良否,qty as 数量,\
lingyongman as 领用人,
place as 库位,recordman as 记录人, mark as 备注 from outrecord
'''
model.setQuery(sql)
self.ui.tableView_5.setModel(model)
self.ui.radioButton.setChecked(True)
self.ui.radioButton_4.setChecked(True)
self.ui.radioButton_5.setChecked(True)
self.inall()
self.outall()
self.curall()
plist = dbconn.getprono()
self.ui.prono.addItems(plist)
self.ui.comboBox.addItems(plist)
self.ui.comboBox_2.addItems(plist)
pname = dbconn.getpronamebyno(self.ui.prono.currentText())
self.ui.lineEdit.setText(pname)
self.ui.lineEdit_3.setText(pname)
self.ui.lineEdit_11.setText(pname)
self.connect(self.ui.prono,
QtCore.SIGNAL('currentIndexChanged(QString)'),
self.updatelineedit)
self.connect(self.ui.comboBox,
QtCore.SIGNAL('currentIndexChanged(QString)'),
self.updateoutlineedit)
self.connect(self.ui.comboBox_2,
QtCore.SIGNAL('currentIndexChanged(QString)'),
self.querlineedit)
self.connect(self.ui.pushButton, QtCore.SIGNAL('clicked()'),
self.insertdata)
self.connect(self.ui.pushButton_3, QtCore.SIGNAL('clicked()'),
self.outdata)
self.connect(self.ui.lineEdit_2, QtCore.SIGNAL('textChanged(QString)'),
self.checkint)
self.connect(self.ui.lineEdit_6, QtCore.SIGNAL('textChanged(QString)'),
self.checkint)
#self.connect(self.ui.addButton,QtCore.SIGNAL("click()"),self.addinfo)
#self.connect(self.ui.cancelButton,QtCore.SIGNAL("click()"),QtCore.SLOT('close()'))
self.connect(self.ui.pushButton_2, QtCore.SIGNAL('clicked()'),
self.cancledate)
self.connect(self.ui.pushButton_5, QtCore.SIGNAL('clicked()'),
self.addproduct)
self.connect(self.ui.pushButton_6, QtCore.SIGNAL('clicked()'),
self.updateproduct)
self.connect(self.ui.pushButton_7, QtCore.SIGNAL('clicked()'),
self.delproduct)
self.connect(self.ui.pushButton_8, QtCore.SIGNAL('clicked()'),
self.querproduct)
self.connect(self.ui.tableView, QtCore.SIGNAL('clicked(QModelIndex)'),
self.selproductno)
self.connect(self.ui.tabWidget, QtCore.SIGNAL('currentChanged(int)'),
self.tabchange)
self.connect(self.ui.pushButton_9, QtCore.SIGNAL('clicked()'),
self.inall)
self.connect(self.ui.pushButton_10, QtCore.SIGNAL('clicked()'),
self.outall)
self.connect(self.ui.pushButton_11, QtCore.SIGNAL('clicked()'),
self.curall)
