public ActionResult WorkOrderExport(MaterialOtherSearchModel model)
{
model.PageSize = 1000;
var totalCount = 0;
var result = MaterialBusiness.MaterialOtherSearch(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("Order No");
row1.CreateCell(1).SetCellValue("Sap No");
row1.CreateCell(2).SetCellValue("Product ");
row1.CreateCell(3).SetCellValue("Receipt Time");
row1.CreateCell(4).SetCellValue("Receipt By");
row1.CreateCell(5).SetCellValue("Close Date/Shift");
row1.CreateCell(6).SetCellValue("Order Archived");
row1.CreateCell(7).SetCellValue("Parameter Record");
row1.CreateCell(8).SetCellValue("Maintenance Record");
row1.CreateCell(9).SetCellValue("Tool Machine Setup Check List ");
row1.CreateCell(10).SetCellValue("Quantity Confirm");
row1.CreateCell(11).SetCellValue("Archived By");
row1.CreateCell(12).SetCellValue("Weekly Check");
row1.CreateCell(13).SetCellValue("Remarks");
row1.CreateCell(14).SetCellValue("GetBy");
row1.CreateCell(15).SetCellValue("GetTime");
for (int i = 0; i < result.Count(); i++)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1);
rowtemp.CreateCell(0).SetCellValue(result[i].WIWorkOrder);
rowtemp.CreateCell(1).SetCellValue(result[i].WISapPN);
rowtemp.CreateCell(2).SetCellValue(result[i].WIProductName);
rowtemp.CreateCell(3).SetCellValue(result[i].WIReceiptTime);
rowtemp.CreateCell(4).SetCellValue(result[i].WIReceiptBy);
rowtemp.CreateCell(5).SetCellValue(result[i].WICloseDateShift);
rowtemp.CreateCell(6).SetCellValue(result[i].WIOrderArchived);
rowtemp.CreateCell(7).SetCellValue(result[i].WIParameterRecord);
rowtemp.CreateCell(8).SetCellValue(result[i].WIToolMaintenanceRecord);
rowtemp.CreateCell(9).SetCellValue(result[i].WIToolMachineCheck);
rowtemp.CreateCell(10).SetCellValue(result[i].WIQuantityConfirm);
rowtemp.CreateCell(11).SetCellValue(result[i].WIArchivedBy);
rowtemp.CreateCell(12).SetCellValue(result[i].WIWeeklyCheck);
rowtemp.CreateCell(13).SetCellValue(result[i].WIRemarks);
rowtemp.CreateCell(14).SetCellValue(result[i].WIGetBy);
rowtemp.CreateCell(15).SetCellValue(result[i].WIGetTime);
}
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
var exportFileName = string.Format("{0}{1}.xls", "WorkOrderInfo", DateTime.Now.ToString("yyyyMMddHHmmss"));
return(File(ms, "application/vnd.ms-excel", exportFileName));
}
public ActionResult MaterialOtherSearchResult(MaterialOtherSearchModel model)
{
var totalCount = 0;
var result = MaterialBusiness.MaterialOtherSearch(model, out totalCount);
var page = new Page(totalCount, model.CurrentPage);
var resultModel = new MaterialOtherSearchResultModel
{
Models = result,
Page = page
};
return(View(resultModel));
}
public static List <WorkOrderInfo> MaterialOtherSearch(MaterialOtherSearchModel model, out int totalCount)
{
var result = _materialDal.MaterialOtherSearch(model, out totalCount);
return(result);
}
