public ActionResult ToCheckExcel()
{
string orderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty);
List<CheckDataEntity> listResult = new CheckDataProvider().GetCheckOrder(orderNum);
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("库位名称"));
dt.Columns.Add(new DataColumn("库位编号"));
dt.Columns.Add(new DataColumn("产品编码"));
dt.Columns.Add(new DataColumn("产品条码"));
dt.Columns.Add(new DataColumn("产品名称"));
dt.Columns.Add(new DataColumn("批次"));
dt.Columns.Add(new DataColumn("盘点数"));
foreach (CheckDataEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.LocalName;
row[1] = t.LocalNum;
row[2] = t.ProductNum;
row[3] = t.BarCode;
row[4] = t.ProductName;
row[5] = t.BatchNum;
row[6] = "";
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFiles/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("盘点管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss"));
NPOIExcel excel = new NPOIExcel("盘点管理", "盘点单", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape());
}
else
{
this.ReturnJson.AddProperty("d", "无数据导出!");
}
return Content(this.ReturnJson.ToString());
}
