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