MVC JsonResult

public JsonResult GetRecommendMemberJson(int memberId, int maxLevel = 2, DateTime? beginDateTime = null,
            DateTime? endDateTime = null)
        {
            var res = new JsonResult();  
            var recommendRegCount = 0;
            var recommentInvestCount = 0;
            if (memberId != 0)
            {
                var member = _MemberService.GetMemberById(memberId);
                if (member != null)
                {
                    //查询用户的推荐人
                    var query = "SELECT * FROM f_GetCommMember(@RegName,@MaxLevel)";
                    var commendMembers = _memberRepository.sqlconnection.Query<Member>(
                    query,
                    new { RegName = member.RegName, MaxLevel = maxLevel })
                    .ToList();

                    List<MemberRecommendModel> memberRecommentList = commendMembers.Select(x =>
                    {
                        var memberRecommendModel = new MemberRecommendModel();
                        memberRecommendModel.RegTime = x.RegTime;
                        //首投时间
                        var firstInvestsql =
                            "select min(i.CreateTime) from Invest as i left join Loan as l on i.LoanId = l.Id   where i.MemberID=@MemberID and i.IsValid=1 and l.Status in (" + (int)LoanStatusEnum.还款中 + "," + (int)LoanStatusEnum.还款完成 + ")";
                        var firstInvesttime =
                            _memberRepository.sqlconnection.Query<DateTime?>(firstInvestsql, new { MemberID = x.Id }).FirstOrDefault();
                        memberRecommendModel.FirstInvestTime = firstInvesttime;
                        return memberRecommendModel;
                    }).ToList();
                    if (beginDateTime == null)
                        beginDateTime = DateTime.Now.AddMonths(-1);
                    if (endDateTime == null)
                        endDateTime = DateTime.Now;

                    recommendRegCount =
                                memberRecommentList.Count(c => c.RegTime >= beginDateTime && c.RegTime <= endDateTime);
                    recommentInvestCount =
                         memberRecommentList.Count(c => c.FirstInvestTime >= beginDateTime && c.FirstInvestTime <= endDateTime);
                }
            }
            res.Data = new {RecommendRegCount = recommendRegCount, RecommentInvestCount = recommentInvestCount};
            res.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
            return res;  
        }