/// <summary> /// 下载Excel文件 /// </summary> /// <param name="searchText"></param> /// <returns></returns> public FileResult ExportExcel(string searchText) { AlumniService service = new AlumniService(); List <AlumniInfo> alumniInfos = service.Query(); string[] headers = { "编号", "姓名", "性别", "民族", "籍贯", "生日", "婚姻状况", "手机号码", "电子邮箱", "联系地址", "最高学历", "毕业院校", "主修专业", "毕业时间", "兴趣爱好", "校友会职务", "工作单位", "社会职位", "实名认证", "备注" }; byte[] buffer = FileHelper.ExportToExcel(headers, alumniInfos, "校友名录"); return(File(buffer, "application/ms-excel", "哈理工校友通讯录.xls")); }
public JsonResult QueryList(int pageNumber, int pageSize, string searchText) { AlumniService service = new AlumniService(); int total = 0; List <AlumniInfo> alumniInfos = service.Query(searchText, pageSize, pageNumber, out total); var data = new { total = total, rows = alumniInfos }; return(Json(data, JsonRequestBehavior.AllowGet)); }