/// <summary>
/// 获取稿件费用数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <FinanceContributeEntity> GetFinanceContributeList(FinanceContributeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
IList <FinanceContributeEntity> list = clientHelper.Post <IList <FinanceContributeEntity>, FinanceContributeQuery>(GetAPIUrl(APIConstant.FINANCECONTRIBUTE_GETLIST), query);
return(list);
}
/// <summary>
/// 删除稿件费用
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExecResult DelFinanceContribute(FinanceContributeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post <ExecResult, FinanceContributeQuery>(GetAPIUrl(APIConstant.FINANCECONTRIBUTE_DEL), query);
return(result);
}
/// <summary>
/// 获取版面费报表分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager <FinanceContributeEntity> GetFinancePageFeeReportPageList(FinanceContributeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
Pager <FinanceContributeEntity> pager = clientHelper.PostAuth <Pager <FinanceContributeEntity>, FinanceContributeQuery>(GetAPIUrl(APIConstant.FINANCEGLANCE_GETPAGEFEEREPORTPAGELIST), query);
return(pager);
}
public FinanceContributeEntity GetModel(FinanceContributeQuery query)
{
IFinanceContributeService service = ServiceContainer.Instance.Container.Resolve <IFinanceContributeService>();
FinanceContributeEntity model = service.GetFinanceContribute(query.PKID);
return(model);
}
public Pager <FinanceContributeEntity> GetPageList(FinanceContributeQuery query)
{
IFinanceContributeService service = ServiceContainer.Instance.Container.Resolve <IFinanceContributeService>();
Pager <FinanceContributeEntity> pager = service.GetFinanceContributePageList(query);
return(pager);
}
public IList <FinanceContributeEntity> GetList(FinanceContributeQuery query)
{
IFinanceContributeService service = ServiceContainer.Instance.Container.Resolve <IFinanceContributeService>();
IList <FinanceContributeEntity> list = service.GetFinanceContributeList(query);
return(list);
}
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("导出稿件费用信息异常！"));
}
}
/// <summary>
/// 获取稿件费用实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public FinanceContributeEntity GetFinanceContributeModel(FinanceContributeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
FinanceContributeEntity model = clientHelper.Post <FinanceContributeEntity, FinanceContributeQuery>(GetAPIUrl(APIConstant.FINANCECONTRIBUTE_GETMODEL), query);
return(model);
}
/// <summary>
/// 获取稿件费用分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager <FinanceContributeEntity> GetFinanceContributePageList(FinanceContributeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
Pager <FinanceContributeEntity> pager = clientHelper.Post <Pager <FinanceContributeEntity>, FinanceContributeQuery>(GetAPIUrl(APIConstant.FINANCECONTRIBUTE_GETPAGELIST), query);
return(pager);
}
/// <summary>
/// 获取版面费报表分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager <FinanceContributeEntity> GetFinancePageFeeReportPageList(FinanceContributeQuery query)
{
Pager <FinanceContributeEntity> pager = FinanceContributeBusProvider.GetFinancePageFeeReportPageList(query);
if (pager == null)
{
return(pager);
}
IList <FinanceContributeEntity> list = pager.ItemList;
if (list == null || list.Count == 0)
{
return(pager);
}
AuthorInfoService service = new AuthorInfoService();
AuthorInfoQuery aQuery = new AuthorInfoQuery();
aQuery.JournalID = query.JournalID;
var dict = service.AuthorInfoBusProvider.GetAuthorDict(aQuery);
foreach (var mode in list)
{
mode.InUserName = dict.GetValue(mode.InUser, mode.InUser.ToString());
}
pager.ItemList = list;
return(pager);
}
public ActionResult GetFContributeList(FinanceContributeQuery query)
{
IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>();
query.JournalID = CurAuthor.JournalID;
IList <FinanceContributeEntity> list = service.GetFinanceContributeList(query);
return(Json(new { list }));
}
public ActionResult FContributeDelete(Int64[] PKIDs)
{
IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>();
FinanceContributeQuery query = new FinanceContributeQuery();
query.JournalID = CurAuthor.JournalID;
query.PKIDs = PKIDs;
ExecResult result = service.DelFinanceContribute(query);
return(Json(new { result = result.result, msg = result.msg }));
}
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 GetFContributePageList(FinanceContributeQuery query)
{
IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>();
query.JournalID = CurAuthor.JournalID;
query.IsShowAuthor = true;
query.CurrentPage = Convert.ToInt32(Request.Params["page"]);
query.PageSize = Convert.ToInt32(Request.Params["pagesize"]);
Pager <FinanceContributeEntity> pager = service.GetFinanceContributePageList(query);
return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords }));
}
private FinanceContributeEntity GetFinanceArticleModel(Int64 PKID)
{
FinanceContributeEntity model = null;
if (PKID > 0)
{
FinanceContributeQuery query = new FinanceContributeQuery();
query.JournalID = CurAuthor.JournalID;
query.PKID = PKID;
IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>();
model = service.GetFinanceContributeModel(query);
}
if (model == null)
{
model = new FinanceContributeEntity();
}
return(model);
}
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 }));
}
public ExecResult Del(FinanceContributeQuery query)
{
IFinanceContributeService service = ServiceContainer.Instance.Container.Resolve <IFinanceContributeService>();
return(service.Del(query.PKIDs));
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="financeContributeQuery">FinanceContributeQuery查询实体对象</param>
/// <returns>Pager<FinanceContributeEntity></returns>
public Pager <FinanceContributeEntity> GetFinanceContributePageList(FinanceContributeQuery financeContributeQuery)
{
return(FinanceContributeDataAccess.Instance.GetFinanceContributePageList(financeContributeQuery));
}
/// <summary>
/// 缴费通知是否存在
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public bool FinanceContributeIsExists(FinanceContributeQuery query)
{
return(FinanceContributeDataAccess.Instance.FinanceContributeIsExists(query));
}
/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="financeContributeQuery">FinanceContributeQuery查询实体对象</param>
/// <returns>List<FinanceContributeEntity></returns>
public List <FinanceContributeEntity> GetFinanceContributeList(FinanceContributeQuery financeContributeQuery)
{
return(FinanceContributeBusProvider.GetFinanceContributeList(financeContributeQuery));
}
/// <summary>
/// 获取版面费报表分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager <FinanceContributeEntity> GetFinancePageFeeReportPageList(FinanceContributeQuery query)
{
return(FinanceContributeDataAccess.Instance.GetFinancePageFeeReportPageList(query));
}
/// <summary>
/// 保存稿件费用信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult Save(FinanceContributeEntity model)
{
ExecResult execResult = new ExecResult();
bool result = false;
model.RemitBillNo = model.RemitBillNo.TextFilter();
model.InvoiceNo = model.InvoiceNo.TextFilter();
model.PostNo = model.PostNo.TextFilter();
model.Note = model.Note.TextFilter();
if (model.IsSystem)
{
model.InComeDate = DateTime.Now;
model.Status = 1;
}
if (model.PKID == 0)
{
FinanceContributeQuery fQuery = new FinanceContributeQuery();
fQuery.JournalID = model.JournalID;
fQuery.CID = model.CID;
fQuery.FeeType = model.FeeType;
if (FinanceContributeBusProvider.FinanceContributeIsExists(fQuery))
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "该费用已经存在！";
return(execResult);
}
result = AddFinanceContribute(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "新增稿件费用成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "新增稿件费用失败！";
}
}
else
{
result = UpdateFinanceContribute(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "修改稿件费用成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "修改稿件费用失败！";
}
}
if (result)
{
//更新缴费通知记录
if (model.NoticeID > 0)
{
PayNoticeQuery query = new PayNoticeQuery();
query.NoticeID = model.NoticeID;
query.Status = (Byte)(model.IsSystem ? 1 : 2);
PayNoticeBusiness business = new PayNoticeBusiness();
business.ChangeStatus(query);
}
}
return(execResult);
}
