Esempio n. 1
0
    def __init__(self, parent=None):
        super(DlgIMSMain, self).__init__(None)
        if ims.model.dbSysUser.g_current_user is None:
            sys.exit(0)
        self.setWindowTitle(u'ut库存管理系统--欢迎使用-%s'%ims.model.dbSysUser.g_current_user.username)
        self.tabWidget = QTabWidget(self)
        self.dlgStock = DlgStock(self)
        self.tabWidget.addTab(self.dlgStock, u'库存列表')
        '''进出货记录'''
        self.dlgRecordSearch = DlgRecordSearch(self)
        self.tabWidget.addTab(self.dlgRecordSearch, u'进出货记录')
        self.tabWidget.addTab(DlgClient(self), u'客户列表')

        '''物品列表'''        
        spliterH = QSplitter(Qt.Horizontal, self)       
        self.treeArticle = QTreeWidget(self)       
        spliterH.addWidget(self.treeArticle)
        spliterH.addWidget(self.tabWidget)
        spliterH.setStretchFactor(0, 40)
        spliterH.setStretchFactor(1, 100)
        self.setCentralWidget(spliterH)

        self.setMinimumSize(800, 600)
        self.resize(800, 600)
        self.__initMenu()
        self.__initToolbar()
        self.__initTreeCtrl_Article()
        self.__udpateArticleTreeView()     
        self.treeArticle.itemSelectionChanged.connect(self.slotSelecteArticle)
