using Dapper;
using Znyc.Cloudcar.Admin.Commons.IDbContext;
using Znyc.Cloudcar.Admin.Commons.Repositories;
using Znyc.Cloudcar.Admin.Security.Entitys;
using Znyc.Cloudcar.Admin.Security.IRepositories;

namespace Znyc.Cloudcar.Admin.Security.Repositories
{
    /// <summary>
    ///     应用仓储实现
    /// </summary>
    public class AuditRepository : BaseRepository<AuditEntity, long>, IAuditRepository
    {
        public AuditRepository()
        {
        }

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

        /// <summary>
        ///     根据
        /// </summary>
        /// <param name="productId">产品ID</param>
        /// <param name="productType">产品类型</param>
        /// <returns></returns>
        public AuditEntity GetProductAuditByProductId(string productId, string productType)
        {
            string sql = string.Format(
                "SELECT * from ProductAudit where ProductId={0} and ProductType={1} and IsDeleted=0",
                productId, productType);
            return DapperConn.QueryFirstOrDefault<AuditEntity>(sql);
        }
    }
}