62,041
社区成员
发帖
与我相关
我的任务
分享
$("#btnDown").click(function () {//下載
var srow = $("#carAndDriverInfo").bootstrapTable('getSelections');
if (srow.length == 0) {
toastr.warning("请选择需要下載的數據!");
return;
}
var arrdata = {};
for (var i = 0; i < srow.length; i++) {
arrdata[i] = srow[i].CARNO;
}
var oList = document.getElementById("carAndDriverInfo").rows[0].innerText;
var thName = oList.replace(/^[\r\t\n]+|[\r\t\n]+$/g, '').replace(/[\r\t\n]+/g, '\n').split('\n');
$.ajax({
type: "post",
url: "/SCBD0104/ExcelDown",
data: { thName: thName.toString(), carNoArr: arrdata },
//dataType: 'JSON',
})
});
[HttpPost]
public FileResult ExcelDown(string thName, string[] carNoArr)
{
//string excelName = "車輛與司機關係報表.xls";
//System.Data.DataTable dt = _CarAndDriverRepostory.GetCarAndDriverExcel(carNoArr);
//ExcelDown daysSendCarExcel = new ExcelDown();
//bool result = daysSendCarExcel.ExportExcel(dt, thName, excelName);
string pathName = Server.MapPath("~/Excel/車輛與司機關係報表.xls");
return File(pathName, "application/ms-excel", "車輛與司機關係報表.xls");
}