| | |
| | | foreign_key: '', |
| | | sql: _dataresource, |
| | | script: _customScript, |
| | | transaction: setting.transaction === 'true' |
| | | } |
| | | } |
| | | |
| | |
| | | |
| | | if (!params || params.length === 0) return '' |
| | | let LText_field = [] |
| | | let transaction = false |
| | | |
| | | let userName = sessionStorage.getItem('User_Name') || '' |
| | | let fullName = sessionStorage.getItem('Full_Name') || '' |
| | |
| | | ${_script} |
| | | ` |
| | | } |
| | | if (item.transaction) { |
| | | transaction = true |
| | | } |
| | | |
| | | item.columns.forEach(cell => { |
| | | LText_field.push(`Select '${item.name}' as tablename,'${cell.field}' as fieldname,'${cell.datatype}' as field_type`) |
| | |
| | | LText: LText.join(' union all '), |
| | | LText_field: LText_field.join(' union all '), |
| | | BID: BID || '' |
| | | } |
| | | |
| | | if (transaction) { |
| | | param.func = 'sPC_Get_structured_data_try' |
| | | } |
| | | |
| | | param.LText = Utils.formatOptions(param.LText) |