天天看點

Dapper Extensions NOT IN OR IN OR 嵌套

var pgMain = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List<IPredicate>() };
var exclude = new List<string>();

// Dapper NOT IN
pgMain.Predicates.Add(Predicates.Field<T_ADC_Model>(f => f.ID, Operator.Eq, exclude, true));

//Dapper IN
pgMain.Predicates.Add(Predicates.Field<T_ADC_Model>(f => f.ID, Operator.Eq, exclude,));

//Dapper 嵌套
var pgSearch = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List<IPredicate>() };
pgSearch.Predicates.Add(Predicates.Field<T_ADC_Model>(f => f.UpdateTime, Operator.Ge, "開始時間"));
pgSearch.Predicates.Add(Predicates.Field<T_ADC_Model>(f => f.UpdateTime, Operator.Le, "結束時間"));
pgMain.Predicates.Add(pgSearch);