コード例 #1
0
        public async Task <int> Count(StoreWarrantyServiceFilter filter)
        {
            IQueryable <StoreWarrantyServiceDAO> StoreWarrantyServices = DataContext.StoreWarrantyService.AsNoTracking();

            StoreWarrantyServices = DynamicFilter(StoreWarrantyServices, filter);
            return(await StoreWarrantyServices.CountAsync());
        }
コード例 #2
0
        public async Task <List <StoreWarrantyService> > List(StoreWarrantyServiceFilter filter)
        {
            if (filter == null)
            {
                return(new List <StoreWarrantyService>());
            }
            IQueryable <StoreWarrantyServiceDAO> StoreWarrantyServiceDAOs = DataContext.StoreWarrantyService.AsNoTracking();

            StoreWarrantyServiceDAOs = DynamicFilter(StoreWarrantyServiceDAOs, filter);
            StoreWarrantyServiceDAOs = DynamicOrder(StoreWarrantyServiceDAOs, filter);
            List <StoreWarrantyService> StoreWarrantyServices = await DynamicSelect(StoreWarrantyServiceDAOs, filter);

            return(StoreWarrantyServices);
        }
コード例 #3
0
        private IQueryable <StoreWarrantyServiceDAO> DynamicOrder(IQueryable <StoreWarrantyServiceDAO> query, StoreWarrantyServiceFilter filter)
        {
            switch (filter.OrderType)
            {
            case OrderType.ASC:
                switch (filter.OrderBy)
                {
                case StoreWarrantyServiceOrder.Id:
                    query = query.OrderBy(q => q.Id);
                    break;

                case StoreWarrantyServiceOrder.Name:
                    query = query.OrderBy(q => q.Name);
                    break;

                case StoreWarrantyServiceOrder.Detail:
                    query = query.OrderBy(q => q.Detail);
                    break;

                case StoreWarrantyServiceOrder.Store:
                    query = query.OrderBy(q => q.StoreId);
                    break;
                }
                break;

            case OrderType.DESC:
                switch (filter.OrderBy)
                {
                case StoreWarrantyServiceOrder.Id:
                    query = query.OrderByDescending(q => q.Id);
                    break;

                case StoreWarrantyServiceOrder.Name:
                    query = query.OrderByDescending(q => q.Name);
                    break;

                case StoreWarrantyServiceOrder.Detail:
                    query = query.OrderByDescending(q => q.Detail);
                    break;

                case StoreWarrantyServiceOrder.Store:
                    query = query.OrderByDescending(q => q.StoreId);
                    break;
                }
                break;
            }
            query = query.Skip(filter.Skip).Take(filter.Take);
            return(query);
        }
コード例 #4
0
        private IQueryable <StoreWarrantyServiceDAO> OrFilter(IQueryable <StoreWarrantyServiceDAO> query, StoreWarrantyServiceFilter filter)
        {
            if (filter.OrFilter == null || filter.OrFilter.Count == 0)
            {
                return(query);
            }
            IQueryable <StoreWarrantyServiceDAO> initQuery = query.Where(q => false);

            foreach (StoreWarrantyServiceFilter StoreWarrantyServiceFilter in filter.OrFilter)
            {
                IQueryable <StoreWarrantyServiceDAO> queryable = query;
                if (StoreWarrantyServiceFilter.Id != null && StoreWarrantyServiceFilter.Id.HasValue)
                {
                    queryable = queryable.Where(q => q.Id, StoreWarrantyServiceFilter.Id);
                }
                if (StoreWarrantyServiceFilter.Name != null && StoreWarrantyServiceFilter.Name.HasValue)
                {
                    queryable = queryable.Where(q => q.Name, StoreWarrantyServiceFilter.Name);
                }
                if (StoreWarrantyServiceFilter.Detail != null && StoreWarrantyServiceFilter.Detail.HasValue)
                {
                    queryable = queryable.Where(q => q.Detail, StoreWarrantyServiceFilter.Detail);
                }
                if (StoreWarrantyServiceFilter.StoreId != null && StoreWarrantyServiceFilter.StoreId.HasValue)
                {
                    queryable = queryable.Where(q => q.StoreId, StoreWarrantyServiceFilter.StoreId);
                }
                initQuery = initQuery.Union(queryable);
            }
            return(initQuery);
        }
