| | |
|---|
| | | defSql = this.getSysDefaultSql(cell, item, process, group, true) |
|---|
| | | } |
|---|
| | | |
|---|
| | | let backSql = this.getSysBackSql(cell.verify.cbScripts) |
|---|
| | | let backSql = this.getSysBackSql(cell.verify.cbScripts, cell.cbTable) |
|---|
| | | |
|---|
| | | if (backSql) { |
|---|
| | | backSql = `${defSql} |
|---|
| | |
|---|
| | | return sql |
|---|
| | | } |
|---|
| | | |
|---|
| | | getSysBackSql = (scripts) => { |
|---|
| | | getSysBackSql = (scripts, cbTable) => { |
|---|
| | | let _prev = '' |
|---|
| | | let _back = '' |
|---|
| | | |
|---|
| | |
|---|
| | | |
|---|
| | | if (!tbName) return |
|---|
| | | |
|---|
| | | tbName = tbName.replace(/@|#/, '') |
|---|
| | | |
|---|
| | | let content = tb.replace(/(@|#)[a-zA-Z0-9_]+\s+table\s+\(\s*/, '').replace(/\s*\)$/, '') |
|---|
| | | content = content.replace(/decimal\(\s*\d+\s*,\s*\d+\s*\)/ig, 'decimal') |
|---|
| | | |
|---|
| | | let keys = [] |
|---|
| | | let vals = [] |
|---|
| | | let error = false |
|---|
| | | let istop = new RegExp(cbTable + '$', 'ig').test(tbName) |
|---|
| | | let id = tbName.replace(/@|#/, '') |
|---|
| | | |
|---|
| | | content.split(/\s*,\s*/).forEach(m => { |
|---|
| | | let ms = m.split(/\s+/) |
|---|
| | | if (ms.length > 1) { |
|---|
| | | keys.push(ms[0]) |
|---|
| | | if (/nvarchar/i.test(ms[1])) { |
|---|
| | | if (/^mk_level$/i.test(ms[0])) { |
|---|
| | | vals.push(istop ? `'1'` : `'2'`) |
|---|
| | | } else if (/^mk_id$/i.test(ms[0])) { |
|---|
| | | vals.push(istop ? `'${cbTable}'` : `'${id}'`) |
|---|
| | | } else if (/^mk_bid$/i.test(ms[0])) { |
|---|
| | | vals.push(istop ? `''` : `'${cbTable}'`) |
|---|
| | | } else if (/nvarchar/i.test(ms[1])) { |
|---|
| | | vals.push(`'mk'`) |
|---|
| | | } else if (/date/i.test(ms[1])) { |
|---|
| | | vals.push(`'1949-10-01'`) |
|---|
