public static string BuildActivityQuery(UserActivityQuery query) { StringBuilder sb = new StringBuilder(); sb.Append("SET Transaction Isolation Level Read UNCOMMITTED "); SelectQueryBuilder builder = new SelectQueryBuilder(); builder.SelectFromTable("SUserActivity"); builder.SelectColumns("UserActivityID"); if (query.UserID > 0) { builder.AddWhere("ActivityUser", Comparison.Equals, query.UserID); } WhereClause clause = builder.AddWhere("ActivityTime", Comparison.GreaterOrEquals, query.StartTime); clause.AddClause(LogicOperator.And, Comparison.LessOrEquals, query.EndTime); return(builder.BuildQuery()); }
public abstract List <UserActivity> GetUserActivities(UserActivityQuery query, out int totalRecord);