From afb39f8ab004b2607bb718edab02e99c7a010114 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期三, 22 三月 2023 14:36:44 +0800 Subject: [PATCH] 2023-03-22 --- src/views/design/header/index.jsx | 84 +++++++++++++---------------------------- 1 files changed, 27 insertions(+), 57 deletions(-) diff --git a/src/views/design/header/index.jsx b/src/views/design/header/index.jsx index 8c60992..2155478 100644 --- a/src/views/design/header/index.jsx +++ b/src/views/design/header/index.jsx @@ -259,74 +259,44 @@ let shim = +sessionStorage.getItem('sys_time_shim') let timestamp = moment().add(shim, 'seconds').format('YYYY-MM-DD HH:mm:ss') - // if (window.GLOB.WebSql) { - // window.GLOB.WebSql.transaction(tx => { - // tx.executeSql('DELETE FROM FUNCS') + let objectStore = window.GLOB.IndexDB.transaction(['funcs'], 'readwrite').objectStore('funcs') - // funcs.forEach(item => { - // if (!item.key_sql) return - // tx.executeSql('INSERT INTO FUNCS (func_code, key_sql) VALUES (?, ?)', [item.func_code, item.key_sql]) - // }) - // tx.executeSql(`UPDATE VERSIONS SET createDate='${timestamp}' where CDefine1='funcs'`) - // }) - // } else { - let objectStore = window.GLOB.IndexDB.transaction(['funcs'], 'readwrite').objectStore('funcs') + objectStore.clear() - objectStore.clear() + funcs.forEach(item => { + if (!item.key_sql) return + item.id = item.func_code + objectStore.add(item) + }) - funcs.forEach(item => { - if (!item.key_sql) return - item.id = item.func_code - objectStore.add(item) - }) - - let funcStore = window.GLOB.IndexDB.transaction(['version'], 'readwrite').objectStore('version') - funcStore.put({id: 'funcs', version: '1.0', createDate: timestamp}) - // } + let funcStore = window.GLOB.IndexDB.transaction(['version'], 'readwrite').objectStore('version') + funcStore.put({id: 'funcs', version: '1.0', createDate: timestamp}) } getfuncTime = () => { return new Promise((resolve, reject) => { - // if (window.GLOB.WebSql) { - // window.GLOB.WebSql.transaction(tx => { - // tx.executeSql("SELECT * FROM VERSIONS where CDefine1='funcs'", [], (tx, results) => { - // let rows = results.rows - // if (rows.length === 0) { - // tx.executeSql('DELETE FROM FUNCS') - // tx.executeSql('INSERT INTO VERSIONS (version, createDate, CDefine1) VALUES (?, ?, ?)', ['1.0', '1970-01-01 14:59:09.000', 'funcs']) - // resolve({createDate: '1970-01-01 14:59:09.000'}) - // } else { - // resolve(rows[0]) - // } - // }, (tx, results) => { - // reject() - // console.warn(results) - // }) - // }) - // } else { - let objectStore = window.GLOB.IndexDB.transaction(['version'], 'readwrite').objectStore('version') - let request = objectStore.get('funcs') + let objectStore = window.GLOB.IndexDB.transaction(['version'], 'readwrite').objectStore('version') + let request = objectStore.get('funcs') - request.onerror = (event) => { - console.warn(event) - reject() - } + request.onerror = (event) => { + console.warn(event) + reject() + } - request.onsuccess = () => { - if (request.result) { - resolve(request.result) - } else { - let add = objectStore.add({id: 'funcs', version: '1.0', createDate: '1970-01-01 14:59:09.000'}) - - add.onerror = () => { - reject() - } - add.onsuccess = () => { - resolve({id: 'funcs', version: '1.0', createDate: '1970-01-01 14:59:09.000'}) - } + request.onsuccess = () => { + if (request.result) { + resolve(request.result) + } else { + let add = objectStore.add({id: 'funcs', version: '1.0', createDate: '1970-01-01 14:59:09.000'}) + + add.onerror = () => { + reject() + } + add.onsuccess = () => { + resolve({id: 'funcs', version: '1.0', createDate: '1970-01-01 14:59:09.000'}) } } - // } + } }) } -- Gitblit v1.8.0