NC6X报表数据加工做语义模型（返回SQL篇）(10)

来源：网络收集时间：2026-04-06

导读： */ private void buildSelectSql() { this.builderSQL=new StringBuilder(); String totalFiled=\+hkd+\+usd+\ \+mb+\+xb+\+jb+\+ob+\ ; this.builderSQL.append(\); this.builderSQL.append(\ hkd ,usd/10000 as u

private void buildSelectSql() {

this.builderSQL=new StringBuilder();

String totalFiled=\+hkd+\+usd+\

\+mb+\+xb+\+jb+\+ob+\ ;

this.builderSQL.append(\);

this.builderSQL.append(\

hkd ,usd/10000 as usd,\);

this.builderSQL.append(\

jb,ob/10000 as ob,\+totalFiled);

} /***

* 查询所有子查询总结果集(9个子查询视图的结果集) * @author WYR

* @since 2017-09-25 * @return

* @throws DAOException */

@SuppressWarnings(\)

private List> getTempTableData() throws DAOException{

List> data = new ArrayList>(); List tempVOList=null; String sql=getubqueryAllSql();

tempVOList=(List)

getDao().executeQuery(sql, new

BeanListProcessor(GpCflowprofileNewTempVO.class));

if(null!=tempVOList&&tempVOList.size()>0){

for (GpCflowprofileNewTempVO tempVO : tempVOList) {

List