DEMOMySql/MicroServices/Business/Business.Application/ResourceExamineManagement/AccountValidityAppService.cs

using Business.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Volo.Abp.Application.Services;

namespace Business.ResourceExamineManagement
{
    public class AccountValidityAppService : ApplicationService
    {
        private readonly BusinessDbContext _businessDbContext;
        public AccountValidityAppService(BusinessDbContext businessDbContext)
        {
            _businessDbContext = businessDbContext;
        }
        public bool IsActived()
        {
            string sql = $"exec pr_User_Account_Validity @type=0";
            var rfuser = _businessDbContext.rf_userDto.FromSqlRaw(sql).ToList();

            if (rfuser.Any())
            {
                if (rfuser[0].TimePassword.Contains(DateTime.Now.Year.ToString()))
                {
                    return true;
                }
            }
            return false;
        }
    }
}