/**
* 对账日志列表
*
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
* @throws Exception
*/
public ActionForward list(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
CheckAccountErrorLogForm checkAcountErrorLogForm = (CheckAccountErrorLogForm) form;
CheckAccountErrorLogBean checkAccountErrorLogBean = new CheckAccountErrorLogBean();
PageAttribute page =
new PageAttribute(checkAcountErrorLogForm.getCurPage(), Constant.PAGE_SIZE);
String[] totalFee =
checkAccountErrorLogBean.checkAccountErrorLogCount(
"wht_accountErrorLog", checkAcountErrorLogForm);
page.setRsCount(Integer.parseInt(totalFee[0]));
SysUserInterface sit = new SysUserInterface();
List list =
checkAccountErrorLogBean.listCheckAccountErrorLog(
"wht_accountErrorLog", checkAcountErrorLogForm, page);
request.setAttribute("totalFee", totalFee);
request.setAttribute("itypeSel", getStingSel(sit.listInterfaceType(), "接口商"));
request.setAttribute("checkAccountErrorLog", checkAcountErrorLogForm);
request.setAttribute("page", page);
request.setAttribute("checkAccountErrorLogList", list);
return new ActionForward("/task/checkAccountErrorLogList.jsp");
}
/**
* 导出对账日志明细
*
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward excelExport(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
CheckAccountErrorLogForm checkAcountErrorLogForm = (CheckAccountErrorLogForm) form;
CheckAccountErrorLogBean checkAccountErrorLogBean = new CheckAccountErrorLogBean();
PageAttribute page =
new PageAttribute(checkAcountErrorLogForm.getCurPage(), Constant.PAGE_SIZE);
String[] totalFee =
checkAccountErrorLogBean.checkAccountErrorLogCount(
"wht_accountErrorLog", checkAcountErrorLogForm);
page.setRsCount(Integer.parseInt(totalFee[0]));
List list =
checkAccountErrorLogBean.listCheckAccountErrorLog_EXCEL(
"wht_accountErrorLog", checkAcountErrorLogForm, page);
// 导出excel
String[][] colTitles = new String[][] {{"编号", "接口商", "账目日期", "任务执行日期", "对账结果"}};
int size = colTitles[0].length;
List body = new ArrayList();
// 只取其中某些字段
int count = 0;
int sum1 = 0;
for (Object tmp : list) {
String[] temp = (String[]) tmp;
String[] recode = new String[size];
// 取其中某些字段
int i = 0;
recode[i++] = ++count + "";
recode[i++] = temp[0];
recode[i++] = temp[1];
recode[i++] = temp[2];
recode[i++] = temp[3];
body.add(recode);
}
Map rsMap = null;
// 转换成excel格式数据
if (body.size() > 0) {
rsMap = DataUtil.toNestedStringsListMap(1, body);
}
Excel excel = new Excel();
excel.setCols(colTitles[0].length);
excel.createCaption("对账日志明细报表");
excel.createColCaption(colTitles);
if (rsMap != null) {
excel.createBody(rsMap);
}
// excel.createRemarks("交易明细");
String excelFileName = URLEncoder.encode("对账日志明细报表" + ".xls", "UTF-8");
response.addHeader("Content-Disposition", "attachment; filename=" + excelFileName);
OutputStream out = null;
try {
out = response.getOutputStream();
excel.createFile(out);
} finally {
if (out != null) {
try {
out.close();
} catch (IOException e) {
}
}
checkAccountErrorLogBean = null;
checkAcountErrorLogForm = null;
}
return mapping.findForward(null);
}