public ActionResult IndexOld() { string cacheKey = WebCaching.UserId + "_" + ExcelHelper.EXPORT_EXCEL_CONTEXT; string strHtml = ""; string fileName = ""; var obj = CacheHelper.Instance.Get(cacheKey); if (obj != null) { if (obj is List <ExcelConvertHelper.ExcelContext> ) { List <ExcelConvertHelper.ExcelContext> excelContexts = obj as List <ExcelConvertHelper.ExcelContext>; ExcelHelper.Export(excelContexts, ref strHtml); fileName = excelContexts[0].FileName; } else { ExcelConvertHelper.ExcelContext excelContext = obj as ExcelConvertHelper.ExcelContext; ExcelHelper.Export(excelContext, ref strHtml); fileName = excelContext.FileName; } CacheHelper.Instance.Remove(cacheKey); } if (!string.IsNullOrEmpty(strHtml)) { Response.Clear(); Response.BufferOutput = false; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8)); Response.ContentType = "application/ms-excel"; Response.Write(strHtml); Response.Close(); } return(View()); }
public ActionResult Export(LigerGrid grid, FormCollection data) { string strError = ""; grid.ConvertParams(data); eContract.Common.ExcelConvertHelper.ExcelContext context = new ExcelConvertHelper.ExcelContext(); if (SystemService.FunctionRoleService.ExportExcel(grid, ref context, ref strError)) { return(Json(AjaxResult.Success())); } return(Json(AjaxResult.Error(strError))); }
public ActionResult Index() { string cacheKey = WebCaching.UserId + "_" + ExcelHelper.EXPORT_EXCEL_CONTEXT; string strHtml = ""; string fileName = ""; string exportFilePath = Server.MapPath("~/DownLoad/ExportFiles/"); if (!Directory.Exists(exportFilePath)) { Directory.CreateDirectory(exportFilePath); } string exportFile = exportFilePath + WebCaching.UserAccount + "_Export_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; var obj = CacheHelper.Instance.Get(cacheKey); if (obj != null) { if (obj is List <ExcelConvertHelper.ExcelContext> ) { List <ExcelConvertHelper.ExcelContext> excelContexts = obj as List <ExcelConvertHelper.ExcelContext>; ExcelHelper helper = new ExcelHelper(); helper.ExportExcel(excelContexts, exportFile); fileName = excelContexts[0].FileName; } else { ExcelConvertHelper.ExcelContext excelContext = obj as ExcelConvertHelper.ExcelContext; ExcelHelper helper = new ExcelHelper(); helper.ExportExcel(excelContext, exportFile); fileName = excelContext.FileName; } CacheHelper.Instance.Remove(cacheKey); } if (System.IO.File.Exists(exportFile)) { byte[] fileContent = System.IO.File.ReadAllBytes(exportFile); System.IO.File.Delete(exportFile); Response.Clear(); Response.ClearHeaders(); Response.Buffer = false; Response.AppendHeader("Content-Type", "application/x-msdownload"); Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8)); Response.ContentType = "application/octet-stream"; Response.BinaryWrite(fileContent); Response.Flush(); Response.End(); } return(View()); }
public virtual bool ExportExcel(LigerGrid grid, ref ExcelConvertHelper.ExcelContext context, ref string Error) { QueryUser query = new QueryUser(); query.ligerGrid = grid; eContract.Common.ExcelConvertHelper.ColumnList columns = new eContract.Common.ExcelConvertHelper.ColumnList(); columns.Add(CasUserTable.C_USER_ACCOUNT, "登录名"); columns.Add(CasUserTable.C_ENGLISH_NAME, "姓名"); context = new ExcelConvertHelper.ExcelContext(); context.FileName = "UserList" + ".xls"; context.Title = "用户列表"; //context.Data = DataAccess.QueryDataSet(query); WhereBuilder where = query.ParseSQL(); context.Data = DataAccess.Select(where.SQLString, where.Parameters).Tables[0]; if (columns != null) { context.Columns.Add(columns); } CacheHelper.Instance.Set(WebCaching.UserId + "_" + ExcelHelper.EXPORT_EXCEL_CONTEXT, context); return(true); }
public virtual bool ExportExcel(LigerGrid grid, ref ExcelConvertHelper.ExcelContext context, ref string Error) { SecRoleQuery query = new SecRoleQuery(); query.ligerGrid = grid; eContract.Common.ExcelConvertHelper.ColumnList columns = new eContract.Common.ExcelConvertHelper.ColumnList(); columns.Add(SecRoleTable.C_ROLE_ID, "角色编号"); columns.Add("role_type_name", "角色类型"); columns.Add(SecRoleTable.C_ROLE_NAME, "角色名称"); columns.Add(SecRoleTable.C_REMARK, "角色描述"); context = new ExcelConvertHelper.ExcelContext(); context.FileName = "RoleList" + ".xls"; context.Title = "角色列表"; WhereBuilder where = query.ParseSQL(); context.Data = DataAccess.Select(where.SQLString, where.Parameters).Tables[0]; if (columns != null) { context.Columns.Add(columns); } CacheHelper.Instance.Set(WebCaching.UserId + "_" + ExcelHelper.EXPORT_EXCEL_CONTEXT, context); return(true); }