Esempio n. 2
0
class DlgIMSMain(QMainWindow): 
    
    def __init__(self, parent=None):
        super(DlgIMSMain, self).__init__(None)
        if ims.model.dbSysUser.g_current_user is None:
            sys.exit(0)
        self.setWindowTitle(u'ut库存管理系统--欢迎使用-%s'%ims.model.dbSysUser.g_current_user.username)
        self.tabWidget = QTabWidget(self)
        self.dlgStock = DlgStock(self)
        self.tabWidget.addTab(self.dlgStock, u'库存列表')
        '''进出货记录'''
        self.dlgRecordSearch = DlgRecordSearch(self)
        self.tabWidget.addTab(self.dlgRecordSearch, u'进出货记录')
        self.tabWidget.addTab(DlgClient(self), u'客户列表')

        '''物品列表'''        
        spliterH = QSplitter(Qt.Horizontal, self)       
        self.treeArticle = QTreeWidget(self)       
        spliterH.addWidget(self.treeArticle)
        spliterH.addWidget(self.tabWidget)
        spliterH.setStretchFactor(0, 40)
        spliterH.setStretchFactor(1, 100)
        self.setCentralWidget(spliterH)

        self.setMinimumSize(800, 600)
        self.resize(800, 600)
        self.__initMenu()
        self.__initToolbar()
        self.__initTreeCtrl_Article()
        self.__udpateArticleTreeView()     
        self.treeArticle.itemSelectionChanged.connect(self.slotSelecteArticle)

    def slotSelecteArticle(self):
        item = self.treeArticle.currentItem()
        if item is None: return
        text = item.text(1)
        #print '=======id = ',text
        if text == '': return
        res = text.toInt()
        if not res[1]: return
        articleid = None
        if res[0] > 0: articleid = res[0]
        self.dlgStock.setArticleIdFilter(articleid)
        self.dlgRecordSearch.setArticleIdFilter(articleid)

    '''更新物品分类树'''
    def __initTreeCtrl_Article(self):               
        strListHeader = QStringList()
        strListHeader.append(u'物料分类')
        self.treeArticle.setHeaderLabels(strListHeader)
        self.treeArticle.setStyleSheet( "QTreeView::item:hover{background-color:rgb(0,255,0,50)} "
                                          "QTreeView:item{border-bottom:1px solid #999999;border-right:1px solid #999999}"
                                          "QTreeView::item:selected{background-color:rgb(255,0,0,100)}");
    def __udpateArticleTreeView(self):
        self.treeArticle.clear()
        '''添加一个显示所有库存的项'''
        item = QTreeWidgetItem()
        item.setText(0,u'显示所有')
        item.setText(1,u'-1')
        self.treeArticle.addTopLevelItem(item)

        listTypes1 = dbArticleType().getType1() 
        '''插入类别1'''       
        for t1 in listTypes1:
            item = QTreeWidgetItem()
            #print t1
            item.setText(0, t1.text)                
            item.setBackgroundColor(0, Qt.green)       
            listType2 = dbArticleType().getType2(t1.id)
            '''插入类别2 '''
            for t2 in listType2:
                #print '-',t2.text
                item2 = QTreeWidgetItem()
                item2.setText(0, t2.text)                
                item2.setBackgroundColor(0, Qt.green)
                item.addChild(item2)
                articles = dbArticle().getArticlesByTypeId(t2.id)
                '''插入物品型号'''
                for ac in articles:
                    item3 = QTreeWidgetItem()
                    item3.setText(0, ac.model)
                    item3.setText(1, str(ac.id))
                    item2.addChild(item3)
                    
            self.treeArticle.addTopLevelItem(item)
           
    #'''初始化菜单'''
    def __initMenu(self):
        self.action_in      = QAction(QIcon("images/shopping.png"),u"进货", self)
        self.action_out     = QAction(QIcon("images/sale.png"), u"出货", self)
        self.action_article = QAction(QIcon("images/shipping.png"), u"物料整理", self)
        self.action_client  = QAction(QIcon("images/26.png"),u"客户通讯录", self)
        self.action_backup  = QAction(QIcon("images/timezone.png"), u'备份数据库',self)
        self.action_chart   = QAction(QIcon("images/chart.png"), u"统计曲线", self)
        self.action_exit    = QAction(QIcon("images/Restricted 1.png"),u'退出系统', self)
        self.action_about         = QAction(u'关于', self)
        self.action_change_pass   = QAction(u'修改密码', self)
        self.action_admin         = QAction(u'帐户管理', self)

        self.action_client.triggered.connect(self.slotDlgClient)
        self.action_exit.triggered.connect(self.close)
        self.action_in.triggered.connect(self.slotIn)
        self.action_out.triggered.connect(self.slotOut)
        self.action_article.triggered.connect(self.slotArticle)
        self.action_about.triggered.connect(self.slotAbout)
        self.action_backup.triggered.connect(self.slotBackup)
        self.action_change_pass.triggered.connect(self.slotChangePassword)
        self.action_admin.triggered.connect(self.slotAdmin)

        menubar = self.menuBar()
        menufile = QMenu(u"文件",self)
        menufile.addAction(self.action_article)
        menufile.addAction(self.action_client)
        menufile.addSeparator()
        menufile.addAction(self.action_exit)

        menuUser = QMenu(u'帐户设置',self)
        menuUser.addAction(self.action_change_pass)
        menuUser.addSeparator()
        menuUser.addAction(self.action_admin)

        menuSystem = QMenu(u'系统设置',self)
        menuSystem.addAction(self.action_backup)
        action_auto_backup = QAction(u'自动备份数据库', self)
        menuSystem.addAction(action_auto_backup)
        menuSystem.addAction(QAction(u'保存登陆密码',self))

        menubar.addMenu(menufile)
        menubar.addMenu(menuUser)
        menubar.addMenu(menuSystem)
        menubar.addAction(self.action_about)
        if not ims.model.dbSysUser.g_current_user.is_enable_write_all():
            self.action_in.setEnabled(False)
            self.action_out.setEnabled(False)

    def __initToolbar(self):
        toolbar = QToolBar(self)
        #toolbar.setFixedHeight(70)
        toolbar.setIconSize(QSize(50,50))
        toolbar.addAction(self.action_in)
        toolbar.addAction(self.action_out)
        
        toolbar.addSeparator()
        toolbar.addAction(self.action_article)
        toolbar.addSeparator()
        toolbar.addAction(self.action_client)
        toolbar.addSeparator()
        toolbar.addAction(self.action_chart)
        toolbar.addSeparator()
        toolbar.addAction(self.action_exit)
        self.addToolBar(toolbar)


    #导出库存列表
    def slotExportRemain(self):
        filePath = QFileDialog.getSaveFileName(self)
        if not filePath: return
        filePath.append('.txt')
        import ims.FunctionTools
        ims.FunctionTools.ExportTableWidgetData(self.tableViewRemain, filePath)
        QMessageBox.information(self, u'info', u'已导出到%s'%filePath)

    #导出出入库记录
    def slotExportRecord(self):
        filePath = u'%s'%QFileDialog.getSaveFileName(self)
        if filePath=='': return
        filePath = filePath.rstrip(u'.xls')
        filePath = filePath + (u'.xls')
        import ims.FunctionTools
        ims.FunctionTools.ExportTableWidgetDataToExcel(self.dlgRecordSearch.ui.tableView, filePath)
        QMessageBox.information(self, u'info', u'已导出到%s'%filePath)

    def slotAbout(self):
        QMessageBox.about(self,u'库存管理系统',\
                          u'''UT库存管理系统,基于python2.7和pyqt4.8构建,\
                          \n版权所有,欢迎使用\
                          \n欢迎反馈交流^_^\
                          \nEmail: [email protected]\
                          \nQQ:    794345226''')

    def slotAdmin(self):
        res = QInputDialog.getText(self, u'系统管理', u'请输入管理员密码', QLineEdit.Password)
        if not res[0]: return
        #if res[1] != u'ut123654': return
        from ims.DlgSysUserAdmin import DlgSysUserAdmin
        dlg = DlgSysUserAdmin(self)
        dlg.setModal(True)
        dlg.exec_()

    #'''备份数据库,将数据库文件复制到其他位置'''
    def slotBackup(self):
        dstPath = QFileDialog.getExistingDirectory(self)
        if dstPath == "" : return
        date = QDate.currentDate()
        dstPath = dstPath +('\\ims_database_%04d%02d%02d.db3'%(date.year(), date.month(), date.day()))
        import  shutil
        srcPath = dbActicleIMS.getInstance().getDatabaseFilePath()
        print 'copy [%s] to [%s]'%(srcPath, dstPath)
        try:
            shutil.copyfile(srcPath,dstPath)
            QMessageBox.information(self, 'Successed!', u'数据库已成功备份到\n%s'%dstPath)
        except Exception,e:
            print e
            QMessageBox.critical(self, 'Successed!', u'数据库备份失败%s'%e)