public ActionResult Query(FcpaSearchDTO dto) { UserLoginDTO lng = Session["UserLoginInfo"] as UserLoginDTO; dto.UserInfo = lng.UserInfo(); var result = FcpaProvider.Query(dto); return(new JsonResult(result)); }
public ActionResult Export(FcpaSearchDTO dto) { dto.rows = int.MaxValue; dto.page = 1; UserLoginDTO lng = Session["UserLoginInfo"] as UserLoginDTO; dto.UserInfo = lng.UserInfo(); var result = FcpaProvider.Query(dto); var headers = new List <ExcelHeaderModel>() { new ExcelHeaderModel { Header = "经销商", PropertyName = "DistributorName", Width = 40 }, new ExcelHeaderModel { Header = "姓名", PropertyName = "Name", Width = 15 }, new ExcelHeaderModel { Header = "部门", PropertyName = "Department", Width = 15 }, new ExcelHeaderModel { Header = "职位", PropertyName = "Title", Width = 15 }, new ExcelHeaderModel { Header = "培训状态", PropertyName = "StatusDesc", Width = 10 }, new ExcelHeaderModel { Header = "培训完成日期", PropertyName = "CompletedDate", Width = 22 }, new ExcelHeaderModel { Header = "在职状态", PropertyName = "OffWorkDesc", Width = 22 }, new ExcelHeaderModel { Header = "所属领域", PropertyName = "DomainDesc", Width = 22 }, new ExcelHeaderModel { Header = "更新日期", PropertyName = "UpdateDate", Width = 22 }, new ExcelHeaderModel { Header = "过期日期", PropertyName = "ExpireDate", Width = 10 }, new ExcelHeaderModel { Header = "备注", PropertyName = "Remark", Width = 10 } }; var buffer = result.rows.ToExcel(headers); return(File(buffer, "application/vnd.ms-excel", string.Format("FCPA Training Record List({0}).xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")))); }