public List <IssueViewLogEntity> GetIssueViewLogList(IssueViewLogQuery query)
{
List <IssueViewLogEntity> list = new List <IssueViewLogEntity>();
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT ViewLogID,JournalID,ContentID,AuthorID,Daytime,Year,Month,IP,AddDate FROM dbo.IssueViewLog WITH(NOLOCK)");
string whereSQL = IssueViewLogQueryToSQLWhere(query);
string orderBy = IssueViewLogQueryToSQLOrder(query);
if (!string.IsNullOrEmpty(whereSQL))
{
sqlCommandText.Append(" WHERE " + whereSQL);
}
if (!string.IsNullOrEmpty(orderBy))
{
sqlCommandText.Append(" ORDER BY " + orderBy);
}
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
using (IDataReader dr = db.ExecuteReader(cmd))
{
list = MakeIssueViewLogList(dr);
}
return(list);
}
public ActionResult GetIssueViewLogDetailPageList(IssueViewLogQuery query)
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve <IIssueFacadeService>();
query.JournalID = CurAuthor.JournalID;
query.IsReport = false;
query.CurrentPage = Convert.ToInt32(Request.Params["page"]);
query.PageSize = Convert.ToInt32(Request.Params["pagesize"]);
Pager <IssueViewLogEntity> pager = service.GetIssueViewLogDetailPageList(query);
return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords }));
}
public Pager <IssueViewLogEntity> GetIssueViewLogPageList(IssueViewLogQuery query)
{
int recordCount = 0;
string whereSQL = IssueViewLogQueryToSQLWhere(query);
string orderBy = IssueViewLogQueryToSQLOrder(query);
DataSet ds = db.GetPagingData("IssueViewLog", "ViewLogID,JournalID,ContentID,AuthorID,Daytime,Year,Month,IP,AddDate", orderBy, whereSQL, query.CurrentPage, query.PageSize, out recordCount);
Pager <IssueViewLogEntity> pager = new Pager <IssueViewLogEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeIssueViewLogList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return(pager);
}
/// <summary>
/// 将查询实体转换为Order语句
/// <param name="query">查询实体</param>
/// <returns>获取Order语句，不包含Order</returns>
/// </summary>
public string IssueViewLogQueryToSQLOrder(IssueViewLogQuery query)
{
return(" ViewLogID DESC");
}
/// <summary>
/// 将查询实体转换为Where语句
/// <param name="query">查询实体</param>
/// <returns>获取Where语句，不包含Where</returns>
/// </summary>
public string IssueViewLogQueryToSQLWhere(IssueViewLogQuery query)
{
return(string.Empty);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="issueViewLogQuery">IssueViewLogQuery查询实体对象</param>
/// <returns>Pager<IssueViewLogEntity></returns>
public Pager <IssueViewLogEntity> GetIssueViewLogPageList(IssueViewLogQuery issueViewLogQuery)
{
return(IssueViewLogDataAccess.Instance.GetIssueViewLogPageList(issueViewLogQuery));
}
/// <summary>
/// 获取期刊下载明细
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager <IssueViewLogEntity> GetIssueViewLogDetailPageList(IssueViewLogQuery query)
{
return(IssueBusProvider.GetIssueViewLogDetailPageList(query));
}
/// <summary>
/// 获取期刊浏览明细
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager <IssueViewLogEntity> GetIssueViewLogDetailPageList(IssueViewLogQuery query)
{
return(IssueDataAccess.Instance.GetIssueViewLogDetailPageList(query));
}
/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="issueViewLogQuery">IssueViewLogQuery查询实体对象</param>
/// <returns>List<IssueViewLogEntity></returns>
public List <IssueViewLogEntity> GetIssueViewLogList(IssueViewLogQuery issueViewLogQuery)
{
return(IssueViewLogBusProvider.GetIssueViewLogList(issueViewLogQuery));
}
