/** 意见批量处理 */
public void batchOperate() {
// 用户信息
UserInfo userInfo = getCurrentUser();
HttpServletRequest request = getCurrentRequest();
String ids = request.getParameter("ids");
String desc = request.getParameter("desc");
String type = request.getParameter("type");
// 处理的告警参数
AlarmEntity alarm = new AlarmEntity();
alarm.setDeal_flag(Constants.ALARM_E_CODE); // 已处理
alarm.setUser_id(userInfo.getUserID());
alarm.setConfirm_time(DateUtil.formatDateToString(new Date(), "yyyy-MM-dd HH:mm:ss"));
alarm.setIds(formatString(ids));
alarm.setOpeerate_desc(desc);
alarm.setOperate_type(type);
try {
this.service.update("VehicleCheckManage.updateAlarm", alarm);
} catch (BusinessException e) {
this.log.error("意见批量处理出错", e);
this.printWriter("处理失败!");
}
this.printWriter("处理成功!");
}
/** 导出 */
public String exportList(String title, String sheetName, List<AlarmEntity> exportList) {
String filePath = "";
OutputStream outputStream = null;
try {
filePath = "/tmp/" + UUIDGenerator.getUUID() + sheetName + ".xls";
File file = new File(filePath);
if (!file.getParentFile().exists()) {
file.getParentFile().mkdirs();
}
outputStream = new FileOutputStream(filePath);
// 使用Excel导出器IEExcelExporter
IEExcelExporter excelExporter = new IEExcelExporter(outputStream);
excelExporter.setTitle(
title + "(" + searchVO.getBeginTime() + "~" + searchVO.getEndTime() + ")");
excelExporter.putAutoExtendSheets(sheetName, 0, exportList);
// 将Excel写入到指定的流中
excelExporter.write();
} catch (FileNotFoundException e) {
log.error("Export error:" + e.getMessage());
return ERROR;
} catch (Exception e) {
log.error("Export error:" + e.getMessage());
return ERROR;
} finally {
// 关闭流
if (null != outputStream) {
try {
outputStream.close();
} catch (IOException e) {;
}
}
}
// 设置下载文件属性
FileInputStream fileInputStream = null;
OutputStream out = null;
try {
// 设置下载文件属性
String fileName = URLEncoder.encode(title, "UTF8");
HttpServletResponse response = ServletActionContext.getResponse();
response.setHeader(
"Content-disposition",
"attachment;filename="
+ fileName
+ "-"
+ DateUtil.formatDateToString(new Date(), "yyyyMMddHHmmss")
+ ".xls");
response.setContentType("application/msexcel; charset=\"utf-8\"");
// 下载刚生成的文件
fileInputStream = new FileInputStream(filePath);
out = response.getOutputStream();
int i = 0;
while ((i = fileInputStream.read()) != -1) {
out.write(i);
}
} catch (FileNotFoundException e) {
log.error("Export error:" + e.getMessage());
return ERROR;
} catch (Exception e) {
log.error("Export error:" + e.getMessage());
return ERROR;
} finally {
// 关闭流
if (null != fileInputStream) {
try {
fileInputStream.close();
} catch (IOException e) {;
}
}
if (null != out) {
try {
out.close();
} catch (IOException e) {;
}
}
}
return null;
}