Exemplo n.º 1
0
        private string GetItemNo(int categoryId)
        {
            //1:获取分类
            var category = _categoryRepository.Get(categoryId);
            //2:获取当前分类下产品的数量
            var productCount = _productRepository.Count(u => u.CategoryId.Equals(categoryId));

            //3:生成编号 01001
            return($"{category.CategoryNo}{(productCount + 1).ToString().PadLeft(4, '0')}");
        }
Exemplo n.º 2
0
        public Task <HomeStatsModel> GetHomeStats()
        {
            var developerCount   = _userRepository.Count(x => x.RoleId != SetLocaleRole.Developer.Value);
            var translatorCount  = _userRepository.Count(x => x.RoleId == SetLocaleRole.Translator.Value);
            var keyCount         = _wordRepository.Count();
            var appCount         = _appRepository.Count();
            var translationCount = _wordRepository.FindAll().Sum(x => x.TranslationCount);

            var model = new HomeStatsModel
            {
                ApplicationCount = appCount,
                DeveloperCount   = developerCount,
                TranslatorCount  = translatorCount,
                KeyCount         = keyCount,
                TranslationCount = translationCount
            };

            return(Task.FromResult(model));
        }
        public static IQueryable <TEntity> Pagination <TEntity>(this IRepository <TEntity> source, int currentPage,
                                                                int limit, out int rowCount) where TEntity : class
        {
            rowCount = source.Count();

            return(source.Entity
                   .Skip((currentPage - 1) * limit)
                   .Take(limit)
                   .AsQueryable());
        }
Exemplo n.º 4
0
 public virtual int GetUnreadMessageCount(UserIdentifier sender, UserIdentifier receiver)
 {
     using (CurrentUnitOfWork.SetTenantId(receiver.TenantId))
     {
         return(_chatMessageRepository.Count(cm => cm.UserId == receiver.UserId &&
                                             cm.TargetUserId == sender.UserId &&
                                             cm.TargetTenantId == sender.TenantId &&
                                             cm.ReadState == ChatMessageReadState.Unread));
     }
 }
        public async Task <List <OrganizationUnitDto> > GetOrganizationUnits()
        {
            var units = ObjectMapper.Map <List <OrganizationUnitDto> >(await _organizationUnitManager.FindChildrenAsync(null, true));

            foreach (var organizationUnitDto in units)
            {
                organizationUnitDto.MemberCount = _userOrgRepository.Count(uou => uou.OrganizationUnitId == organizationUnitDto.Id);
            }
            return(units);
        }
Exemplo n.º 6
0
        public void Crud_NewObject_Success()
        {
            int originalCount = repository.Count();

            output.WriteLine($"Total number of sessions before executing CRUD operations is {originalCount}.");

            // Create.
            Session original = DataFactory.CreateSession();
            Session created  = repository.Create(original);

            output.WriteLine($"Created new session:\n{JsonConvert.SerializeObject(created)}");
            Assert.Equal(original.Id, created.Id);

            // Retrieve single.
            Session retrieved = repository.Retrieve(created.Id);

            output.WriteLine($"Retrieved newly created session:\n{JsonConvert.SerializeObject(retrieved)}");
            Assert.Equal(created.Id, retrieved.Id);

            // Update.
            const string updatedSolutionId = "Sif3Framework2";

            retrieved.SolutionId = updatedSolutionId;
            repository.Update(retrieved);
            Session updated = repository.Retrieve(retrieved.Id);

            output.WriteLine(
                $"Updated the SolutionId of the newly created session to {updatedSolutionId}:\n{JsonConvert.SerializeObject(updated)}");
            Assert.Equal(retrieved.Id, updated.Id);
            Assert.Equal(updatedSolutionId, updated.SolutionId);

            // Delete.
            repository.Delete(created);
            Session deleted = repository.Retrieve(created.Id);

            output.WriteLine($"Successfully deleted session {created.Id} - {deleted == null}.");
            Assert.Null(deleted);
            int currentCount = repository.Count();

            output.WriteLine($"Total number of sessions after executing CRUD operation is {currentCount}.");
            Assert.Equal(originalCount, currentCount);
        }
