znyc.recruitment.admin.api/Znyc.Recruitment.Admin.Security.Core/Repositories/Recruitment/RecruitmentRepository.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 RecruitmentRepository : BaseRepository<RecruitmentEntity, long>, IRecruitmentRepository
    {
        public RecruitmentRepository()
        {
        }

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

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