public string ToDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
builderItem.NullCheck("builderItem");
builder.NullCheck("builder");
return(GetDescription(builderItem, builder));
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
string result = string.Empty;
if ((Guid)builderItem.Data == Guid.Empty)
result = "NULL";
else
result = builder.CheckUnicodeQuotationMark(builderItem.Data.ToString());
return result;
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
string result = string.Empty;
DateTime minDate = new DateTime(1753, 1, 1);
if ((DateTime)builderItem.Data < minDate)
result = "NULL";
else
result = builder.FormatDateTime((DateTime)builderItem.Data);
return result;
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
string result = string.Empty;
if ((Guid)builderItem.Data == Guid.Empty)
{
result = "NULL";
}
else
{
result = builder.CheckUnicodeQuotationMark(builderItem.Data.ToString());
}
return(result);
}
private static DataDescriptionGeneratorBase GetDataDescriptor(SqlCaluseBuilderItemWithData buiderItem)
{
DataDescriptionGeneratorBase result = null;
foreach (DataDescriptionGeneratorBase generator in _DataDescriptors)
{
if (generator.IsMatched(buiderItem))
{
result = generator;
break;
}
}
return(result);
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
string result = string.Empty;
DateTime minDate = new DateTime(1753, 1, 1);
if ((DateTime)builderItem.Data < minDate)
{
result = "NULL";
}
else
{
result = builder.FormatDateTime((DateTime)builderItem.Data);
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="builderItem"></param>
/// <param name="builder"></param>
/// <returns></returns>
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
StringBuilder strB = new StringBuilder();
if (builderItem != null)
{
IEnumerable <string> keywords = GetKeywords(builderItem.Data.ToString());
foreach (string keyword in keywords)
{
if (strB.Length > 0)
{
strB.Append(" OR ");
}
strB.Append('"');
strB.Append(keyword.Replace("\"", "\"\""));
strB.Append('"');
}
}
return(builder.CheckUnicodeQuotationMark(strB.ToString()));
}
/// <summary>
///
/// </summary>
/// <param name="builderItem"></param>
/// <returns></returns>
protected override bool DecideIsMatched(SqlCaluseBuilderItemWithData builderItem)
{
bool result = false;
/*
* string pattern2 = @"\b(?i)(constains){1}\s*\({1}.*\){1}";
* foreach (Match match in Regex.Matches(input, pattern2))
* {
* Console.WriteLine(match.Value);
* }
*/
SqlClauseBuilderItemUW uwItem = builderItem as SqlClauseBuilderItemUW;
if (uwItem != null)
{
if (uwItem.Template.IsNotEmpty())
{
ParseResult pr = ExpressionParser.Parse(uwItem.Template, false);
if (pr.Identifiers != null)
{
pr.Identifiers.ScanIdentifiers(id =>
{
if (string.Compare(id.Identifier, "contains", true) == 0)
{
result = true;
}
return(result == false);
});
}
}
}
return(result);
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
return("NULL");
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
return(StreamToHexString((Stream)builderItem.Data));
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
return(((int)Convert.ChangeType(builderItem.Data, typeof(int))).ToString());
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
return ((int)Convert.ChangeType(builderItem.Data, typeof(int))).ToString();
}
protected override bool DecideIsMatched(SqlCaluseBuilderItemWithData builderItem)
{
return(builderItem.Data.GetType().IsEnum);
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
return builderItem.Data.ToString();
}
/// <summary>
/// 是否匹配。确定是否由自己这个类处理
/// </summary>
/// <param name="builderItem"></param>
/// <returns></returns>
public bool IsMatched(SqlCaluseBuilderItemWithData builderItem)
{
builderItem.NullCheck("builderItem");
return(DecideIsMatched(builderItem));
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
return(builder.CheckUnicodeQuotationMark(builderItem.Data.ToString()));
}
protected override bool DecideIsMatched(SqlCaluseBuilderItemWithData builderItem)
{
return builderItem.Data is string;
}
/// <summary> /// /// </summary> /// <param name="builderItem"></param> /// <returns></returns> protected abstract bool DecideIsMatched(SqlCaluseBuilderItemWithData builderItem);
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
return(builderItem.Data.ToString());
}
protected override bool DecideIsMatched(SqlCaluseBuilderItemWithData builderItem)
{
return(builderItem.IsExpression);
}
/// <summary> /// 需要重载 /// </summary> /// <param name="builderItem"></param> /// <param name="builder"></param> /// <returns></returns> protected abstract string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder);
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
return BytesToHexString((byte[])builderItem.Data);
}
//public override string GetDataDesp(ISqlBuilder builder)
//{
// string result = string.Empty;
// if (this.data == null || this.data is DBNull)
// result = "NULL";
// else
// {
// if (this.data is DateTime)
// {
// DateTime minDate = new DateTime(1753, 1, 1);
// if ((DateTime)this.data < minDate)
// result = "NULL";
// else
// result = builder.FormatDateTime((DateTime)this.data);
// }
// else if (this.data is System.Guid)
// {
// if ((Guid)this.data == Guid.Empty)
// result = "NULL";
// else
// result = builder.CheckUnicodeQuotationMark(this.data.ToString());
// }
// else
// {
// if (this.isExpression == false && (this.data is string || this.data.GetType().IsEnum))
// result = builder.CheckUnicodeQuotationMark(this.data.ToString());
// else
// if (this.data is bool)
// result = ((int)Convert.ChangeType(this.data, typeof(int))).ToString();
// else
// {
// if (this.data is byte[])
// result = BytesToHexString((byte[])data);
// else
// if (this.data is Stream)
// result = StreamToHexString((Stream)data);
// else
// result = this.data.ToString();
// }
// }
// }
// return result;
//}
private static DataDescriptionGeneratorBase GetDataDescriptor(SqlCaluseBuilderItemWithData buiderItem)
{
DataDescriptionGeneratorBase result = null;
foreach (DataDescriptionGeneratorBase generator in _DataDescriptors)
{
if (generator.IsMatched(buiderItem))
{
result = generator;
break;
}
}
return result;
}
protected override bool DecideIsMatched(SqlCaluseBuilderItemWithData builderItem)
{
return(builderItem.Data is string);
}
protected override bool DecideIsMatched(SqlCaluseBuilderItemWithData builderItem)
{
return builderItem.IsExpression;
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
return "NULL";
}
protected override bool DecideIsMatched(SqlCaluseBuilderItemWithData builderItem)
{
return builderItem.Data.GetType().IsEnum;
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
return builder.CheckUnicodeQuotationMark(builderItem.Data.ToString());
}
protected override string GetDescription(SqlCaluseBuilderItemWithData builderItem, ISqlBuilder builder)
{
return StreamToHexString((Stream)builderItem.Data);
}
