public static ISetClause SetItem(this ISetClause set, ISetItemExpression setItem)
{
var list = (set.Sets?.ToList() ?? new List <ISetItemExpression>());
list.RemoveAll(s => s.Column.Name == setItem.Column.Name);
list.Add(setItem);
set.Sets = list.ToArray();
return(set);
}
public static ISetClause Values(this ISetClause set, IEnumerable <IValueExpression> values)
{
var list = values.ToList();
for (int i = 0, j = 0; i < set.Sets.Length && j < list.Count;)
{
var setitem = set.Sets[i++];
// 避免覆盖
if (setitem.Value == null)
{
setitem.Value = list[j++];
}
}
set.Sets = set.Sets;
return(set);
}
public static ISetClause SetItemVarCustomer(this ISetClause set, ColumnExpression column, string customer)
{
return(SetItem(set, column.SetVarCustomer(customer)));
}
public static ISetClause SetItemVarParam(this ISetClause set, ColumnExpression column, string param = null)
{
return(SetItem(set, column.SetVarParam(param)));
}
public static ISetClause SetItem(this ISetClause set, ColumnExpression column, object value)
{
return(SetItem(set, column.Set(value)));
}
public static ISetClause SetItem(this ISetClause set, IColumnExpression column, IValueExpression value)
{
return(SetItem(set, column.Set(value)));
}
public static ISetClause ValuesVarCustomer(this ISetClause set, params string[] customrs)
{
return(Values(set, customrs.Select(val => new CustomerExpression(val))));
}
public static ISetClause ValuesVarParam(this ISetClause set)
{
return(Values(set, set.Sets.ToList().FindAll(s => s.Value == null).Select(s => s.Column.ToParam())));
}
public static ISetClause Values(this ISetClause set, params object[] values)
{
return(Values(set, values.Select(val => val is IValueExpression ? val as IValueExpression : new LiteralValueExpression(val))));
}
public static ISetClause ValuesC(this ISetClause set, params string[] customers)
{
return(ValuesVarCustomer(set, customers));
}
public static ISetClause ValuesP(this ISetClause set)
{
return(ValuesVarParam(set));
}
public static ISetClause Vals(this ISetClause set, params object[] values)
{
return(Values(set, values));
}
public static ISetClause Vals(this ISetClause set, IEnumerable <IValueExpression> values)
{
return(Values(set, values));
}
