public ArticleInfo_QueryCollection QueryArticleList(string key, string gameCode, string category, int pageIndex, int pageSize) { pageIndex = pageIndex < 0 ? 0 : pageIndex; pageSize = pageSize > BusinessHelper.MaxPageSize ? BusinessHelper.MaxPageSize : pageSize; string QueryArticleList_sql = SqlModule.DataModule.FirstOrDefault(x => x.Key == "Data_QueryArticleList").SQL; var collection = DB.CreateSQLQuery(QueryArticleList_sql) .SetString("@Key", key) .SetString("@GameCode", gameCode) .SetString("@Category", category) .SetInt("@PageIndex", pageIndex) .SetInt("@PageSize", pageSize).List <ArticleInfo_Query>(); var returnmodel = new ArticleInfo_QueryCollection(); returnmodel.ArticleList = collection; string QueryArticleCount_sql = SqlModule.DataModule.FirstOrDefault(x => x.Key == "Data_QueryArticleList_TotalCount").SQL; var TotalCount = DB.CreateSQLQuery(QueryArticleList_sql) .SetString("@Key", key) .SetString("@GameCode", gameCode) .SetString("@Category", category) .First <int>(); returnmodel.TotalCount = TotalCount; return(returnmodel); }
public ArticleInfo_QueryCollection QueryNoStaticPathArticleList(int pageIndex, int pageSize) { var result = new ArticleInfo_QueryCollection(); var manager = new ArticleManager(); int totalCount = 0; result.ArticleList = manager.QueryNoStaticPathArticleList(pageIndex, pageSize, out totalCount); result.TotalCount = totalCount; return(result); }
//private static Dictionary<string, ArticleInfo_QueryCollection> _articleCollection = new Dictionary<string, ArticleInfo_QueryCollection>(); /// <summary> /// 查询文章列表 /// todo:后台权限 /// </summary> public Task <ArticleInfo_QueryCollection> QueryArticleList_YouHua(string category, string gameCode, int pageIndex, int pageSize) { try { //string cacheKey = string.Format("{0}_{1}_{2}_{3}", category, gameCode, pageIndex, pageSize); var result = new ArticleInfo_QueryCollection(); //if (_articleCollection != null && _articleCollection.Count > 0 && _articleCollection.ContainsKey(cacheKey)) //{ // result = _articleCollection.FirstOrDefault(s => s.Key == cacheKey).Value; //} //else //{ if (string.IsNullOrEmpty(category)) { throw new LogicException("未查询到文章类别"); } var Key = RedisKeys.ArticleListKey; string cacheKey = string.Format("{0}_{1}_{2}_{3}_{4}", Key, category, gameCode, pageIndex, pageSize); var obj = RedisHelperEx.DB_CoreCacheData.GetObj <ArticleInfo_QueryCollection>(cacheKey); if (obj != null) { return(Task.FromResult(obj)); } var array = category.Split('|'); var gameCodeArray = gameCode.Split('|'); result = new DataQuery().QueryArticleList_YouHua(array, gameCodeArray, pageIndex, pageSize); //if (!_articleCollection.ContainsKey(cacheKey)) // _articleCollection.Add(cacheKey, result); //} if (result != null) { RedisHelperEx.DB_CoreCacheData.SetObj(cacheKey, result, TimeSpan.FromMinutes(5)); } return(Task.FromResult(result)); } catch (LogicException ex) { throw ex; } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public ArticleInfo_QueryCollection QueryArticleList_YouHua(string[] category, string[] gameCode, int pageIndex, int pageSize) { ArticleInfo_QueryCollection collection = new ArticleInfo_QueryCollection(); // 通过数据库存储过程进行查询 var query = from a in DB.CreateQuery <E_SiteMessage_Article_List>() where category.Contains(a.Category) && gameCode.Contains(a.GameCode) //orderby a.CreateTime descending select a; collection.TotalCount = query.Count(); collection.ArticleList = query.OrderByDescending(p => p.CreateTime).Skip(pageIndex * pageSize).Take(pageSize).ToList().Select(a => new ArticleInfo_Query { Category = a.Category.Trim(), CreateTime = a.CreateTime, CreateUserDisplayName = a.CreateUserDisplayName, CreateUserKey = a.CreateUserKey, DescContent = a.DescContent, Description = a.Description, GameCode = a.GameCode, Id = a.Id, IsRedTitle = a.IsRedTitle, KeyWords = a.KeyWords, NextId = a.NextId, NextTitle = a.NextTitle, PreId = a.PreId, PreTitle = a.PreTitle, ReadCount = a.ReadCount, ShowIndex = a.ShowIndex, Title = a.Title, UpdateTime = a.UpdateTime, UpdateUserDisplayName = a.UpdateUserDisplayName, UpdateUserKey = a.UpdateUserKey, NextStaticPath = a.NextStaticPath, PreStaticPath = a.PreStaticPath, StaticPath = a.StaticPath, }).ToList(); return(collection); //var list = manager.QueryArticleList_YouHua(array, gameCodeArray, pageIndex, pageSize); // return list; }
public ArticleInfo_QueryCollection QueryArticleList_YouHua(string[] array_category, string[] gameCodeArray, int pageIndex, int pageSize) { Session.Clear(); ArticleInfo_QueryCollection collection = new ArticleInfo_QueryCollection(); // 通过数据库存储过程进行查询 var query = from a in Session.Query <Article>() where array_category.Contains(a.Category) && gameCodeArray.Contains(a.GameCode) orderby a.CreateTime descending select new ArticleInfo_Query { Category = a.Category.Trim(), CreateTime = a.CreateTime, CreateUserDisplayName = a.CreateUserDisplayName, CreateUserKey = a.CreateUserKey, DescContent = a.DescContent, Description = a.Description, GameCode = a.GameCode, Id = a.Id, IsRedTitle = a.IsRedTitle, KeyWords = a.KeyWords, NextId = a.NextId, NextTitle = a.NextTitle, PreId = a.PreId, PreTitle = a.PreTitle, ReadCount = a.ReadCount, ShowIndex = a.ShowIndex, Title = a.Title, UpdateTime = a.UpdateTime, UpdateUserDisplayName = a.UpdateUserDisplayName, UpdateUserKey = a.UpdateUserKey, NextStaticPath = a.NextStaticPath, PreStaticPath = a.PreStaticPath, StaticPath = a.StaticPath, }; collection.TotalCount = query.Count(); collection.ArticleList = query.Skip(pageIndex * pageSize).Take(pageSize).ToList(); return(collection); }