/// <summary>
/// 获取参考文献查询条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private string GetIssueReferenceFilter(IssueReferenceQuery query)
{
StringBuilder strFilter = new StringBuilder(" JournalID=" + query.JournalID);
if (query.ContentID != null)
{
strFilter.AppendFormat(" and ContentID={0}", query.ContentID.Value);
}
return strFilter.ToString();
}
/// <summary>
/// 获取参考文献分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<IssueReferenceEntity> GetIssueReferencePageList(IssueReferenceQuery query)
{
if (string.IsNullOrWhiteSpace(query.OrderStr))
query.OrderStr = " ReferenceID DESC";
string strSql = "SELECT *,ROW_NUMBER() OVER(ORDER BY " + query.OrderStr + ") AS ROW_ID FROM dbo.IssueReference with(nolock)"
, sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.IssueReference with(nolock)";
string whereSQL = GetIssueReferenceFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
sumStr += " WHERE " + whereSQL;
}
return db.GetPageList<IssueReferenceEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex)
, sumStr
, query.CurrentPage, query.PageSize
, (dr, pager) =>
{
pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]);
}
, MakeIssueReferenceList);
}
/// <summary>
/// 获取参考文献分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<IssueReferenceEntity> GetIssueReferencePageList(IssueReferenceQuery query)
{
return IssueDataAccess.Instance.GetIssueReferencePageList(query);
}
/// <summary>
/// 获取参考文献数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<IssueReferenceEntity> GetIssueReferenceList(IssueReferenceQuery query)
{
if (string.IsNullOrWhiteSpace(query.OrderStr))
query.OrderStr = " ReferenceID DESC";
string strSql = "SELECT * FROM dbo.IssueReference with(nolock)";
string whereSQL = GetIssueReferenceFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
}
strSql += " ORDER BY " + query.OrderStr;
return db.GetList<IssueReferenceEntity>(strSql, MakeIssueReferenceList);
}
/// <summary>
/// 获取参考文献分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<IssueReferenceEntity> GetIssueReferencePageList(IssueReferenceQuery query)
{
return IssueBusProvider.GetIssueReferencePageList(query);
}
