public List <UserFolder> GetList(IUserFoldersExp exp) { var query = Query() .Where(exp.GetExpression()); if (exp.StartIndex.HasValue) { query.SetFirstResult(exp.StartIndex.Value); } if (exp.Limit.HasValue) { query.SetMaxResults(exp.Limit.Value); } if (!string.IsNullOrEmpty(exp.OrderBy)) { var sortField = UserFolderTable.Columns.Name; if (exp.OrderBy == "timeModified") { sortField = UserFolderTable.Columns.TimeModified; } query.OrderBy(sortField, exp.OrderAsc != null && exp.OrderAsc.Value); } var list = Db.ExecuteList(query) .ConvertAll(ToUserFolder); return(list); }
public int Remove(IUserFoldersExp exp) { var query = new SqlDelete(UserFolderTable.TABLE_NAME) .Where(exp.GetExpression()); var result = Db.ExecuteNonQuery(query); return(result); }