HYTOS

                    kyouho 2018.07.16 edit query order by code

            sql = "select Code,Metric,Inch,InchStr,MetricStr from 'NOMINAL PIPE SIZE' ORDER BY CODE ASC"

                pipeSize = NominalPipeSize(row[0], float(row[1]) if row[1] is not None else None, float(row[2]) if row[2] is not None else None, row[3], row[4])

    '''

        @brief      insert nominal pipe size table

        @author     kyouho

        @date       2018.07.16

    '''

    def insertNomialPipeSize(self, pipeSizes):

        try:

            # Creates or opens a file called mydb with a SQLite3 DB

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            sql = "INSERT INTO 'NOMINAL PIPE SIZE'(Code, Metric, Inch, InchStr, MetricStr) VALUES(?,?,?,?,?)"

            for pipeSize in pipeSizes:

                param = (pipeSize.code, pipeSize.metric, pipeSize.inch, pipeSize.inchStr, pipeSize.metricStr)

                cursor.execute(sql, param)

            conn.commit()

            # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            conn.rollback()

            print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        finally:

            # Close the db connection

            conn.close()

    '''

        @brief      delete nominal pipe size table

        @author     kyouho

        @date       2018.07.16

    '''

    def deleteNomialPipeSize(self):

        try:

            dbPath = self.getCurrentProject().getPath() + "/db/ITI_PID.db"

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            sql = "DELETE FROM 'NOMINAL PIPE SIZE'"

            try:

                cursor.execute(sql)

                conn.commit()

            except Exception as ex:

                print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        finally:

            conn.close()

                self.ui.tableWidgetNominalDiameter.setItem(row, 1, QTableWidgetItem('' if pipeSize.metric is None else str(pipeSize.metric)))

                self.ui.tableWidgetNominalDiameter.setItem(row, 2, QTableWidgetItem('' if pipeSize.inch is None else str(pipeSize.inch)))

        self.saveNomialPipeSize()

    '''

        @brief      save common code data

        @author     kyouho

        @date       2018.07.16

    '''

    def saveNomialPipeSize(self):

        pipeSizes = []

        try:

            docData = AppDocData.instance()

            self.deleteNomialPipeSize()

            from AppDocData import NominalPipeSize

            table = self.ui.tableWidgetNominalDiameter

            rowCount = table.rowCount()

            for row in range(rowCount):

                code = table.item(row, 0).text()

                metric = table.item(row, 1).text()

                inch = table.item(row, 2).text()

                inchStr = table.item(row, 3).text()

                metricStr = table.item(row, 4).text()

                pipeSize = NominalPipeSize(code, float(metric) if metric != '' else None, float(inch) if inch != '' else None, inchStr, metricStr)

                pipeSizes.append(pipeSize)

            docData.insertNomialPipeSize(pipeSizes)

        except Exception as ex:

            print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

    '''

        @brief      save common code data

        @author     kyouho

        @date       2018.07.16

    '''

    def deleteNomialPipeSize(self):

        docData = AppDocData.instance()

        docData.deleteNomialPipeSize()

        self.groupBox.setTitle(_translate("CodeTableDialog", "Nominal Diameter"))

            <string>Nominal Diameter</string>