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