samePartSql.append(\人民币' then money else 0
end as Rmb,\);
samePartSql.append(\港币' then money else 0 end
as hkd,\);
samePartSql.append(\澳元' then money else 0 end
as ob,\);
samePartSql.append(\加币' then money else 0 end
as jb,\);
samePartSql.append(\新加坡元' then money else 0
end as xb \);
samePartSql.append(\);
samePartSql.append(\+getQueryTempTableDataSql(cashflow)+\
group by pk_group,inoutname\);
}
return samePartSql.toString();
/***
* 初始化查询参数(获取查询条件值) *
* @param context * @author WYR * @since 2017-09-26
* @throws Exception */
private void getQueryParameters(IContext context)throws Exception{
HashMap
context.getAttribute(FreeReportContextKey.KEY_REPORT_QUERYCONDITIONVOS);
if(null!=conditionvos&&conditionvos.length>0){
hashmap=new HashMap
hashmap.put(conditionvo.getFieldCode(),
conditionvo.getValue());
}
checkQueryParametersAndSetValue(hashmap);
}else{
ExceptionUtils.wrappBusinessException(\查询条件不能为空，请检
查!\);
}
/***校验查询条件与赋值 *
}
* @author WYR * @since 2017-09-26 *
* @param hashmap * @throws Exception */
private void checkQueryParametersAndSetValue(HashMap
hashmap)throws Exception{
beg_date=null; end_date=null; usd=0.00;
hkd=0.00;
mb=0.00; ob=0.00; xb=0.00; jb=0.00;
if(null==hashmap||hashmap.size()==0){
ExceptionUtils.wrappBusinessException(\查询条件不能为空，请检
查!\);
}
String begdate=hashmap.get(\); String enddate=hashmap.get(\);
String usdstr=hashmap.get(\); String hkdstr=hashmap.get(\); String mbstr=hashmap.get(\); String obstr=hashmap.get(\); String xbstr=hashmap.get(\); String jbstr=hashmap.get(\);
if(null==begdate||begdate.length()==0){
ExceptionUtils.wrappBusinessException(\开始日期不能为空，请检
查!\);
}
if(null==enddate||enddate.length()==0){
ExceptionUtils.wrappBusinessException(\结束日期不能为空，请检
查!\);
}
if(!NumberUtils.isNumber(usdstr)){
ExceptionUtils.wrappBusinessException(\美元汇率只能输入正整数或
正小数，请检查!\);
}
if(!NumberUtils.isNumber(hkdstr)){
ExceptionUtils.wrappBusinessException(\港币汇率只能输入正整数或
正小数，请检查!\);
}
if(!NumberUtils.isNumber(mbstr)){
ExceptionUtils.wrappBusinessException(\马币汇率只能输入正整数或
正小数，请检查!\);
}
if(!NumberUtils.isNumber(obstr)){
ExceptionUtils.wrappBusinessException(\澳元汇率只能输入正整数或
正小数，请检查!\);
}
if(!NumberUtils.isNumber(xbstr)){
ExceptionUtils.wrappBusinessException(\新币汇率只能输入正整数或
正小数，请检查!\);
}
if(!NumberUtils.isNumber(jbstr)){
ExceptionUtils.wrappBusinessException(\加币汇率只能输入正整数或
正小数，请检查!\);
}
//由于试图里面日期字段是2017-09-27 与2017-09-27 09:06:37 这两种 beg_date=begdate.substring(0, 10);
end_date=enddate.substring(0, 10)+\; usd=Double.valueOf(usdstr);
hkd=Double.valueOf(hkdstr);
mb=Double.valueOf(mbstr);