public List <IssueDownLogEntity> GetIssueDownLogList(IssueDownLogQuery query) { List <IssueDownLogEntity> list = new List <IssueDownLogEntity>(); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT DownLogID,JournalID,ContentID,AuthorID,Daytime,Year,Month,IP,AddDate FROM dbo.IssueDownLog WITH(NOLOCK)"); string whereSQL = IssueDownLogQueryToSQLWhere(query); string orderBy = IssueDownLogQueryToSQLOrder(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 = MakeIssueDownLogList(dr); } return(list); }
public ActionResult GetIssueDownLogDetailPageList(IssueDownLogQuery 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 <IssueDownLogEntity> pager = service.GetIssueDownLogDetailPageList(query); return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords })); }
public Pager <IssueDownLogEntity> GetIssueDownLogPageList(IssueDownLogQuery query) { int recordCount = 0; string whereSQL = IssueDownLogQueryToSQLWhere(query); string orderBy = IssueDownLogQueryToSQLOrder(query); DataSet ds = db.GetPagingData("IssueDownLog", "DownLogID,JournalID,ContentID,AuthorID,Daytime,Year,Month,IP,AddDate", orderBy, whereSQL, query.CurrentPage, query.PageSize, out recordCount); Pager <IssueDownLogEntity> pager = new Pager <IssueDownLogEntity>(); if (ds != null && ds.Tables.Count > 0) { pager.ItemList = MakeIssueDownLogList(ds.Tables[0]); } pager.CurrentPage = query.CurrentPage; pager.PageSize = query.PageSize; pager.TotalRecords = recordCount; return(pager); }
/// <summary> /// 获取所有符合查询条件的数据 /// </summary> /// <param name="issueDownLogQuery">IssueDownLogQuery查询实体对象</param> /// <returns>List<IssueDownLogEntity></returns> public List <IssueDownLogEntity> GetIssueDownLogList(IssueDownLogQuery issueDownLogQuery) { return(IssueDownLogBusProvider.GetIssueDownLogList(issueDownLogQuery)); }
/// <summary> /// 获取期刊下载明细 /// </summary> /// <param name="query"></param> /// <returns></returns> public Pager <IssueDownLogEntity> GetIssueDownLogDetailPageList(IssueDownLogQuery query) { return(IssueBusProvider.GetIssueDownLogDetailPageList(query)); }
/// <summary> /// 将查询实体转换为Order语句 /// <param name="query">查询实体</param> /// <returns>获取Order语句,不包含Order</returns> /// </summary> public string IssueDownLogQueryToSQLOrder(IssueDownLogQuery query) { return(" DownLogID DESC"); }
/// <summary> /// 将查询实体转换为Where语句 /// <param name="query">查询实体</param> /// <returns>获取Where语句,不包含Where</returns> /// </summary> public string IssueDownLogQueryToSQLWhere(IssueDownLogQuery query) { return(string.Empty); }
/// <summary> /// 获取期刊下载明细 /// </summary> /// <param name="query"></param> /// <returns></returns> public Pager <IssueDownLogEntity> GetIssueDownLogDetailPageList(IssueDownLogQuery query) { return(IssueDataAccess.Instance.GetIssueDownLogDetailPageList(query)); }