* 批量导出会员订单列表
* @return
*/
public String loadManyExcel(){
try {
HSSFWorkbook workbook =proxyOrdService.getLoadManyExcelResult(dataValue);
fileName = "会员订单" + ".xls";
byte[] by={};
by=fileName.getBytes("gb2312");
HttpServletRequest request = ServletActionContext.getRequest();
request.setAttribute("fileName", new String(by,"ISO-8859-1"));// 设置文件名
ByteArrayOutputStream baos = new ByteArrayOutputStream();
workbook.write(baos);
baos.flush();
byte[] aa = baos.toByteArray();
setExcelStream(new ByteArrayInputStream(aa, 0, aa.length));
baos.close();
} catch (Exception e) {
e.printStackTrace();
}
setMessage(Constants.getLanName(MemberConstant.MEM_EXCEL_SUSS));
return "exportOrdSale";
}
/* 导出会员列表信息
* @see com.chinatopv.service.ProxyOrdService#getLoadManyExcelResult(java.lang.String)
*/
public HSSFWorkbook getLoadManyExcelResult(String dataValue){
HSSFWorkbook book=null;
try {
List<OrdSale> ordSales=proxyOrdDao.getOrdSalesList(dataValue);
book=new HSSFWorkbook();
HSSFSheet sheet=book.createSheet("会员订单列表");
CellStyle headStyle=ExcelStyle.getHeadStyle(book);
headStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER_SELECTION);
CellStyle cellStyle=ExcelStyle.getTitleStyle(book);
Font font=book.createFont();
font.setFontHeightInPoints(Short.valueOf("12"));
cellStyle.setFont(font);
CellStyle wgtStyle=ExcelStyle.getTitleStyle(book);
Font wft=book.createFont();
wft.setFontHeightInPoints(Short.valueOf("14"));
wft.setBoldweight(Font.BOLDWEIGHT_BOLD);
wgtStyle.setFont(wft);
DateFormat df=new SimpleDateFormat("yyyy-MM-dd");
String time="";
String[][] titles={
{"会员订单列表","",""},
{"订单号","订单类型","订单状态","订单总额","收货人","状态","销售价格"}
};
int n=0;
int m=0;
for(int i=0;i<titles.length;i++){
HSSFRow row=sheet.createRow(n);
if(i==0&&wgtStyle!=null){
row.setHeight(Short.valueOf("600"));
}
for(int j=0;j<titles[i].length;j++){
HSSFCell cell=row.createCell(j);
cell.setCellValue(titles[i][j]);
cell.setCellStyle(cellStyle);
if(i==0&&wgtStyle!=null){
cell.setCellStyle(wgtStyle);
}else{
cell.setCellStyle(cellStyle);
}
}
n=i+1;
}
sheet.addMergedRegion(new CellRangeAddress(0,0,0,30));
sheet.autoSizeColumn(0);
Integer rowNum=titles.length-1;
if(ordSales!=null&&ordSales.size()>0){
for(OrdSale pack:ordSales){
if(pack.getOrdSaleProList().size()>0){
for(OrdSalePro ord:pack.getOrdSaleProList()){
rowNum++;
String[][] titleValue={
{pack.getCode(),getOrderTypes(pack.getType()),getStockOrderState(pack.getState()),pack.getTotal()==null?"":pack.getTotal().toString()+pack.getCcy(),pack.getConsName(),
pack.getConsPhone(),pack.getConsEmail(),pack.getAsysId()==null?"":pack.getAsysId().toString(),pack.getAsysName(),pack.getApointId()==null?"":pack.getApointId().toString(),
pack.getApointName(),pack.getSaleId()==null?"":pack.getSaleId().toString(),pack.getSaleName(),
HSSFRow row=sheet.createRow(rowNum);
row.setHeight(Short.valueOf("600"));
for(int f=0;f<titleValue[0].length;f++){
HSSFCell cell=row.createCell(f);
cell.setCellValue(titleValue[0][f]);
cell.setCellStyle(cellStyle);
}
}
}else{
rowNum++;
String[][] titleValue={
{pack.getCode(),getOrderTypes(pack.getType()),getStockOrderState(pack.getState()), "","",""}
};
HSSFRow row=sheet.createRow(rowNum);
row.setHeight(Short.valueOf("600"));
for(int f=0;f<titleValue[0].length;f++){
HSSFCell cell=row.createCell(f);
cell.setCellValue(titleValue[0][f]);
cell.setCellStyle(cellStyle);
}
}
}
}
} catch (Exception e) {
logger.error(this.getClass(), e);
e.printStackTrace();
}
return book;
}
<action name="memOrdAction" class="com.chinatopv.action.proxy.MemOrdAction">
<result name="pageListTopv">/wechat/wechatOrderList.jsp</result>
<result name="viewTopv">/wechat/wechatOrderView.jsp</result>
<result name="exportOrdSale" type="stream">
<param name="contentType">application/octet-stream</param>
<param name="contentDisposition">attachment;filename="${#request['fileName']}</param>
<param name="inputName">excelStream</param>
</result>
</result>
<result name="input">/redirectToWechatLogin.jsp</result>
</action>
var flag=true;
var count=0;
var dateValue="";
function checkItems(str) {
var e = window.event.srcElement;
var all = eval("document.all." + str);
if(flag==false){
if(dateValue!=""){
dateValue+=",";
}
}
if (e.checked) {
var a = document.getElementsByName(e.name);
all.checked = true;
flag=true;
// dateValue.push(e.value);
dateValue+=e.value+",";
for (var i = 0; i < a.length; i++) {
if (!a[i].checked) {
all.checked = false;
count=1;
break;
}
}
} else {
var a = document.getElementsByName('idList');
var n = a.length;
all.checked = false;
dateValue=dateValue.replace(e.value+",","");
for (var i = 0; i < n; i++) {
if(a[i].checked){
count=1;
flag=true;
return;
}
count=0;
}
// dateValue.splice($.inArray(e.value,dateValue),1);
}
}
// 复选框的全选,多选,全不选,反选
function checkBoxAlls(str) {
var a = document.getElementsByName(str);
var n = a.length;
dateValue="";
for (var i = 0; i < n; i++) {
a[i].checked = window.event.srcElement.checked;
if(a[i].checked){
count=1;
dateValue+=a[i].value+",";
flag=true;
}else{
count=0;
}
}
}
<td width="3%" height="22" align="center" class="list_th">
<input type="checkbox" name="All"
onClick="checkBoxAlls('idList')" />
</td>
<td align="center" height="22" class="list_td">
<input type="checkbox" name="idList" οnclick="checkItems('All')"
value="<s:property value='ordId'/>" />
<input type="hidden" name="ordState" class="ordState" value="<s:property value="state"/>"/>
</td>