从Grid 导出Excel2

<%@ include file="/html/wsportlet/assetmanage/init.jsp"%>
<%@ page contentType="text/html; charset=UTF-8"%>
<%@ include file="/html/wsportlet/common/selectexportcolumn.jspf"%>

<portlet:renderURL windowState="<%=WindowState.MAXIMIZED.toString()%>"
var="createURL">
<portlet:param name="struts_action"
value="/machineryroom/addmachineryroom" />
<portlet:param name="redirect" value="<%=HtmlUtil.escape(currentURL)%>" />
</portlet:renderURL>

<portlet:renderURL windowState="<%=WindowState.MAXIMIZED.toString()%>"
var="updateURL">
<portlet:param name="struts_action"
value="/machineryroom/updatemachineryroom" />
<portlet:param name="redirect" value="<%=HtmlUtil.escape(currentURL)%>" />
</portlet:renderURL>

<portlet:renderURL windowState="<%=WindowState.MAXIMIZED.toString()%>"
var="viewURL">
<portlet:param name="struts_action"
value="/machineryroom/viewmachineryroom" />
<portlet:param name="redirect" value="<%=HtmlUtil.escape(currentURL)%>" />
</portlet:renderURL>

<div>
<form id="queryform" method="post" class="inputform">
<fieldset>
<legend>
<liferay-ui:message key="frame.query.condition" />
</legend>
<dl>
<div>
<dt>
<label>
机房名称
</label>
</dt>
<dd>
<input type="text" name="f_am.name" value=""
οnkeypress="machineryroomgrid.doEnterQuery();" />
</dd>
</div>
<div class="right">
<dt>
节点
</dt>
<dd>
<cdn:optionaltag name="f_am.nodeid" datasource="request"
labelColumn="name" datalist="nodeLs" valueColumn="id"
blankline="true" onchange ="machineryroomgrid.doQuery();" />
</dd>
</div>
</dl>
<dl>
<div>
<dt>
启用状态
</dt>
<dd>
<cdn:optionaltag name="f_am.active"
datalist="<%=ParamKeys.ACTIVE%>" datasource="cache"
dbTable="ws_param" labelColumn="displayvalue"
valueColumn="paramvalue" blankline="true" readonly="true"
οnchange="machineryroomgrid.doQuery();" />

</dd>
</div>

</dl>
</fieldset>

</form>

<div class="btnframe">
<span class="btn search first" οnclick="machineryroomgrid.doQuery();">
查询 </span>

<span class="btn add" οnclick="createMachineryroom();"> 新增机房 </span>
<span class="btn modify" οnclick="updateMachineryroom();"> 修改机房
</span>
<span class="btn delete" οnclick="deleteMachineryroom();"> 删除机房
</span>

</div>

<div id="initMachineryroomGridBox" height="350px" class="gridbox"></div>

</div>

<script>

var pageConstants = new Object();

//新建机房信息
function createMachineryroom(){
var data = {"machineryroomVO.machineryroomid":-1};
postForm('<%=createURL%>', data);
};

//查看机房
function viewMachineryroom(id){
var selectedIds = "";
if(id){
selectedIds = id;
}
else {
var gridObj = machineryroomgrid;
selectedIds = GridUtil.getSelectedIds(gridObj, false);
if(selectedIds == false){
return false;
}
}
var data = {"machineryroomid":selectedIds};
postForm('<%=viewURL%>', data);
};


function doQuery(){
machineryroomgrid.doQuery();
}

//修改机房信息
function updateMachineryroom(){
var gridObj = machineryroomgrid;
var selectedIds = GridUtil.getSelectedIds(gridObj, false);
if(selectedIds == false){
return false;
}
var data = {"machineryroomid":selectedIds};
postForm('<%=updateURL%>', data);
};

//删除机房
function deleteMachineryroom(){
var gridObj = machineryroomgrid;
var selectedIds = GridUtil.getSelectedIds(gridObj, true);
if(selectedIds == false){
return false;
}
if(window.confirm("<liferay-ui:message key="frame.confirm.delete" />")){
var targetUrl = '/c/machineryroom/deletemachineryroom?machineryroomid='+selectedIds;
AjaxUtil.doPost(targetUrl, null, callback);
}
};

function callback(text){
var jsonmsg = eval(text);
alert(jsonmsg.msg)
if(jsonmsg.success){
machineryroomgrid.refresh();
}
}
var data =[
["机房ID" ,"id" ,false ,10 ,'ro' , '#FFFFFF', 'center', 'str'],
["节点" ,"nodeid" ,true ,0 ,'sro' , '#FFFFFF', 'center', 'str'],
["节点名称" ,"nodename" ,false ,10 ,'ro' , '#FFFFFF', 'center', 'str'],
["机房名称" ,"name" ,false ,10 ,'ro' , '#FFFFFF', 'center', 'str'],
["基准机房" ,"baseroomname" ,false ,10 ,'ro' , '#FFFFFF', 'center', 'str'],
["所属销区" ,"saleareaname" ,false ,18 ,'ro' , '#FFFFFF', 'center', 'str'],
["运营商" ,"yys" ,false ,10 ,'sro' , '#FFFFFF', 'center', 'str'],
["采购单位" ,"purchase_org" ,false ,10 ,'ro' , '#FFFFFF', 'center', 'str'],
["管理单位" ,"manage_org" ,false ,10 ,'ro' , '#FFFFFF', 'center', 'str'],
["启用状态" ,"active" ,false ,10 , 'sro', '#FFFFFF', 'center', 'str']
];
var exportURL = '/c/machineryroom/doExport';
var cols=new GridUtil.colFactory(data);
function initMachineryroomGrid(){
var pc = cols.getColIndex();
machineryroomgrid = new dhtmlXGridObject('initMachineryroomGridBox');
cols.setGridColumns(machineryroomgrid);
machineryroomgrid.setImagePath('/html/js/dhtmlxgrid/imgs/');
machineryroomgrid.enablePaging();
machineryroomgrid.setQueryForm("queryform");
machineryroomgrid.setEditable(false);
machineryroomgrid.enableMultiselect(true);
machineryroomgrid.enableAutoHeight(true,"350px",false);
machineryroomgrid.setExtLinkUrl(0, "javascript://viewMachineryroom();","_self");
<c:forEach var="act" items="${nodeLs}" varStatus="i">
machineryroomgrid.getCombo(pc.nodeid).put("<c:out value='${act.id}'/>","<c:out value='${act.name}'/>");
</c:forEach>
<c:forEach var="act" items="${activeLs}" varStatus="i">
machineryroomgrid.getCombo(pc.active).put("<c:out value='${act.paramvalue}'/>","<c:out value='${act.displayvalue}'/>");
</c:forEach>
<c:forEach var="carrycompany" items="${carrycompanyLs}" varStatus="i">
machineryroomgrid.getCombo(pc.yys).put("<c:out value='${carrycompany.paramvalue}'/>","<c:out value='${carrycompany.displayvalue}'/>");
</c:forEach>

machineryroomgrid.init();
machineryroomgrid.doQuery('/c/machineryroom/initmachineryroom');
};
pageConstants.custitem = cols.getColIndex();
jQuery(document).ready(initMachineryroomGrid);
function gridReset(){
machineryroomgrid.refresh();
}


</script>