using System.Linq.Expressions;
using SqlSugar;

namespace KH.WMS.Core.Database.Repositories;

/// <summary>
/// 仓储接口
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
public interface IRepository<T, TKey> 
    where T : class
    where TKey : struct
{
    /// <summary>
    /// 根据ID获取实体
    /// </summary>
    Task<T?> GetByIdAsync(TKey id);

    /// <summary>
    /// 获取所有实体
    /// </summary>
    Task<List<T>> GetAllAsync();

    /// <summary>
    /// 根据条件查询实体
    /// </summary>
    Task<List<T>> GetListAsync(Expression<Func<T, bool>> expression);

    /// <summary>
    /// 根据条件查询单个实体
    /// </summary>
    Task<T?> GetFirstOrDefaultAsync(Expression<Func<T, bool>> expression);

    /// <summary>
    /// 分页查询
    /// </summary>
    Task<(List<T> Items, int Total)> GetPagedListAsync(int pageIndex, int pageSize, Expression<Func<T, bool>>? expression = null);

    /// <summary>
    /// 插入实体
    /// </summary>
    Task<TKey> InsertAsync(T entity);

    /// <summary>
    /// 批量插入实体
    /// </summary>
    Task<List<TKey>> InsertAsync(List<T> entities);

    /// <summary>
    /// 
    /// </summary>
    /// <param name="entity"></param>
    /// <returns></returns>
    Task<T> InsertReturnEntityAsync(T entity);

    /// <summary>
    /// 
    /// </summary>
    /// <param name="entities"></param>
    /// <returns></returns>
    Task<List<T>> InsertReturnEntityAsync(List<T> entities);

    /// <summary>
    /// 更新实体
    /// </summary>
    Task<bool> UpdateAsync(T entity);

    /// <summary>
    /// 批量更新实体
    /// </summary>
    Task<bool> UpdateAsync(List<T> entities);

    /// <summary>
    /// 删除实体
    /// </summary>
    Task<bool> DeleteAsync(TKey id);

    /// <summary>
    /// 批量删除实体
    /// </summary>
    Task<bool> DeleteAsync(List<TKey> ids);

    /// <summary>
    /// 根据条件删除实体
    /// </summary>
    Task<bool> DeleteAsync(Expression<Func<T, bool>> expression);

    /// <summary>
    /// 检查实体是否存在
    /// </summary>
    Task<bool> ExistsAsync(Expression<Func<T, bool>> expression);

    /// <summary>
    /// 获取实体数量
    /// </summary>
    Task<int> CountAsync(Expression<Func<T, bool>>? expression = null);
}