<%@page import="com.forgon.tools.date.DateTools"%>
<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.forgon.disinfectsystem.operationreservation.service.*"%>
<%@page import="com.forgon.disinfectsystem.inventorymanagement.model.HrpInvoicePlan"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.Arrays"%>
<%@page import="java.util.List"%>
<%@page import="java.util.Date"%>
<%@page import="org.apache.commons.lang.StringUtils"%>
<%@page import="com.forgon.tools.util.SqlUtils"%>
<%@page import="com.forgon.tools.*,org.apache.commons.lang.*,com.forgon.directory.service.*"%>
<%
String fileName= "手术预约单列表.xls";
ServletOutputStream servletOutputStream = response.getOutputStream();
response.setContentType("application/octet-stream");
response.addHeader("Content-Disposition","attachment;filename=" + new String(fileName.getBytes("GBK"), "ISO8859_1"));
OperationReservationManager operationReservationManager = (OperationReservationManager)SpringBeanManger.getBean("operationReservationManager");
String startTimeStr  = request.getParameter("startTime");
String endTimeStr  = request.getParameter("endTime");
if(StringUtils.isNotBlank(startTimeStr) && StringUtils.isNotBlank(endTimeStr)){
	startTimeStr = startTimeStr + " 00:00:00";
	endTimeStr = endTimeStr + " 23:59:59";
	Date startTime = DateTools.coverStrToDate(startTimeStr, DateTools.COMMON_DATE_HMS);
	Date endTime = DateTools.coverStrToDate(endTimeStr, DateTools.COMMON_DATE_HMS);
	operationReservationManager.exportOperationReservation(startTime, endTime, servletOutputStream);
}
servletOutputStream.flush();
out.clear();
out = pageContext.pushBody();
%>