/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(int pcode = 0, string name = "", string code = "") { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_组织机构管理_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); string where = "1=1"; List <object> param = new List <object>(); if (pcode > 0) { where += " AND P_CODE=?"; param.Add(pcode); } if (string.IsNullOrWhiteSpace(name) == false) { where += " AND NAME LIKE '%" + name.Replace('\'', ' ') + "%'"; } if (string.IsNullOrWhiteSpace(code) == false) { where += " AND DEPT_CODE=? "; param.Add(code); } var dt = BF_DEPARTMENT.Instance.GetTableFields("NAME,DEPT_CODE,DEPT_LEVEL,P_CODE,DEPT_FLAG,REMARK,CREATE_TIME,UPDATE_TIME", where, param); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } dt.Columns.Remove("ID"); dt.Columns["NAME"].Caption = "部门名称"; dt.Columns["DEPT_CODE"].Caption = "部门编码"; dt.Columns["DEPT_LEVEL"].Caption = "部门层级"; dt.Columns["P_CODE"].Caption = "上级部门编码"; dt.Columns["DEPT_FLAG"].Caption = "部门标志"; dt.Columns["REMARK"].Caption = "部门说明"; dt.Columns["CREATE_TIME"].Caption = "创建时间"; dt.Columns["UPDATE_TIME"].Caption = "最后更新时间"; Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功")); }
/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(int pid = 0, string name = "", string url = "") { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_菜单管理_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); string where = "1=1"; List <object> param = new List <object>(); if (pid > 0) { where += " AND PID=?"; param.Add(pid); } if (string.IsNullOrWhiteSpace(name) == false) { where += " AND NAME LIKE '%" + name.Replace('\'', ' ') + "%'"; } if (string.IsNullOrWhiteSpace(url) == false) { where += " AND URL LIKE '%" + url.Replace('\'', ' ') + "%'"; } var dt = BF_MENU.Instance.GetTableFields("PID,NAME,URL,IS_ENABLE,IS_SHOW_NAV,CREATE_TIME,UPDATE_TIME", where, param); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } dt.Columns["PID"].Caption = "上级菜单"; dt.Columns["NAME"].Caption = "菜单名称"; dt.Columns["URL"].Caption = "菜单URL地址"; dt.Columns["IS_ENABLE"].Caption = "启用状态"; dt.Columns["IS_SHOW_NAV"].Caption = "导航显示"; dt.Columns["CREATE_TIME"].Caption = "创建时间"; dt.Columns["UPDATE_TIME"].Caption = "最后更新时间"; Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功!")); }
/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(string name = "", string ip = "", int type = 0) { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_数据库管理_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); string where = "1=1"; if (string.IsNullOrWhiteSpace(name) == false) { where += " AND NAME LIKE '%" + name.Replace('\'', ' ') + "%'"; } if (string.IsNullOrWhiteSpace(ip) == false) { where += " AND IP LIKE '%" + ip.Replace('\'', ' ') + "%'"; } if (type > 0) { where += " AND DB_TYPE=" + type; } var dt = BF_DATABASE.Instance.GetTableFields("NAME,DB_TYPE,IP,PORT,USER_NAME,DB_NAME,REMARK,UPDATE_TIME", where); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } dt.Columns["NAME"].Caption = "数据库名称"; dt.Columns["DB_TYPE"].Caption = "数据库类型"; dt.Columns["IP"].Caption = "IP地址"; dt.Columns["PORT"].Caption = "端口号"; dt.Columns["USER_NAME"].Caption = "用户名"; dt.Columns["DB_NAME"].Caption = "实例名"; dt.Columns["REMARK"].Caption = "备注"; dt.Columns["UPDATE_TIME"].Caption = "最后更新时间"; Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功")); }
/// <summary> /// 样表 /// </summary> /// <param name="entity">实体</param> /// <returns></returns> private ActionResult ImportDownload(BF_IMPORT.Entity entity) { try { List <string> commentList = new List <string>(); DataTable dt = BF_IMPORT.GetSampleTable(entity, out commentList); string filename = HttpUtility.UrlEncode(string.Format("{0}_{1}.xlsx", entity.NAME, DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true || System.IO.File.Exists(fullName) == false) { return(ShowAlert("未生成Excel文件")); } IWorkbook workBook; using (FileStream fs = System.IO.File.OpenRead(fullName)) { workBook = new XSSFWorkbook(fs); ISheet sheet = workBook.GetSheetAt(0); IRow row = sheet.GetRow(0); XSSFDrawing patriarch = (XSSFDrawing)sheet.CreateDrawingPatriarch(); for (int c = 0; c < row.Cells.Count; c++) { if (string.IsNullOrWhiteSpace(commentList[c]) == false) { IComment comment = patriarch.CreateCellComment(new XSSFClientAnchor(0, 50, 0, 50, c, 0, c + 3, 5)); comment.Author = "编辑提示"; comment.String = new XSSFRichTextString("【编辑提示】\r\n" + commentList[c]); row.Cells[c].CellComment = comment; } } } //重写文件 using (FileStream fs = System.IO.File.Create(fullName)) { workBook.Write(fs); fs.Close(); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { ShowAlert("生成样表出错:" + ex.Message); } return(View()); }
/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(string content = "") { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_操作日志_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); List <object> param = new List <object>(); #region 添加参数 string where = "1=1"; if (string.IsNullOrWhiteSpace(content) == false) { where += " and content LIKE '%" + content.Replace('\'', ' ') + "%'"; } #endregion var dt = BLL.FW.BF_OP_LOG.Instance.GetTableFields("LOG_TIME,LOG_LEVEL,IS_SUCCESS,SRC_IP,SRC_PORT,USER_NAME,CONTROLLER,ACTION,REQ_URL,CONTENT,DETAIL", where, param); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } dt.Columns["LOG_TIME"].Caption = "日志时间"; dt.Columns["LOG_LEVEL"].Caption = "等级"; dt.Columns["IS_SUCCESS"].Caption = "成功"; dt.Columns["SRC_IP"].Caption = "源IP"; dt.Columns["SRC_PORT"].Caption = "源端口"; dt.Columns["USER_NAME"].Caption = "登录名"; dt.Columns["CONTROLLER"].Caption = "控制器名称"; dt.Columns["ACTION"].Caption = "ACTION名称"; dt.Columns["REQ_URL"].Caption = "请求URL地址"; dt.Columns["CONTENT"].Caption = "请求内容"; dt.Columns["DETAIL"].Caption = "源IP"; Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功")); }
/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(string name = "") { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_图形报表_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); #region 添加参数 string orderByField = "CR.ID"; string orderByType = "DESC"; List <object> param = new List <object>(); string where = "1=1"; if (string.IsNullOrWhiteSpace(name) == false) { where += " and CR.NAME LIKE '%" + name.Replace('\'', ' ') + "%'"; } #endregion int count = 0; DataTable dt = BF_CHART_REPORT.Instance.GetDataTable(0, 0, ref count, name, orderByField, orderByType); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } dt.Columns.Remove("ID"); dt.Columns["NAME"].Caption = "名称"; dt.Columns["DBNAME"].Caption = "数据库名称"; dt.Columns["CHART_TYPE"].Caption = "类别"; dt.Columns["SHOWEXPORT"].Caption = "导出"; dt.Columns["SHOWDEBUG"].Caption = "调试"; dt.Columns["SQL_CODE"].Caption = "SQL"; dt.Columns["IS_ENABLE"].Caption = "启用"; dt.Columns["UPDATE_TIME"].Caption = "更新时间"; Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功")); }
/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(int pid = 0, string name = "") { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_脚本类型_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); string where = "1=1"; List <object> param = new List <object>(); if (pid > 0) { where += " AND PID=?"; param.Add(pid); } if (string.IsNullOrWhiteSpace(name) == false) { where += " AND NAME LIKE '%" + name.Replace('\'', ' ') + "%'"; } int count = 0; var dt = BF_ST_TYPE.Instance.GetDataTable(0, 0, ref count, pid, name, "st.ID", "asc"); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } dt.Columns["NAME"].Caption = "类型名称"; dt.Columns["PNAME"].Caption = "上层类型"; dt.Columns["REMARK"].Caption = "备注"; dt.Columns["CREATENAME"].Caption = "创建者"; dt.Columns["CREATE_TIME"].Caption = "创建时间"; dt.Columns["UPDATENAME"].Caption = "最后更新者"; dt.Columns["UPDATE_TIME"].Caption = "最后更新时间"; Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功")); }
/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(string enName = "", string cnName = "") { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_字段显示配置_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); string where = "1=1"; if (string.IsNullOrWhiteSpace(enName) == false) { where += " AND EN_NAME LIKE '%" + enName.Replace('\'', ' ') + "%'"; } if (string.IsNullOrWhiteSpace(cnName) == false) { where += " AND CN_NAME LIKE '%" + cnName.Replace('\'', ' ') + "%'"; } var dt = BF_FIELD.Instance.GetTableFields("EN_NAME,CN_NAME,FIELD_DATA_TYPE,IS_REQUISITE,IS_SHOW,SHOW_WIDTH", where); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } dt.Columns["EN_NAME"].Caption = "字段英文名"; dt.Columns["CN_NAME"].Caption = "字段中文名"; dt.Columns["FIELD_DATA_TYPE"].Caption = "IP字段类型"; dt.Columns["IS_REQUISITE"].Caption = "是否必须"; dt.Columns["IS_SHOW"].Caption = "是否显示"; dt.Columns["SHOW_WIDTH"].Caption = "显示宽度"; Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功")); }
/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(string message = "", int TaskId = 0) { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_任务日志_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); List <object> param = new List <object>(); #region 添加参数 string where = "TASK_ID=?"; param.Add(TaskId); if (string.IsNullOrWhiteSpace(message) == false) { where += " and message LIKE '%" + message.Replace('\'', ' ') + "%'"; } #endregion var dt = BLL.FW.BF_ST_TASK_LOG.Instance.GetTableFields("LOG_TIME,LOG_LEVEL,MESSAGE", where, param); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } dt.Columns["LOG_TIME"].Caption = "日志时间"; dt.Columns["LOG_LEVEL"].Caption = "等级"; dt.Columns["MESSAGE"].Caption = "日志内容"; Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功")); }
/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(string daterange = "", string flowName = "", string nodeName = "", string param = "", string statusId = "", string successId = "") { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_脚本任务_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); int count = 0; var dt = BF_ST_TASK.Instance.GetDataTable(0, 0, ref count, daterange, flowName, nodeName, param, statusId, successId); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } dt.Columns.Remove("ID"); dt.Columns["FLOWNAME"].Caption = "流程名称"; dt.Columns["NODENAME"].Caption = "节点名称"; dt.Columns["IS_MANUAL"].Caption = "手动启动"; dt.Columns["REFERENCE_DATE"].Caption = "基准日期"; dt.Columns["RETRY_TIMES"].Caption = "重试次数"; dt.Columns["RUN_STATUS"].Caption = "运行状态"; dt.Columns["IS_SUCCESS"].Caption = "是否成功"; dt.Columns["START_TIME"].Caption = "开始时间"; dt.Columns["FINISH_TIME"].Caption = "结束时间"; dt.Columns["CREATE_TIME"].Caption = "创建时间"; dt.Columns["REMARK"].Caption = "备注"; Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功")); }
/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(string name = "") { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_数据外导配置_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); string where = "1=1"; if (string.IsNullOrWhiteSpace(name) == false) { where += " AND NAME LIKE '%" + name.Replace('\'', ' ') + "%'"; } var dt = BF_IMPORT.Instance.GetTable(where); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功")); }
/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(string name = "", int runState = -1, int isEnable = -1, int lastTaskIs = -1, int self = 0) { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_脚本任务_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), System.Text.Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); string where = "1=1"; List <object> param = new List <object>(); #region 添加参数 if (!string.IsNullOrWhiteSpace(name)) { where += " AND NAME LIKE '%" + name.Replace('\'', ' ') + "%'"; } if (runState > -1) { where += " AND RUN_STATUS = " + runState; } if (isEnable > -1) { where += " AND IS_ENABLE = " + isEnable; } if (lastTaskIs > -1) { where += " AND LAST_TASK_IS =" + lastTaskIs; } if (self > 0) { where += " AND CREATE_UID = " + SystemSession.UserID; } #endregion var dt = BLL.FW.BF_ST_FLOW.Instance.GetTableFields("ID,NAME,TYPE_ID,CRON,RETRY_TIMES,IS_ENABLE,RUN_STATUS,LAST_TASK_IS,LAST_TASK_ID", where, param); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } dt.Columns.Remove("ID"); dt.Columns["NAME"].Caption = "脚本流名称"; dt.Columns["TYPE_ID"].Caption = "脚本流类型"; dt.Columns["CRON"].Caption = "时间表达式"; dt.Columns["RETRY_TIMES"].Caption = "失败重试次数"; dt.Columns["IS_ENABLE"].Caption = "是否启用"; dt.Columns["RUN_STATUS"].Caption = "运行状态"; dt.Columns["LAST_TASK_IS"].Caption = "最新任务是否成功"; dt.Columns["LAST_TASK_ID"].Caption = "最新任务ID"; Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功")); }
/// <summary> /// 导出文件附件 /// </summary> /// <param name="wherestr">搜索条件</param> /// <returns>附件信息</returns> public ActionResult ExportFile(string name = "", string typeId = "", string dbId = "", int self = 0) { try { string filename = HttpUtility.UrlEncode(string.Format("导出报表_脚本任务_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")), Encoding.UTF8); string path = System.Web.HttpContext.Current.Server.MapPath("~/tmp/"); string where = "1=1"; List <object> param = new List <object>(); #region 添加参数 if (string.IsNullOrWhiteSpace(name) == false) { where += " AND NAME LIKE '%" + name.Replace('\'', ' ') + "%'"; } if (string.IsNullOrWhiteSpace(typeId) == false) { where += " AND TYPE_ID = ?"; param.Add(typeId); } if (string.IsNullOrWhiteSpace(dbId) == false) { where += " AND DB_ID = ?"; param.Add(dbId); } #endregion int count = 0; var dt = BF_ST_NODE.Instance.GetDataTable(0, 0, ref count, name, typeId, dbId, self); if (dt == null) { return(ShowAlert("导出数据到Excel出现错误:未查询出数据")); } dt.Columns.Remove("ID"); dt.Columns.Remove("LAST_TASK_ID"); dt.Columns["NAME"].Caption = "任务名称"; dt.Columns["TYPENAME"].Caption = "类型"; dt.Columns["TASKNAME"].Caption = "最新任务"; dt.Columns["DBNAME"].Caption = "数据库名称"; dt.Columns["RUN_STATUS"].Caption = "运行状态"; dt.Columns["LAST_TASK_IS"].Caption = "是否成功"; dt.Columns["LAST_TASK_ST"].Caption = "开始时间"; dt.Columns["LAST_TASK_FT"].Caption = "结束时间"; dt.Columns["CREATE_NAME"].Caption = "创建者"; dt.Columns["CREATE_TIME"].Caption = "创建时间"; dt.Columns["UPDATE_TIME"].Caption = "更新时间"; dt.Columns["UPDATE_NAME"].Caption = "更新者"; Library.Export.ExcelFile export = new Library.Export.ExcelFile(path); string fullName = export.ToExcel(dt); if (string.IsNullOrWhiteSpace(fullName) == true) { return(ShowAlert("未生成Excel文件")); } System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Clear();//清除缓冲区所有内容 System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); System.Web.HttpContext.Current.Response.WriteFile(fullName); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); //删除文件 export.Delete(fullName); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "导出默认报表[DB]到Excel出错:" + ex.ToString()); return(ShowAlert("导出数据到Excel出现未知错误:" + ex.Message)); } return(ShowAlert("导出成功")); }