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);
        }
    }
}