| | |
|---|
| | | let DateCount = '' |
|---|
| | | if (_dataresource) { |
|---|
| | | /*system_query*/ |
|---|
| | | if (/@pageSize@|@orderBy@|@mk_total/i.test(testSql)) { |
|---|
| | | if (/@pageSize@|@orderBy@|@mk_total/i.test(testSql) || (item.wrap && item.wrap.tree === 'true')) { |
|---|
| | | LText = `select ${arr_field} from ${_dataresource} ${_search} ` |
|---|
| | | } else if (item.setting.laypage === 'true' && item.setting.order) { |
|---|
| | | LText = `select top @pageSize@ ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by @orderBy@) as rows from ${_dataresource} ${_search}) tmptable where rows > @pageSize@ * (@pageIndex@ - 1) order by tmptable.rows ` |
|---|
