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

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


        /// <summary>
        ///     根据ProductId修改通话评价反馈是否已读
        /// </summary>
        /// <param name="productId"></param>
        /// <returns></returns>
        public async Task<int> UpdateIsReadAsync(long userId, long productId, int productType)
        {
            string sql = @"UPDATE rm_call_feedback SET IsRead=TRUE,ModifiedUserId=@ModifiedUserId,ModifiedTime=NOW() WHERE ProductId=@ProductId AND ProductType=@ProductType;";
            return await DapperConn.ExecuteAsync(sql, new { ModifiedUserId = userId, ProductId = productId, ProductType = productType });
        }
    }
}