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

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

        /// <summary>
        ///     »ñÈ¡Ç°Ò»ÌìÊý¾Ýͳ¼Æ
        /// </summary>
        /// <returns></returns>
        public async Task<StatisticalEntity> GetStatisticalAsync()
        {
            string sql = @"SELECT * FROM sys_statistical ORDER BY CreatedTime DESC";
            return await DapperConn.QueryFirstOrDefaultAsync<StatisticalEntity>(sql);
        }
    }
}