//库存导出Excel public string Excel(int typeid = 1, string cname = "") { 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("入库时间")); List <Warehousing> list = WarehousingManager.Excel(typeid, cname); foreach (var item in list) { DataRow row = dt.NewRow(); row[0] = item.Wid; row[1] = item.Supplier.SlTypeId; row[2] = item.Product.PName; row[3] = item.WareStateType.TName; row[4] = item.Supplier.SlAddress; row[5] = item.Product.PCount; row[6] = item.time; dt.Rows.Add(row); } var name = string.Format("库存清单报表{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); string path = Server.MapPath("~/Excel/"); var pathname = string.Format("/Excel/{0}", name); //AsposeExcel excel = new AsposeExcel(System.IO.Path.Combine(path, name), ""); //excel.DatatableToExcel(dt, "库存清单报表", "库存清单报表"); FileStream fs = new FileStream(System.IO.Path.Combine(path, name), FileMode.Open, FileAccess.Read); File(fs, "application/vnd.ms-excel", name); fs.Close(); return(pathname); }
//protected override void OnActionExecuting(ActionExecutingContext filterContext) //{ // if (Session["jurisdiction"] == null) //判断session是否为空 // { // //filterContext.Result = new RedirectResult(Url.Action("Index", "Home"));//方法名,控制器名 // filterContext.Result =new RedirectResult("/Ma/Index.html");//方法名,控制器名 // return; // } // base.OnActionExecuting(filterContext); //} //查询库存清单 public ActionResult WhAll(int PageIndex, int PageSize, int typeid, string name) { return(Json(WarehousingManager.WhAll(PageIndex, PageSize, typeid, name), JsonRequestBehavior.AllowGet)); }