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

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

        /// <summary>
        ///     Ìí¼ÓÐÅÏ¢
        /// </summary>
        /// <param name="entity"></param>
        public async Task<object> InsertAsync(MessageEntity entity)
        {
            string sql = string.Format(
                @"INSERT INTO `rm_message`(`CreatedUserId`, `CreatedTime`, `IsDeleted`, `SendId`, `Type`, `GroupId`,
                                    `Content`, `SendTime`, `ProductId`, `Title`, `MessageTitle`, `ProductType`) VALUES
                                    ({0}, now(), 0, {1},{2},{3}, '{4}', now(), {5}, '{6}','{7}', {8}); SELECT LAST_INSERT_ID();",
                entity.SendId, entity.SendId, entity.Type, entity.GroupId, entity.Content, entity.ProductId,
                entity.Title, entity.MessageTitle, entity.ProductType);
            //var input= await DapperConn.QueryFirstOrDefaultAsync<Message>(sql);
            long input = await DapperConn.ExecuteScalarAsync<long>(sql, entity);
            return input;
        }
    }
}