public Script Copy(string appendix)
{
return new Script()
{
ActionsComment = ActionsComment,
ActionsFireSequentially = ActionsFireSequentially,
ActionsIfFalse = ActionsIfFalse.Select(a => a.Copy(appendix)).ToArray(),
ActionsIfTrue = ActionsIfTrue.Select(a => a.Copy(appendix)).ToArray(),
ActiveInEasy = ActiveInEasy,
ActiveInHard = ActiveInHard,
ActiveInMedium = ActiveInMedium,
Comment = Comment,
ConditionsComment = ConditionsComment,
DeactivateUponSuccess = DeactivateUponSuccess,
EvaluationInterval = EvaluationInterval,
EvaluationIntervalType = EvaluationIntervalType,
IsActive = IsActive,
IsSubroutine = IsSubroutine,
LoopActions = LoopActions,
LoopCount = LoopCount,
Name = Name + appendix,
OrConditions = OrConditions.Select(c => c.Copy(appendix)).ToArray(),
SequentialTargetName = SequentialTargetName, // TODO: appendix?
SequentialTargetType = SequentialTargetType,
Unknown = Unknown,
Unknown2 = Unknown2,
Unknown3 = Unknown3,
UsesEvaluationIntervalType = UsesEvaluationIntervalType,
};
}
public Where <TDto, TProperty, TTable> OrWhere <TProperty>(string columnName)
{
var orWhere = new Where <TDto, TProperty, TTable>(TableImpl, Parameters, columnName);
OrConditions.Add(orWhere);
return(orWhere);
}
public void WhereOrCondition(string WhereClauseContent, Guid?GuidParameter)
{
if (GuidParameter == Guid.Empty || GuidParameter == null)
{
return;
}
OrConditions.Add(" " + WhereClauseContent + " ");
}
public void WhereOrCondition(string WhereClauseContent, string StringParameter)
{
if (string.IsNullOrEmpty(StringParameter))
{
return;
}
OrConditions.Add(" " + WhereClauseContent + " ");
}
public void WhereOrCondition(string WhereClauseContent, double?DoubleParameter)
{
if (DoubleParameter == null)
{
return;
}
OrConditions.Add(" " + WhereClauseContent + " ");
}
public void WhereOrCondition(string WhereClauseContent, int?IntParameter)
{
if (IntParameter == null)
{
return;
}
OrConditions.Add(" " + WhereClauseContent + " ");
}
public PredicateProgramDto ToDto()
{
return(new PredicateProgramDto
{
AndConditions = AndConditions != null?AndConditions.Select(ParameterPredicate.ToDto).ToList() : null,
OrConditions = OrConditions != null?OrConditions.Select(ParameterPredicate.ToDto).ToList() : null,
Condition = ParameterPredicate.ToDto(Condition),
Program = Program.Name
});
}
public Where <TDto, TProperty, TTable> OrWhere <TProperty>(Expression <Func <TDto, TProperty> > columnExpression, string colPrefix = null)
{
var columnName = SpryExpression.GetColumnName(columnExpression);
if (!string.IsNullOrWhiteSpace(colPrefix))
{
columnName = colPrefix + "." + columnName;
}
var orWhere = new Where <TDto, TProperty, TTable>(TableImpl, Parameters, columnName);
OrConditions.Add(orWhere);
return(orWhere);
}
public override int GetSize(bool includingHeader)
{
return(base.GetSize(includingHeader)
+ 2
+ Comment.Length
+ 2
+ ConditionComment.Length
+ 2
+ ActionComment.Length
+ 4 * 1
+ 4
+ OrConditions.Sum(o => o.GetSize(true))
+ ActionsIfTrue.Sum(a => a.GetSize(true))
+ ActionsIfFalse.Sum(a => a.GetSize(true)));
}
public string GetQuery()
{
if (!AndConditions.Any() && !OrConditions.Any())
{
return(InitialQuery + " " + WhereClause);
}
var IsFirst = true;
WhereClause = new StringBuilder(" where ");
// Add And Conditions
if (AndConditions.Any())
{
foreach (var condition in AndConditions)
{
if (!IsFirst)
{
WhereClause.Append(" and ");
}
WhereClause.Append(" " + condition + " ");
IsFirst = false;
}
}
//Add Or Conditions
if (OrConditions.Any())
{
foreach (var condition in OrConditions)
{
if (!IsFirst)
{
WhereClause.Append(" or ");
}
WhereClause.Append(" " + condition + " ");
IsFirst = false;
}
}
return(InitialQuery + " " + WhereClause + " " + GroupByClause + " " + HavingClause);
}
public void WhereOrCondition(string WhereClauseContent)
{
OrConditions.Add(" " + WhereClauseContent + " ");
}