/// <summary>
/// 每次的行操作都会判断前面的执行方式
/// </summary>
/// <param name="column"></param>
protected virtual void AddColumn(ColumnRelevanceMapper column)
{
if (_sqlOperatorEnum != SqlOperatorEnum.None)
{
column.SqlOperatorEnum = _sqlOperatorEnum;
//初始化sql操作
_sqlOperatorEnum = SqlOperatorEnum.None;
}
ReduceSql.Add(column);
}
public BatchParameterReduce AddWhere(Expression expression)
{
SqlOperatorEnum operatorEnum = SqlOperatorEnum.None;
if (RenewalHelper.WhereCount() != 0)
{
operatorEnum = SqlOperatorEnum.And;
}
ConvertExpression(expression, RenewalHelper.Where, operatorEnum);
return(this);
}
private SqlOperatorEnum SqlEnumConvert(SqlOperatorEnum sqlOperatorEnum)
{
if (sqlOperatorEnum == SqlOperatorEnum.Equal)
{
return(SqlOperatorEnum.EqualNull);
}
if (sqlOperatorEnum == SqlOperatorEnum.NotEqual)
{
return(SqlOperatorEnum.EqualNotNull);
}
return(SqlOperatorEnum.None);
}
public static String GetOperator(this SqlOperatorEnum sql)
{
switch (sql)
{
case SqlOperatorEnum.And:
return(And);
case SqlOperatorEnum.Equal:
return(Equal);
case SqlOperatorEnum.EqualNotNull:
return(EqualNotNull);
case SqlOperatorEnum.EqualNull:
return(EqualNull);
case SqlOperatorEnum.Having:
return(Having);
case SqlOperatorEnum.In:
return(In);
case SqlOperatorEnum.LeftBrace:
return(LeftBrace);
case SqlOperatorEnum.NotEqual:
return(NotEqual);
case SqlOperatorEnum.On:
return(On);
case SqlOperatorEnum.Or:
return(Or);
case SqlOperatorEnum.OrderBy:
return(OrderBy);
case SqlOperatorEnum.RightBrace:
return(RightBrace);
case SqlOperatorEnum.Select:
return(Select);
case SqlOperatorEnum.Where:
return(Where);
case SqlOperatorEnum.LessThan:
return(Less);
case SqlOperatorEnum.LessThanOrEqual:
return(LessThan);
case SqlOperatorEnum.GreaterThan:
return(Greater);
case SqlOperatorEnum.GreaterThanOrEqual:
return(GreaterThan);
case SqlOperatorEnum.Top:
return(Top);
default:
return("");
}
}
private void ConvertExpression(Expression expression, List <ColumnRelevanceMapper> columns, SqlOperatorEnum operatorEnum = SqlOperatorEnum.None)
{
ParameterReduce parameterReduce = new ParameterReduce(Parameters, columns);
if (operatorEnum != SqlOperatorEnum.None)
{
parameterReduce.AddOperator(operatorEnum);
}
expression.ConvertExpression(parameterReduce);
}
/// <summary>
/// 添加操作符号
/// </summary>
/// <param name="SqlOperatorEnum"></param>
public void AddOperator(SqlOperatorEnum SqlOperatorEnum)
{
this._sqlOperatorEnum = SqlOperatorEnum;
}
