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