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

        public CertificationRepository(IDbContextCore dbContext) : base(dbContext)
        {
        }

        /// <summary>
        /// </summary>
        /// <param name="UnionId"></param>
        /// <returns></returns>
        public async Task<CertificationEntity> GetAsync(string UnionId)
        {
            string sql = string.Format(
                "SELECT Id,Gender,IdCard,IssuedAddress,PositivePhoto,ReversePhoto,Status from znyc.sys_certification where UnionId='{0}'",
                UnionId);
            return await DapperConn.QueryFirstOrDefaultAsync<CertificationEntity>(sql);
        }
    }
}