/// <summary>
/// 本期下载排行
/// </summary>
/// <param name="helper"></param>
/// <returns></returns>
public static IList<IssueContentEntity> GeCurIssueDownloadsOrderList(this HtmlHelper helper, int TopCount)
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
# region 年卷期
IssueSetQuery issuequery = new IssueSetQuery();
issuequery.JournalID = GetJournalID();
IssueSiteEntity issueInfoEntity = service.GetCurIssueInfo(issuequery);
if (issueInfoEntity == null)
{
issueInfoEntity = new IssueSiteEntity();
issueInfoEntity.Year = DateTime.Now.Year;
issueInfoEntity.Volume = 1;
issueInfoEntity.Issue = 1;
}
# endregion
IssueContentQuery query = new IssueContentQuery();
query.JournalID = GetJournalID();
query.PageSize = TopCount;
query.Year = issueInfoEntity.Year;
query.Issue = issueInfoEntity.Issue;
query.CurrentPage = 1;
query.SortName = " Downloads ";
query.SortOrder = " DESC ";
Pager<IssueContentEntity> listIssueContentEntity = service.GetIssueContentPageList(query);
if (listIssueContentEntity != null)
{
return listIssueContentEntity.ItemList;
}
else
{
return new List<IssueContentEntity>();
}
}
/// <summary>
/// 获取期设置数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<IssueSetEntity> GetIssueSetList(IssueSetQuery query)
{
return IssueBusProvider.GetIssueSetList(query);
}
public IssueSetEntity GetIssueSetModel(IssueSetQuery query)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>();
IssueSetEntity model = null;
if (query.IssueSetID == 0)
model = service.GetMaxIssueSet(query.JournalID);
else
model = service.GetIssueSet(query.IssueSetID);
if (model != null)
{
Pager<IssueSetEntity> currentEntity = service.GetIssueSetPageList(query);
if (currentEntity != null && currentEntity.ItemList!=null && currentEntity.ItemList.Count>0)
{
IList<IssueSetEntity> list= currentEntity.ItemList;
IssueSetEntity single= list.Where(o => o.Issue == model.Issue).SingleOrDefault();
model.PrintExpenses = single.PrintExpenses;
}
}
return model;
}
public ExecResult DelIssueSet(IssueSetQuery query)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>();
return service.DelIssueSet(query.IssueSetIDs);
}
/// <summary>
/// 获取期设置条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private string GetIssueSetFilter(IssueSetQuery 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 IssueSiteEntity GetCurIssueInfo(IssueSetQuery query)
{
IssueSiteEntity issueInfoEntity = null;
string sql = @"SELECT TOP 1 y.[Year],y.Volume,issue.Issue,issue.TitlePhoto
FROM dbo.YearVolume y WITH(NOLOCK),(SELECT TOP 1 i.JournalID,i.Issue,i.TitlePhoto FROM dbo.IssueSet i WITH(NOLOCK) WHERE i.JournalID=@JournalID AND i.Status=1 AND i.TitlePhoto<>'' AND i.TitlePhoto IS NOT NULL ORDER BY i.Issue DESC) issue
WHERE y.JournalID=@JournalID AND y.Status=1 ORDER BY [Year] DESC";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, query.JournalID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
issueInfoEntity = new IssueSiteEntity();
if (dr.Read())
{
issueInfoEntity.Year = TypeParse.ToInt(dr["Year"], DateTime.Now.Year);
issueInfoEntity.Volume = TypeParse.ToInt(dr["Volume"], 0);
issueInfoEntity.Issue = TypeParse.ToInt(dr["Issue"], 0);
issueInfoEntity.TitlePhoto = dr.IsDBNull(dr.GetOrdinal("TitlePhoto")) ? "" : dr["TitlePhoto"].ToString();
}
dr.Close();
}
return issueInfoEntity;
}
/// <summary>
/// 获取当前期刊最新的年、卷、期、当期封面图片
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IssueSiteEntity GetCurIssueInfo(IssueSetQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
IssueSiteEntity model = clientHelper.Post<IssueSiteEntity, IssueSetQuery>(GetAPIUrl(APIConstant.ISSUE_GETCURISSUEINFO), query);
return model;
}
/// <summary>
/// 获取期设置数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<IssueSetEntity> GetIssueSetList(IssueSetQuery query)
{
string strSql = "SELECT * FROM dbo.IssueSet with(nolock)";
string whereSQL = GetIssueSetFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
}
strSql += " order by " + GetIssueSetOrder(query);
return db.GetList<IssueSetEntity>(strSql, MakeIssueSetList);
}
/// <summary>
/// 获取期设置分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<IssueSetEntity> GetIssueSetPageList(IssueSetQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
Pager<IssueSetEntity> pager = clientHelper.Post<Pager<IssueSetEntity>, IssueSetQuery>(GetAPIUrl(APIConstant.ISSUESET_GETPAGELIST), query);
return pager;
}
/// <summary>
/// 删除期设置
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExecResult DelIssueSet(IssueSetQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post<ExecResult, IssueSetQuery>(GetAPIUrl(APIConstant.ISSUESET_DEL), query);
return result;
}
/// <summary>
/// 获取期设置实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IssueSetEntity GetIssueSetModel(IssueSetQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
IssueSetEntity model = clientHelper.Post<IssueSetEntity, IssueSetQuery>(GetAPIUrl(APIConstant.ISSUESET_GETMODEL), query);
return model;
}
/// <summary>
/// 获取期设置列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<IssueSetEntity> GetIssueSetList(IssueSetQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
IList<IssueSetEntity> list = clientHelper.Post<IList<IssueSetEntity>, IssueSetQuery>(GetAPIUrl(APIConstant.ISSUESET_GETLIST), query);
return list;
}
/// <summary>
/// 获取期设置分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<IssueSetEntity> GetIssueSetPageList(IssueSetQuery query)
{
return IssueBusProvider.GetIssueSetPageList(query);
}
/// <summary>
/// 获取当前期刊最新的年、卷、期、当期封面图片
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IssueSiteEntity GetCurIssueInfo(IssueSetQuery query)
{
return IssueDataAccess.Instance.GetCurIssueInfo(query);
}
public IssueSiteEntity GetCurIssueInfo()
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
IssueSetQuery query = new IssueSetQuery();
query.JournalID = CurAuthor.JournalID;
IssueSiteEntity issueInfoEntity = service.GetCurIssueInfo(query);
if (issueInfoEntity == null)
{
issueInfoEntity = new IssueSiteEntity();
}
return issueInfoEntity;
}
/// <summary>
/// 获取期设置分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<IssueSetEntity> GetIssueSetPageList(IssueSetQuery query)
{
return IssueDataAccess.Instance.GetIssueSetPageList(query);
}
public ActionResult GetIssueSetList(IssueSetQuery query)
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
query.JournalID = CurAuthor.JournalID;
IList<IssueSetEntity> list = service.GetIssueSetList(query);
return Json(new { list });
}
/// <summary>
/// 获取期设置分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<IssueSetEntity> GetIssueSetPageList(IssueSetQuery query)
{
string strSql = "SELECT IssueSet.*,(case when a.PrintExpenses is null then 0 else a.PrintExpenses end)as PrintExpenses ,ROW_NUMBER() OVER(ORDER BY " + GetIssueSetOrder(query) + ") AS ROW_ID FROM dbo.IssueSet LEFT JOIN (select Issue,PrintExpenses from JournalOfCost where Year=" + query.Year + " AND JournalID="+query.JournalID+" ) as a ON IssueSet.Issue=a.Issue ",
sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.IssueSet with(nolock)";
string whereSQL = GetIssueSetFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
sumStr += " WHERE " + whereSQL;
}
return db.GetPageList<IssueSetEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex)
, sumStr
, query.CurrentPage, query.PageSize
, (dr, pager) =>
{
pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]);
}
, MakeIssueSetList);
}
public ActionResult GetIssueSetPageList(IssueSetQuery 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<IssueSetEntity> pager = service.GetIssueSetPageList(query);
return Json(new { Rows = pager.ItemList, Total = pager.TotalRecords });
}
/// <summary>
/// 获取期设置排序
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private string GetIssueSetOrder(IssueSetQuery query)
{
return " IssueSet.Issue ASC ";
}
private IssueSetEntity GetIssueSetModel(Int64 IssueSetID,int year)
{
IssueSetQuery query = new IssueSetQuery();
query.JournalID = CurAuthor.JournalID;
query.IssueSetID = IssueSetID;
query.Year = year;
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
IssueSetEntity model = service.GetIssueSetModel(query);
if (model == null)
model = new IssueSetEntity();
return model;
}
public IList<IssueSetEntity> GetIssueSetList(IssueSetQuery query)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>();
IList<IssueSetEntity> list = service.GetIssueSetList(query);
return list;
}
public ActionResult DelIssueSet(Int64[] IssueSetIDs)
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
IssueSetQuery query = new IssueSetQuery();
query.JournalID = CurAuthor.JournalID;
query.IssueSetIDs = IssueSetIDs;
ExecResult result = service.DelIssueSet(query);
return Json(new { result = result.result, msg = result.msg });
}
public Pager<IssueSetEntity> GetIssueSetPageList(IssueSetQuery query)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>();
Pager<IssueSetEntity> pager = service.GetIssueSetPageList(query);
return pager;
}
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 IssueSiteEntity GetCurIssueInfo(IssueSetQuery query)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>();
IssueSiteEntity issueEntity = service.GetCurIssueInfo(query);
return issueEntity;
}
/// <summary>
/// 获取当前期刊最新的年、卷、期、当期封面图片
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IssueSiteEntity GetCurIssueInfo(IssueSetQuery query)
{
return IssueBusProvider.GetCurIssueInfo(query);
}
