public ActionResult GetExpertWorkloadList(WorkloadQuery query) { decimal totalMoney = 0; IAuthorFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorFacadeService>(); query.JournalID = JournalID; int pageIndex = TypeParse.ToInt(Request.Params["page"], 1); int pageSize = TypeParse.ToInt(Request.Params["pageSize"], 15); IList <WorkloadEntity> listAuthor = service.GetWorkloadList(query); for (int i = 0; i < listAuthor.Count; i++) { listAuthor[i].ExpertReviewFee = (SiteConfig.ExpertReviewFee * listAuthor[i].AlreadyCount).ToString("C2"); totalMoney += SiteConfig.ExpertReviewFee * listAuthor[i].AlreadyCount; } if (query.isIgnoreNoWork == true) { listAuthor = listAuthor.Where(p => p.AlreadyCount > 0).OrderByDescending(x => x.AlreadyCount).ToList(); return(Json(new { Rows = listAuthor.Where(p => p.AlreadyCount > 0).Skip((pageIndex - 1) * pageSize).Take(pageSize), Total = listAuthor.Count, TotalMoney = totalMoney.ToString("C2") })); } else { return(Json(new { Rows = listAuthor.Skip((pageIndex - 1) * pageSize).Take(pageSize), Total = listAuthor.Count, TotalMoney = totalMoney.ToString("C2") })); } }
public ActionResult ExpertWorkloadListToExcel(WorkloadQuery query) { decimal totalMoney = 0; decimal money = Convert.ToDecimal(Request.Params["Money"]); IAuthorFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorFacadeService>(); query.JournalID = JournalID; int pageIndex = TypeParse.ToInt(Request.Params["page"], 1); IList <WorkloadEntity> listAuthor = service.GetWorkloadList(query); for (int i = 0; i < listAuthor.Count; i++) { listAuthor[i].ExpertReviewFee = (SiteConfig.ExpertReviewFee * listAuthor[i].AlreadyCount).ToString("C2"); totalMoney += SiteConfig.ExpertReviewFee * listAuthor[i].AlreadyCount; } string[] titleFiles = new string[] { "专家姓名", "登录名", "待审稿件", "已审稿件", "审稿费", "发票抬头", "户名", "帐号", "开户行", "专家单位", "专家地址", "邮编", "联系电话", "手机" }; int[] titleWidth = new int[] { 50, 100, 50, 50, 80, 100, 50, 150, 100, 120, 150, 50, 100, 80 }; string[] dataFiles = new string[] { "RealName", "LoginName", "WaitCount", "AlreadyCount", "ExpertReviewFee", "InvoiceUnit", "ReserveField1", "ReserveField2", "ReserveField3", "WorkUnit", "Address", "ZipCode", "Tel", "Mobile" }; string[] fomateFiles = new string[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; string strTempPath = "/UploadFile/TempFile/" + "ExpertWorkloadList.xls"; if (query.isIgnoreNoWork == true) { listAuthor = listAuthor.Where(p => p.AlreadyCount > 0).OrderByDescending(x => x.AlreadyCount).ToList(); ExcelHelperEx.CreateExcel <WorkloadEntity>("专家信息列表_审稿费每篇" + money + "元,总计_" + totalMoney + "元", titleFiles, titleWidth, dataFiles, fomateFiles, listAuthor, strTempPath); } else { ExcelHelperEx.CreateExcel <WorkloadEntity>("专家信息列表_审稿费每篇" + money + "元,总计_" + totalMoney + "元", titleFiles, titleWidth, dataFiles, fomateFiles, listAuthor, strTempPath); } return(Json(new { flag = 1, ExcelPath = strTempPath })); }
/// <summary> /// 获取编辑Model /// </summary> /// <param name="AuthorID"></param> /// <returns></returns> private AuthorDetailEntity GetEditorModel(Int64 AuthorID) { AuthorDetailEntity model = null; if (AuthorID > 0) { AuthorDetailQuery query = new AuthorDetailQuery(); query.JournalID = CurAuthor.JournalID; query.AuthorID = AuthorID; IAuthorPlatformFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorPlatformFacadeService>(); model = service.GetAuthorDetailModel(query); } if (model == null) { model = new AuthorDetailEntity(); } IAuthorFacadeService authorService = ServiceContainer.Instance.Container.Resolve <IAuthorFacadeService>(); var list = authorService.GetEditorFieldsSet(); if (list == null) { list = new List <FieldsSet>(); } list.Insert(0, new FieldsSet { DisplayName = "中文姓名", FieldName = "中文姓名", DBField = "AuthorName", IsShow = true, IsRequire = true }); model.FieldList = list.Where(p => p.IsShow).ToList(); if (model.AuthorModel == null) { model.AuthorModel = new AuthorInfoEntity(); } return(model); }
public ActionResult GetStatDetail(StatQuery query) { IAuthorFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorFacadeService>(); query.JournalID = JournalID; int pageIndex = TypeParse.ToInt(Request.Params["page"], 1); IList <StatDealContributionDetailEntity> listStatDetail = service.GetDealContributionDetail(query); return(Json(new { Rows = listStatDetail.Skip((pageIndex - 1) * 10).Take(10), Total = listStatDetail.Count })); }
public ActionResult GetContributionList(long SiteID, string EMail) { string contributions = string.Empty; //根据邮箱获取作者实体-得到作者ID IAuthorFacadeService authorService = ServiceContainer.Instance.Container.Resolve <IAuthorFacadeService>(); AuthorInfoQuery query = new AuthorInfoQuery(); query.LoginName = EMail; query.JournalID = SiteID; query.GroupID = (int)EnumMemberGroup.Author; AuthorInfoEntity authorInfoEntity = authorService.GetAuthorInfo(query); //获取作者最新状态的稿件列表 IFlowFacadeService flowService = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>(); CirculationEntity cirEntity = new CirculationEntity(); cirEntity.JournalID = SiteID; cirEntity.CurAuthorID = authorInfoEntity.AuthorID; //int pageIndex = TypeParse.ToInt(Request.Params["page"], 1); cirEntity.CurrentPage = 1; cirEntity.PageSize = TypeParse.ToInt(Request.Params["pagesize"], 100); Pager <FlowContribution> pager = flowService.GetAuthorContributionList(cirEntity); if (pager.ItemList.Count == 0) { return(base.Json(new { code = "1000002", msg = "没有查询到符合条件的数据。" }, JsonRequestBehavior.AllowGet));//没有稿件数据 } else if (pager.ItemList.Count == 1) { return(base.Json(new { code = "1000003", msg = "查询到1条符合条件的数据。" }, JsonRequestBehavior.AllowGet)); } else { contributions += "["; for (int i = 0; i < pager.ItemList.Count; i++) { contributions += "{\"Title\":\"" + pager.ItemList[i].Title + "\",\"AuthorName\":\"" + pager.ItemList[i].AuthorName + "\",\"AuditStatus\":\"" + pager.ItemList[i].AuditStatus + "\",\"AddDate\":\"" + pager.ItemList[i].AddDate + "\"},"; } contributions.Remove(contributions.LastIndexOf(','), 1); contributions += "]"; return(base.Json(new { code = "1000004", msg = "查询到" + pager.ItemList.Count + "条符合条件的数据。", Contributions = contributions }, JsonRequestBehavior.AllowGet)); } }
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 JsonResult GetNewEditorWorkloadList() { IAuthorFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorFacadeService>(); AuthorInfoQuery query = new AuthorInfoQuery(); query.JournalID = CurAuthor.JournalID; query.GroupID = (int)EnumMemberGroup.Editor; query.RoleID = 0; IList <AuthorInfoEntity> pager = service.GetAuthorListByRole(query); Dictionary <string, IList <FlowStatusEntity> > dic = new Dictionary <string, IList <FlowStatusEntity> >(); if (pager != null && pager.Count > 0) { foreach (var item in pager) { AuthorInfoQuery currentEntity = new AuthorInfoQuery(); currentEntity.AuthorID = item.AuthorID; IList <FlowStatusEntity> list = GetFlowStatusList(currentEntity); dic.Add(item.RealName + "-" + item.AuthorID + "-" + item.RoleID + "-" + item.RoleName, list); } } return(Json(dic)); }
/// <summary> /// 获取作者字段信息 /// </summary> /// <returns></returns> private IDictionary <string, string> GetAuthorDetail() { IDictionary <string, string> dict = new Dictionary <string, string>(); dict.Add("AuthorName", "中文名称"); dict.Add("AuthorModel.LoginName", "登录名"); //dict.Add("AuthorModel.Pwd", "登录密码"); //dict.Add("AuthorModel.GroupID", "用户类型"); //dict.Add("AuthorModel.Status", "用户状态"); dict.Add("ReserveField2", "用户类型"); dict.Add("ReserveField3", "用户状态"); IAuthorFacadeService authorService = ServiceContainer.Instance.Container.Resolve <IAuthorFacadeService>(); var list = authorService.GetFieldsSet(); foreach (var item in list) { if (!dict.ContainsKey(item.DBField)) { dict.Add(item.DBField, item.DisplayName); } } dict.Add("AuthorModel.AddDate", "注册时间"); return(dict); }
/// <summary> /// 单篇送排 /// </summary> /// <param name="CID"></param> /// <returns></returns> public ActionResult SingleSendTypesetting(long CID) { ExecResult eResult = new ExecResult(); FangZService.JournalXService jService = new FangZService.JournalXService(); try { # region get token // 验证令牌正确性 TokenQuery tokenQuery = new TokenQuery(); tokenQuery.JournalID = SiteConfig.SiteID; tokenQuery.AuthorID = 0; tokenQuery.Type = 3; tokenQuery.ExpireDate = DateTime.Now.AddDays(-7); IAuthorFacadeService authorService = ServiceContainer.Instance.Container.Resolve <IAuthorFacadeService>(); TokenEntity tokenEntity = authorService.GetToken(tokenQuery); string SafetyCode = ""; if (tokenEntity != null) { SafetyCode = tokenEntity.Token; } # endregion