public ActionResult ExpertRenderToExcel(AuthorDetailQuery query, string strDict) { try { IAuthorPlatformFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorPlatformFacadeService>(); query.JournalID = CurAuthor.JournalID; query.GroupID = 3; IList <AuthorDetailEntity> list = service.GetAuthorDetailList(query); if (list == null || list.Count <= 0) { return(Content("没有数据不能导出,请先进行查询!")); } strDict = Server.UrlDecode(strDict); JavaScriptSerializer s = new JavaScriptSerializer(); Dictionary <string, object> JsonData = (Dictionary <string, object>)s.DeserializeObject(strDict); IDictionary <string, string> dict = ((object[])JsonData.First().Value).Select(p => (Dictionary <string, object>)p).ToDictionary(p => p["key"].ToString(), q => q["value"].ToString()); //获取学历[Education]数据字典显示名-dict2[list[i].Education].ToString() ISiteConfigFacadeService service2 = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); DictValueQuery query2 = new DictValueQuery(); query2.JournalID = CurAuthor.JournalID; query2.DictKey = "Education"; IDictionary <int, string> dict2 = service2.GetDictValueDcit(query2); //获取职称[JobTitle]数据字典显示名-dict3[list[i].JobTitle].ToString() DictValueQuery query3 = new DictValueQuery(); query3.JournalID = CurAuthor.JournalID; query3.DictKey = "JobTitle"; IDictionary <int, string> dict3 = service2.GetDictValueDcit(query3); //替换字段内容 if (dict != null && dict.Count > 0) { for (int i = 0; i < list.Count; i++) { if (list[i].AuthorModel.GroupID == 2) { list[i].ReserveField2 = "作者"; } if (list[i].AuthorModel.Status == 1) { list[i].ReserveField3 = "正常"; } else { list[i].ReserveField3 = "已停用"; } list[i].ReserveField4 = dict2[list[i].Education].ToString(); list[i].ReserveField5 = dict3[list[i].JobTitle].ToString(); } } //开始导出Excel RenderToExcel.ExportListToExcel <AuthorDetailEntity>(list, dict , null , "专家信息_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls"); return(Content("导出成功!")); } catch (Exception ex) { LogProvider.Instance.Error("导出专家信息出现异常:" + ex.Message); return(Content("导出专家信息异常!")); } }
public ActionResult Index() { string url = Request.QueryString["url"]; ViewBag.RETURL = url; ViewBag.IsShowMoreRole = false; if (CurAuthor != null) { if (CurAuthor.RoleIDList != null) { if (CurAuthor.GroupID == (Byte)EnumMemberGroup.Editor && CurAuthor.RoleIDList.Count > 1) { ViewBag.RoleList = SelectRole("selRoleList", "65px;"); ViewBag.IsShowMoreRole = true; } if (CurAuthor.GroupID == (Byte)EnumMemberGroup.Expert && CurAuthor.RoleIDList.Count > 1) { ViewBag.RoleList = SelectExpertRole("selRoleList", "80px;"); ViewBag.IsShowMoreRole = true; } if (CurAuthor.GroupID == (Byte)EnumMemberGroup.Author && CurAuthor.RoleIDList.Count > 1) { ViewBag.RoleList = SelectAuthorRole("selRoleList", "80px;"); ViewBag.IsShowMoreRole = true; } } ViewBag.Group = CurAuthor.GroupID; ViewBag.Author = CurAuthor.AuthorID; ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); DictValueQuery query = new DictValueQuery(); query.JournalID = SiteConfig.SiteID; query.DictKey = "NotAccessSearch"; IDictionary <int, string> dict = service.GetDictValueDcit(query); if (dict != null && dict.Count > 0) { foreach (var item in dict) { if (item.Value == CurAuthor.AuthorID.ToString()) { ViewBag.IsShowSearch = false; break; } else { ViewBag.IsShowSearch = true; } } } } //ISiteConfigFacadeService facadeService = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>(); //DictValueQuery dictQuery = new DictValueQuery(); //dictQuery.JournalID = JournalID; //dictQuery.DictKey = "NotAccessSearch"; //IList<DictValueEntity> dictList = facadeService.GetDictValueList(dictQuery); //文海峰 2014-1-8 IFlowFacadeService siteConfigService = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>(); IList <FlowStatusEntity> flowStatuslist = siteConfigService.GetFlowStatusList(new FlowStatusQuery() { JournalID = JournalID }); ViewBag.flowStatuslist = flowStatuslist; return(View()); }