internal Command Build <T>(Expression <Func <T, T> > updater, Expression <Func <T, bool> > predicate) where T : class
{
//UPDATE TABLE #SET# WHERE 1=1 And FieldName = @p0
Command cmd = this.Build <T>(CommandBuilder.UpdateByExpr, predicate, null, null);
MemberInitExpression updateExpr = (MemberInitExpression)updater.Body;
StringBuilder sqlBuilder = new StringBuilder(Environment.NewLine);
for (int i = 0; i < updateExpr.Bindings.Count; i++)
{
//SQL片断
MemberAssignment member = (MemberAssignment)updateExpr.Bindings[i];
var propertiesMap = MapperBuilder.GetPropertiesMap <T>();
string dbName = member.Member.Name;
if (propertiesMap.ContainsKey(member.Member.Name))
{
dbName = propertiesMap[member.Member.Name].DbName;
}
sqlBuilder.AppendFormat("{0} = {1}{2}", dbName, _parameterPrefix, member.Member.Name);
if (i < updateExpr.Bindings.Count - 1)
{
sqlBuilder.Append(",");
}
sqlBuilder.AppendLine();
//SQL参数
if (member.Expression is ConstantExpression)
{
cmd.DynamicParameters.Add(member.Member.Name, ((ConstantExpression)member.Expression).Value);
}
else
{
//计算常量
PartialEvaluator evaluator = new PartialEvaluator();
Expression evalExpr = evaluator.Eval(member.Expression);
cmd.DynamicParameters.Add(member.Member.Name, ((ConstantExpression)evalExpr).Value);
}
}
cmd.Text = Regex.Replace(cmd.Text, _placeHolderSet, sqlBuilder.ToString(), RegexOptions.IgnoreCase);
return(cmd);
}
/// <summary>
/// 解析脚本条件
/// </summary>
/// <param name="expression">条件表达式</param>
public void Build(Expression expression)
{
this._lstArguments = new List <object>();
this._stcConditions = new Stack <string>();
this._parameters = new XDictionary <string, object>();
this._parameterMembers = new XDictionary <string, string>();
string condition = string.Empty;
//计算常量
PartialEvaluator evaluator = new PartialEvaluator();
Expression evalExpr = evaluator.Eval(expression);
//x=>true 表达式，转成 1==1
if (evalExpr.NodeType == ExpressionType.Constant)
{
evalExpr = VisitBoolean(evalExpr);
}
//遍历整个树节点
this.Visit(evalExpr);
if (this._stcConditions.Count > 0)
{
condition = string.Format(" AND {0}", _stcConditions.Pop());
MatchCollection matches = Regex.Matches(condition, string.Format(@"{0}(?<Name>p(?<Index>[0-9]+))", _parameterPrefix));
foreach (Match match in matches)
{
if (!match.Success)
{
continue;
}
string index = match.Groups["Index"].Value;
string parameterName = match.Groups["Name"].Value;
if (_parameters[parameterName] == null)
{
_parameters.Add(parameterName, _lstArguments[Convert.ToInt32(index)]);
}
}
}
this.Condition = condition;
this.Parameters = _parameters;
}
public void Build(Expression expression, Dictionary <String, PropertyEx> propertiesMap, IDictionary <string, object> dynParameters = null)
{
this._lstArguments = new List <object>();
this._stcConditions = new Stack <string>();
this._parameters = new XDictionary <string, object>();
this._parameterMembers = new XDictionary <string, string>();
this._propertiesMap = propertiesMap;
string condition = string.Empty;
//计算常量
PartialEvaluator evaluator = new PartialEvaluator();
Expression evalExpr = evaluator.Eval(expression);
//x=>true 表达式，转成 1==1
if (evalExpr.NodeType == ExpressionType.Constant)
{
evalExpr = VisitBoolean(evalExpr);
}
//遍历整个树节点
this.Visit(evalExpr);
if (this._stcConditions.Count > 0)
{
condition = string.Format(" AND {0}", _stcConditions.Pop());
MatchCollection matches = Regex.Matches(condition, string.Format(@"{0}(?<Name>p(?<Index>[0-9]+))", _parameterPrefix));
foreach (Match match in matches)
{
if (!match.Success)
{
continue;
}
string index = match.Groups["Index"].Value;
string parameterName = match.Groups["Name"].Value;
if (_parameters[parameterName] == null)
{
_parameters.Add(parameterName, _lstArguments[Convert.ToInt32(index)]);
}
}
}
//处理动态参数
if (dynParameters != null)
{
StringBuilder sb = new StringBuilder();
foreach (KeyValuePair <string, object> item in dynParameters)
{
var pm = propertiesMap.Where(x => x.Key == item.Key);
if (pm.Count() != 0)
{
sb.AppendFormat(" AND {3}{0} = {1}{2} ", pm.First().Value.DbName, _parameterPrefix, item.Key, TableAlias);
}
else
{
sb.AppendFormat(" AND {3}{0} = {1}{2} ", item.Key, _parameterPrefix, item.Key, TableAlias);
}
_parameters.Add(item.Key, item.Value);
}
condition = condition + sb.ToString();
}
this.Condition = condition;
this.Parameters = _parameters;
}
