/// <summary> /// 导出Excel /// </summary> /// <param name="userName">Name of the user.</param> /// <param name="content">The content.</param> /// <param name="datetime1">The datetime1.</param> /// <param name="datetime2">The datetime2.</param> /// Author : Napoleon /// Created : 2015-01-14 14:15:33 public ActionResult ExcelLog(string userName, string content, string datetime1, string datetime2) { string fileName = "系统日志" + DateTime.Now.ToString("yyyyMMddhhmmssff") + ".xls"; string filePath = Server.MapPath("../Export/"); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } SystemLog log = new SystemLog(); log.UserName = userName; log.OperateContent = content; datetime1 = string.IsNullOrWhiteSpace(datetime1) ? SqlDateTime.MinValue.ToString() : datetime1; datetime2 = string.IsNullOrWhiteSpace(datetime2) ? SqlDateTime.MaxValue.ToString() : datetime2; DataTable dt = log.SelectLogTable(datetime1, datetime2); string[] titles = { "ID", "操作用户", "IP地址", "日志时间", "日志类型", "错误地址", "日志内容" }; string[] columns = { "Id", "UserName", "IpAddress", "OperateTime", "OperateType", "OperateUrl", "OperateContent" }; MemoryStream fileStream = dt.CreateSheet(titles, columns); fileStream.Seek(0, SeekOrigin.Begin); fileStream.StreamToFile(filePath + fileName); return(Content("../Export/" + fileName)); //return File(fileStream, "application/vnd.ms-excel", PublicFields.LogExcelName); }
/// <summary> /// 导出Excel /// </summary> /// <param name="userName">Name of the user.</param> /// <param name="content">The content.</param> /// <param name="datetime1">The datetime1.</param> /// <param name="datetime2">The datetime2.</param> /// Author : Napoleon /// Created : 2015-01-14 14:15:33 public FileResult ExcelLog(string userName, string content, string datetime1, string datetime2) { SystemLog log = new SystemLog(); log.UserName = userName; log.OperateContent = content; datetime1 = string.IsNullOrWhiteSpace(datetime1) ? SqlDateTime.MinValue.ToString() : datetime1; datetime2 = string.IsNullOrWhiteSpace(datetime2) ? SqlDateTime.MaxValue.ToString() : datetime2; DataTable dt = log.SelectLogTable(datetime1, datetime2); string[] titles = { "ID", "操作用户", "IP地址", "日志时间", "日志类型", "错误地址", "日志内容" }; string[] columns = { "Id", "UserName", "IpAddress", "OperateTime", "OperateType", "OperateUrl", "OperateContent" }; //string excel = dt.Excel("", columns, titles, false, null, ""); //MemoryStream fileStream = new MemoryStream(Encoding.Default.GetBytes(excel)); //return File(fileStream, "application/ms-excel", PublicFields.LogExcelName); MemoryStream fileStream = dt.CreateSheet(titles, columns); fileStream.Seek(0, SeekOrigin.Begin); return File(fileStream, "application/vnd.ms-excel", PublicFields.LogExcelName); }
/// <summary> /// 导出Excel /// </summary> /// <param name="userName">Name of the user.</param> /// <param name="content">The content.</param> /// <param name="datetime1">The datetime1.</param> /// <param name="datetime2">The datetime2.</param> /// Author : Napoleon /// Created : 2015-01-14 14:15:33 public ActionResult ExcelLog(string userName, string content, string datetime1, string datetime2) { string fileName = "系统日志" + DateTime.Now.ToString("yyyyMMddhhmmssff") + ".xls"; string filePath = Server.MapPath("../Export/"); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } SystemLog log = new SystemLog(); log.UserName = userName; log.OperateContent = content; datetime1 = string.IsNullOrWhiteSpace(datetime1) ? SqlDateTime.MinValue.ToString() : datetime1; datetime2 = string.IsNullOrWhiteSpace(datetime2) ? SqlDateTime.MaxValue.ToString() : datetime2; DataTable dt = log.SelectLogTable(datetime1, datetime2); string[] titles = { "ID", "操作用户", "IP地址", "日志时间", "日志类型", "错误地址", "日志内容" }; string[] columns = { "Id", "UserName", "IpAddress", "OperateTime", "OperateType", "OperateUrl", "OperateContent" }; MemoryStream fileStream = dt.CreateSheet(titles, columns); fileStream.Seek(0, SeekOrigin.Begin); fileStream.StreamToFile(filePath + fileName); return Content("../Export/" + fileName); //return File(fileStream, "application/vnd.ms-excel", PublicFields.LogExcelName); }