| | |
|---|
| | | let arr_field = setting.all_field || setting.arr_field |
|---|
| | | |
|---|
| | | if (_dataresource) { |
|---|
| | | if (setting.laypage && orderBy) { |
|---|
| | | if (setting.custompage) { |
|---|
| | | LText = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search} ` |
|---|
| | | if (setting.custompage) { |
|---|
| | | LText = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search} ` |
|---|
| | | } else if (setting.laypage && orderBy) { |
|---|
| | | LText = `/*system_query*/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 ` |
|---|
| | | if (setting.sub_field) { |
|---|
| | | DateCount = `/*system_query*/select count(1) as total from (select distinct ${setting.primaryKey} from ${_dataresource} ${_search})a` |
|---|
| | | } else { |
|---|
| | | LText = `/*system_query*/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 ` |
|---|
| | | if (setting.sub_field) { |
|---|
| | | DateCount = `/*system_query*/select count(1) as total from (select distinct ${setting.primaryKey} from ${_dataresource} ${_search})a` |
|---|
| | | } else { |
|---|
| | | DateCount = `/*system_query*/select count(1) as total from ${_dataresource} ${_search}` |
|---|
| | | } |
|---|
| | | DateCount = `/*system_query*/select count(1) as total from ${_dataresource} ${_search}` |
|---|
| | | } |
|---|
| | | } else if (orderBy) { |
|---|
| | | LText = `/*system_query*/select ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${orderBy}) as rows from ${_dataresource} ${_search}) tmptable order by tmptable.rows ` |
|---|
