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 ISetItemExpression ValueVarParam(this ISetItemExpression setItem, string param = null)
{
if (string.IsNullOrWhiteSpace(param))
{
param = setItem.Column.Name;
}
setItem.Value = new ParamExpression(param);
return(setItem);
}
public static ISetItemExpression ValueVarCustomer(this ISetItemExpression setItem, string customer)
{
setItem.Value = new CustomerExpression(customer);
return(setItem);
}
public static ISetItemExpression ValueVarObject(this ISetItemExpression setItem, object value)
{
setItem.Value = new LiteralValueExpression(value);
return(setItem);
}
public static ISetItemExpression ValueC(this ISetItemExpression setItem, string customer)
{
return(ValueVarCustomer(setItem, customer));
}
public static ISetItemExpression ValueP(this ISetItemExpression setItem, string param = null)
{
return(ValueVarParam(setItem, param));
}
public static ISetItemExpression ValueObj(this ISetItemExpression setItem, object value)
{
return(ValueVarObject(setItem, value));
}
public static IUpdateStatement Set(this IUpdateStatement update, ISetItemExpression setItem)
{
update.Set = update.Set.SetItem(setItem);
return(update);
}
