public JsonResult ApproverAgentLoad(string ApprovalNameOrMUDID, string AgentNameOrMUDID, int rows, int page) { int total; var list = IUserInfoService.ApproverAgentLoad(ApprovalNameOrMUDID, AgentNameOrMUDID, rows, page, out total); return(Json(new { state = 1, rows = list, total = total })); }
public ActionResult ExportApproverAgent(string ApprovalNameOrMUDID, string AgentNameOrMUDID) { int total = 0; var list = IUserInfoService.ApproverAgentLoad(ApprovalNameOrMUDID, AgentNameOrMUDID, int.MaxValue, 1, out total); if (list != null && list.Count > 0) { XSSFWorkbook book = new XSSFWorkbook(); #region var headerStyle = book.CreateCellStyle(); var headerStyle = book.CreateCellStyle(); var headerFontStyle = book.CreateFont(); headerFontStyle.Color = NPOI.HSSF.Util.HSSFColor.White.Index; headerFontStyle.Boldweight = short.MaxValue; headerFontStyle.FontHeightInPoints = 10; headerStyle.FillPattern = NPOI.SS.UserModel.FillPattern.SolidForeground; headerStyle.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.LightOrange.Index; headerStyle.Alignment = HorizontalAlignment.Center; headerStyle.SetFont(headerFontStyle); #endregion var sheet = book.CreateSheet("report"); var row = sheet.CreateRow(0); #region header sheet.SetColumnWidth(0, 30 * 256); sheet.SetColumnWidth(1, 30 * 256); sheet.SetColumnWidth(2, 30 * 256); sheet.SetColumnWidth(3, 30 * 256); sheet.SetColumnWidth(4, 30 * 256); sheet.SetColumnWidth(5, 30 * 256); sheet.SetColumnWidth(6, 30 * 256); var cell = row.CreateCell(0); cell.SetCellValue("申请人姓名"); cell.CellStyle = headerStyle; cell = row.CreateCell(1); cell.SetCellValue("申请人MUDID"); cell.CellStyle = headerStyle; cell = row.CreateCell(2); cell.SetCellValue("代理人姓名"); cell.CellStyle = headerStyle; cell = row.CreateCell(3); cell.SetCellValue("代理人MUDID"); cell.CellStyle = headerStyle; cell = row.CreateCell(4); cell.SetCellValue("开始日期"); cell.CellStyle = headerStyle; cell = row.CreateCell(5); cell.SetCellValue("结束日期"); cell.CellStyle = headerStyle; cell = row.CreateCell(6); cell.SetCellValue("是否启用"); cell.CellStyle = headerStyle; #endregion #region var dataCellStyle = book.CreateCellStyle(); var dataCellStyle = book.CreateCellStyle(); var dataFontStyle = book.CreateFont(); dataFontStyle.Color = NPOI.HSSF.Util.HSSFColor.Black.Index; dataFontStyle.Boldweight = short.MaxValue; dataFontStyle.FontHeightInPoints = 10; dataCellStyle.FillPattern = NPOI.SS.UserModel.FillPattern.SolidForeground; dataCellStyle.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.White.Index; //dataCellStyle.Alignment = HorizontalAlignment.Center; dataCellStyle.SetFont(dataFontStyle); #endregion P_UserDelegate disItm; int dataCnt = list.Count; for (int i = 0; i < dataCnt; i++) { disItm = list[i]; row = sheet.CreateRow(1 + i); #region data cell cell = row.CreateCell(0); cell.SetCellValue(disItm.UserName); // 审批人姓名 cell = row.CreateCell(1); cell.SetCellValue(disItm.UserMUDID); //申请人MUDID cell = row.CreateCell(2); cell.SetCellValue(disItm.DelegateUserName); // 代理人姓名 cell = row.CreateCell(3); cell.SetCellValue(disItm.DelegateUserMUDID); // 代理人MUDID cell = row.CreateCell(4); cell.SetCellValue(disItm.StartTime == null ? "" : disItm.StartTime.ToString("yyyy-MM-dd HH:mm:ss")); // 开始日期 cell = row.CreateCell(5); cell.SetCellValue(disItm.EndTime == null ? "" : disItm.EndTime.ToString("yyyy-MM-dd HH:mm:ss")); // 结束日期 cell = row.CreateCell(6); cell.SetCellValue(disItm.IsEnable == 0 ? "否" : "是"); // 是否启用 cell = row.CreateCell(7); #endregion } byte[] excelData; using (System.IO.MemoryStream _ms = new System.IO.MemoryStream()) { book.Write(_ms); excelData = _ms.ToArray(); //_ms.Close(); } var cont = "导出直线经理代理审批"; var num = operationAuditService.AddAudit("5", cont); ViewBag.Msg = "导出成功!"; return(File(excelData, "application/vnd.ms-excel", HttpUtility.UrlEncode("ApproverAgent_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xlsx", System.Text.Encoding.UTF8))); } else { ViewBag.Msg = "无符合条件数据!"; return(View()); } }