znyc.recruitment.admin.api/Znyc.Recruitment.Admin.Security.Core/Repositories/Recruitment/ApplyJobRepository.cs

using Dapper;
using System.Threading.Tasks;
using Znyc.Recruitment.Admin.Commons.IDbContext;
using Znyc.Recruitment.Admin.Commons.Repositories;
using Znyc.Recruitment.Admin.Security.Entitys;
using Znyc.Recruitment.Admin.Security.IRepositories;

namespace Znyc.Recruitment.Admin.Security.Repositories
{
    /// <summary>
    ///     求职仓储实现
    /// </summary>
    public class ApplyJobRepository : BaseRepository<ApplyJobEntity, long>, IApplyJobRepository
    {
        public ApplyJobRepository()
        {
        }

        public ApplyJobRepository(IDbContextCore context) : base(context)
        {
        }

        /// <summary>
        ///     根据UserId修改求职信息是否实名认证
        /// </summary>
        /// <param name="userId"></param>
        /// <returns></returns>
        public async Task<int> UpdateIsRealAuthenticationAsync(long userId)
        {
            string sql = @"UPDATE rm_applyjob SET IsRealAuthentication=TRUE WHERE UserId=@UserId";
            return await DapperConn.ExecuteAsync(sql, new { UserId = userId });
        }
    }
}