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());
}
