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