/// <summary> /// 返回查询表格 /// </summary> /// <returns></returns> public ActionResult getHUCountJson() { T_IPSFR_USER_SW sw = new T_IPSFR_USER_SW(); sw.TopORGNO = Request.Params["TopORGNO"]; var list = HUReportCls.getHUCountModel(sw); StringBuilder sb = new StringBuilder(); sb.AppendFormat("<table id=\"tb\" cellpadding=\"0\" cellspacing=\"0\">"); sb.AppendFormat("<thead>"); sb.AppendFormat(" <tr>"); sb.AppendFormat(" <th rowspan=\"2\">单位</th>"); sb.AppendFormat(" <th rowspan=\"2\">总数</th>"); sb.AppendFormat(" <th colspan=\"2\">性别</th>"); sb.AppendFormat(" <th colspan=\"2\">固/兼职</th>"); sb.AppendFormat(" </tr>"); sb.AppendFormat(" <tr>"); sb.AppendFormat(" <th>男</th>"); sb.AppendFormat(" <th>女</th>"); sb.AppendFormat(" <th>固职</th>"); sb.AppendFormat(" <th>兼职</th>"); sb.AppendFormat(" </tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); int i = 0; foreach (var item in list) { i++; if (i % 2 == 0) { sb.AppendFormat(" <tr>"); } else { sb.AppendFormat(" <tr class='row1'>"); } sb.AppendFormat("<td class=\"left\">{0}</td>", item.ORGName); sb.AppendFormat("<td class=\"center\">{0}</td>", item.HUCount); sb.AppendFormat("<td class=\"center\">{0}</td>", item.Sex1Count); sb.AppendFormat("<td class=\"center\">{0}</td>", item.Sex0Count); sb.AppendFormat("<td class=\"center\">{0}</td>", item.Onstate0Count); sb.AppendFormat("<td class=\"center\">{0}</td>", item.Onstate1Count); sb.AppendFormat("</tr>"); } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); return(Content(JsonConvert.SerializeObject(new Message(true, sb.ToString(), "")), "text/html;charset=UTF-8")); }
/// <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)); }