/// <summary>
/// 充值导出excel
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public FileResult ExportExcelForRech(string mobile = "", string suite = "-1", string platform = "全部", string starttime = "", string endtime = "")
{
StringBuilder strb = new StringBuilder();
strb.Append(" where 1=1 ");
if (mobile != "")
{
strb.Append(" and a.account like '" + mobile + "%' ");
}
if (suite != "-1")
{
strb.Append(" and a.vossuiteid = " + suite + " ");
}
if (platform != "全部")
{
strb.Append(" and a.platform = '" + platform + "' ");
}
if (starttime != "" && endtime != "")
{
strb.Append(" and (convert(varchar(10),a.paytime,120) between '" + starttime + "' and '" + endtime + "')");
}
strb.Append(" order by a.addtime desc ");
DataTable dt = Recharge.GetRechargeListForDt(1, -1, strb.ToString());
Dictionary <string, string> listcol = new Dictionary <string, string>()
{
};
listcol["编号"] = "rechargeid"; listcol["手机号"] = "account"; listcol["姓名"] = "nickname"; listcol["职位"] = "userrank"; listcol["充值金额"] = "total_fee";
listcol["充值套餐"] = "suitename";
listcol["支付方式"] = "platform"; listcol["充值时间"] = "paytime";
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");
}
