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 ContributionInfoEntity GetModel(ContributionInfoQuery query) { IContributionInfoService service = ServiceContainer.Instance.Container.Resolve <IContributionInfoService>(); ContributionInfoEntity model = service.GetContributionInfo(query); return(model); }
public string GetContributionAttachment(ContributionInfoQuery cQuery) { IContributionInfoService service = ServiceContainer.Instance.Container.Resolve <IContributionInfoService>(); string result = service.GetContributionAttachment(cQuery); return(result); }
public Pager <FinanceAccountEntity> GetFinanceGaoFeePageList(ContributionInfoQuery query) { IFinanceContributeService service = ServiceContainer.Instance.Container.Resolve <IFinanceContributeService>(); Pager <FinanceAccountEntity> pager = service.GetFinanceGaoFeePageList(query); return(pager); }
public ExecResult ChangeStatus(ContributionInfoQuery query) { IContributionInfoService service = ServiceContainer.Instance.Container.Resolve <IContributionInfoService>(); ExecResult result = service.ChangeStatus(query); return(result); }
public IList <ContributionInfoEntity> GetList(ContributionInfoQuery query) { IContributionInfoService service = ServiceContainer.Instance.Container.Resolve <IContributionInfoService>(); IList <ContributionInfoEntity> pager = service.GetContributionInfoList(query); return(pager); }
/// <summary> /// 获取稿件数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public IList <ContributionInfoEntity> GetContributionInfoList(ContributionInfoQuery query) { IList <ContributionInfoEntity> listC = ContributionInfoBusProvider.GetContributionInfoList(query); if (query.IsAuxiliary) { JournalChannelQuery jChannelQuery = new JournalChannelQuery(); jChannelQuery.JournalID = query.JournalID; IssueService service = new IssueService(); IList <JournalChannelEntity> list = service.GetJournalChannelList(jChannelQuery); foreach (ContributionInfoEntity item in listC) { JournalChannelEntity itemChannel = list.SingleOrDefault(p => p.JChannelID == item.JChannelID); if (itemChannel != null) { item.JChannelName = itemChannel.ChannelName; } item.AuthorList = GetContributionAuthorList(new ContributionAuthorQuery() { JournalID = item.JournalID, CID = item.CID }); } } return(listC); }
/// <summary> /// 获取稿件信息实体 /// </summary> /// <param name="query"></param> /// <returns></returns> public ContributionInfoEntity GetContributionInfo(ContributionInfoQuery query) { var model = ContributionInfoBusProvider.GetContributionInfo(query.CID); if (model == null) { return(model); } if (query.IsAuxiliary) { model.AuthorList = GetContributionAuthorList(new ContributionAuthorQuery() { JournalID = query.JournalID, CID = query.CID, isModify = query.isModify }); model.ReferenceList = GetContributionReferenceList(new ContributionReferenceQuery() { JournalID = query.JournalID, CID = query.CID }); model.FundList = GetContributionFundList(new ContributionFundQuery() { JournalID = query.JournalID, CID = query.CID }); model.AttModel = GetContributionInfoAttByCID(query.CID); } return(model); }
/// <summary> /// 改变稿件状态 /// </summary> /// <param name="query"></param> /// <returns></returns> public ExecResult ChangeContributionInfoStatus(ContributionInfoQuery query) { HttpClientHelper clientHelper = new HttpClientHelper(); ExecResult result = clientHelper.Post <ExecResult, ContributionInfoQuery>(GetAPIUrl(APIConstant.CONTRIBUTIONINFO_CHANGESTATUS), query); return(result); }
/// <summary> /// 获取财务入款通知分页列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public Pager <FinanceAccountEntity> GetFinanceAccountPageList(ContributionInfoQuery query) { HttpClientHelper clientHelper = new HttpClientHelper(); Pager <FinanceAccountEntity> pager = clientHelper.PostAuth <Pager <FinanceAccountEntity>, ContributionInfoQuery>(GetAPIUrl(APIConstant.FINANCEACCOUNT_GETPAGELIST), query); return(pager); }
/// <summary> /// 删除稿件数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public ExecResult DelContributionInfo(ContributionInfoQuery query) { HttpClientHelper clientHelper = new HttpClientHelper(); ExecResult result = clientHelper.Post <ExecResult, ContributionInfoQuery>(GetAPIUrl(APIConstant.CONTRIBUTIONINFO_DEL), query); return(result); }
/// <summary> /// 获取稿件实体 /// </summary> /// <param name="query"></param> /// <returns></returns> public ContributionInfoEntity GetContributionInfoModel(ContributionInfoQuery query) { HttpClientHelper clientHelper = new HttpClientHelper(); ContributionInfoEntity model = clientHelper.Post <ContributionInfoEntity, ContributionInfoQuery>(GetAPIUrl(APIConstant.CONTRIBUTIONINFO_GETMODEL), query); return(model); }
/// <summary> /// 获取稿件数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public IList <ContributionInfoEntity> GetContributionInfoList(ContributionInfoQuery query) { HttpClientHelper clientHelper = new HttpClientHelper(); IList <ContributionInfoEntity> list = clientHelper.Post <IList <ContributionInfoEntity>, ContributionInfoQuery>(GetAPIUrl(APIConstant.CONTRIBUTIONINFO_GETLIST), query); return(list); }
/// <summary> /// 获取稿件分页数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public Pager <ContributionInfoEntity> GetContributionInfoPageList(ContributionInfoQuery query) { HttpClientHelper clientHelper = new HttpClientHelper(); Pager <ContributionInfoEntity> pager = clientHelper.Post <Pager <ContributionInfoEntity>, ContributionInfoQuery>(GetAPIUrl(APIConstant.CONTRIBUTIONINFO_GETPAGELIST), query); return(pager); }
/// <summary> /// 提交审稿单 /// </summary> /// <param name="auditBillEntity"></param> /// <returns></returns> public bool SubmitAuditBill(AuditBillEntity auditBillEntity) { bool flag = false; // 得到审稿操作信息 FlowActionQuery actionQuery = new FlowActionQuery(); actionQuery.ActionID = auditBillEntity.ActionID; actionQuery.JournalID = auditBillEntity.JournalID; FlowActionEntity actionEntity = new FlowActionService().GetFlowActionEntity(actionQuery); // 得到审稿状态及配置信息 FlowStatusQuery flowStatusQuery = new FlowStatusQuery(); flowStatusQuery.JournalID = auditBillEntity.JournalID; flowStatusQuery.StatusID = actionEntity == null ? 0 : actionEntity.StatusID; FlowStep flowStep = new FlowStatusService().GetFlowStep(flowStatusQuery); //得到稿件信息 ContributionInfoEntity contributionInfoEntity = new ContributionInfoEntity(); ContributionInfoQuery query = new ContributionInfoQuery(); query.JournalID = auditBillEntity.JournalID; query.CID = auditBillEntity.CID; ContributionInfoService service = new ContributionInfoService(); contributionInfoEntity = service.GetContributionInfo(query); if (contributionInfoEntity.AuthorID == Convert.ToInt64(auditBillEntity.ReveiverList.Split(',')[0])) { auditBillEntity.ReveiverList = contributionInfoEntity.AuthorID.ToString(); flag = FlowCirculationBusProvider.ProcessFlowCirulation(auditBillEntity); } else { flag = FlowCirculationBusProvider.ProcessFlowCirulation(auditBillEntity); } if (flag) { if (flowStep.FlowConfig != null) { if (flowStep.FlowConfig.IsEmailRemind) { /// TODO:记录定期发送邮件的任务 } if (flowStep.FlowConfig.IsSMSRemind) { /// TODO:记录定期发送短信的任务 } } } return(flag); }
public ActionResult GetFinanceAccountPageList(ContributionInfoQuery query) { IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>(); query.JournalID = CurAuthor.JournalID; query.OrderStr = Request.Params["sortorder"];//排序类型(只按稿件编号排序) query.CurrentPage = Convert.ToInt32(Request.Params["page"]); query.PageSize = Convert.ToInt32(Request.Params["pagesize"]); Pager <FinanceAccountEntity> pager = service.GetFinanceAccountPageList(query); return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords })); }
public ActionResult AuthorManuscript(Int64[] CIDs) { IAuthorPlatformFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorPlatformFacadeService>(); ContributionInfoQuery query = new ContributionInfoQuery(); query.JournalID = CurAuthor.JournalID; query.CIDs = CIDs; query.Status = -100; ExecResult result = service.ChangeContributionInfoStatus(query); return(Json(new { result = result.result, msg = result.result.Equals(EnumJsonResult.success.ToString()) ? "撤稿成功!" : "撤稿失败!" })); }
public ActionResult GetAuthorPageList(ContributionInfoQuery query) { IAuthorPlatformFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorPlatformFacadeService>(); query.JournalID = CurAuthor.JournalID; //query.Status = -3; query.CurrentPage = Convert.ToInt32(Request.Params["page"]); query.PageSize = Convert.ToInt32(Request.Params["pagesize"]); query.OrderStr = " AddDate desc"; Pager <ContributionInfoEntity> pager = service.GetContributionInfoPageList(query); return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords })); }
public ActionResult GetFinanceOutAccountPageList(ContributionInfoQuery query) { IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>(); query.JournalID = CurAuthor.JournalID; query.Year = Convert.ToInt32(query.Year) == 0 ? -1 : query.Year; query.Issue = Convert.ToInt32(query.Issue) == 0 ? -1 : query.Issue; query.CurrentPage = Convert.ToInt32(Request.Params["page"]); query.PageSize = Convert.ToInt32(Request.Params["pagesize"]); Pager <FinanceAccountEntity> pager = service.GetFinanceAccountPageList(query); return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords })); }
/// <summary> /// 改变稿件状态 /// </summary> /// <param name="query"></param> /// <returns></returns> public ExecResult ChangeStatus(ContributionInfoQuery query) { ExecResult result = new ExecResult(); bool flag = ContributionInfoBusProvider.ChangeStatus(query); if (flag) { result.result = EnumJsonResult.success.ToString(); result.msg = "更新稿件状态成功!"; } else { result.result = EnumJsonResult.failure.ToString(); result.msg = "更新稿件状态失败!"; } return(result); }
public ExecResult UpdateIntroLetter(ContributionInfoQuery model) { IContributionInfoService service = ServiceContainer.Instance.Container.Resolve <IContributionInfoService>(); bool flag = service.UpdateIntroLetter(model); ExecResult result = new ExecResult(); if (flag) { result.result = EnumJsonResult.success.ToString(); } else { result.result = EnumJsonResult.error.ToString(); result.msg = "更新介绍信标记出现异常,请稍后再试"; } return(result); }
public ActionResult FinanceAccountToExcel(ContributionInfoQuery query) { IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>(); query.JournalID = CurAuthor.JournalID; query.IsReport = true; IList <FinanceAccountEntity> list = service.GetFinanceAccountPageList(query).ItemList; string[] titleFiles = new string[] { "稿件编号", "稿件标题", "审稿费(通知)", "版面费(通知)", "审稿费(已入款)", "备注", "版面费(已入款)", "备注", "第一作者", "通讯作者", "联系电话", "手机", "发票单位", "邮编", "投稿日期" }; int[] titleWidth = new int[] { 60, 200, 60, 60, 70, 80, 70, 80, 50, 50, 70, 70, 120, 40, 120 }; string[] dataFiles = new string[] { "CNumber", "Title", "ReadingFeeNoticeStatus", "LayoutFeeNoticeStatus", "ReadingFeeStr", "Note", "LayoutFeeStr", "PageNote", "FirstAuthor", "CommunicationAuthor", "Tel", "Mobile", "InvoiceUnit", "ZipCode", "AddDate" }; string[] fomateFiles = new string[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "{0:yyyy-MM-dd}" }; string strTempPath = "/UploadFile/TempFile/" + "FinanceAccount.xls"; ExcelHelperEx.CreateExcel <FinanceAccountEntity>("作者版面费报表", titleFiles, titleWidth, dataFiles, fomateFiles, list, strTempPath); return(Json(new { flag = 1, ExcelPath = strTempPath })); }
public ExecResult CancelDelete(ContributionInfoQuery cEntity) { IContributionInfoService service = ServiceContainer.Instance.Container.Resolve <IContributionInfoService>(); bool flag = service.CancelDelete(cEntity); ExecResult result = new ExecResult(); if (flag) { result.result = EnumJsonResult.success.ToString(); } else { result.result = EnumJsonResult.error.ToString(); result.msg = "撤销删除出现异常,请稍后再试"; } return(result); }
public ActionResult FinanceGaoFeeToExcel(ContributionInfoQuery query) { try { IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>(); query.JournalID = CurAuthor.JournalID; query.Status = 1; query.IsReport = true; if (SiteConfig.GaoFeeText3 > 0) { query.isPageFeeGet = true; } IList <FinanceAccountEntity> list = service.GetFinanceGaoFeePageList(query).ItemList; if (list == null || list.Count <= 0) { return(Content("没有数据不能导出,请先进行查询!")); } string strTempPath = "/UploadFile/TempFile/" + "FinanceGaoFee.xls"; if (SiteConfig.GaoFeeText3 > 0) { for (int i = 0; i < list.Count; i++) { list[i].ArticlePaymentFee = list[i].LayoutFee * SiteConfig.GaoFeeText3 / 100; } string[] titleFiles = new string[] { "稿件编号", "稿件标题", "第一作者", "通讯作者", "发票抬头", "应付稿费", "手机", "联系电话", "单位", "地址", "邮编" }; int[] titleWidth = new int[] { 80, 200, 40, 40, 100, 60, 80, 90, 100, 150, 60 }; string[] dataFiles = new string[] { "CNumber", "Title", "FirstAuthor", "CommunicationAuthor", "InvoiceUnit", "ArticlePaymentFee", "Mobile", "Tel", "WorkUnit", "Address", "ZipCode" }; string[] fomateFiles = new string[] { "", "", "", "", "", "", "", "", "", "", "" }; ExcelHelperEx.CreateExcel <FinanceAccountEntity>("作者稿费统计一览表", titleFiles, titleWidth, dataFiles, fomateFiles, list, strTempPath); } else { string[] titleFiles = new string[] { "稿件编号", "稿件标题", "第一作者", "通讯作者", "发票抬头", "应付稿费", "稿费备注", "手机", "联系电话", "单位", "地址", "邮编" }; int[] titleWidth = new int[] { 80, 200, 40, 40, 100, 60, 80, 80, 90, 100, 150, 60 }; string[] dataFiles = new string[] { "CNumber", "Title", "FirstAuthor", "CommunicationAuthor", "InvoiceUnit", "ArticlePaymentFeeStr", "ArticlePaymentNote", "Mobile", "Tel", "WorkUnit", "Address", "ZipCode" }; string[] fomateFiles = new string[] { "", "", "", "", "", "", "", "", "", "", "", "" }; ExcelHelperEx.CreateExcel <FinanceAccountEntity>("作者稿费统计一览表", titleFiles, titleWidth, dataFiles, fomateFiles, list, strTempPath); } return(Json(new { flag = 1, ExcelPath = strTempPath })); } catch (Exception ex) { LogProvider.Instance.Error("导出作者稿费信息出现异常:" + ex.Message); return(Content("导出作者稿费信息异常!")); } }
private void GetFilePath() { // 根据稿件ID或者流程日志ID得到稿件路径 long CIDParam = 0; if (!string.IsNullOrEmpty(Request.QueryString["CID"])) { CIDParam = TypeParse.ToLong(Request.QueryString["CID"], 0); } // 日志ID long FlowLogID = 0; if (!string.IsNullOrEmpty(Request.QueryString["FlowID"])) { FlowLogID = TypeParse.ToLong(Request.QueryString["FlowID"], 0); } if (CIDParam > 0) { IContributionFacadeService cService = ServiceContainer.Instance.Container.Resolve <IContributionFacadeService>(); // 得到稿件路径 ContributionInfoQuery cQuery = new ContributionInfoQuery(); cQuery.JournalID = SiteConfig.SiteID; cQuery.CID = CIDParam; _filePath = cService.GetContributionAttachment(cQuery); } else if (FlowLogID > 0) { IFlowFacadeService flowService = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>(); // 附件路径 FlowLogQuery logQuery = new FlowLogQuery(); logQuery.JournalID = SiteConfig.SiteID; logQuery.FlowLogID = FlowLogID; _filePath = flowService.GetFlowLogAttachment(logQuery); } if (!string.IsNullOrEmpty(Request.QueryString["fileName"])) { _fileName = Request.QueryString["fileName"]; } else { _fileName = "在线审阅稿件"; } }
/// <summary> /// 获取财务出款通知分页列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public Pager <FinanceAccountEntity> GetFinanceOutAccountPageList(ContributionInfoQuery query) { Pager <FinanceAccountEntity> pager = FinanceContributeBusProvider.GetFinanceOutAccountPageList(query); if (pager == null) { return(pager); } IList <FinanceAccountEntity> list = pager.ItemList; if (list == null || list.Count == 0) { return(pager); } AuthorInfoService service = new AuthorInfoService(); AuthorInfoQuery aQuery = new AuthorInfoQuery(); aQuery.JournalID = query.JournalID; pager.ItemList = list; return(pager); }
/// <summary> /// 组装数据 /// </summary> /// <param name="list"></param> /// <returns></returns> private List <MessageRecodeEntity> GetMsgList(List <MessageRecodeEntity> list, MessageRecodeQuery mQuery) { if (list == null || list.Count == 0) { return(list); } AuthorInfoService service = new AuthorInfoService(); AuthorInfoEntity entity = new AuthorInfoEntity(); AuthorInfoQuery query = new AuthorInfoQuery(); query.JournalID = mQuery.JournalID; var dict = service.AuthorInfoBusProvider.GetAuthorDict(query); //获取稿件作者数据字典 ContributionInfoService cservice = new ContributionInfoService(); ContributionInfoEntity centity = new ContributionInfoEntity(); ContributionInfoQuery cquery = new ContributionInfoQuery(); cquery.JournalID = mQuery.JournalID; cquery.CID = (long)mQuery.CID; var cdict = cservice.GetContributionAuthorDict(cquery); centity = cservice.GetContributionInfo(cquery); foreach (var mode in list) { mode.SendUserName = dict.GetValue(mode.SendUser, mode.SendUser.ToString()); entity = service.GetAuthorInfo(mode.ReciveUser); if (entity != null) { mode.ReciveUserName = dict.GetValue(mode.ReciveUser, mode.ReciveUser.ToString()); } else { mode.ReciveUserName = cdict.GetValue(mode.ReciveUser, mode.ReciveUser.ToString()); } } return(list); }
/// <summary> /// 获取财务入款通知分页列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public Pager <FinanceAccountEntity> GetFinanceAccountPageList(ContributionInfoQuery query) { Pager <FinanceAccountEntity> pager = FinanceContributeBusProvider.GetFinanceAccountPageList(query); if (pager == null) { return(pager); } IList <FinanceAccountEntity> list = pager.ItemList; if (list == null || list.Count == 0) { return(pager); } //AuthorInfoService service = new AuthorInfoService(); //AuthorInfoQuery aQuery = new AuthorInfoQuery(); //aQuery.JournalID = query.JournalID; //var dict = service.AuthorInfoBusProvider.GetAuthorDict(aQuery); //foreach (var mode in list) //{ // mode.EditAuthorName = dict.GetValue(mode.EditAuthorID, mode.EditAuthorID.ToString()); // mode.FirstAuthor = dict.GetValue(mode.FirstAuthorID, mode.FirstAuthorID.ToString()); //} ContributionInfoService service = new ContributionInfoService(); ContributionInfoQuery cQuery = new ContributionInfoQuery(); cQuery.JournalID = query.JournalID; var dict = service.ContributionInfoBusProvider.GetContributionAuthorDict(cQuery); //foreach (var mode in list) //{ // //mode.EditAuthorName = dict.GetValue(mode.EditAuthorID, mode.EditAuthorID.ToString()); // mode.FirstAuthor = dict.GetValue(mode.FirstAuthorID, mode.FirstAuthorID.ToString()); //} pager.ItemList = list; return(pager); }
/// <summary> /// 获取稿费统计一览表分页数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public Pager <FinanceAccountEntity> GetFinanceGaoFeePageList(ContributionInfoQuery query) { Pager <FinanceAccountEntity> pager = FinanceContributeBusProvider.GetFinanceGaoFeePageList(query); if (pager == null) { return(pager); } IList <FinanceAccountEntity> list = pager.ItemList; if (list == null || list.Count == 0) { return(pager); } ContributionInfoService service = new ContributionInfoService(); ContributionInfoQuery cQuery = new ContributionInfoQuery(); cQuery.JournalID = query.JournalID; var dict = service.ContributionInfoBusProvider.GetContributionAuthorDict(cQuery); pager.ItemList = list; return(pager); }
public ActionResult GetFinanceGaoFeePageList(ContributionInfoQuery query) { IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>(); query.JournalID = CurAuthor.JournalID; if (SiteConfig.GaoFeeText3 > 0) { query.isPageFeeGet = true; } query.OrderStr = Request.Params["sortorder"];//排序类型(只按稿件编号排序) query.CurrentPage = Convert.ToInt32(Request.Params["page"]); query.PageSize = Convert.ToInt32(Request.Params["pagesize"]); Pager <FinanceAccountEntity> pager = service.GetFinanceGaoFeePageList(query); if (SiteConfig.GaoFeeText3 > 0) { return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords, SolidMoney = (pager.Money * SiteConfig.GaoFeeText3 / 100).ToString("C2") })); } else { return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords, SolidMoney = pager.Money.ToString("C2") })); } }