Example #1
0
        public APIResult <GetListModel> GetList([FromBody] GetListArgsModel args)
        {
            var query = wechatCoreDb.QueryRobotMessage()
                        .Where(m => !m.IsDel);

            if (args.Status.HasValue)
            {
                query = query.Where(m => m.Status == args.Status.Value);
            }
            if (!string.IsNullOrEmpty(args.Question))
            {
                query = query.Where(m => m.Question.Contains(args.Question));
            }
            if (args.QuestionType.HasValue)
            {
                query = query.Where(m => m.QuestionType == args.QuestionType.Value);
            }

            var list = query
                       .OrderByDescending(m => m.Id)
                       .Select(m => new RowItem()
            {
                Id           = m.Id,
                Question     = m.Question,
                QuestionType = m.QuestionType,
                Answer       = m.Answer,
                Status       = m.Status
            })
                       .ToList();

            return(Success(new GetListModel()
            {
                Items = list
            }));
        }