public static COASqlEqualData <T, T1, T2, T3, T4> Where <T, T1, T2, T3, T4>(this COASqlEqualData <T, T1, T2, T3, T4> data, Expression <Func <T1, T2, T3, T4, bool> > where)
{
var wherestr = Types.PredicateToString(where, data.DataBaseType);
data.WhereQuery = wherestr;
data.SqlQuery += wherestr;
return(data);
}
public static COASqlEqualData <T, T1, T2, T3, T4, T5, T6, T7, T8> Equal <T, T1, T2, T3, T4, T5, T6, T7, T8>(this COASqlJoinData <T, T1, T2, T3, T4, T5, T6, T7, T8> data, Expression <Func <T1, T2, T3, T4, T5, T6, T7, T8, bool> > equal)
{
data.JoinQuery = JoinEqualGenerator(equal, data.JoinType);
foreach (var item in data.JoinQuery)
{
data.SqlQuery += item;
}
var equaldata = new COASqlEqualData <T, T1, T2, T3, T4, T5, T6, T7, T8>();
equaldata.Add(data);
return(equaldata);
}
public static COASqlEqualData <T, T1, T2, T3, T4, T5, T6, T7, T8> OrderByDesc <T, T1, T2, T3, T4, T5, T6, T7, T8>(this COASqlEqualData <T, T1, T2, T3, T4, T5, T6, T7, T8> data, Expression <Func <T1, T2, T3, T4, T5, T6, T7, T8, object> > order)
{
data.OrderQuery = OrderByString(order, true);
data.SqlQuery += data.OrderQuery;
return(data);
}
//JoinOrderByDesc
public static COASqlEqualData <T, T1, T2> OrderByDesc <T, T1, T2>(this COASqlEqualData <T, T1, T2> data, Expression <Func <T1, T2, object> > order)
{
data.OrderQuery = OrderByString(order);
data.SqlQuery += data.OrderQuery;
return(data);
}