private static string WhereSql(Model.ServiceHostStatMinute.Query query)
{
SQLBuilder builder = new SQLBuilder();
builder.AppendWhere();
builder.Append(query.StatTimeStart != null, "and", "stat_time>@StatTimeStart");
builder.Append(query.StatTimeEnd != null, "and", "stat_time<=@StatTimeEnd");
builder.Append(!string.IsNullOrWhiteSpace(query.Host), "and", "host=@Host");
builder.Append(!string.IsNullOrWhiteSpace(query.ServiceName), "and", "service_name=@ServiceName");
return(builder.Sql());
}
public static string SelectBy(Model.ServiceHostStatMinute.Query query)
{
return(string.Join(" ", BaseSelectSql(), WhereSql(query)));
}