Exemplo n.º 7
0
        public int GetLoginFailedTimes(string userName, DateTime?currentDate)
        {
            if (!currentDate.HasValue)
            {
                currentDate = DateTime.Now;
            }

            var loginSucceedLog = _userlogRepository.Table.Where(x => x.UserName == userName && x.ActivityType == "LOGIN_SUCCEED" && x.DateCreated.Value.Date == currentDate.Value.Date).OrderByDescending(x => x.DateCreated).FirstOrDefault();

            return(_userlogRepository.Count(c => c.DateCreated >= loginSucceedLog.DateCreated && c.ActivityType == "LOGIN_FAILED"));
        }
Exemplo n.º 8
0
        public RuimapPageResultDto <DeviceOutput> GetPageDevice(int pageIndex = 1, int pageSize = 10)
        {
            var count = _deviceInfoTbRepo.Count();

            var result = _deviceInfoTbRepo.GetAll().OrderBy(d => d.DeviceCode).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();

            int currPage  = pageIndex;
            int totalPage = (int)Math.Ceiling(count / (pageSize * 1.0));

            return(new RuimapPageResultDto <DeviceOutput>(count, currPage, totalPage, result.MapTo <List <DeviceOutput> >()));
        }
Exemplo n.º 9
0
 /// <summary>
 /// 自动生成订单
 /// </summary>
 /// <returns></returns>
 private string GenerateOrderNo()
 {
     //取消
     using (CurrentUnitOfWork.DisableFilter(AbpDataFilters.SoftDelete))
     {
         int curYear = DateTime.Now.Year, curMonth = DateTime.Now.Month;
         var counts = _orderRepository.Count(u => u.CreationTime.Year.Equals(curYear) && u.CreationTime.Month.Equals(curMonth));
         //1:通过日期来
         return($"MO{DateTime.Now.ToString("yyyyMM")}{(counts + 1).ToString().PadLeft(5, '0')}");
     }
 }
Exemplo n.º 10
0
        public void Count_getCountRecord_Integer()
        {
            //Arrange
            _repo = new DataAccessRepository(_context);

            //Act
            int data = _repo.Count("DenemeD");

            //Assert
            Assert.IsInstanceOfType(data, typeof(int));
        }
        public async Task GetOrUpdateTag_TestAsync()
        {
            var allTags    = _tagRep.GetAllList();
            var allTagStrs = allTags.Select(o => o.Name).ToList();

            allTagStrs.Add("新标签");


            (await _tagService.GetOrCreateTagsAsync(allTagStrs)).Count.ShouldBe(allTagStrs.Count);
            _tagRep.Count().ShouldBe(allTags.Count + 1);
        }
Exemplo n.º 12
0
        public PagedResultDto <PoemDto> GetPagedPoems(PagedResultRequestDto dto)
        {
            var count = _poemRepository.Count();
            var lst   = _poemRepository.GetAllIncluding(c => c.Author).OrderBy(o => o.Id).PageBy(dto).ToList();

            return(new PagedResultDto <PoemDto>
            {
                TotalCount = count,
                Items = ObjectMapper.Map <List <PoemDto> >(lst) //lst.MapTo<List<PoemDto>>()
            });
        }
Exemplo n.º 13
0
 public bool IsSubscribed(UserIdentifier user, string notificationName, string entityTypeName, string entityId)
 {
     //关闭多租户查询
     using (_unitOfWorkManager.Current.DisableFilter(AbpDataFilters.MayHaveTenant))
     {
         return(_notificationSubscriptionsRepository.Count(s =>
                                                           s.UserId == user.UserId &&
                                                           s.NotificationName == notificationName
                                                           ) > 0);
     }
 }
