using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using SqlSugar;

namespace HH.WCS.Mobox3.RiDong.util;

internal static class ExpressionHelper
{
    public static Expression<Func<T, bool>> AndAlso<T>(this Expression<Func<T, bool>> left, Expression<Func<T, bool>> right)
    {
        var invokedExpr = Expression.Invoke(right, left.Parameters);
        return Expression.Lambda<Func<T, bool>>(Expression.AndAlso(left.Body, invokedExpr), left.Parameters);
    }
    public class Person
    {
        public string Name { get; set; }
        public int Age { get; set; }
    }
    public static void test()
    {
        var list = new List<Person>();
        list.Add(new Person { Age = 1, Name = "111" });
        list.Add(new Person { Age = 1, Name = "222" });
        list.Add(new Person { Age = 1, Name = "333" });
        list.Add(new Person { Age = 2, Name = "111" });
        list.Add(new Person { Age = 2, Name = "222" });
        list.Add(new Person { Age = 2, Name = "333" });
        list.Add(new Person { Age = 3, Name = "111" });
        list.Add(new Person { Age = 3, Name = "222" });
        list.Add(new Person { Age = 3, Name = "333" });


        Expression<Func<Person, bool>> expression = x => x.Age >= 2;

        expression = expression.AndAlso(x => x.Name == "111").AndAlso(x => x.Age == 3);

        var data = list.Where(expression.Compile()).ToList();
        var name = "";
        var exp = Expressionable.Create<Person>();
        exp.AndIF(!string.IsNullOrEmpty(name), it => it.Age == 1);
        //exp.OrIF(!string.IsNullOrEmpty(name), it => it.Age == 1);//.OrIf 是条件成立才会拼接OR
        exp.Or(it => it.Name.Contains("jack"));//拼接OR
        var people = new SqlHelper<object>().GetInstance().Queryable<Person>().Where(exp.ToExpression()).ToList();
    }
}