From 1a14ff6035932eadfb6ef7970e3adb24b4e158a6 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期三, 18 十二月 2019 18:56:17 +0800 Subject: [PATCH] 2019-12-18 --- src/tabviews/commontable/index.jsx | 38 +++++++++++++++++++++++++++++++++++--- 1 files changed, 35 insertions(+), 3 deletions(-) diff --git a/src/tabviews/commontable/index.jsx b/src/tabviews/commontable/index.jsx index eb03ae3..0325d43 100644 --- a/src/tabviews/commontable/index.jsx +++ b/src/tabviews/commontable/index.jsx @@ -248,7 +248,7 @@ let LText = `select top ${pageSize} ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${orderBy}) as rows from ${setting.dataresource} ${_search}) tmptable where rows > ${pageSize * (pageIndex - 1)} order by tmptable.rows` let DateCount = `select count(1) as total from ${setting.dataresource} ${_search}` - console.log(LText) + param.LText = Utils.formatOptions(LText) param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') + '.000' param.secretkey = Utils.encrypt(param.LText, param.timestamp) @@ -368,7 +368,33 @@ this.reloadtable() } else if (btn.execError === 'view' && type === 'error') { this.reloadview() + } else if (type === 'excelOut') { + this.handleExcelout() } + } + + handleExcelout = () => { + const { arr_field, orderColumn, orderType, search, setting } = this.state + + let _search = Utils.joinMainSearchkey(search) + _search = _search ? 'where (' + _search + ')' : '' + // 鑾峰彇鍒楄〃鏁版嵁 + let param = { + func: setting.innerFunc || 'sPC_Get_TableData', + obj_name: 'data', + arr_field: arr_field + } + + let orderBy = orderColumn ? (orderColumn + ' ' + orderType) : setting.order + + let LText = `select ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${orderBy}) as rows from ${setting.dataresource} ${_search}) tmptable order by tmptable.rows` + + param.LText = Utils.formatOptions(LText) + param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') + '.000' + param.secretkey = Utils.encrypt(param.LText, param.timestamp) + param.DateCount = '' + + Api.genericInterface(param) } gettableselected = () => { @@ -378,6 +404,10 @@ data.push(this.refs.mainTable.props.data[item]) }) return data + } + + buttonTrigger = (btn, record) => { + this.refs.mainButton.actionTrigger(btn, record) } UNSAFE_componentWillMount () { @@ -404,6 +434,7 @@ } {actions && <MainAction + ref="mainButton" MenuID={this.props.MenuID} setting={setting} refreshdata={this.refreshbyaction} @@ -415,14 +446,15 @@ {columns && <MainTable ref="mainTable" + dict={this.state.dict} MenuID={this.props.MenuID} setting={setting} - refreshdata={this.refreshbytable} columns={columns} data={this.state.data} total={this.state.total} loading={this.state.loading} - dict={this.state.dict} + refreshdata={this.refreshbytable} + buttonTrigger={this.buttonTrigger} /> } <BackTop> -- Gitblit v1.8.0