Esempio n. 1
0
 public PagingResult<VAccount> GetVAccounts(AccountFilter filter, int page = 1, int pageSize = 20)
 {
     var paging = new Paging
     {
         PageSize = pageSize,
         CurrentPage = page,
     };
     var data = Dao.GetVAccounts(filter, paging);
     return new PagingResult<VAccount>(paging, data);
 }
Esempio n. 2
0
        public List<Account> GetAccounts(AccountFilter filter, Paging page = null)
        {
            using (var db = GetDataContext())
            {
                var query = db.Account.AsQueryable();
                if (filter.Deleted.HasValue)
                {
                    var deletedValue = (short)(filter.Deleted.Value ? 1 : 0);
                    query = query.Where(e => e.Deleted == deletedValue);
                }

                if (filter.Enabled.HasValue)
                {
                    var enabledValue = (short)(filter.Enabled.Value ? Status.Enabled : Status.Disabled);
                    query = query.Where(e => e.Status == enabledValue);
                }

                if (!string.IsNullOrEmpty(filter.SearchKey))
                {
                    query = query.Where(e => e.TrueName.Contains(filter.SearchKey) || e.Username.Contains(filter.SearchKey));
                }

                if (filter.BeginTime.HasValue)
                {
                    query = query.Where(e => e.CreateTime > filter.BeginTime.Value);
                }

                if (filter.EndTime.HasValue)
                {
                    query = query.Where(e => e.CreateTime <= filter.EndTime.Value);
                }
                if (filter.Usernames != null)
                {
                    query = query.Where(e => filter.Usernames.Contains(e.Username));
                }
                if (filter.AccountIds != null)
                {
                    query = query.Where(e => filter.AccountIds.Contains(e.AccountId));
                }

                return query.OrderByDescending(e => e.AccountId).SetPage(page).ToList();
            }
        }