if(!beginTime.equals("")&&!endTime.equals("")) {
                  hql="select sum(d.money)  from Income d where d.company.id="+companyId+" and d.incomeTime>='"+beginTime+"' and d.incomeTime<='"+endTime+"' and d.isDeleted=0";
                  }
                  else if(!beginTime.equals("")) {
                      hql="select sum(d.money)  from Income d where d.company.id="+companyId+" and d.incomeTime>='"+beginTime+"' and d.isDeleted=0";
                  } 
                  else if(!endTime.equals(""))  {
                      hql="select sum(d.money)  from Income d where d.company.id="+companyId+" and d.incomeTime<='"+endTime+"' and d.isDeleted=0";
                  }
                  else {
                      hql="select sum(d.money)  from Income d where d.company.id="+companyId+" and d.isDeleted=0";
                  }

StringBuilder buff = new StringBuilder("select sum(d.money) from Income d where d.isDeleted=0 and d.company.id=");
buff.append(companyId);
if (beginTime != null && beginTime.length() != 0) {
    buff.append(" and d.incomeTime >= '").append(beginTime).append("'");
}
if (endTime != null && endTime.length() != 0) {
    buff.append(" and d.incomeTime <= '").append(endTime).append("'");
}
hql = buff.toString();