/// <summary>
/// 获取年卷排序
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private string GetYearVolumeOrder(YearVolumeQuery query)
{
return " Year DESC ";
}
/// <summary>
/// 获取年卷分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<YearVolumeEntity> GetYearVolumePageList(YearVolumeQuery query)
{
string strSql = "SELECT *,ROW_NUMBER() OVER(ORDER BY " + GetYearVolumeOrder(query) + ") AS ROW_ID FROM dbo.YearVolume with(nolock)",
sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.YearVolume with(nolock)";
string whereSQL = GetYearVolumeFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
sumStr += " WHERE " + whereSQL;
}
return db.GetPageList<YearVolumeEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex)
, sumStr
, query.CurrentPage, query.PageSize
, (dr, pager) =>
{
pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]);
}
, MakeYearVolumeList);
}
/// <summary>
/// 获取年卷条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private string GetYearVolumeFilter(YearVolumeQuery query)
{
StringBuilder strFilter = new StringBuilder(" JournalID= " + query.JournalID);
if (query.Status != null)
strFilter.Append(" and Status=").Append(query.Status.Value);
return strFilter.ToString();
}
/// <summary>
/// 获取年卷分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<YearVolumeEntity> GetYearVolumePageList(YearVolumeQuery query)
{
return IssueDataAccess.Instance.GetYearVolumePageList(query);
}
/// <summary>
/// 获取年卷数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<YearVolumeEntity> GetYearVolumeList(YearVolumeQuery query)
{
string strSql = "SELECT * FROM dbo.YearVolume with(nolock)";
string whereSQL = GetYearVolumeFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
}
strSql += " order by " + GetYearVolumeOrder(query);
return db.GetList<YearVolumeEntity>(strSql, MakeYearVolumeList);
}
public Pager<YearVolumeEntity> GetYearVolumePageList(YearVolumeQuery query)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>();
Pager<YearVolumeEntity> pager = service.GetYearVolumePageList(query);
return pager;
}
/// <summary>
/// 获取年卷设置列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<YearVolumeEntity> GetYearVolumeList(YearVolumeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
IList<YearVolumeEntity> list = clientHelper.Post<IList<YearVolumeEntity>, YearVolumeQuery>(GetAPIUrl(APIConstant.YEARVOLUME_GETLIST), query);
return list;
}
public ActionResult GetYearVolumePageList(YearVolumeQuery query)
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
query.JournalID = CurAuthor.JournalID;
query.CurrentPage = Convert.ToInt32(Request.Params["page"]);
query.PageSize = Convert.ToInt32(Request.Params["pagesize"]);
Pager<YearVolumeEntity> pager = service.GetYearVolumePageList(query);
return Json(new { Rows = pager.ItemList, Total = pager.TotalRecords });
}
public ActionResult IssuePush(IssueContentQuery query)
{
//获取模板文件内容
string str = WKT.Common.Utils.Utils.ReadFileContent(Utils.GetMapPath(SiteConfig.RootPath + "/data/Issue.Template"));
StringBuilder sb = new StringBuilder(str);
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
//根据年获取卷
YearVolumeQuery YVQuery = new YearVolumeQuery();
YVQuery.JournalID = CurAuthor.JournalID;
IList<YearVolumeEntity> YearVolList = service.GetYearVolumeList(YVQuery);
int Volume = YearVolList.Single<YearVolumeEntity>(p => p.Year == query.Year).Volume;
//根据查询条件获取期刊列表
query.JournalID = CurAuthor.JournalID;
IList<IssueContentEntity> list = service.GetIssueContentList(query);
//替换模板文件基本内容
str = str.Replace("%Year%", query.Year.ToString()).Replace("%Vol%", Volume.ToString()).Replace("%Issue%", query.Issue.ToString()).Replace("%SiteName%", SiteConfig.SiteName).Replace("%SiteURL%", "<a href=\"http://" + Request.Url.Host + "\" target=\"_blank\">http://" + Request.Url.Host + "</a>");
//向模板文件加入期刊列表内容
string listing = string.Empty;
for (int i = 0; i < list.Count; i++)
{
listing += "<tr>";
listing += "<td style=\"text-align:center; width:50px; font-weight:bold;\">" + (i + 1) + "</td>";
listing += "<td style=\"text-align:left; font-weight:bold;\"><a href=\"http://" + Request.Url.Host + "/Magazine/Show?id=" + list[i].ContentID + "\" target=\"_blank\">" + list[i].Title + "</a></td>";
listing += "</tr>";
listing += "<tr>";
listing += "<td colspan=\"2\" style=\"text-align:left; padding-left:55px; font-size:12px;border-bottom:1px solid #e2e2e2;\">" + list[i].Authors + "</td>";
listing += "</tr>";
}
str = str.Replace("%Content%", listing);
//WKT.Common.Utils.Utils.WritStrToFile(str, @"D:\xx.htm");
return Json(new { flag = 1, htmlContent = str });
}
public ActionResult DelYearVolume(Int64[] SetIDs)
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
YearVolumeQuery query = new YearVolumeQuery();
query.JournalID = CurAuthor.JournalID;
query.setIDs = SetIDs;
ExecResult result = service.DelYearVolume(query);
return Json(new { result = result.result, msg = result.msg });
}
public ActionResult GetYearVolumeList(YearVolumeQuery query)
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
query.JournalID = CurAuthor.JournalID;
IList<YearVolumeEntity> list = service.GetYearVolumeList(query);
return Json(new { list });
}
/// <summary>
/// 删除年卷设置
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExecResult DelYearVolume(YearVolumeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post<ExecResult, YearVolumeQuery>(GetAPIUrl(APIConstant.YEARVOLUME_DEL), query);
return result;
}
/// <summary>
/// 获取年卷设置分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<YearVolumeEntity> GetYearVolumePageList(YearVolumeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
Pager<YearVolumeEntity> pager = clientHelper.Post<Pager<YearVolumeEntity>, YearVolumeQuery>(GetAPIUrl(APIConstant.YEARVOLUME_GETPAGELIST), query);
return pager;
}
/// <summary>
/// 获取年卷设置实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public YearVolumeEntity GetYearVolumeModel(YearVolumeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
YearVolumeEntity model = clientHelper.Post<YearVolumeEntity, YearVolumeQuery>(GetAPIUrl(APIConstant.YEARVOLUME_GETMODEL), query);
return model;
}
public IList<YearVolumeEntity> GetYearVolumeList(YearVolumeQuery query)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>();
IList<YearVolumeEntity> list = service.GetYearVolumeList(query);
return list;
}
private YearVolumeEntity GetYearVolumeModel(Int64 SetID)
{
YearVolumeQuery query = new YearVolumeQuery();
query.JournalID = CurAuthor.JournalID;
query.setID = SetID;
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
YearVolumeEntity model = service.GetYearVolumeModel(query);
if (model == null)
model = new YearVolumeEntity();
return model;
}
public YearVolumeEntity GetYearVolumeModel(YearVolumeQuery query)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>();
YearVolumeEntity model=null;
if (query.setID == 0)
model = service.GetMaxYearVolume(query.JournalID);
else
model = service.GetYearVolume(query.setID);
return model;
}
public ActionResult FinanceOutAccount()
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
//获取所有年
YearVolumeQuery query = new YearVolumeQuery();
query.JournalID = JournalID;
IList<YearVolumeEntity> listYearVolume = service.GetYearVolumeList(query);
//获取所有期
IssueSetQuery issueSetQuery = new IssueSetQuery();
issueSetQuery.JournalID = JournalID;
IList<IssueSetEntity> listIssue = service.GetIssueSetList(issueSetQuery);
ViewBag.listYearVolume = listYearVolume;
ViewBag.listIssue = listIssue;
return View();
}
public ExecResult DelYearVolume(YearVolumeQuery query)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>();
return service.DelYearVolume(query.setIDs);
}
/// <summary>
/// 获取年卷分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<YearVolumeEntity> GetYearVolumePageList(YearVolumeQuery query)
{
return IssueBusProvider.GetYearVolumePageList(query);
}
