public ActionResult ExportStock(long warehouseId = 0, long commodityTypeId = 0, string commodityName = "") { var tb = new DataTable(); tb.Columns.Add("货品名称"); tb.Columns.Add("货品类别"); tb.Columns.Add("仓库"); tb.Columns.Add("库存单位"); tb.Columns.Add("最低库存"); tb.Columns.Add("最高库存"); tb.Columns.Add("实际库存"); tb.Columns.Add("预警状态"); var apiResult = new APIResult(); var user = UserContext.CurrentUser; List <Stock> list = StockBll.ExportStock(warehouseId, commodityTypeId, commodityName); foreach (Stock item in list) { tb.Rows.Add(new string[] { item.CommodityName, item.CommodityTypeName, item.WarehourseName, item.CommodityUnitName, item.LowStock.ToString(), item.HighStock.ToString(), item.TotalCount.ToString(), (item.LowStock <= item.TotalCount || item.TotalCount <= item.HighStock)?"正常":"预警", }); } ExcelHelper.ExportByWeb(tb, "库存报表", "库存报表.xls"); return(Json(apiResult)); }