/// <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));
}
