exportToExcel : function() {
var rows = $('#idDgOrder').datagrid('getRows');
var str = '<tr><td>订单号</td><td>收货人</td><td>联系电话</td><td>快递公司</td><td>快递单号</td><td>收货地址</td><td>支付金额</td><td>订单状态</td><td>下单时间</td></tr>';
for(let i = 0 ; i < rows.length ; i++ ){
str += '<tr>';
str += `<td>` + rows[i].sno + `</td><td>` + rows[i].name + `</td><td>` + rows[i].phone + `</td><td>` + rows[i].expressCompanyName + `</td>`;
str += `<td>` + rows[i].expressNo + `</td><td>` + rows[i].detailAddress + `</td><td>` + rows[i].totalPayedAmount + `</td><td>` + rows[i].payStatusStr + `</td>`;
str += `<td>` + rows[i].creationTime + `</td>`;
str += '</tr>';
}
// Worksheet名
var worksheet = 'Sheet1'
var uri = 'data:application/vnd.ms-excel;base64,';
// 下载的表格模板数据
var template = `<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet>
<x:Name>${worksheet}</x:Name>
<x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet>
</x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]-->
</head><body><table>${str}</table></body></html>`;
// 下载模板
window.location.href = uri + base64(template)
}
