Example #1
0
        public QueryUsersResult QueryUsers(QueryUsersParameter param)
        {
            var result = new QueryUsersResult();

            using (var context = base.CreateUserContext())
            {
                var q = from t in context.Accounts
                        where t.AppID == param.AppID &&
                        (param.UserID == null || t.RowID == param.UserID) &&
                        (string.IsNullOrEmpty(param.Keyword) || (t.UserName.Contains(param.Keyword) || t.Email.Contains(param.Keyword)))
                        select new UserEntity
                {
                    UserID     = t.RowID,
                    UserName   = t.UserName,
                    Email      = t.Email,
                    Mobile     = t.Mobile,
                    Flags      = (UserFlags)t.Flags,
                    CreateDate = t.CreateDate
                };
                if (param.OrderBy == QueryUsersOrderBy.CreateDateDesc)
                {
                    q = q.OrderBy(t => t.CreateDate);
                }
                else
                {
                    q = q.OrderByDescending(t => t.CreateDate);
                }
                result.PageResult(q, param);
            }
            return(result);
        }
Example #2
0
 public QueryUsersResult QueryUsers(QueryUsersParameter pager)
 {
     return(mgr.QueryUsers(pager));
 }