public ActionResult GetFinancePageFeeReportPageList(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.GetFinancePageFeeReportPageList(query); return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords, PageMoney = pager.PageMoney.ToString("C2") })); }
public ActionResult FinancePageFeeRenderToExcel(FinanceContributeQuery query) { IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>(); query.JournalID = CurAuthor.JournalID; //query.Status = 1; query.IsReport = true; IList <FinanceContributeEntity> list = service.GetFinancePageFeeReportPageList(query).ItemList; string[] titleFiles = new string[] { "稿件编号", "稿件标题", "版面费", "备注", "通讯作者", "联系电话", "手机", "Email", "工作单位", "发票单位", "联系地址", "邮编", "投稿日期" }; int[] titleWidth = new int[] { 80, 200, 40, 100, 80, 100, 80, 80, 150, 150, 150, 80, 100 }; string[] dataFiles = new string[] { "CNumber", "Title", "PageMoney", "Note", "AuthorName", "Tel", "Mobile", "Email", "WorkUnit", "InvoiceUnit", "Address", "ZipCode", "AddDate" }; string[] fomateFiles = new string[] { "", "", "", "", "", "", "", "", "", "", "", "", "{0:yyyy-MM-dd}" }; string strTempPath = "/UploadFile/TempFile/" + "FinanceContribute.xls"; ExcelHelperEx.CreateExcel <FinanceContributeEntity>("作者版面费报表", titleFiles, titleWidth, dataFiles, fomateFiles, list, strTempPath); return(Json(new { flag = 1, ExcelPath = strTempPath })); }