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