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); }