Exemplo n.º 14
0
        public async System.Threading.Tasks.Task <ActionResult> Index(int?pageNumber, int?pageSize, bool?descending)
        {
            return(await System.Threading.Tasks.Task.Factory.StartNew <ActionResult>(() =>
            {
                try
                {
                    int _pageNumber = 1;
                    int _pageSize = 10;
                    bool _descending = true;

                    if (pageNumber.HasValue)
                    {
                        _pageNumber = pageNumber.Value;
                    }

                    if (pageSize.HasValue)
                    {
                        _pageSize = pageSize.Value;
                    }

                    if (descending.HasValue)
                    {
                        _descending = descending.Value;
                    }

                    int eventsCount = _eventsRepository.Count();

                    EventsGetAllViewModel vm = new EventsGetAllViewModel
                    {
                        PageCount = (int)Math.Ceiling((double)(eventsCount / _pageSize)),
                        CurrentPage = _pageNumber,
                        Events = new List <EventModel>(),
                        TopNews = _newsRepository.GetAll(5, 1, true)
                    };

                    IEnumerable <Event> events = _eventsRepository.GetAll(_pageSize, _pageNumber, _descending);
                    foreach (var e in events)
                    {
                        EventModel em = new EventModel();
                        em.Event = e;
                        em.Game = _gamesRepository.Read(e.GameId);
                        em.Company = _companiesRepository.Read(em.Game.CompanyId);
                        vm.Events.Add(em);
                    }
                    return View(vm);
                }
                catch (Exception ex)
                {
                    _loggingService.Log(ex);
                    return RedirectToRoute(ErrorControllerRoute.GetNotFound);
                }
            }));
        }
Exemplo n.º 15
0
        public PagedResultDto <AuditInfo> GetAuditLogs(GetAuditLogsInput input)
        {
            var query = _auditLogRepository.GetAll();

            query = !string.IsNullOrEmpty(input.Sorting) ? query.OrderBy(input.Sorting) : query.OrderByDescending(t => t.ExecutionTime);

            var count = _auditLogRepository.Count();

            var audityLogs = query.PageBy(input).ToList();

            return(new PagedResultDto <AuditInfo>(count, audityLogs.MapTo <List <AuditInfo> >()));
        }
Exemplo n.º 16
0
        public void UpdateOutgoing(int userId, Outgoing outgoing)
        {
            var exist = _outgoingsRepository.Count(o => o.Id == outgoing.Id && o.UserId == userId) == 1 ? true : false;

            if (!exist)
            {
                throw new AppException("Вам нельзя обновить расход!");
            }
            outgoing.UserId = userId;
            _outgoingsRepository.Update(outgoing);
            //_outgoingsRepository.Save();
        }
Exemplo n.º 17
0
        /// <summary>
        /// 获取分页
        /// </summary>
        /// <param name="dto">111</param>
        /// <returns></returns>
        public PagedResultDto <PoetDto> GetPagedPoets(PagedResultRequestDto dto)
        {
            var count = _poetRepository.Count();
            var list  = _poetRepository.GetAll().OrderBy(o => o.Id).PageBy(dto).ToList();

            return(new PagedResultDto <PoetDto>()
            {
                //新版本 AutoMapper直接注入使用
                Items = ObjectMapper.Map <List <PoetDto> >(list),
                TotalCount = count,
            });
        }
        /// <summary>
        /// Gets the total count of the items that can be exported.
        /// </summary>
        /// <returns></returns>
        public override int TotalExportable()
        {
            // Check for overriden handler.
            if (_totalHandler != null)
            {
                return(_totalHandler());
            }

            IRepository <T> repo = EntityRegistration.GetRepository <T>();

            return(repo.Count());
        }
Exemplo n.º 19
0
        public IActionResult Index()
        {
            var usercount     = _userRepository.Count();
            var topiccount    = _topicRepository.Count();
            var replycount    = _topicReplyRepository.Count();
            var allstatistics = new Tuple <int, int, int>(usercount, topiccount, replycount);

            ViewBag.Statistics = allstatistics;
            var topics = _topicRepository.GetAll().OrderByDescending(r => r.CreateOn).Take(10).ToList();

            return(View(topics));
        }
Exemplo n.º 20
0
        public bool InsertLookUp(LookUp entity)
        {
            if (_lookUpRepository.Count(
                    m => m.LookUpType.Equals(entity.LookUpType) && m.LookUpValue.Equals(entity.LookUpValue)) != 0)
            {
                return(false);
            }
            _lookUpRepository.Add(entity);
            _unitOfWork.CommitChanges();

            return(true);
        }
Exemplo n.º 21
0
 public virtual bool IsSubscribed(UserIdentifier user, string notificationName, string entityTypeName, string entityId)
 {
     using (_unitOfWorkManager.Current.SetTenantId(user.TenantId))
     {
         return(_notificationSubscriptionRepository.Count(s =>
                                                          s.UserId == user.UserId &&
                                                          s.NotificationName == notificationName &&
                                                          s.EntityTypeName == entityTypeName &&
                                                          s.EntityId == entityId
                                                          ) > 0);
     }
 }
