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