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