znyc.cloudcar/Znyc.CloudCar.Repository/Audit/AuditRepository.cs

using FreeSql;
using Znyc.CloudCar.Auth.HttpContextUser;
using Znyc.CloudCar.IRepository.Audit;
using Znyc.CloudCar.Model.Entities;

namespace Znyc.CloudCar.Repository.Audit
{
    public class AuditRepository : RepositoryBase<AuditEntity>, IAuditRepository
    {
        public AuditRepository(UnitOfWorkManager uowm, IHttpContextUser user) : base(uowm, user)
        {
        }

        /// <summary>
        /// 审核失败列表
        /// </summary>
        /// <param name="userId"></param>
        /// <returns></returns>
        public async Task<List<AuditEntity>> GetAuditFailListAsync(long userId)
        {
            return await Orm.Ado.QueryAsync<AuditEntity>(@"SELECT t.EquipmentId,t.EquipmentTitle,t.HandleStatus,t.Note,t.ModifiedTime,t.CreatedTime  FROM
                        (SELECT EquipmentId,max(CreatedTime) as CreatedTime FROM audit WHERE HandleStatus = 4 AND (EquipmentId in
                                (SELECT Id FROM equipment WHERE UserId =?userId  AND `State`= 30 AND IsDeleted = 0)) GROUP BY EquipmentId) a
                        INNER JOIN audit t ON t.EquipmentId = a.EquipmentId AND t.CreatedTime = a.CreatedTime", new { userId });
        }
    }
}