using LeaRun.Application.Code; using LeaRun.Util.Offices; using LeaRun.Util; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; namespace LeaRun.Application.Web.Areas.ReportManage.Controllers { /// /// 版 本 6.1 /// Copyright (c) 2013-2016 上海力软信息技术有限公司 /// 创建人:佘赐雄 /// 日 期:2016.3.28 16:54 /// 描 述:报表Demo /// public class MobileAuditorController : MvcControllerBase { #region 视图功能 /// /// 采购报表 /// /// [HttpGet] [HandlerAuthorize(PermissionMode.Enforce)] public ActionResult Purchase() { return View(); } /// /// 销售报表 /// /// [HttpGet] [HandlerAuthorize(PermissionMode.Enforce)] public ActionResult Sales() { return View(); } /// /// 仓库报表 /// /// [HttpGet] [HandlerAuthorize(PermissionMode.Enforce)] public ActionResult Store() { return View(); } /// /// 对账报表 /// /// [HttpGet] [HandlerAuthorize(PermissionMode.Enforce)] public ActionResult Reconciliation() { return View(); } #endregion #region 获取数据 /// /// 获取采购报表数据 /// /// [HttpGet] public ActionResult GetPurchaseJson() { var data = ExcelHelper.ExcelImport(Server.MapPath("~/Areas/ReportManage/Views/ReportDemo/data/Purchase.xlsx")); return Content(data.ToJson()); } /// /// 获取销售报表数据 /// /// [HttpGet] public ActionResult GetSalesJson() { var data = ExcelHelper.ExcelImport(Server.MapPath("~/Areas/ReportManage/Views/ReportDemo/data/Sales.xlsx")); return Content(data.ToJson()); } /// /// 获取仓库报表数据 /// /// [HttpGet] public ActionResult GetStoreJson() { var data = ExcelHelper.ExcelImport(Server.MapPath("~/Areas/ReportManage/Views/ReportDemo/data/Store.xlsx")); return Content(data.ToJson()); } /// /// 获取对账报表数据 /// /// [HttpGet] public ActionResult GetReconciliationJson() { var data = ExcelHelper.ExcelImport(Server.MapPath("~/Areas/ReportManage/Views/ReportDemo/data/Reconciliation.xlsx")); return Content(data.ToJson()); } #endregion } }