/// <summary> /// 页面公用ViewBag /// </summary> /// <param name="PageCode">页面编码(菜单编码)</param> /// <param name="RightCode">权限编码 用于页面级权限验证</param> /// <param name="PageTitle">页面标题 标题为空自动获取页面标题及上级页面标题</param> public void pubViewBag(string PageCode, string RightCode, string PageTitle) { CookieModel cookieInfo = SystemCls.getCookieInfo(); ViewBag.getPageMenuStr = getPageMenuStr(PageCode); ViewBag.PageCode = PageCode; string curORGNo = SystemCls.getCurUserOrgNo(); if (PublicCls.OrgIsShi(curORGNo)) { curORGNo = ConfigCls.getConfigValue("ProvincialCapital");//州府所在地行政区划编码 } //获取火险等级 ViewBag.fireLevel = YJ_DANGERCLASSCls.getLevelByOrgNo(new YJ_DANGERCLASS_SW { BYORGNO = curORGNo }); //获取滚动信息 if (T_SYS_PARAMETERCls.getValueByFlag(new T_SYS_PARAMETER_SW { PARAMFLAG = "LoginInfo" }).ToString() == "0") { ViewBag.marqueeSysInfo = T_SYS_PARAMETERCls.getValueByFlag(new T_SYS_PARAMETER_SW { PARAMFLAG = "marqueeIndexInfo" }).ToString(); } else { ViewBag.marqueeSysInfo = YJ_WEATHERCls.getWeather(new YJ_WEATHER_SW { BYORGNO = curORGNo }); } ViewBag.PageLeftMenu = getPageLeftMenu(PageCode); //左侧菜单 ViewBag.isPageRight = SystemCls.isRight(RightCode); //判断页面是否有权限 ViewBag.SystemName = ConfigCls.getSystemName(); //系统名称 ViewBag.noticeRefreshTimeInterval = ConfigCls.noticeRefreshTimeInterval(); //菜单自动刷新间隔 ViewBag.PageTitle = PageTitle; //如果页面标题为空,则自动通过页面编码从系统菜单表中获取菜单名称及上级菜单名称 if (string.IsNullOrEmpty(PageTitle)) { ViewBag.PageTitle = T_SYS_MENUCls.getModel(new T_SYS_MENU_SW { MENUCODE = PageCode, SYSFLAG = ConfigCls.getSystemFlag() }).MENUNAME; } ViewBag.Title = ConfigCls.getSystemName() + "-" + ViewBag.PageTitle; //Title名称 ViewBag.SystemLogo = ConfigCls.getSystemLogo(); //获取系统logo图片 ViewBag.trueName = cookieInfo.trueName; //当前登录用户姓名 ViewBag.TopFireAlarm = ConfigCls.getTopFireAlarm(); //是否火情报警 ViewBag.TopFireLevel = ConfigCls.getTopFireLevel(); //是否显示火险等级 ViewBag.depName = StateSwitch.GetOrgNameByOrgNO(SystemCls.getCurUserOrgNo()); //部门名称 string systemFlag = ConfigCls.getSystemFlag(); //系统标识 如Springer ViewBag.T_UrlReferrer = Request.UrlReferrer; }
public FileResult CollectCountExportExcel() { string BYORGNO = Request.Params["BYORGNO"]; string TIMEBegin = Request.Params["TIMEBegin"]; string TIMEEnd = Request.Params["TIMEEnd"]; string HID = Request.Params["HID"]; string SYSTYPEVALUE = Request.Params["SYSTYPEVALUE"]; var vMenu = T_SYS_MENUCls.getModel(new T_SYS_MENU_SW { MENUCODE = "004004", SYSFLAG = ConfigCls.getSystemFlag() }); NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1"); //添加一个sheet sheet1.IsPrintGridlines = true; //打印时显示网格线 sheet1.DisplayGridlines = true; //查看时显示网格线 IRow row = sheet1.CreateRow(0); row.CreateCell(0).SetCellValue(vMenu.MENUNAME); row.GetCell(0).CellStyle = getCellStyleTitle(book); IEnumerable <T_IPSCOL_COLLECT_TypeCountModel> typeModel; var list = T_IPSCOL_COLLECTCls.getModelCount(new T_IPSCOL_COLLECT_SW { TopORGNO = BYORGNO, DateBegin = TIMEBegin, DateEnd = TIMEEnd }, out typeModel); int typeCount = 0;//计算类别有多少列 foreach (var v in typeModel) { typeCount++; } sheet1.SetColumnWidth(0, 30 * 256); sheet1.SetColumnWidth(1, 20 * 256); for (int i = 0; i < typeCount; i++) { sheet1.SetColumnWidth(i + 2, 20 * 256); } row = sheet1.CreateRow(1); if (PublicCls.OrgIsZhen(BYORGNO) == false) { row.CreateCell(0).SetCellValue("单位"); } else { row.CreateCell(0).SetCellValue("姓名"); } row.CreateCell(1).SetCellValue("总数"); int indexType = 2;//从第二列开始 foreach (var v in typeModel) { row.CreateCell(indexType).SetCellValue(v.typeName); indexType++; } for (int i = 0; i < typeCount + 2; i++) { row.GetCell(i).CellStyle = getCellStyleHead(book); } sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 0, 0, typeCount + 1)); int rowI = 0; //数据行 foreach (var v in list) //循环获取数据 { row = sheet1.CreateRow(rowI + 2); if (string.IsNullOrEmpty(v.ORGName) == false) { row.CreateCell(0).SetCellValue(v.ORGName); row.GetCell(0).CellStyle = getCellStyleLeft(book); } else { row.CreateCell(0).SetCellValue(v.HName); row.GetCell(0).CellStyle = getCellStyleCenter(book); } row.CreateCell(1).SetCellValue(v.CollectCount); row.GetCell(1).CellStyle = getCellStyleCenter(book); int TypeI = 2;//类型开始列 foreach (var vv in v.TypeCountModel) { row.CreateCell(TypeI).SetCellValue(vv.typeCount); row.GetCell(TypeI).CellStyle = getCellStyleCenter(book); TypeI++; } rowI++; } // 写入到客户端 System.IO.MemoryStream ms = new System.IO.MemoryStream(); book.Write(ms); ms.Seek(0, SeekOrigin.Begin); string fileName = vMenu.MENUNAME + DateTime.Now.ToString("yyyy-MM-dd") + ".xls"; return(File(ms, "application/vnd.ms-excel", fileName)); }
/// <summary> /// 导出 /// </summary> /// <returns></returns> public FileResult HUCountExportExcel() { var vMenu = T_SYS_MENUCls.getModel(new T_SYS_MENU_SW { MENUCODE = "004001", SYSFLAG = ConfigCls.getSystemFlag() }); //vMenu.MENUNAME 页面/菜单名称 NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); //添加一个sheet NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1"); sheet1.IsPrintGridlines = true; //打印时显示网格线 sheet1.DisplayGridlines = true; //查看时显示网格线 sheet1.SetColumnWidth(0, 50 * 256); sheet1.SetColumnWidth(1, 10 * 256); sheet1.SetColumnWidth(2, 10 * 256); sheet1.SetColumnWidth(3, 10 * 256); sheet1.SetColumnWidth(4, 10 * 256); sheet1.SetColumnWidth(5, 10 * 256); IRow row = sheet1.CreateRow(0); row.CreateCell(0).SetCellValue(vMenu.MENUNAME); row.GetCell(0).CellStyle = getCellStyleTitle(book); row = sheet1.CreateRow(1); row.CreateCell(0).SetCellValue("单位"); row.CreateCell(1).SetCellValue("总数"); row.CreateCell(2).SetCellValue("性别"); row.CreateCell(4).SetCellValue("固/兼职"); row.GetCell(0).CellStyle = getCellStyleHead(book); row.GetCell(1).CellStyle = getCellStyleHead(book); row.GetCell(2).CellStyle = getCellStyleHead(book); row.GetCell(4).CellStyle = getCellStyleHead(book); row = sheet1.CreateRow(2); row.CreateCell(2).SetCellValue("男"); row.CreateCell(3).SetCellValue("女"); row.CreateCell(4).SetCellValue("固职"); row.CreateCell(5).SetCellValue("兼职"); row.GetCell(2).CellStyle = getCellStyleHead(book); row.GetCell(3).CellStyle = getCellStyleHead(book); row.GetCell(4).CellStyle = getCellStyleHead(book); row.GetCell(5).CellStyle = getCellStyleHead(book); sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 0, 0, 5)); sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(1, 1, 2, 3)); sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(1, 1, 4, 5)); sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(1, 2, 0, 0)); sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(1, 2, 1, 1)); T_IPSFR_USER_SW sw = new T_IPSFR_USER_SW(); sw.TopORGNO = Request.Params["TopORGNO"]; var list = HUReportCls.getHUCountModel(sw); int rowI = 0; foreach (var item in list) { row = sheet1.CreateRow(rowI + 3); row.CreateCell(0).SetCellValue(item.ORGName); row.CreateCell(1).SetCellValue(item.HUCount); row.CreateCell(2).SetCellValue(item.Sex0Count); row.CreateCell(3).SetCellValue(item.Sex1Count); row.CreateCell(4).SetCellValue(item.Onstate0Count); row.CreateCell(5).SetCellValue(item.Onstate1Count); for (int i = 0; i < 6; i++) { if (i == 0) { row.GetCell(0).CellStyle = getCellStyleLeft(book); } else { row.GetCell(i).CellStyle = getCellStyleCenter(book); } } rowI++; } // 写入到客户端 System.IO.MemoryStream ms = new System.IO.MemoryStream(); book.Write(ms); ms.Seek(0, SeekOrigin.Begin); string fileName = vMenu.MENUNAME + DateTime.Now.ToString("yyyy-MM-dd") + ".xls"; return(File(ms, "application/vnd.ms-excel", fileName)); }