public ActionResult FinanceGlanceToExcel(FinanceContributeQuery query) { try { IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>(); query.JournalID = CurAuthor.JournalID; query.Status = 1; query.IsReport = true; IList <FinanceContributeEntity> list = service.GetFinanceGlancePageList(query).ItemList; if (list == null || list.Count <= 0) { return(Content("没有数据不能导出,请先进行查询!")); } string[] titleFiles = new string[] { "稿件编号", "稿件标题", "通讯作者", "第一作者", "单位", "费用类型", "交费金额", "备注", "入款人", "入款日期", "发票抬头", "发票号码", "挂号号码", "寄出日期" }; int[] titleWidth = new int[] { 80, 200, 40, 40, 100, 40, 60, 100, 40, 80, 120, 100, 80, 100 }; string[] dataFiles = new string[] { "CNumber", "Title", "CommunicationAuthorName", "FirstAuthorName", "WorkUnit", "FeeTypeName", "Amount", "Note", "InUserName", "InComeDate", "InvoiceUnit", "InvoiceNo", "PostNo", "SendDate" }; string[] fomateFiles = new string[] { "", "", "", "", "", "", "", "", "", "{0:yyyy-MM-dd}", "", "", "", "{0:yyyy-MM-dd}" }; string strTempPath = "/UploadFile/TempFile/" + "FinanceGlance.xls"; ExcelHelperEx.CreateExcel <FinanceContributeEntity>("财务统计一览表", titleFiles, titleWidth, dataFiles, fomateFiles, list, strTempPath); return(Json(new { flag = 1, ExcelPath = strTempPath })); } catch (Exception ex) { LogProvider.Instance.Error("导出稿件费用信息出现异常:" + ex.Message); return(Content("导出稿件费用信息异常!")); } }
public ActionResult GetFinanceGlancePageList(FinanceContributeQuery query) { IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>(); query.JournalID = CurAuthor.JournalID; query.Status = 1; query.CurrentPage = Convert.ToInt32(Request.Params["page"]); query.PageSize = Convert.ToInt32(Request.Params["pagesize"]); Pager <FinanceContributeEntity> pager = service.GetFinanceGlancePageList(query); return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords, SolidMoney = pager.Money.ToString("C2") })); }