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