/// <summary> /// 编译LIKE语句 /// </summary> /// <param name="where"></param> /// <param name="filter"></param> private void BuildWhereWithLike(StringBuilder where, NormalFilterInfo filter) { //for example // username like '%明%' if (where == null || filter == null) { return; } string relation = WhereRelationDictData[filter.NormalWhereRelation].Replace(Constants.ReplaceValue, filter.WhereValue); where.AppendFormat("{0}{1}{0}({2}{0}{3})", Constants.WhiteSpace, EnumUtility.GetEnumOperation(filter.ConnectRelation), filter.FieldName, relation); }
/// <summary> /// 编译LIKE语句 /// </summary> /// <param name="where"></param> /// <param name="filter"></param> private void BuildWhereWithLike(StringBuilder where, NormalFilterInfo filter) { //for example // username like '%明%' if (where == null || filter == null) { return; } string relation = WhereRelationDictData[filter.NormalWhereRelation].Replace(Constants.ReplaceValue, filter.WhereValue); where.AppendFormat("{0}{1}{0}({2}{0}{3})", Constants.WhiteSpace, EnumUtil.GetEnumOperation(filter.ConnectRelation), filter.FieldName, relation); }
/// <summary> /// 编译普通语句 /// </summary> /// <param name="where"></param> /// <param name="filter"></param> private void BuildWhereWithNormal(StringBuilder where, NormalFilterInfo filter) { //for example // userid = 1001 if (where == null || filter == null) { return; } string relation = WhereRelationDictData[filter.NormalWhereRelation]; //处理数据类型之间的区别 string value = filter.FieldType != FieldTypeEnum.Number ? string.Format("'{0}'", filter.WhereValue) : filter.WhereValue; where.AppendFormat("{0}{1}{0}({2}{0}{3}{4})", Constants.WhiteSpace, EnumUtil.GetEnumOperation(filter.ConnectRelation), filter.FieldName, relation, value); }
/// <summary> /// 编译普通语句 /// </summary> /// <param name="where"></param> /// <param name="filter"></param> private void BuildWhereWithNormal(StringBuilder where, NormalFilterInfo filter) { //for example // userid = 1001 if (where == null || filter == null) { return; } string relation = WhereRelationDictData[filter.NormalWhereRelation]; //处理数据类型之间的区别 string value = filter.FieldType != FieldTypeEnum.Number ? string.Format("'{0}'", filter.WhereValue) : filter.WhereValue; where.AppendFormat("{0}{1}{0}({2}{0}{3}{4})", Constants.WhiteSpace, EnumUtility.GetEnumOperation(filter.ConnectRelation), filter.FieldName, relation, value); }