コード例 #5
0
 private IQueryable <StoreWarrantyServiceDAO> DynamicFilter(IQueryable <StoreWarrantyServiceDAO> query, StoreWarrantyServiceFilter filter)
 {
     if (filter == null)
     {
         return(query.Where(q => false));
     }
     if (filter.Id != null && filter.Id.HasValue)
     {
         query = query.Where(q => q.Id, filter.Id);
     }
     if (filter.Name != null && filter.Name.HasValue)
     {
         query = query.Where(q => q.Name, filter.Name);
     }
     if (filter.Detail != null && filter.Detail.HasValue)
     {
         query = query.Where(q => q.Detail, filter.Detail);
     }
     if (filter.StoreId != null && filter.StoreId.HasValue)
     {
         query = query.Where(q => q.StoreId, filter.StoreId);
     }
     query = OrFilter(query, filter);
     return(query);
 }
コード例 #6
0
        private async Task <List <StoreWarrantyService> > DynamicSelect(IQueryable <StoreWarrantyServiceDAO> query, StoreWarrantyServiceFilter filter)
        {
            List <StoreWarrantyService> StoreWarrantyServices = await query.Select(q => new StoreWarrantyService()
            {
                Id      = filter.Selects.Contains(StoreWarrantyServiceSelect.Id) ? q.Id : default(long),
                Name    = filter.Selects.Contains(StoreWarrantyServiceSelect.Name) ? q.Name : default(string),
                Detail  = filter.Selects.Contains(StoreWarrantyServiceSelect.Detail) ? q.Detail : default(string),
                StoreId = filter.Selects.Contains(StoreWarrantyServiceSelect.Store) ? q.StoreId : default(long),
                Store   = filter.Selects.Contains(StoreWarrantyServiceSelect.Store) && q.Store != null ? new Store
                {
                    Id                = q.Store.Id,
                    Code              = q.Store.Code,
                    CodeDraft         = q.Store.CodeDraft,
                    Name              = q.Store.Name,
                    UnsignName        = q.Store.UnsignName,
                    ParentStoreId     = q.Store.ParentStoreId,
                    OrganizationId    = q.Store.OrganizationId,
                    StoreTypeId       = q.Store.StoreTypeId,
                    StoreGroupingId   = q.Store.StoreGroupingId,
                    Telephone         = q.Store.Telephone,
                    ProvinceId        = q.Store.ProvinceId,
                    DistrictId        = q.Store.DistrictId,
                    WardId            = q.Store.WardId,
                    Address           = q.Store.Address,
                    UnsignAddress     = q.Store.UnsignAddress,
                    DeliveryAddress   = q.Store.DeliveryAddress,
                    Latitude          = q.Store.Latitude,
                    Longitude         = q.Store.Longitude,
                    DeliveryLatitude  = q.Store.DeliveryLatitude,
                    DeliveryLongitude = q.Store.DeliveryLongitude,
                    OwnerName         = q.Store.OwnerName,
                    OwnerPhone        = q.Store.OwnerPhone,
                    OwnerEmail        = q.Store.OwnerEmail,
                    TaxCode           = q.Store.TaxCode,
                    LegalEntity       = q.Store.LegalEntity,
                    AppUserId         = q.Store.AppUserId,
                    StatusId          = q.Store.StatusId,
                    RowId             = q.Store.RowId,
                    Used              = q.Store.Used,
                    StoreStatusId     = q.Store.StoreStatusId,
                } : null,
            }).ToListAsync();

            return(StoreWarrantyServices);
        }