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 IssueSubscribeToExcel(IssueSubscribeQuery query, string strDict) { try { strDict = Server.UrlDecode(strDict); JavaScriptSerializer s = new JavaScriptSerializer(); Dictionary <string, object> JsonData = (Dictionary <string, object>)s.DeserializeObject(strDict); IDictionary <string, string> dict = ((object[])JsonData["dict"]).Select(p => (Dictionary <string, object>)p).ToDictionary(p => p["key"].ToString(), q => q["value"].ToString()); IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve <IIssueFacadeService>(); query.JournalID = CurAuthor.JournalID; IList <IssueSubscribeEntity> list = service.GetIssueSubscribeList(query); if (list == null || list.Count <= 0) { return(Content("没有数据不能导出,请先进行查询!")); } RenderToExcel.ExportListToExcel <IssueSubscribeEntity>(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 FinanceOutAccountRenderToExcel(ContributionInfoQuery query, string strDict) { try { IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>(); query.JournalID = CurAuthor.JournalID; query.IsReport = true; IList <FinanceAccountEntity> list = service.GetFinanceAccountPageList(query).ItemList; 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()); IList <FinanceAccountEntity> outList = list.Select(o => { o.LayoutFee = Math.Round(o.LayoutFee / 100 * query.Percent); return(o); }).ToList <FinanceAccountEntity>(); RenderToExcel.ExportListToExcel <FinanceAccountEntity>(list, dict , null , "出款_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls"); return(Content("导出成功!")); } catch (Exception ex) { LogProvider.Instance.Error("导出入款登记与通知信息出现异常:" + ex.Message); return(Content("导出入款登记与通知信息异常!")); } }
public JsonResult ExpertPayMoneyRenderToExcel(WorkloadQuery query, string strDict) { try { IAuthorFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorFacadeService>(); IAuthorPlatformFacadeService serviceAuthorPlatform = ServiceContainer.Instance.Container.Resolve <IAuthorPlatformFacadeService>(); query.JournalID = CurAuthor.JournalID; query.GroupID = query.GroupID; IList <WorkloadEntity> list = service.GetWorkloadList(query); IList <AuthorDetailEntity> listDetail = serviceAuthorPlatform.GetAuthorDetailList(new AuthorDetailQuery() { GroupID = 3, JournalID = JournalID }); list = (from author in list join authorDetail in listDetail on author.AuthorID equals authorDetail.AuthorID into JionauthorDetail from authorDetail in JionauthorDetail.DefaultIfEmpty() select new WorkloadEntity() { RealName = author.RealName, LoginName = author.LoginName, AlreadyCount = author.AlreadyCount, WaitCount = author.WaitCount, ZipCode = authorDetail.ZipCode, Address = authorDetail.Address }).ToList <WorkloadEntity>(); if (list == null || list.Count <= 0) { return(Json(new { flag = "error", msg = "没有数据不能导出,请先进行查询!" })); } 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()); RenderToExcel.ExportListToExcel <WorkloadEntity>(list, dict , null , "专家审稿费信息_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls"); return(Json(new { flag = "success" })); } catch (Exception ex) { LogProvider.Instance.Error("导出作者信息出现异常:" + ex.Message); return(Json(new { flag = "error", msg = "导出作者信息异常!" })); } }
public ActionResult ContributionAccountToExcel(ContributionAccountQuery query, string strDict) { string msg = string.Empty; try { IAuthorPlatformFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorPlatformFacadeService>(); query.JournalID = CurAuthor.JournalID; query.IsReport = true; 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()); IList <ContributionAccountEntity> list = new List <ContributionAccountEntity>(); IList <FlowStatusEntity> listFs = new List <FlowStatusEntity>(); IList <FlowContribution> listFc = new List <FlowContribution>(); switch (query.Kind) { case 4: msg = "按过程稿统计收稿量"; listFs = GetContributionProcessList(); break; case 3: msg = "按退稿统计收稿量"; listFc = GetContributionReturnList(); break; case 2: msg = "按作者统计收稿量"; var pager = service.GetContributionAccountListByAuhor(query); if (pager != null) { list = pager.ItemList; } break; case 1: msg = "按基金统计收稿量"; list = service.GetContributionAccountListByFund(query); break; case 0: msg = "按时间统计收稿量"; list = service.GetContributionAccountListByYear(query); break; } if (query.Kind == 1 || query.Kind == 2 || query.Kind == 0) { if (list == null || list.Count <= 0) { return(Content("没有数据不能导出,请先进行查询!")); } RenderToExcel.ExportListToExcel <ContributionAccountEntity>(list, dict , null , msg + "_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls"); } else if (query.Kind == 3) { if (listFc == null || listFc.Count <= 0) { return(Content("没有数据不能导出,请先进行查询!")); } RenderToExcel.ExportListToExcel <FlowContribution>(listFc, dict , null , msg + "_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls"); } else if (query.Kind == 4) { if (listFs == null || listFs.Count <= 0) { return(Content("没有数据不能导出,请先进行查询!")); } RenderToExcel.ExportListToExcel <FlowStatusEntity>(listFs, dict , null , msg + "_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls"); } return(Content("导出成功!")); } catch (Exception ex) { LogProvider.Instance.Error("导出" + msg + "出现异常:" + ex.Message); return(Content("导出" + msg + "异常!")); } }