HYTOS

        #self.equipmentDataList = []

        @brief      delete inst data list

        @author     kyouho

        @date       2018.08.14

    '''

    def deleteInstDataList(self, removeUID):

        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()

            for uid in removeUID:

                sql = "delete from INSTRUMENT_DATA_LIST where uid = '{}'".format(uid)

                cursor.execute(sql)

            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()

    '''

        result = []

        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 = 'select UID, ITEM_NO, SERVICE, NO_REQ, FLUID, DESC_OF_PART, OPERATION_CONDITION_TEMP, OPERATION_CONDITION_PRESS, DESIGN_CONDITION_TEMP, DESIGN_CONDITION_PRESS, MATERIAL, WEIGHT, POWER, INSULATION, PNID_NO, REV from EQUIPMENT_DATA_LIST'

            if docName is not None:

                sql += " where PNID_NO = '{}'".format(docName)

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows:

                data = []

                for index in range(len(cursor.description)): 

                    data.append(row[index])

                result.append(data)

        # 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()

        return result

    '''

        @brief      get instrument data list

        @author     kyouho

        @date       2018.08.14

    '''

    def getInstrumentDataList(self, docName = None):

        result = []

        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 = 'select UID, ITEM_NO, SERVICE, FLOW_RATE, PRESSURE, TEMPERATURE, TPYE, RANGE, NOR_LEVEL_MM, NOR_LEVEL_PERCENT, DEL_PRESS, SHUT_OFF, LOCATION, PNID_NO, REV from INSTRUMENT_DATA_LIST'

            if docName is not None:

                sql += " where PNID_NO = '{}'".format(docName)

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows:

                data = []

                for index in range(len(cursor.description)): 

                    data.append(row[index])

                result.append(data)

        # 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()

        return result

        # 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      set instrumnet data list

        @author     kyoyho

        @date       2018.08.14

    '''

    def setInstrumentDataList(self, dataList):

        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()

            for data in dataList:

                sql = "insert or replace into INSTRUMENT_DATA_LIST(UID, ITEM_NO, SERVICE, FLOW_RATE, PRESSURE, TEMPERATURE, TPYE, RANGE, NOR_LEVEL_MM, NOR_LEVEL_PERCENT, DEL_PRESS, SHUT_OFF, LOCATION, PNID_NO, REV) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

                param = tuple(data)

                cursor.execute(sql, param)

            conn.commit()

        self.sceneInstData = {}

        self.instColumnList = ['UID', 'ITEM_NO', 'SERVICE', 'FLOW_RATE', 'PRESSURE', 'TEMPERATURE', 'TPYE', 'RANGE', 'NOR_LEVEL_MM', 'NOR_LEVEL_PERCENT', 'DEL_PRESS', 'SHUT_OFF', 'LOCATION', 'PNID_NO', 'REV']

        instTable.setHorizontalHeaderLabels(['UID', 'ITEM_NO', 'SERVICE', 'FLOW_RATE', 'PRESSURE', 'TEMPERATURE', 'TPYE', 'RANGE', 'NOR_LEVEL_MM', 'NOR_LEVEL_PERCENT', 'DEL_PRESS', 'SHUT_OFF', 'LOCATION', 'PNID_NO', 'REV'])

        self.settingInstrumentData()

    '''

        @brief      setting equip data

        @author     kyouho

        @date       2018.08.14

    '''

    def settingInstrumentData(self):

        instTable = self.ui.tableWidgetInstrumentDataList

        docData = AppDocData.instance()

        # 기존 저장된 데이터 불러옴

        index = self.ui.comboBoxDoc.currentIndex()

        text = self.ui.comboBoxDoc.itemText(index)

        if self.ui.comboBoxDoc.currentIndex() == 0:

            text = None

        dataList = docData.getInstrumentDataList(text)

        instTable.setRowCount(len(dataList))

        row = 0

        for data in dataList:

            for dataIndex in range(len(data)):

                instTable.setItem(row, dataIndex, QTableWidgetItem(data[dataIndex] if data[dataIndex] is not None else ''))

            row += 1

        # 현재 문서명이 같으면 중복 체크 (Equipment 경우 uid로)

        if docData.imgName is not None and (docData.imgName == text or self.ui.comboBoxDoc.currentIndex() == 0):

            rowCount = instTable.rowCount()

            uidList = []

            for row in range(rowCount):

                uidList.append(instTable.item(row, 0).text())

            for uid in self.sceneInstData.keys():

                # 중복 (어떻게 할지)

                if uidList.count(uid) >= 1:

                    continue

                # 신규

                else:

                    rowCount += 1

                    instTable.setRowCount(rowCount)

                    equipData = self.sceneInstData[uid]

                    for index in range(len(equipData)):

                        widgetItem = QTableWidgetItem(equipData[index] if equipData[index] is not None else '')

                        if widgetItem.text() != '':

                            widgetItem.setBackground(QColor(int(134), int(229), int(127)))

                        instTable.setItem(rowCount - 1, index, widgetItem)

        from QEngineeringInstrumentItem import QEngineeringInstrumentItem

        items = [item for item in self.parent.graphicsView.scene.items() if type(item) is QEngineeringInstrumentItem]

        for item in items:

            self.sceneInstData[item.uid] = item.getInstrumentDataList()

    ''' self.equipmentDataList

        self.saveInstrumentDataList()

        docData.deleteInstDataList(self.removeUID[2])

    '''

        @brief      save Equip Data

        @author     kyouho

        @date       2018.08.13

    '''

    def saveInstrumentDataList(self):

        instTable = self.ui.tableWidgetInstrumentDataList

        docData = AppDocData.instance()

        dataLists = []

        for rowIndex in range(instTable.rowCount()):

            dataList = []

            for columnIndex in range(instTable.columnCount()):

                widgetItem = instTable.item(rowIndex, columnIndex)

                if widgetItem is not None:

                    dataList.append(widgetItem.text())

                else:

                    dataList.append('')

            dataLists.append(dataList)

        docData.setInstrumentDataList(dataLists)

        self.tableWidgetInstrumentDataList.setColumnCount(15)

        self.tabWidget.setCurrentIndex(2)

instColumnList = ['UID', 'ITEM_NO', 'SERVICE', 'FLOW_RATE', 'PRESSURE', 'TEMPERATURE', 'TPYE', 'RANGE', 'NOR_LEVEL_MM', 'NOR_LEVEL_PERCENT', 'DEL_PRESS', 'SHUT_OFF', 'LOCATION', 'PNID_NO', 'REV']

    '''

        @brief      return equip Data List

        @author     kyouho

        @date       2018.08.14

    '''

    def getInstrumentDataList(self):

        dataList = []

        try:

            from AppDocData import AppDocData

            global instColumnList

            docData = AppDocData.instance()

            attrs = self.attrs

            for index in range(len(instColumnList)):

                dataList.append('')

            dataList[0] = self.uid

            dataList[13] = docData.imgName

            for attr in attrs:

                pass

        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))

        return dataList

      <number>2</number>

          <number>15</number>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>