导出
前端是用layui写的
<div class="layui-inline layui-btn-container layui-btn-container-bottom">
//Html.Button("ID", "显示内容", "样式", "控制器名称", "POST请求")
@Html.Button("btnUserToExcel", "导出", "layui-btn layui-bg-cyan", "YangTest", "YangTest")
</div>
<script>
//导出
$("#btnUserToExcel").click(function () {
var index = layer.load(1, { shade: 0.5 });//样式
$.post("ExportToExcel", { UserName: "YangzhikeAi" }, function (data) {
layer.close(index);
layer.alert(data.Message);
if (data.Code == "Success") {
window.location.href = "@Url.RouteUrl(new { Controller = "YangTest", Action = "Download"})/?file=" + data.FileName;
}
})
})<script>
//后台
[HttpGet]
[Ignore]
[DeleteFile]//下载
public ActionResult Download(string file)
{
string fullPath = Path.Combine(Server.MapPath("~/ExportFile"), file);
return File(fullPath, "application/vnd.ms-excel", file);
}
/// <summary>
/// 导出称重数据
/// </summary>
/// <param name="UserName">操作员</param>
/// <param name="Plate">车牌号</param>
/// <param name="GoodsID">物资规格ID</param>
/// <param name="InOrOut">出库入库</param>
/// <param name="DeviceID">设备ID</param>
/// <param name="Driver">司机</param>
/// <param name="BeginTime">开始时间</param>
/// <param name="EndTime">结束时间</param>
/// <returns></returns>
public JsonResult ExportToExcel(string limit, string page, string BeginTime, string EndTime, string DataType, string MaterialType, string MeasurementArea, string Warehouse, string Workshop, string ContainerNum, string CraneNum, string HeavyTime, string Weight, string PlateNum, string ShipmentsUnit)
{
try
{//根据条件查询datatable
DataTable dt = userService.GetYangTestData( BeginTime, EndTime, DataType, MaterialType, MeasurementArea, Warehouse, Workshop, ContainerNum, CraneNum, HeavyTime, Weight, PlateNum, ShipmentsUnit);HSSFWorkbook workbook = new HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet = workbook.CreateSheet("称重数据");
NPOI.SS.UserModel.IRow header = sheet.CreateRow(0);
header.CreateCell(0).SetCellValue("行车号");
header.CreateCell(1).SetCellValue("数据类型");
header.CreateCell(2).SetCellValue("物料类型");
header.CreateCell(3).SetCellValue("计量区域");
header.CreateCell(4).SetCellValue("仓库");
header.CreateCell(5).SetCellValue("工段");
header.CreateCell(6).SetCellValue("集装箱");
header.CreateCell(7).SetCellValue("取重时间");
header.CreateCell(8).SetCellValue("重量");
header.CreateCell(9).SetCellValue("车辆号");
header.CreateCell(10).SetCellValue("发货单位");
header.CreateCell(11).SetCellValue("更新时间");
for (int i = 0; i < dt.Rows.Count; i++)
{
NPOI.SS.UserModel.IRow row = sheet.CreateRow(i + 1);
row.CreateCell(0).SetCellValue(dt.Rows[i]["CraneNum"].ToString());
row.CreateCell(1).SetCellValue(dt.Rows[i]["DataType"].ToString());
row.CreateCell(2).SetCellValue(dt.Rows[i]["MaterialType"].ToString());
row.CreateCell(3).SetCellValue(dt.Rows[i]["MeasurementArea"].ToString());
row.CreateCell(4).SetCellValue(dt.Rows[i]["Warehouse"].ToString());
row.CreateCell(5).SetCellValue(dt.Rows[i]["Workshop"].ToString());
row.CreateCell(6).SetCellValue(dt.Rows[i]["ContainerNum"].ToString() == "True" ? "入库" : "出库");
row.CreateCell(7).SetCellValue(dt.Rows[i]["HeavyTime"].ToString());
row.CreateCell(8).SetCellValue(dt.Rows[i]["Weight"].ToString());
row.CreateCell(9).SetCellValue(dt.Rows[i]["PlateNum"].ToString());
row.CreateCell(10).SetCellValue(dt.Rows[i]["ShipmentsUnit"].ToString());
row.CreateCell(11).SetCellValue(dt.Rows[i]["UploadTime"].ToString());
}
string fileName = "称重数据表" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
string filePath = Path.Combine(Server.MapPath("~/ExportFile"), fileName);
using (MemoryStream memoryStream = new MemoryStream())
{
workbook.Write(memoryStream);
FileStream fileStream = new FileStream(filePath, FileMode.Create, FileAccess.Write);
memoryStream.WriteTo(fileStream);
fileStream.Close();
}
return Json(new { FileName = fileName, Code = "Success", Message = "导出成功!" }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return Json(new { FileName = "", Code = "Error", Message = "导出失败:" + ex.Message }, JsonRequestBehavior.AllowGet);
}
}