/// <summary>
/// 编译时间点类型的where语句
/// </summary>
/// <param name="where"></param>
/// <param name="filter"></param>
private void BuildWhereWithPointInTime(StringBuilder where, PointInTimeFilterInfo filter)
{
//CreateTime >=DATE_ADD(now(),INTERVAL -4 Hour);
if (where == null || filter == null)
{
return;
}
string expression = PointInTimeRelationDictData[filter.PointInTimeWhereRelation].Replace(Constants.ReplaceValue, filter.WhereValue.ToString());
where.AppendFormat("{0}{1}({2}{0}{3})", Constants.WhiteSpace, EnumUtil.GetEnumOperation(filter.ConnectRelation), filter.FieldName, expression);
}
/// <summary>
/// 编译时间点类型的where语句
/// </summary>
/// <param name="where"></param>
/// <param name="filter"></param>
private void BuildWhereWithPointInTime(StringBuilder where, PointInTimeFilterInfo filter)
{
//CreateTime >=DATE_ADD(now(),INTERVAL -4 Hour);
if (where == null || filter == null) { return; }
string expression = PointInTimeRelationDictData[filter.PointInTimeWhereRelation].Replace(Constants.ReplaceValue, filter.WhereValue.ToString());
where.AppendFormat("{0}{1}({2}{0}{3})", Constants.WhiteSpace, EnumUtility.GetEnumOperation(filter.ConnectRelation), filter.FieldName, expression);
}