Exemplo n.º 22
0
        public PagedResultDto <PoetDto> GetPagedPoets(PagedResultRequestDto dto)
        {
            var count = _poetRepository.Count();
            var lst   = _poetRepository.OrderBy(o => o.Id).PageBy(dto).ToList();
            var items = new List <PoetDto>();

            return(new PagedResultDto <PoetDto>
            {
                TotalCount = count,
                Items = ObjectMapper.Map <List <Poet>, List <PoetDto> >(lst)
            });
        }
Exemplo n.º 23
0
        public RuimapPageResultDto <MessageNoteOutput> GetPageMessageNote(string title = "", int flag = 9, string reporterId = "", int pageIndex = 1, int pageSize = 9999)
        {
            int count = 0;
            List <MessageNoteTb> result = new List <MessageNoteTb>();

            if (flag == 9)
            {
                count  = _messageNoteRepo.Count(m => m.Title.Contains(title) && m.ToReporter.Any(r => r.Id.ToString().Contains(reporterId)));
                result = _messageNoteRepo.GetAll().Where(m => m.Title.Contains(title) && m.ToReporter.Any(r => r.Id.ToString().Contains(reporterId))).OrderByDescending(m => m.Date).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
            }
            else
            {
                count  = _messageNoteRepo.Count(m => m.Title.Contains(title) && m.Flag == flag && m.ToReporter.Any(r => r.Id.ToString().Contains(reporterId)));
                result = _messageNoteRepo.GetAll().Where(m => m.Title.Contains(title) && m.Flag == flag && m.ToReporter.Any(r => r.Id.ToString().Contains(reporterId))).OrderByDescending(m => m.Date).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
            }

            int currPage  = pageIndex;
            int totalPage = (int)Math.Ceiling(count / (pageSize * 1.0));

            return(new RuimapPageResultDto <MessageNoteOutput>(count, currPage, totalPage, result.MapTo <List <MessageNoteOutput> >()));
        }
Exemplo n.º 24
0
        public async Task <string> Index()
        {
            var student = await _studentRepository.GetAll().FirstOrDefaultAsync();

            var oop = await _studentRepository.SingleAsync(a => a.Id == 2009);

            var longCount = await _studentRepository.LongCountAsync();

            var count = _studentRepository.Count();

            return($"{oop.Name}+{student.Name}+{longCount}+{count}");
        }
Exemplo n.º 25
0
        public void TestSaveId()
        {
            IRepository <Apple> repository = Injector.Resolve <IRepository <Apple> >();

            repository.Save(new Apple {
                Id = 12, Type = "Elstar"
            });

            Assert.AreEqual(2, repository.Count());
            Assert.AreEqual(12, repository.FindAll()[1].Id);
            Assert.AreEqual("Elstar", repository.FindAll()[1].Type);
        }
        public void GetTest()
        {
            Assert.Equal(3, repository.Count());

            var allWords = repository.GetAll();

            Assert.Contains(allWords, w => w.Name == "school");
            Assert.DoesNotContain(allWords, w => w.Name == "school2");

            Assert.Equal(2, repository.GetPagedAll(0, 2).Count);
            Assert.Equal(1, repository.GetPagedAll(1, 2).Count);
        }
