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));
}
public string GetPager(int page, int rows, long warehouseId = 0, long commodityTypeId = 0, string commodityName = "")
{
var pager = StockBll.PagerStock(page, rows, warehouseId, commodityTypeId, commodityName);
return(JsonConvert.SerializeObject(pager));
}
