文档详情

Webwork项目POI导出数据到Excel[借鉴].pdf

发布:2021-10-19约1.17万字共6页下载文档
文本预览下载声明
1.action 中获得 list 放入 dataList ,并传参 private List dataList = new ArrayList(); 并生成 get 、set 方法 ... ... public String downLoadFile() { try { curYear = Calendar .getInstance().get(Calendar .YEAR); if(year == 0) year = curYear; int curMonth = Calendar .getInstance().get(Calendar .MONTH)+1; if(quarter == 0) quarter = DateCommonUtil.getCurrentMonthQuarter(curMonth); ProjectInfoService projectService = (ProjectInfoService) SpringContext.getInstance().getBean(projectService); FilterList projFilterList = new FilterList(); if(!StringUtil.isNullOrBlank(deptId)) projFilterList.add(ProjectInfo.class.getName(), FilterListHelper .EQUAL, implementResponsibledepid, deptId); if(!StringUtil.isNullOrBlank(projCode)) projFilterList.add(ProjectInfo.class.getName(), FilterListHelper .LIKE, projectserialnum, projCode); if(!StringUtil.isNullOrBlank(projName)) projFilterList.add(ProjectInfo.class.getName(), FilterListHelper .LIKE, projectname, projName); if(!StringUtil.isNullOrBlank(projManager)) projFilterList.add(ProjectInfo.class.getName(), FilterListHelper .LIKE, projectmanagername, projManager); List projectIdList = projectService.queryProjectIdListByRoles(projFilterList,string); FilterList filterList = new FilterList(); filterList.setResultRange(super .getPos(), super .getRowsPerPage()); filterList.add(ExpenseScores.class.getName(), FilterListHelper .EQUAL, year, year); filterList.add(ExpenseScores.class.getName(), FilterListHelper .EQUAL, quarter, quarter); filterList.add(ExpenseScores.class.getName(),
显示全部
相似文档