public ActionResult MachineToolExcel(MaToolSearchModel model)
{
model.PageSize = 1000;
var totalCount = 0;
var result = MaterialBusiness.SearchMaToolPageList(model, out totalCount).ToList();
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");
//给sheet1添加第一行的头部标题
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
row1.CreateCell(0).SetCellValue("Equipment/Fixture Name");
row1.CreateCell(1).SetCellValue("Equipment No");
row1.CreateCell(2).SetCellValue("Fixture No");
row1.CreateCell(3).SetCellValue("Type");
row1.CreateCell(4).SetCellValue("Serial Number");
row1.CreateCell(5).SetCellValue("Quantity");
row1.CreateCell(6).SetCellValue("Manufactured Date");
row1.CreateCell(7).SetCellValue("power");
row1.CreateCell(8).SetCellValue("Outline Dimension");
row1.CreateCell(9).SetCellValue("Ability");
row1.CreateCell(10).SetCellValue("Pressure air");
row1.CreateCell(11).SetCellValue("Cooling water");
row1.CreateCell(12).SetCellValue("Incoming Date");
row1.CreateCell(13).SetCellValue("Remark");
for (int i = 0; i < result.Count(); i++)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1);
rowtemp.CreateCell(0).SetCellValue(result[i].BMEquipmentName);
rowtemp.CreateCell(1).SetCellValue(result[i].BMEquipmentNo);
rowtemp.CreateCell(2).SetCellValue(result[i].BMFixtureNo);
rowtemp.CreateCell(3).SetCellValue(result[i].BMType);
rowtemp.CreateCell(4).SetCellValue(result[i].BMSerialNumber);
rowtemp.CreateCell(5).SetCellValue(Convert.ToInt32(result[i].BMQuantity));
rowtemp.CreateCell(6).SetCellValue(result[i].BMManufacturedDate);
rowtemp.CreateCell(7).SetCellValue(result[i].BMPower);
rowtemp.CreateCell(8).SetCellValue(result[i].BMOutlineDimension);
rowtemp.CreateCell(9).SetCellValue(result[i].BMAbility);
rowtemp.CreateCell(10).SetCellValue(Convert.ToDouble(result[i].BMNeedPressureAir));
rowtemp.CreateCell(11).SetCellValue(Convert.ToDouble(result[i].BMNeedCoolingWater));
rowtemp.CreateCell(12).SetCellValue(result[i].BMIncomingDate);
rowtemp.CreateCell(12).SetCellValue(result[i].BMRemarks);
}
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
var exportFileName = string.Format("{0}{1}.xls", "MaterialToolInfo", DateTime.Now.ToString("yyyyMMddHHmmss"));
return(File(ms, "application/vnd.ms-excel", exportFileName));
}
/// <summary>
/// 查询设备和工具
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult MachineToolSearch(MaToolSearchModel model)
{
var totalCount = 0;
var result = MaterialBusiness.SearchMaToolPageList(model, out totalCount);
var page = new Page(totalCount, model.CurrentPage);
var resultModel = new MaToolSearchResultModel
{
Models = result,
Page = page
};
return(View("MachineSearch", resultModel));
}
