Exemple #1
0
 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)
Exemple #2
0
 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)
Exemple #3
0
    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)
Exemple #4
0
    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)