public FileResult Excel(T_InStockTaskInfo model)
{
string strErrMsg = string.Empty;
List <T_InStockTaskDetailsInfo> lstExport = new List <T_InStockTaskDetailsInfo>();
tfunc_detail.GetExportTaskDetail(model, ref lstExport, ref strErrMsg);
//创建Excel文件的对象
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
//添加一个sheet
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");
//给sheet1添加第一行的头部标题
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
row1.CreateCell(0).SetCellValue("任务号");
row1.CreateCell(1).SetCellValue("单据类型");
row1.CreateCell(2).SetCellValue("ERP单号");
row1.CreateCell(3).SetCellValue("物料号");
row1.CreateCell(4).SetCellValue("物料名称");
row1.CreateCell(5).SetCellValue("任务数");
row1.CreateCell(6).SetCellValue("剩余数");
row1.CreateCell(9).SetCellValue("上架数");
row1.CreateCell(7).SetCellValue("操作人");
row1.CreateCell(8).SetCellValue("操作时间");
row1.CreateCell(9).SetCellValue("创建人");
row1.CreateCell(10).SetCellValue("创建时间");
row1.CreateCell(11).SetCellValue("供应商编号");
row1.CreateCell(12).SetCellValue("供应商");
//将数据逐步写入sheet1各个行
for (int i = 0; i < lstExport.Count; i++)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1);
rowtemp.CreateCell(0).SetCellValue(lstExport[i].TaskNo);
rowtemp.CreateCell(1).SetCellValue(lstExport[i].StrVoucherType);
rowtemp.CreateCell(2).SetCellValue(lstExport[i].ErpVoucherNo);
rowtemp.CreateCell(3).SetCellValue(lstExport[i].MaterialNo);
rowtemp.CreateCell(4).SetCellValue(lstExport[i].MaterialDesc);
rowtemp.CreateCell(5).SetCellValue(lstExport[i].TaskQty.ToString());
rowtemp.CreateCell(6).SetCellValue(lstExport[i].RemainQty.ToString());
rowtemp.CreateCell(7).SetCellValue(lstExport[i].ShelveQty.ToString());
rowtemp.CreateCell(8).SetCellValue(lstExport[i].OperatorUserName.ToString());
rowtemp.CreateCell(9).SetCellValue(lstExport[i].OperatorDateTime.ToString());
rowtemp.CreateCell(10).SetCellValue(lstExport[i].Creater.ToString());
rowtemp.CreateCell(11).SetCellValue(lstExport[i].CreateTime.ToString());
rowtemp.CreateCell(12).SetCellValue(lstExport[i].SupCusCode);
rowtemp.CreateCell(13).SetCellValue(lstExport[i].SupCusName);
}
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
return(File(ms, "application/vnd.ms-excel", DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"));
}
public bool GetExportTaskDetail(T_InStockTaskInfo model, ref List <T_InStockTaskDetailsInfo> modelList, ref string strErrMsg)
{
T_InTaskDetails_Func tfunc = new T_InTaskDetails_Func();
return(tfunc.GetExportTaskDetail(model, ref modelList, ref strErrMsg));
}