Esempio n. 1
0
        public async Task <MessageModel <PageModel <TopicDetail> > > Get(int page = 1, string tname = "", string key = "")
        {
            int tid = 0;

            if (string.IsNullOrEmpty(key) || string.IsNullOrWhiteSpace(key))
            {
                key = "";
            }
            if (string.IsNullOrEmpty(tname) || string.IsNullOrWhiteSpace(tname))
            {
                tname = "";
            }
            tname = UnicodeHelper.UnicodeToString(tname);

            if (!string.IsNullOrEmpty(tname))
            {
                tid = ((await _topicServices.Query(ts => ts.tName == tname)).FirstOrDefault()?.Id).ObjToInt();
            }

            int intPageSize = 6;


            var data = await _topicDetailServices.QueryPage(a => !a.tdIsDelete && a.tdSectendDetail == "tbug" && ((tid == 0 && true) || (tid > 0 && a.TopicId == tid)) && ((a.tdName != null && a.tdName.Contains(key)) || (a.tdDetail != null && a.tdDetail.Contains(key))), page, intPageSize, " Id desc ");



            return(new MessageModel <PageModel <TopicDetail> >()
            {
                msg = "获取成功",
                success = data.dataCount >= 0,
                response = data
            });
        }
Esempio n. 2
0
        public async Task <object> Get()
        {
            List <Topic> topics = new List <Topic>();

            try
            {
                topics = await _topicServices.Query(a => !a.tIsDelete && a.tSectendDetail == "tbug");
            }
            catch (Exception) { }

            return(Ok(new
            {
                success = topics.Any(),
                data = topics
            }));
        }
Esempio n. 3
0
        public async Task <MessageModel <PageModel <TopicDetail> > > Get(int page = 1, string tname = "", string key = "")
        {
            var data          = new MessageModel <PageModel <TopicDetail> >();
            int intTotalCount = 6;
            int TotalCount    = 0;
            int PageCount     = 1;
            List <TopicDetail> topicDetails = new List <TopicDetail>();

            //总数据,使用AOP切面缓存
            //topicDetails = await _topicDetailServices.GetTopicDetails();
            topicDetails = await _topicDetailServices.Query(a => !a.tdIsDelete && a.tdSectendDetail == "tbug");

            if (!string.IsNullOrEmpty(key))
            {
                topicDetails = topicDetails.Where(t => (t.tdName != null && t.tdName.Contains(key)) || (t.tdDetail != null && t.tdDetail.Contains(key))).ToList();
            }

            tname = UnicodeHelper.UnicodeToString(tname);

            if (!string.IsNullOrEmpty(tname))
            {
                var tid = (await _topicServices.Query(ts => ts.tName == tname)).FirstOrDefault()?.Id.ObjToInt();
                topicDetails = topicDetails.Where(t => t.TopicId == tid).ToList();
            }

            //筛选后的数据总数
            TotalCount = topicDetails.Count;
            //筛选后的总页数
            PageCount = (Math.Ceiling(TotalCount.ObjToDecimal() / intTotalCount.ObjToDecimal())).ObjToInt();

            topicDetails = topicDetails.OrderByDescending(d => d.Id).Skip((page - 1) * intTotalCount).Take(intTotalCount).ToList();

            return(new MessageModel <PageModel <TopicDetail> >()
            {
                msg = "获取成功",
                success = TotalCount >= 0,
                response = new PageModel <TopicDetail>()
                {
                    page = page,
                    pageCount = PageCount,
                    dataCount = TotalCount,
                    data = topicDetails,
                }
            });
        }
        public async Task <object> Get(int page = 1, string tname = "")
        {
            int intTotalCount = 6;
            int TotalCount    = 1;
            List <TopicDetail> topicDetails = new List <TopicDetail>();

            topicDetails = await _topicDetailServices.Query(a => !a.tdIsDelete && a.tdSectendDetail == "tbug");

            if (!string.IsNullOrEmpty(tname))
            {
                var tid = (await _topicServices.Query(ts => ts.tName == tname)).FirstOrDefault()?.Id.ObjToInt();
                topicDetails = topicDetails.Where(t => t.TopicId == tid).ToList();
            }

            topicDetails = topicDetails.OrderByDescending(d => d.Id).Skip((page - 1) * intTotalCount).Take(intTotalCount).ToList();

            return(Ok(new
            {
                success = true,
                page = page,
                pageCount = TotalCount,
                Article = topicDetails
            }));
        }
Esempio n. 5
0
        public async Task <MessageModel <PageModel <TopicDetail> > > Get(int page = 1, string tname = "")
        {
            var data          = new MessageModel <PageModel <TopicDetail> >();
            int intTotalCount = 6;
            int TotalCount    = 0;
            int PageCount     = 1;
            List <TopicDetail> topicDetails = new List <TopicDetail>();

            topicDetails = await _topicDetailServices.Query(a => !a.tdIsDelete && a.tdSectendDetail == "tbug");

            if (!string.IsNullOrEmpty(tname))
            {
                var tid = (await _topicServices.Query(ts => ts.tName == tname)).FirstOrDefault()?.Id.ObjToInt();
                topicDetails = topicDetails.Where(t => t.TopicId == tid).ToList();
            }
            //数据总数
            TotalCount = topicDetails.Count;

            //总页数
            PageCount = (Math.Ceiling(topicDetails.Count.ObjToDecimal() / intTotalCount.ObjToDecimal())).ObjToInt();

            topicDetails = topicDetails.OrderByDescending(d => d.Id).Skip((page - 1) * intTotalCount).Take(intTotalCount).ToList();

            return(new MessageModel <PageModel <TopicDetail> >()
            {
                Msg = "获取成功",
                Success = topicDetails.Count >= 0,
                Response = new PageModel <TopicDetail>()
                {
                    page = page,
                    pageCount = PageCount,
                    dataCount = TotalCount,
                    data = topicDetails,
                }
            });
        }