using System;
using System.Linq.Expressions;


namespace Mtxfw.Utility.DataAccess
{
    /// <summary>
    /// 删除类
    /// </summary>
    public partial class Sql : DbHelperSqlSugar
    {
        /// <summary>
        /// 根据实体类删除数据
        /// </summary>
        /// <typeparam name="T">实体类名称</typeparam>
        /// <param name="entity">实体类</param>
        /// <returns></returns>
        public int Del<T>(T entity) where T : class, new()
        {
            return Db.Deleteable<T>(entity).ExecuteCommand();
        }

        /// <summary>
        /// 根据主键删除数据
        /// </summary>
        /// <typeparam name="T">实体类名称</typeparam>
        /// <param name="keyValue">主键</param>
        /// <returns></returns>
        public int Del<T>(int keyValue) where T : class, new()
        {
            return Db.Deleteable<T>(keyValue).ExecuteCommand();
        }

        /// <summary>
        /// 根据主键批量删除
        /// </summary>
        /// <typeparam name="T">实体类名称</typeparam>
        /// <param name="keyValues">主键集合</param>
        /// <returns></returns>
        public int Del<T>(object[] keyValues) where T : class, new()
        {
            return Db.Deleteable<T>(keyValues).ExecuteCommand();
        }

        /// <summary>
        /// 根据条件删除
        /// </summary>
        /// <typeparam name="T">实体类名称</typeparam>
        /// <param name="predicate">linq 条件 -> (t => t.id == 1 && t.name == "aaaa")</param>
        /// <returns></returns>
        public int Del<T>(Expression<Func<T, bool>> predicate) where T : class, new()
        {
            return Db.Deleteable<T>(predicate).ExecuteCommand();
        }
    }
}