/// <summary> /// 提现导出excel /// </summary> /// <param name="dt"></param> /// <returns></returns> public FileResult ExportExcel(string username = "", string mobile = "", string alipayaccount = "", string status = "") { StringBuilder strb = new StringBuilder(); strb.Append(" where 1=1 "); if (username != "") { strb.Append(" and a.username like '%" + username + "%' "); } if (mobile != "") { strb.Append(" and a.mobile like '" + mobile + "%' "); } if (alipayaccount != "") { strb.Append(" and a.alipay like '" + alipayaccount + "%' "); } if (status != "-1") { strb.Append(" and a.state =" + status); } strb.Append(" order by a.[addtime] desc"); //编号、手机号、姓名、支付宝账号、提现金额、提现时间、状态(审核中、已完成)、异常信息(支持文本输入) DataTable dt = Recharge.GetDrawListForDT(1, -1, strb.ToString()); Dictionary <string, string> listcol = new Dictionary <string, string>() { }; listcol["编号"] = "drawid"; listcol["手机"] = "mobile"; listcol["姓名"] = "username"; listcol["支付宝账号"] = "alipay"; listcol["提现金额"] = "money"; listcol["提现时间"] = "addtime"; listcol["状态"] = "state"; listcol["异常信息"] = "exception"; string html = ExcelHelper.BuildHtml(dt, listcol); //第一种:使用FileContentResult byte[] fileContents = Encoding.Default.GetBytes(html); return(File(fileContents, "application/ms-excel", "提现信息" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls")); ////第二种:使用FileStreamResult //var fileStream = new MemoryStream(fileContents); //return File(fileStream, "application/ms-excel", "fileStream.xls"); ////第三种:使用FilePathResult ////服务器上首先必须要有这个Excel文件,然会通过Server.MapPath获取路径返回. //var fileName = Server.MapPath("~/Files/fileName.xls"); //return File(fileName, "application/ms-excel", "fileName.xls"); }