From 89fb1308d92e10a27cf8f91f4dd766eb38976e12 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期四, 26 十一月 2020 21:56:42 +0800
Subject: [PATCH] 2020-11-26
---
src/views/mobdesign/index.jsx | 71 -----------------------------------
1 files changed, 0 insertions(+), 71 deletions(-)
diff --git a/src/views/mobdesign/index.jsx b/src/views/mobdesign/index.jsx
index ce401ef..92dbcf0 100644
--- a/src/views/mobdesign/index.jsx
+++ b/src/views/mobdesign/index.jsx
@@ -192,77 +192,6 @@
})
}
- testFunc = () => {
- let datas = [{
- name: 'a',
- arr_field: 'MapCode,Country',
- par_tablename: '',
- type: '',
- primaryKey: 'MapCode',
- foreign_key: '',
- sql: `select MapCode,Country from @tc1`,
- script: `declare @tc1 table (MapCode nvarchar(50),Country nvarchar(50)) insert into @tc1 (MapCode,Country) select MapCode,Country from sMap where Province=''`
- }, {
- name: 'b',
- arr_field: 'MapCode,Province,ParMapCode',
- par_tablename: 'a',
- type: 'array',
- primaryKey: 'MapCode',
- foreign_key: 'ParMapCode',
- sql: `select MapCode,Province,ParMapCode from @tc2`,
- script: `declare @tc2 table (MapCode nvarchar(50),Province nvarchar(50),ParMapCode nvarchar(50)) insert into @tc2 (MapCode,Province,ParMapCode) select MapCode,Province,ParMapCode from sMap where Province!='' and City=''`
- }, {
- name: 'c',
- arr_field: 'MapCode,City,ParMapCode',
- par_tablename: 'b',
- type: 'array',
- primaryKey: 'MapCode',
- foreign_key: 'ParMapCode',
- sql: `select MapCode,City,ParMapCode from @tc3`,
- script: `declare @tc3 table (MapCode nvarchar(50),City nvarchar(50),ParMapCode nvarchar(50)) insert into @tc3 (MapCode,City,ParMapCode) select MapCode,City,ParMapCode from sMap where City!='' and Area=''`
- }, {
- name: 'd',
- arr_field: 'MapCode,Area,ParMapCode',
- par_tablename: 'c',
- type: 'array',
- primaryKey: 'MapCode',
- foreign_key: 'ParMapCode',
- sql: `select MapCode,Area,ParMapCode from sMap where Area!=''`,
- script: ``
- }]
-
- let LText = datas.map((item, index) => {
- // item.par_tablename = ''
- // item.foreign_key = ''
-
- let _orderBy = 'MapCode desc'
- let _search = ''
- let _sql = `select top 1000 ${item.arr_field} from (select ${item.arr_field} ,ROW_NUMBER() over(order by ${_orderBy}) as rows from (${item.sql}) tb ${_search}) tmptable order by tmptable.rows `
-
- return `Select '${item.name}' as tablename,'${window.btoa(window.encodeURIComponent(_sql))}' as LText,'${window.btoa(window.encodeURIComponent(item.script))}' as Lcustomize,'${item.type}' as table_type,'${item.primaryKey}' as primary_key,'${item.par_tablename}' as par_tablename,'${item.foreign_key}' as foreign_key,'${index}' as Sort`
- })
-
- let LText_field = []
- datas.forEach(item => {
- item.arr_field.split(',').forEach(cell => {
- LText_field.push(`Select '${item.name}' as tablename,'${cell}' as fieldname,'nvarchar(50)' as field_type`)
- })
- })
-
- let param = {
- func: 'sPC_Get_structured_data',
- LText: LText.join(' union all '),
- LText_field: LText_field.join(' union all ')
- }
-
- param.LText = Utils.formatOptions(param.LText)
- param.LText_field = Utils.formatOptions(param.LText_field)
- param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
- param.secretkey = Utils.encrypt(param.LText, param.timestamp)
-
- Api.getLocalConfig(param)
- }
-
// save = () => {
// html2canvas(document.getElementById('view')).then(canvas => {
// let imgUri = canvas.toDataURL('image/png').replace('image/png', 'image/octet-stream'); // 鑾峰彇鐢熸垚鐨勫浘鐗囩殑url
--
Gitblit v1.8.0