Exemplo n.º 27
0
        /// <summary>
        /// 按时间分类数据
        /// </summary>
        /// <returns></returns>
        public List <ReportFormsDto> GetReportFormsByTime(string StartTime, string EndTime, string AnomalyGrade, string AnomalyType, string MonitorRoom)

        {
            dVRCameraRepairlist();
            List <ReportFormsDto> listreportForms = new List <ReportFormsDto>();

            List <DateTime> timelist = new List <DateTime>();

            DateTime dateTimeStart = DateTime.Parse(StartTime);
            DateTime dateTimeEnd   = DateTime.Parse(EndTime);

            for (int i = 0; dateTimeStart.Day + i < dateTimeEnd.Day; i++)
            {
                timelist.Add(dateTimeStart.AddDays(i));
            }

            if (!string.IsNullOrEmpty(AnomalyGrade))
            {
                listDVRCameraRepair = listDVRCameraRepair.Where(u => u.AnomalyGrade.Contains(AnomalyGrade));
            }
            if (!string.IsNullOrEmpty(AnomalyType))
            {
                listDVRCameraRepair = listDVRCameraRepair.Where(u => u.AnomalyType.Contains(AnomalyType));
            }
            if (!string.IsNullOrEmpty(MonitorRoom))
            {
                listDVRCameraRepair = listDVRCameraRepair.Where(r => r.DVR_Room != null).Where(u => u.DVR_Room.Contains(MonitorRoom));
            }



            foreach (var item in timelist)

            {
                ReportFormsDto formsDto = new ReportFormsDto();
                formsDto.install_time = item.ToString("yyyy-MM-dd");

                //加载异常数量
                formsDto.CameraAnomaly = listDVRCameraRepair.Where(u => u.CollectTime.Contains(item.ToString("yyyy-MM-dd"))).Count();
                //加载维修数据
                formsDto.RepairTotal = listDVRCameraRepair.Where(u => u.RepairedTime.Contains(item.ToString("yyyy-MM-dd"))).Count();
                //异常+维修总数
                formsDto.CameraAnomalyRepair = formsDto.CameraAnomaly + formsDto.RepairTotal;

                formsDto.CameraTotal = _camerarepository.Count();


                listreportForms.Add(formsDto);
            }

            return(listreportForms);
        }
Exemplo n.º 28
0
        public async Task <Machine> CreateMachine(Machine machine)
        {
            //load any default configuration that will be retrieved from the machine.
            await LoadConfiguration(machine);

            //The new machine will be added to the end of the list
            machine.SortIndex = _machines.Count() + 1;

            //if the configuration is updated with data from the machine then store the configuration.
            _machines.Create(machine);

            return(machine);
        }
Exemplo n.º 29
0
        public void Sweep()
        {
            var peddingTaskCount = _repository.Count(x => x.ScheduledUtc > _clock.UtcNow && x.TaskType == "ResetSite" ||
                                                     x.ScheduledUtc > _clock.UtcNow && x.TaskType == "SwitchTheme");

            if (peddingTaskCount == 0)
            {
                _themeService.EnableThemeFeatures("Mooncake");
                _siteThemeService.SetSiteTheme("Mooncake");
                _scheduledTaskManager.CreateTask("SwitchTheme", _clock.UtcNow.AddMinutes(29), null);
                _scheduledTaskManager.CreateTask("ResetSite", _clock.UtcNow.AddMinutes(30), null);
            }
        }
Exemplo n.º 30
0
 public int GetUserNotificationCount(UserIdentifier user, UserNotificationState?state = null, DateTime?startDate = null, DateTime?endDate = null)
 {
     //关闭多租户查询
     using (_unitOfWorkManager.Current.DisableFilter(AbpDataFilters.MayHaveTenant))
     {
         return(_userNotificationInfoRepository.Count(un =>
                                                      un.UserId == user.UserId &&
                                                      (state == null || un.State == state.Value) &&
                                                      (startDate == null || un.CreationTime >= startDate.Value) &&
                                                      (endDate == null || un.CreationTime <= endDate.Value)
                                                      ));
     }
 }
        public void Count_With_Predicate_Should_Return_Count(IRepository<Contact, string> repository)
        {
            for (var i = 1; i <= 3; i++)
            {
                var contact = new Contact { Name = "Test User " + i, ContactTypeId =1};
                repository.Add(contact);
            }
            for (var i = 4; i <= 7; i++)
            {
                var contact = new Contact { Name = "Test User " + i, ContactTypeId = 2};
                repository.Add(contact);
            }

            repository.Count(x => x.ContactTypeId == 2).ShouldEqual(4);
        }
        public void Count_Should_Return_All_Count(IRepository<Contact, string> repository)
        {
            for (var i = 1; i <= 3; i++)
            {
                var contact = new Contact { Name = "Test User " + i, ContactTypeId =1};
                repository.Add(contact);
            }
            for (var i = 4; i <= 7; i++)
            {
                var contact = new Contact { Name = "Test User " + i, ContactTypeId = 2};
                repository.Add(contact);
            }

            repository.Count().ShouldEqual(7);
        }