public void IsNotNull_Invoke_IsNotNull_ReturnsFalse()
{
//------------Setup for test--------------------------
var notStartsWith = new IsNotNull();
string[] cols = new string[2];
cols[0] = null;
//------------Execute Test---------------------------
bool result = notStartsWith.Invoke(cols);
//------------Assert Results-------------------------
Assert.IsFalse(result);
}
/// <summary>
/// Deserializes the specified configuration in an <see cref="IsNotNull"/> object
/// </summary>
/// <param name="configuration">The configuration.</param>
/// <returns></returns>
public override SqlTag Deserialize(IConfiguration configuration)
{
IsNotNull isNotNull = new IsNotNull(accessorFactory);
/*isNotNull节点格式例子
* <isNotNull property="NullBannerOption">
* ,@{NullBannerOption,column=Account_Banner_Option,dbType=Varchar,type=bool}
* </isNotNull>
*/
isNotNull.Prepend = ConfigurationUtils.GetStringAttribute(configuration.Attributes, "prepend");
isNotNull.Property = ConfigurationUtils.GetStringAttribute(configuration.Attributes, "property");
return(isNotNull);
}
public void GivenSomeString_IsNotNull_Invoke_ReturnsTrue()
{
//------------Setup for test--------------------------
var isNotNull = new IsNotNull();
var cols = new string[2];
cols[0] = "Eight";
//------------Execute Test---------------------------
var result = isNotNull.Invoke(cols);
//------------Assert Results-------------------------
Assert.IsTrue(result);
//------------Execute Test---------------------------
result = isNotNull.Invoke(null);
//------------Assert Results-------------------------
Assert.IsFalse(result);
}
public static ITag LoadTag(XmlNode xmlNode, IList <Include> includes)
{
ITag tag = null;
bool isIn = xmlNode.Attributes?["In"] != null;
var prepend = xmlNode.Attributes?["Prepend"]?.Value.Trim();
var property = xmlNode.Attributes?["Property"]?.Value.Trim();
var compareValue = xmlNode.Attributes?["CompareValue"]?.Value.Trim();
#region Init Tag
switch (xmlNode.Name)
{
case "#text":
case "#cdata-section":
{
var bodyText = " " + xmlNode.InnerText.Replace("\n", "").Trim();
return(new SqlText
{
BodyText = bodyText
});
}
case "Include":
{
var refId = xmlNode.Attributes?["RefId"]?.Value;
var include_tag = new Include
{
RefId = refId,
Prepend = prepend
};
includes.Add(include_tag);
tag = include_tag;
break;
}
case "IsEmpty":
{
tag = new IsEmpty
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsEqual":
{
tag = new IsEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsGreaterEqual":
{
tag = new IsGreaterEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsGreaterThan":
{
tag = new IsGreaterThan
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsLessEqual":
{
tag = new IsLessEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsLessThan":
{
tag = new IsLessThan
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotEmpty":
{
tag = new IsNotEmpty
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotEqual":
{
tag = new IsNotEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotNull":
{
tag = new IsNotNull
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsNull":
{
tag = new IsNull
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsTrue":
{
tag = new IsTrue
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsFalse":
{
tag = new IsFalse
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsProperty":
{
tag = new IsProperty
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "Switch":
{
tag = new Switch
{
Property = property,
//Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
case "Case":
{
var switchNode = xmlNode.ParentNode;
var switchProperty = switchNode.Attributes?["Property"]?.Value.Trim();
var switchPrepend = switchNode.Attributes?["Prepend"]?.Value.Trim();
tag = new Switch.Case
{
CompareValue = compareValue,
Property = switchProperty,
Prepend = switchPrepend,
ChildTags = new List <ITag>()
};
break;
}
case "Default":
{
var switchNode = xmlNode.ParentNode;
var switchProperty = switchNode.Attributes?["Property"]?.Value.Trim();
var switchPrepend = switchNode.Attributes?["Prepend"]?.Value.Trim();
tag = new Switch.Defalut
{
Property = switchProperty,
Prepend = switchPrepend,
ChildTags = new List <ITag>()
};
break;
}
case "Dynamic":
{
tag = new Dynamic
{
Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
case "Where":
{
tag = new Where
{
ChildTags = new List <ITag>()
};
break;
}
case "Set":
{
tag = new Set
{
ChildTags = new List <ITag>()
};
break;
}
case "For":
{
var open = xmlNode.Attributes?["Open"]?.Value.Trim();
var separator = xmlNode.Attributes?["Separator"]?.Value.Trim();
var close = xmlNode.Attributes?["Close"]?.Value.Trim();
var key = xmlNode.Attributes?["Key"]?.Value.Trim();
tag = new For
{
Prepend = prepend,
Property = property,
Open = open,
Close = close,
Separator = separator,
Key = key,
ChildTags = new List <ITag>()
};
break;
}
case "Env":
{
var dbProvider = xmlNode.Attributes?["DbProvider"]?.Value.Trim();
tag = new Env
{
Prepend = prepend,
DbProvider = dbProvider,
ChildTags = new List <ITag>()
};
break;
}
case "#comment": { break; }
default:
{
throw new SmartSqlException($"Statement.LoadTag unkonw tagName:{xmlNode.Name}.");
};
}
#endregion
foreach (XmlNode childNode in xmlNode)
{
ITag childTag = LoadTag(childNode, includes);
if (childTag != null && tag != null)
{
(tag as Tag).ChildTags.Add(childTag);
}
}
return(tag);
}
private ITag LoadTag(XmlNode xmlNode, Statement statement)
{
ITag tag = null;
var prepend = xmlNode.Attributes?["Prepend"]?.Value.Trim();
var property = xmlNode.Attributes?["Property"]?.Value.Trim();
var compareValue = xmlNode.Attributes?["CompareValue"]?.Value.Trim();
#region Init Tag
switch (xmlNode.Name)
{
case "#text":
case "#cdata-section":
{
var innerText = xmlNode.InnerText;
var bodyText = innerText;
//bodyText += innerText.Trim().Replace("\r", " ").Replace("\n", " ");
//bodyText += " ";
return(new SqlText
{
Statement = statement,
BodyText = bodyText
});
}
case "Include":
{
var refId = xmlNode.Attributes?["RefId"]?.Value;
if (refId.IndexOf('.') < 0)
{
refId = $"{statement.SmartSqlMap.Scope}.{refId}";
}
var include_tag = new Include
{
RefId = refId,
Prepend = xmlNode.Attributes?["Prepend"]?.Value
};
statement.IncludeDependencies.Add(include_tag);
tag = include_tag;
break;
}
case "IsEmpty":
{
tag = new IsEmpty
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsEqual":
{
tag = new IsEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsGreaterEqual":
{
tag = new IsGreaterEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsGreaterThan":
{
tag = new IsGreaterThan
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsLessEqual":
{
tag = new IsLessEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsLessThan":
{
tag = new IsLessThan
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotEmpty":
{
tag = new IsNotEmpty
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotEqual":
{
tag = new IsNotEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotNull":
{
tag = new IsNotNull
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsNull":
{
tag = new IsNull
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsTrue":
{
tag = new IsTrue
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsFalse":
{
tag = new IsFalse
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsProperty":
{
tag = new IsProperty
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "Placeholder":
{
tag = new Placeholder
{
Prepend = xmlNode.Attributes?["Prepend"]?.Value,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "Switch":
{
tag = new Switch
{
Property = property,
Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
case "Case":
{
var switchNode = xmlNode.ParentNode;
var switchProperty = switchNode.Attributes?["Property"]?.Value.Trim();
var switchPrepend = switchNode.Attributes?["Prepend"]?.Value.Trim();
tag = new Switch.Case
{
CompareValue = compareValue,
Property = switchProperty,
Prepend = switchPrepend,
ChildTags = new List <ITag>()
};
break;
}
case "Default":
{
var switchNode = xmlNode.ParentNode;
var switchProperty = switchNode.Attributes?["Property"]?.Value.Trim();
var switchPrepend = switchNode.Attributes?["Prepend"]?.Value.Trim();
tag = new Switch.Defalut
{
Property = switchProperty,
Prepend = switchPrepend,
ChildTags = new List <ITag>()
};
break;
}
case "Dynamic":
{
tag = new Dynamic
{
Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
case "Where":
{
tag = new Where
{
ChildTags = new List <ITag>()
};
break;
}
case "Set":
{
tag = new Set
{
ChildTags = new List <ITag>()
};
break;
}
case "For":
{
var open = xmlNode.Attributes?["Open"]?.Value.Trim();
var separator = xmlNode.Attributes?["Separator"]?.Value.Trim();
var close = xmlNode.Attributes?["Close"]?.Value.Trim();
var key = xmlNode.Attributes?["Key"]?.Value.Trim();
tag = new For
{
Prepend = prepend,
Property = property,
Open = open,
Close = close,
Separator = separator,
Key = key,
ChildTags = new List <ITag>()
};
break;
}
case "Env":
{
var dbProvider = xmlNode.Attributes?["DbProvider"]?.Value.Trim();
tag = new Env
{
Prepend = prepend,
DbProvider = dbProvider,
ChildTags = new List <ITag>()
};
break;
}
case "#comment": { return(null); }
default:
{
throw new SmartSqlException($"Statement.LoadTag unkonw tagName:{xmlNode.Name}.");
};
}
tag.Statement = statement;
#endregion
foreach (XmlNode childNode in xmlNode)
{
ITag childTag = LoadTag(childNode, statement);
if (childTag != null && tag != null)
{
childTag.Parent = tag;
(tag as Tag).ChildTags.Add(childTag);
}
}
return(tag);
}
public static ITag LoadTag(XmlNode xmlNode)
{
ITag tag = null;
bool isIn = xmlNode.Attributes?["In"] != null;
var prepend = xmlNode.Attributes?["Prepend"]?.Value;
var property = xmlNode.Attributes?["Property"]?.Value;
var compareValue = xmlNode.Attributes?["CompareValue"]?.Value;
#region Init Tag
switch (xmlNode.Name)
{
case "#text":
case "#cdata-section":
{
var bodyText = xmlNode.InnerText.Replace("\n", "");
return(new SqlText
{
BodyText = bodyText
});
}
case "IsEmpty":
{
tag = new IsEmpty
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsEqual":
{
tag = new IsEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsGreaterEqual":
{
tag = new IsGreaterEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
};
break;
}
case "IsGreaterThan":
{
tag = new IsGreaterThan
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsLessEqual":
{
tag = new IsLessEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsLessThan":
{
tag = new IsLessThan
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotEmpty":
{
tag = new IsNotEmpty
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotEqual":
{
tag = new IsNotEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotNull":
{
tag = new IsNotNull
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsNull":
{
tag = new IsNull
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsTrue":
{
tag = new IsTrue
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsFalse":
{
tag = new IsFalse
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "Switch":
{
tag = new Switch
{
Property = property,
//Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
case "Case":
{
var switchNode = xmlNode.ParentNode;
var switchProperty = switchNode.Attributes?["Property"]?.Value;
var switchPrepend = switchNode.Attributes?["Prepend"]?.Value;
tag = new Switch.Case
{
CompareValue = compareValue,
Property = switchProperty,
Prepend = switchPrepend,
ChildTags = new List <ITag>()
};
break;
}
case "#comment": { break; }
default: { break; };
}
#endregion
foreach (XmlNode childNode in xmlNode)
{
ITag childTag = LoadTag(childNode);
(tag as Tag).ChildTags.Add(childTag);
}
return(tag);
}
public static void CreateFilter(object sender, object selectedItem)
{
if (selectedItem is FilterCollectionViewModel filterCollectionViewModel)
{
CreateFilter(sender, filterCollectionViewModel.Parent);
return;
}
var button = (Button)sender;
var type = (string)button.CommandParameter;
FilterBase entity;
switch (type)
{
case nameof(ActiveOn):
entity = ActiveOn.New("0001-01-01");
break;
case nameof(ActiveWithin):
entity = ActiveWithin.New("0001-01-01,0001-01-01");
break;
case nameof(OfType):
entity = OfType.New("TypeName");
break;
case nameof(NotOfType):
entity = NotOfType.New("TypeName");
break;
case nameof(Contain):
entity = Contain.New("Property", "Value");
break;
case nameof(NotContain):
entity = NotContain.New("Property", "Value");
break;
case nameof(EqualTo):
entity = EqualTo.New("Property", "Value");
break;
case nameof(NotEqualTo):
entity = NotEqualTo.New("Property", "Value");
break;
case nameof(GreaterThan):
entity = GreaterThan.New("Property", "Value");
break;
case nameof(LessThan):
entity = LessThan.New("Property", "Value");
break;
case nameof(GreaterThanEqualTo):
entity = GreaterThanEqualTo.New("Property", "Value");
break;
case nameof(LessThanEqualTo):
entity = LessThanEqualTo.New("Property", "Value");
break;
case nameof(Between):
entity = Between.New("Property", "0001-01-01", "0001-01-01");
break;
case nameof(WithinArray):
entity = WithinArray.New("Property", "ValueA,ValueB,ValueC");
break;
case nameof(NotWithinArray):
entity = NotWithinArray.New("Property", "ValueA,ValueB,ValueC");
break;
case nameof(IsNull):
entity = IsNull.New("Property");
break;
case nameof(IsNotNull):
entity = IsNotNull.New("Property");
break;
case nameof(IsNullOrGreaterThan):
entity = IsNullOrGreaterThan.New("Property", "Value");
break;
case nameof(IsNullOrGreaterThanEqualTo):
entity = IsNullOrGreaterThanEqualTo.New("Property", "Value");
break;
case nameof(IsNullOrLessThan):
entity = IsNullOrLessThan.New("Property", "Value");
break;
case nameof(IsNullOrLessThanEqualTo):
entity = IsNullOrLessThanEqualTo.New("Property", "Value");
break;
case nameof(StartsWith):
entity = StartsWith.New("Property", "Value");
break;
case nameof(EndsWith):
entity = EndsWith.New("Property", "Value");
break;
case nameof(TakeFirst):
entity = TakeFirst.New(1);
break;
case nameof(OfDerivedType):
entity = OfDerivedType.New("TypeName");
break;
case nameof(NotOfDerivedType):
entity = NotOfDerivedType.New("TypeName");
break;
default:
throw new ArgumentOutOfRangeException();
}
FilterViewModel viewModel;
FilterCollectionViewModel viewModelCollection;
if (selectedItem is GroupViewModel entityGroupViewModel)
{
entityGroupViewModel.IsExpanded = true;
entityGroupViewModel.Element.Filters.Add(entity);
viewModelCollection = entityGroupViewModel.Children.OfType <FilterCollectionViewModel>().First();
viewModel = new FilterViewModel(entity, viewModelCollection);
viewModelCollection.Children.Add(viewModel);
}
else if (selectedItem is OutputViewModel outputViewModel)
{
if (!(outputViewModel.Element is AggregateOutputBase elementAsAggregate))
{
return;
}
outputViewModel.IsExpanded = true;
elementAsAggregate.Filters.Add(entity);
viewModelCollection = outputViewModel.Children.OfType <FilterCollectionViewModel>().First();
viewModel = new FilterViewModel(entity, viewModelCollection);
viewModelCollection.Children.Add(viewModel);
}
else
{
return;
}
viewModelCollection.IsExpanded = true;
viewModel.IsSelected = true;
viewModel.IsExpanded = true;
}
private void Criteria_Activated(object sender, EventArgs e)
{
DisableValueFields();
if (BasicOp.Checked)
{
Value.Enabled = true;
if (Visible)
{
Value.Focus();
}
}
else if (InList.Checked)
{
ValueList.Enabled = true;
ImportList.Enabled = true;
EditList.Enabled = true;
if (Visible)
{
ValueList.Focus();
}
}
else if (Between.Checked)
{
Limit1.Enabled = true;
Limit2.Enabled = true;
if (Visible)
{
Limit1.Focus();
}
}
else if (Like.Checked)
{
Substring.Enabled = true;
if (Visible)
{
Substring.Focus();
}
}
else if (Within.Checked)
{
WithinValue.Enabled = true;
WithinUnits.Enabled = true;
if (Visible)
{
WithinValue.Focus();
}
}
else if (All.Checked)
{
All.Focus();
}
else if (IsNotNull.Checked)
{
IsNotNull.Focus();
}
else if (IsNull.Checked)
{
IsNull.Focus();
}
else if (None.Checked)
{
None.Focus();
}
}
private ITag LoadTag(XNode xmlNode, IList <Include> includes)
{
ITag tag = null;
var prepend = xmlNode?.GetAttribute("Prepend")?.Trim();
var property = xmlNode?.GetAttribute("Property")?.Trim();
var compareValue = xmlNode?.GetAttribute("CompareValue")?.Trim();
#region Init Tag
switch (xmlNode.GetName())
{
case "#text":
case "#cdata-section":
{
var bodyText = " " + xmlNode.GetValue().Replace("\n", "").Trim();
return(new SqlText
{
LineInfo = XmlLineInfo.Create(xmlNode),
BodyText = bodyText
});
}
case "If":
{
tag = new IfTag
{
Test = xmlNode.GetAttribute("Test")
};
break;
}
case "Include":
{
var refId = xmlNode?.GetAttribute("RefId");
var include_tag = new Include
{
RefId = refId,
Prepend = prepend
};
includes.Add(include_tag);
tag = include_tag;
break;
}
case "IsEmpty":
{
tag = new IsEmpty
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsEqual":
{
tag = new IsEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "Bind":
{
tag = new BindTag
{
Name = xmlNode.GetAttribute("Name"),
Value = xmlNode.GetAttribute("Value"),
};
break;
}
case "Trim":
{
tag = new TrimTag
{
Prefix = xmlNode.GetAttribute("Prefix"),
PrefixOverrides = xmlNode.GetAttribute("PrefixOverrides"),
Suffix = xmlNode.GetAttribute("Suffix"),
ChildTags = new List <ITag>(),
};
break;
}
case "IsGreaterEqual":
{
tag = new IsGreaterEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsGreaterThan":
{
tag = new IsGreaterThan
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsLessEqual":
{
tag = new IsLessEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsLessThan":
{
tag = new IsLessThan
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotEmpty":
{
tag = new IsNotEmpty
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotEqual":
{
tag = new IsNotEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotNull":
{
tag = new IsNotNull
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsNull":
{
tag = new IsNull
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsTrue":
{
tag = new IsTrue
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsFalse":
{
tag = new IsFalse
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsProperty":
{
tag = new IsProperty
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "Placeholder":
{
tag = new Placeholder
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "Switch":
{
tag = new Switch
{
Property = property,
Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
case "Case":
{
var switchNode = xmlNode.Parent;
var switchProperty = xmlNode?.GetAttribute("Property")?.Trim();
var switchPrepend = xmlNode?.GetAttribute("Prepend")?.Trim();
tag = new Switch.Case
{
CompareValue = compareValue,
Property = switchProperty,
Prepend = switchPrepend,
Test = xmlNode?.GetAttribute("Test")?.Trim(),
ChildTags = new List <ITag>()
};
break;
}
case "Default":
{
var switchNode = xmlNode.Parent;
var switchProperty = xmlNode?.GetAttribute("Property")?.Trim();
var switchPrepend = xmlNode?.GetAttribute("Prepend")?.Trim();
tag = new Switch.Defalut
{
Property = switchProperty,
Prepend = switchPrepend,
ChildTags = new List <ITag>()
};
break;
}
case "Dynamic":
{
tag = new Dynamic
{
Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
case "Where":
{
tag = new Where
{
ChildTags = new List <ITag>()
};
break;
}
case "Set":
{
tag = new Set
{
ChildTags = new List <ITag>()
};
break;
}
case "For":
{
var open = xmlNode?.GetAttribute("Open")?.Trim();
var separator = xmlNode?.GetAttribute("Separator")?.Trim();
var close = xmlNode?.GetAttribute("Close")?.Trim();
var key = xmlNode?.GetAttribute("Key")?.Trim();
var index = xmlNode?.GetAttribute("Index")?.Trim();
tag = new For
{
Prepend = prepend,
Property = property,
Open = open,
Close = close,
Index = index,
Separator = separator,
Key = key,
ChildTags = new List <ITag>()
};
break;
}
case "Env":
{
var dbProvider = xmlNode?.GetAttribute("DbProvider")?.Trim();
tag = new Env
{
Prepend = prepend,
DbProvider = dbProvider,
ChildTags = new List <ITag>()
};
break;
}
case "#comment": { break; }
default:
{
throw new SmartSqlException($"Statement.LoadTag unkonw tagName:{xmlNode.GetName()}.");
};
}
#endregion
if (tag != null)
{
tag.LineInfo = XmlLineInfo.Create(xmlNode);
}
if (xmlNode is XElement ell)
{
foreach (XNode childNode in ell.Nodes())
{
ITag childTag = LoadTag(childNode, includes);
if (childTag != null && tag != null)
{
childTag.Parent = tag;
(tag as Tag).ChildTags.Add(childTag);
}
}
}
return(tag);
}
public static ITag LoadTag(XNode node)
{
ITag tag = null;
if (node.NodeType == System.Xml.XmlNodeType.Text || node.NodeType == System.Xml.XmlNodeType.CDATA)
{
tag = new SqlText
{
BodyText = node.ToString()
};
}
if (node.NodeType == System.Xml.XmlNodeType.Element)
{
XElement elenode = node as XElement;
bool isIn = elenode.Attribute("In") != null;
var prepend = elenode.Attribute("Prepend")?.Value.Trim();
var property = elenode.Attribute("Property")?.Value.Trim();
var compareValue = elenode.Attribute("CompareValue")?.Value.Trim();
var nodeName = elenode.Name.LocalName;
switch (nodeName)
{
case "IsEmpty":
{
tag = new IsEmpty
{
Prepend = prepend,
Property = property,
Children = new List <ITag>()
};
break;
}
case "IsEqual":
{
tag = new IsEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
Children = new List <ITag>()
};
break;
}
case "IsNotEqual":
{
tag = new IsNotEqual
{
Prepend = prepend,
CompareValue = compareValue,
Property = property,
Children = new List <ITag>()
};
break;
}
case "IsGreaterEqual":
{
tag = new IsGreaterEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
};
break;
}
case "IsGreaterThan":
{
tag = new IsGreaterThan
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
Children = new List <ITag>()
};
break;
}
case "IsLessEqual":
{
tag = new IsLessEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
Children = new List <ITag>()
};
break;
}
case "IsLessThan":
{
tag = new IsLessThan
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
Children = new List <ITag>()
};
break;
}
case "IsNotEmpty":
{
tag = new IsNotEmpty
{
Prepend = prepend,
Property = property,
Children = new List <ITag>()
};
break;
}
case "IsNotNull":
{
tag = new IsNotNull
{
Prepend = prepend,
Property = property,
Children = new List <ITag>()
};
break;
}
case "IsNull":
{
tag = new IsNull
{
Prepend = prepend,
Property = property,
Children = new List <ITag>()
};
break;
}
case "Switch":
{
tag = new Switch
{
// Prepend = prepend,
Property = property,
Children = new List <ITag>()
};
break;
}
case "Case":
{
var switchNode = node.Parent;
var switchProperty = switchNode.Attribute("Property")?.Value.Trim();
var switchPrepend = switchNode.Attribute("Prepend")?.Value.Trim();
tag = new Switch.Case
{
Prepend = switchPrepend,
Property = switchProperty,
CompareValue = compareValue,
Children = new List <ITag>()
};
break;
}
case "Default":
{
var switchNode = node.Parent;
var switchProperty = switchNode.Attribute("Property")?.Value.Trim();
var switchPrepend = switchNode.Attribute("Prepend")?.Value.Trim();
tag = new Switch.Default
{
Prepend = switchPrepend,
Property = switchProperty,
Children = new List <ITag>()
};
break;
}
case "Where":
{
tag = new Where
{
Children = new List <ITag>()
};
break;
}
case "Dynamic":
{
tag = new Dynamic
{
Prepend = prepend,
Children = new List <ITag>()
};
break;
}
case "IsProperty":
{
tag = new IsProperty
{
Prepend = prepend,
Children = new List <ITag>(),
Property = property
};
break;
}
default:
{
throw new BaraException($"Statement can't load TagName:{nodeName}");
}
}
foreach (var childNode in elenode.Nodes())
{
ITag childTag = LoadTag(childNode);
if (childTag != null && tag != null)
{
(tag as Tag).Children.Add(childTag);
}
}
}
return(tag);
}
public ITag Build(XmlNode xmlNode)
{
ITag tag = null;
var prepend = xmlNode.Attributes?["Prepend"]?.Value.Trim();
var property = xmlNode.Attributes?["Property"]?.Value.Trim();
var compareValue = xmlNode.Attributes?["CompareValue"]?.Value.Trim();
#region Init Tag
switch (xmlNode.Name)
{
case "#text":
case "#cdata-section":
{
var bodyText = " " + xmlNode.InnerText.Replace("\n", "").Trim();
return(new SqlText
{
BodyText = bodyText
});
}
case "Include":
{
var refId = xmlNode.Attributes?["RefId"]?.Value;
var include_tag = new Include
{
RefId = refId,
Prepend = prepend
};
//includes.Add(include_tag);
tag = include_tag;
break;
}
case "IsEmpty":
{
tag = new IsEmpty
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsEqual":
{
tag = new IsEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsGreaterEqual":
{
tag = new IsGreaterEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsGreaterThan":
{
tag = new IsGreaterThan
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsLessEqual":
{
tag = new IsLessEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsLessThan":
{
tag = new IsLessThan
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotEmpty":
{
tag = new IsNotEmpty
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotEqual":
{
tag = new IsNotEqual
{
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
case "IsNotNull":
{
tag = new IsNotNull
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsNull":
{
tag = new IsNull
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsTrue":
{
tag = new IsTrue
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsFalse":
{
tag = new IsFalse
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "IsProperty":
{
tag = new IsProperty
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "Placeholder":
{
tag = new Placeholder
{
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
case "Switch":
{
tag = new Switch
{
Property = property,
Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
case "Case":
{
var switchNode = xmlNode.ParentNode;
var switchProperty = switchNode.Attributes?["Property"]?.Value.Trim();
var switchPrepend = switchNode.Attributes?["Prepend"]?.Value.Trim();
tag = new Switch.Case
{
CompareValue = compareValue,
Property = switchProperty,
Prepend = switchPrepend,
Test = xmlNode.Attributes?["Test"]?.Value.Trim(),
ChildTags = new List <ITag>()
};
break;
}
case "Bind":
{
tag = new BindTag
{
Name = xmlNode.Attributes["Name"]?.Value,
Value = xmlNode.Attributes["Value"]?.Value,
};
break;
}
case "Trim":
{
tag = new TrimTag
{
Prefix = xmlNode.Attributes["Prefix"]?.Value,
PrefixOverrides = xmlNode.Attributes["PrefixOverrides"]?.Value,
Suffix = xmlNode.Attributes["Suffix"]?.Value,
ChildTags = new List <ITag>()
};
break;
}
case "Default":
{
var switchNode = xmlNode.ParentNode;
var switchProperty = switchNode.Attributes?["Property"]?.Value.Trim();
var switchPrepend = switchNode.Attributes?["Prepend"]?.Value.Trim();
tag = new Switch.Defalut
{
Property = switchProperty,
Prepend = switchPrepend,
ChildTags = new List <ITag>()
};
break;
}
case "Dynamic":
{
tag = new Dynamic
{
Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
case "Where":
{
tag = new Where
{
ChildTags = new List <ITag>()
};
break;
}
case "If":
{
var test = xmlNode.Attributes["Test"]?.Value;
tag = new IfTag
{
Test = test
};
}
break;
case "Set":
{
tag = new Set
{
ChildTags = new List <ITag>()
};
break;
}
case "For":
{
var open = xmlNode.Attributes?["Open"]?.Value.Trim();
var separator = xmlNode.Attributes?["Separator"]?.Value.Trim();
var close = xmlNode.Attributes?["Close"]?.Value.Trim();
var key = xmlNode.Attributes?["Key"]?.Value.Trim();
tag = new For
{
Prepend = prepend,
Property = property,
Open = open,
Close = close,
Separator = separator,
Key = key,
ChildTags = new List <ITag>()
};
break;
}
case "Env":
{
var dbProvider = xmlNode.Attributes?["DbProvider"]?.Value.Trim();
tag = new Env
{
Prepend = prepend,
DbProvider = dbProvider,
ChildTags = new List <ITag>()
};
break;
}
case "#comment": { break; }
default:
{
throw new SmartSqlException($"Statement.LoadTag unkonw tagName:{xmlNode.Name}.");
};
}
#endregion
return(tag);
}
public void FalseIfClassIsNull()
{
var sut = new IsNotNull <object>();
Assert.IsFalse(sut.Validate(null));
}
public void TrueIfClassIsNotNull()
{
var sut = new IsNotNull <object>();
Assert.IsTrue(sut.Validate(new object()));
}
public static ITag LoadTag(XmlNode xmlNode, IList <Include> includes)
{
ITag tag = null;
bool isIn = !string.IsNullOrEmpty(xmlNode.GetValueInXmlAttributes("In"));
var prepend = xmlNode.GetValueInXmlAttributes("Prepend");
var property = xmlNode.GetValueInXmlAttributes("Property");
var compareValue = xmlNode.GetValueInXmlAttributes("CompareValue");
#region Init Tag
string lowerXmlNodeName = xmlNode.Name.ToLower();
switch (lowerXmlNodeName)
{
case "#text":
case "#cdata-section":
{
var bodyText = " " + xmlNode.GetInnerTextInXmlAttributes();
return(new SqlText
{
BodyText = bodyText
});
}
//case "OrderBy":
case "orderby":
{
var bodyText = " " + xmlNode.GetInnerTextInXmlAttributes();
tag = new OrderBy
{
ChildTags = new List <ITag>(),
BodyText = bodyText
};
break;
}
//case "Include":
case "include":
{
var refId = xmlNode.GetValueInXmlAttributes("RefId");
var include_tag = new Include
{
RefId = refId
};
includes.Add(include_tag);
tag = include_tag;
break;
}
//case "If":
case "if":
{
var Test = xmlNode.GetValueInXmlAttributes("Test");
tag = new IfTag
{
Test = Test,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
//case "IsEmpty":
case "isempty":
{
tag = new IsEmpty
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
//case "IsEqual":
case "isequal":
{
tag = new IsEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
//case "IsGreaterEqual":
case "isgreaterequal":
{
tag = new IsGreaterEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
//case "IsGreaterThan":
case "isgreaterthan":
{
tag = new IsGreaterThan
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
//case "IsLessEqual":
case "islessequal":
{
tag = new IsLessEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
//case "IsLessThan":
case "islessthan":
{
tag = new IsLessThan
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
//case "IsNotEmpty":
case "isnotempty":
{
tag = new IsNotEmpty
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
//case "IsNotEqual":
case "isnotequal":
{
tag = new IsNotEqual
{
In = isIn,
Prepend = prepend,
Property = property,
CompareValue = compareValue,
ChildTags = new List <ITag>()
};
break;
}
//case "IsNotNull":
case "isnotnull":
{
tag = new IsNotNull
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
//case "IsNull":
case "isnull":
{
tag = new IsNull
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
//case "IsTrue":
case "istrue":
{
tag = new IsTrue
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
//case "IsFalse":
case "isfalse":
{
tag = new IsFalse
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
//case "IsProperty":
case "isproperty":
{
tag = new IsProperty
{
In = isIn,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
//case "Switch":
case "switch":
{
tag = new Switch
{
Property = property,
//Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
//case "Case":
case "case":
{
var switchNode = xmlNode.ParentNode;
var switchProperty = switchNode.GetValueInXmlAttributes("Property");
var switchPrepend = switchNode.GetValueInXmlAttributes("Prepend");
tag = new Switch.Case
{
CompareValue = compareValue,
Property = switchProperty,
Prepend = switchPrepend,
ChildTags = new List <ITag>()
};
break;
}
//case "Default":
case "default":
{
var switchNode = xmlNode.ParentNode;
var switchProperty = switchNode.GetValueInXmlAttributes("Property");
var switchPrepend = switchNode.GetValueInXmlAttributes("Prepend");
tag = new Switch.Defalut
{
Property = switchProperty,
Prepend = switchPrepend,
ChildTags = new List <ITag>()
};
break;
}
//case "Choose":
case "choose":
{
tag = new ChooseTag
{
//Property = property,
//Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
case "when":
{
var Test = xmlNode.GetValueInXmlAttributes("Test");
//var switchNode = xmlNode.ParentNode;
//var switchProperty = switchNode.GetValueInXmlAttributes("Property");
//var switchPrepend = switchNode.GetValueInXmlAttributes("Prepend");
tag = new ChooseTag.ChooseWhenTag
{
Test = Test,
//Property = switchProperty,
//Prepend = switchPrepend,
ChildTags = new List <ITag>()
};
break;
}
case "otherwise":
{
//var switchNode = xmlNode.ParentNode;
//var switchProperty = switchNode.GetValueInXmlAttributes("Property");
//var switchPrepend = switchNode.GetValueInXmlAttributes("Prepend");
tag = new ChooseTag.ChooseOtherwiseTag
{
//Property = switchProperty,
//Prepend = switchPrepend,
ChildTags = new List <ITag>()
};
break;
}
case "trim":
{
var Prefix = xmlNode.GetValueInXmlAttributes("Prefix", "", false);
var Suffix = xmlNode.GetValueInXmlAttributes("Suffix", "", false);
var PrefixOverrides = xmlNode.GetValueInXmlAttributes("PrefixOverrides");
var SuffixOverrides = xmlNode.GetValueInXmlAttributes("SuffixOverrides");
tag = new TrimTag
{
Prefix = Prefix,
Suffix = Suffix,
PrefixOverrides = PrefixOverrides,
SuffixOverrides = SuffixOverrides,
ChildTags = new List <ITag>()
};
break;
}
case "set":
{
tag = new SetTag()
{
ChildTags = new List <ITag>()
};
break;
}
case "where":
{
tag = new WhereTag
{
ChildTags = new List <ITag>()
};
break;
}
//case "Where":
//case "where":
// {
// tag = new Where
// {
// ChildTags = new List<ITag>()
// };
// break;
// }
//case "Dynamic":
case "dynamic":
{
tag = new Dynamic
{
Prepend = prepend,
ChildTags = new List <ITag>()
};
break;
}
//case "Variable":
case "variable":
{
var bodyText = xmlNode.GetInnerTextInXmlAttributes();
tag = new Variable
{
BodyText = bodyText,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
//case "Bind":
case "bind":
{
var Name = xmlNode.GetValueInXmlAttributes("Name");
var Value = xmlNode.GetValueInXmlAttributes("Value");
//var bodyText = xmlNode.GetInnerTextInXmlAttributes();
tag = new BindTag
{
Name = Name,
Value = Value,
Prepend = prepend,
Property = property,
ChildTags = new List <ITag>()
};
break;
}
//case "Foreach":
case "foreach":
{
var open = xmlNode.GetValueInXmlAttributes("Open");
var separator = xmlNode.GetValueInXmlAttributes("Separator");
var close = xmlNode.GetValueInXmlAttributes("Close");
var item = xmlNode.GetValueInXmlAttributes("Item");
var index = xmlNode.GetValueInXmlAttributes("Index");
tag = new Foreach
{
Prepend = prepend,
Property = property,
Open = open,
Close = close,
Separator = separator,
Item = item,
Index = index,
ChildTags = new List <ITag>()
};
break;
}
//case "Env":
case "env":
{
var dbProvider = xmlNode.GetValueInXmlAttributes("DbProvider");
var DbType = xmlNode.GetValueInXmlAttributes("DbType");
tag = new Env
{
Prepend = prepend,
DbProvider = dbProvider,
DbType = DbType,
ChildTags = new List <ITag>()
};
break;
}
case "#comment": { break; }
default:
{
throw new Exception(string.Format("Statement.LoadTag unkonw tagName:{0}.", xmlNode.Name));
};
}
#endregion
//加载组合查询条件查询
foreach (XmlNode childNode in xmlNode)
{
ITag childTag = LoadTag(childNode, includes);
if (childTag != null && tag != null)
{
(tag as Tag).ChildTags.Add(childTag);
}
}
return(tag);
}