}
ob=Double.valueOf(obstr); xb=Double.valueOf(xbstr); jb=Double.valueOf(jbstr);
/***
* 校验查询条件是否为空(目前所有条件必输项) *
* @author WYR * @since 2017-09-26 * @throws Exception */
private void checkQueryParametersIsNotNull()throws Exception{
if(null==beg_date||\.equals(beg_date)){
ExceptionUtils.wrappBusinessException(\开始日期不能为空，请检
查!\);
}
if(null==end_date||\.equals(end_date)){
ExceptionUtils.wrappBusinessException(\结束日期不能为空，请检
查!\);
}
if(usd<=0){
ExceptionUtils.wrappBusinessException(\美元汇率必须大于0，请检
查!\);
}
if(hkd<=0){
ExceptionUtils.wrappBusinessException(\港币汇率必须大于0，请检
查!\);
}
if(mb<=0){
ExceptionUtils.wrappBusinessException(\马币汇率必须大于0，请检
查!\);
}
if(ob<=0){
ExceptionUtils.wrappBusinessException(\澳元汇率必须大于0，请检
查!\);
}
if(xb<=0){
ExceptionUtils.wrappBusinessException(\新币汇率必须大于0，请检
查!\);
}
if(jb<=0){
ExceptionUtils.wrappBusinessException(\加币汇率必须大于0，请检
查!\);
}
}
/**
* 最外层查询SQL字段部分
* @author WYR * @since 2017-09-26
*/
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
List
tempVOList=(List
getDao().executeQuery(sql, new
BeanListProcessor(GpCflowprofileNewTempVO.class));
if(null!=tempVOList&&tempVOList.size()>0){
for (GpCflowprofileNewTempVO tempVO : tempVOList) {
List
}
}
}
if(null!=data&&data.size()>0){ }
return data;
return null;
/**获取所有子查询UNION ALL 查询SQL(9个子查询视图的SQL UNION ALL) *
* @author WYR * @since 2017-09-25 * @return */
private String getubqueryAllSql(){
String samePartSql=\
pk_group,inoutname,cuname,nvl(recmoney, 0) - nvl(paymoney, 0) as\ +
\ where \;
String sameWherePartSql=\+beg_date+\tallydate<= '\+end_date+\;
String unionStr=\;
StringBuilder bfSql= new StringBuilder();