Webwork项目POI导出数据到Excel[借鉴].pdf
文本预览下载声明
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(),
显示全部