/// <summary> /// 获取Json格式的数据 条件字典Key可以取固定值 selectfields orderby 框架将自动处理 /// </summary> /// <param name="page">当前页码</param> /// <param name="limit">当前也显示条数</param> /// <param name="orderby">排序字段</param> /// <param name="dicwhere">查询条件</param> /// <returns>FastJsonResult<List<Product>>.</returns> public static FastJsonResult <List <Comment> > GetJsonListPage(int page = 1, int limit = 10, string orderby = "", Dictionary <string, object> dicwhere = null) { if (dicwhere == null) { dicwhere = new Dictionary <string, object>(); } if (dicwhere.Keys.Contains(nameof(Comment.IsDeleted))) { dicwhere[nameof(Comment.IsDeleted)] = 0; } else { dicwhere.Add(nameof(Comment.IsDeleted), 0); } var ret = CommentRepository.Instance.GetJsonListPage <Comment>(limit, page, dicwhere, orderby); if (ret != null && ret.code.Toint() == 0 && ret.data.Count > 0) { string blognums = string.Join(",", ret.data.Select(x => x.BlogNum).Distinct()); List <Bloginfo> blogs = BloginfoLogic.GetList(new Dictionary <string, object>() { { $"{nameof(Bloginfo.BlogNum)}|i", blognums }, }); ret.data.ForEach((item) => { item.Extend4 = blogs.FirstOrDefault(x => x.BlogNum == item.BlogNum)?.Title; }); } return(ret); }
/// <summary> /// 获取Json格式的数据 条件字典Key可以取固定值 selectfields orderby 框架将自动处理 /// </summary> /// <param name="page">当前页码</param> /// <param name="limit">当前也显示条数</param> /// <param name="orderby">排序字段</param> /// <param name="dicwhere">查询条件</param> /// <returns>FastJsonResult<List<Product>>.</returns> public static FastJsonResult <List <ArticlePraise> > GetJsonListPage(int page = 1, int limit = 10, string orderby = "", Dictionary <string, object> dicwhere = null) { if (dicwhere == null) { dicwhere = new Dictionary <string, object>(); } if (dicwhere.Keys.Contains(nameof(ArticlePraise.IsDeleted))) { dicwhere[nameof(ArticlePraise.IsDeleted)] = 0; } else { dicwhere.Add(nameof(ArticlePraise.IsDeleted), 0); } var ret = ArticlePraiseRepository.Instance.GetJsonListPage <ArticlePraise>(limit, page, dicwhere, orderby); if (ret != null && ret.code.Toint() == 0 && ret.data.Count > 0) { string memberids = string.Join(",", ret.data.Select(x => x.MemberId).Distinct()); string blognums = string.Join(",", ret.data.Select(x => x.BlogNum).Distinct()); List <Member> members = MemberLogic.GetList(new Dictionary <string, object>() { { $"{nameof(Member.KID)}|i", memberids }, }); List <Bloginfo> blogs = BloginfoLogic.GetList(new Dictionary <string, object>() { { $"{nameof(Bloginfo.BlogNum)}|i", blognums }, }); ret.data.ForEach((item) => { item.Extend4 = members.FirstOrDefault(x => x.KID == item.MemberId.Toint())?.UserName; item.Extend5 = members.FirstOrDefault(x => x.KID == item.MemberId.Toint())?.UserAccount; item.Extend6 = blogs.FirstOrDefault(x => x.BlogNum == item.BlogNum)?.Title; }); } return(ret); }