| | |
| | | primaryKey: setting.primaryKey || '', |
| | | foreign_key: '', |
| | | sql: _dataresource, |
| | | script: _customScript |
| | | script: _customScript, |
| | | transaction: setting.transaction === 'true' |
| | | } |
| | | } |
| | | |
| | |
| | | |
| | | if (!params || params.length === 0) return '' |
| | | let LText_field = [] |
| | | let transaction = false |
| | | let LText = params.map((item, index) => { |
| | | let _sql = item.sql |
| | | let _script = item.script |
| | |
| | | _script = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000) select @ErrorCode='',@retmsg ='' |
| | | ${_script} |
| | | ` |
| | | } |
| | | if (item.transaction) { |
| | | transaction = true |
| | | } |
| | | |
| | | item.columns.forEach(cell => { |
| | |
| | | BID: BID || '' |
| | | } |
| | | |
| | | if (transaction) { |
| | | param.func = 'sPC_Get_structured_data_try' |
| | | } |
| | | |
| | | param.LText = Utils.formatOptions(param.LText) |
| | | param.LText_field = Utils.formatOptions(param.LText_field) |
| | | param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') |