HYTOS

        @author     kyouho

        @date       2018.07.12

    '''

    def saveCommonCodeData(self, tableName, datas):

        import uuid

                # Get a cursor object

                cursor = conn.cursor()

                for data in datas:

                    uid, code, description, allowables = data[0], data[1], data[2], data[3]

                    if not uid:

                        sql = self.project.database.to_sql(

                            "update {} SET CODE=?, DESCRIPTION=?, ALLOWABLES=? WHERE UID = ?".format(tableName))

                        param = (data[1], data[2], data[3], data[0])

                    cursor.execute(sql, param)

                conn.commit()

            # Catch the exception

            self.ui.tableWidgetValveOperCodes.setSortingEnabled(True)

            self.ui.tableWidgetEqpTagNames.setSortingEnabled(True)

            self.ui.tableWidgetReservedWords.setSortingEnabled(True)

            # DB Table명 기준으로 작성

            for table in QCodeTableDialog.CODE_TABLES:

            if tabText != "NominalDiameter":

                item = table.item(row, 1)

                code = item.text()

                if column == 1:

                    result = self.isExistCode(table, code)

            rowCount = table.rowCount()

            for row in range(rowCount):

                if table.isRowHidden(row):

                elif table.item(row, 0):

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

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