| | |
|---|
| | | |
|---|
| | | let _value = '' |
|---|
| | | if (value === 'default') { |
|---|
| | | let fields = usefulfields.filter(item => item.import !== 'false') |
|---|
| | | fields = fields.map(col => col.Column).join(',') |
|---|
| | | let fields = [] |
|---|
| | | let decls = [] |
|---|
| | | usefulfields.forEach(col => { |
|---|
| | | if (col.import === 'false') return |
|---|
| | | |
|---|
| | | if (col.type === 'date') { |
|---|
| | | decls.push(`${col.Column} Nvarchar(50)`) |
|---|
| | | } else { |
|---|
| | | decls.push(`${col.Column} ${col.type}`) |
|---|
| | | } |
|---|
| | | fields.push(col.Column) |
|---|
| | | }) |
|---|
| | | |
|---|
| | | decls = decls.join(',') |
|---|
| | | fields = fields.join(',') |
|---|
| | | |
|---|
| | | if (fields) { |
|---|
| | | fields = fields + ',' |
|---|
| | | decls = decls + ',' |
|---|
| | | } |
|---|
| | | |
|---|
| | | let database = btn.sheet.match(/(.*)\.(.*)\.|@db@/ig) || '' |
|---|
| | |
|---|
| | | |
|---|
| | | database = database ? (database[0] || '') : '' |
|---|
| | | |
|---|
| | | _value = `Insert into ${database}${sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid@,@username,@fullname,@BID@ From #${sheet}` |
|---|
| | | _value = `/* create table #${sheet} (${decls}jskey nvarchar(50),BID nvarchar(50) ) */\nInsert into ${database}${sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid@,@username,@fullname,@BID@ From #${sheet}` |
|---|
| | | } else if (value === 'flowSql') { |
|---|
| | | let sheet = btn.sheet.replace(/(.*)\.(.*)\.|@db@/ig, '') |
|---|
| | | |
|---|
