/// <summary> /// 升级的校验 /// </summary> /// <param name="organization"></param> /// <returns></returns> private OperationResult ValidateUpdate(DetailedOrganizationDTO organization, out OrganizationDAO organizationDao, out OrganizationAttributeDAO organizationAttributeDao) { OperationResult result = new OperationResult(true); organizationDao = null; organizationAttributeDao = null; if (organization == null) { result.Success = false; result.Messages.Add("传入参数不能为空!"); return(result); } if (string.IsNullOrWhiteSpace(organization.Id)) { result.Success = false; result.Messages.Add("id 不能为空"); return(result); } var filter = new OrganizationFilter(); filter.Id = organization.Id; filter.IsActive = true; organizationDao = _dal.GetOrganization(filter); organizationAttributeDao = _dal.GetOrganizationAttribute(filter); //组织不存在 if (organizationDao == null || organizationAttributeDao == null) { result.Success = false; result.Messages.Add("组织不存在"); return(result); } OperationResult dataValidateResult = Validate(organization, true); if (!dataValidateResult.Success) { result.Success = false; result.Messages.AddRange(dataValidateResult.Messages); } #region 向导部分校验 OperationResult validateWizardStepResult = ValidateWizardSetp(organization, organizationAttributeDao); if (!validateWizardStepResult.Success) { result.Success = false; result.Messages.AddRange(validateWizardStepResult.Messages); } #endregion return(result); }
public async Task <List <Role_OrganizationDTO> > SingleListOrganization([FromBody] Role_OrganizationFilterDTO Role_OrganizationFilterDTO) { OrganizationFilter OrganizationFilter = new OrganizationFilter(); OrganizationFilter.Skip = 0; OrganizationFilter.Take = int.MaxValue; OrganizationFilter.OrderBy = OrganizationOrder.Id; OrganizationFilter.OrderType = OrderType.ASC; OrganizationFilter.Selects = OrganizationSelect.Id | OrganizationSelect.Code | OrganizationSelect.Name | OrganizationSelect.Parent; OrganizationFilter.Id = Role_OrganizationFilterDTO.Id; OrganizationFilter.Code = Role_OrganizationFilterDTO.Code; OrganizationFilter.Name = Role_OrganizationFilterDTO.Name; OrganizationFilter.ParentId = Role_OrganizationFilterDTO.ParentId; if (OrganizationFilter.Id == null) { OrganizationFilter.Id = new IdFilter(); } OrganizationFilter.Id.In = await FilterOrganization(OrganizationService, CurrentContext); List <Organization> Organizationes = await OrganizationService.List(OrganizationFilter); List <Role_OrganizationDTO> Role_OrganizationDTOs = Organizationes .Select(x => new Role_OrganizationDTO(x)).ToList(); return(Role_OrganizationDTOs); }
public async Task <List <Ticket_OrganizationDTO> > FilterListOrganization([FromBody] Ticket_OrganizationFilterDTO Ticket_OrganizationFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } OrganizationFilter OrganizationFilter = new OrganizationFilter(); OrganizationFilter.Skip = 0; OrganizationFilter.Take = 20; OrganizationFilter.OrderBy = OrganizationOrder.Id; OrganizationFilter.OrderType = OrderType.ASC; OrganizationFilter.Selects = OrganizationSelect.ALL; OrganizationFilter.Id = Ticket_OrganizationFilterDTO.Id; OrganizationFilter.Name = Ticket_OrganizationFilterDTO.Name; if (OrganizationFilter.Id == null) { OrganizationFilter.Id = new IdFilter(); } OrganizationFilter.Id.In = await FilterOrganization(OrganizationService, CurrentContext); List <Organization> Organizations = await OrganizationService.List(OrganizationFilter); List <Ticket_OrganizationDTO> Ticket_OrganizationDTOs = Organizations .Select(x => new Ticket_OrganizationDTO(x)).ToList(); return(Ticket_OrganizationDTOs); }
public async Task <ActionResult <List <KpiGeneralEmployeeReport_OrganizationDTO> > > FilterListOrganization([FromBody] KpiGeneralEmployeeReport_OrganizationFilterDTO KpiGeneralEmployeeReport_OrganizationFilterDTO) { if (UnAuthorization) { return(Forbid()); } if (!ModelState.IsValid) { throw new BindException(ModelState); } OrganizationFilter OrganizationFilter = new OrganizationFilter(); OrganizationFilter.Skip = 0; OrganizationFilter.Take = int.MaxValue; OrganizationFilter.OrderBy = OrganizationOrder.Id; OrganizationFilter.OrderType = OrderType.ASC; OrganizationFilter.Selects = OrganizationSelect.ALL; OrganizationFilter.StatusId = new IdFilter { Equal = StatusEnum.ACTIVE.Id }; if (OrganizationFilter.Id == null) { OrganizationFilter.Id = new IdFilter(); } OrganizationFilter.Id.In = await FilterOrganization(OrganizationService, CurrentContext); List <Organization> Organizations = await OrganizationService.List(OrganizationFilter); List <KpiGeneralEmployeeReport_OrganizationDTO> KpiGeneralEmployeeReport_OrganizationDTOs = Organizations .Select(x => new KpiGeneralEmployeeReport_OrganizationDTO(x)).ToList(); return(KpiGeneralEmployeeReport_OrganizationDTOs); }
public async Task <List <AppUser_OrganizationDTO> > SingleListOrganization([FromBody] AppUser_OrganizationFilterDTO AppUser_OrganizationFilterDTO) { OrganizationFilter OrganizationFilter = new OrganizationFilter(); OrganizationFilter.Skip = 0; OrganizationFilter.Take = 99999; OrganizationFilter.OrderBy = OrganizationOrder.Id; OrganizationFilter.OrderType = OrderType.ASC; OrganizationFilter.Selects = OrganizationSelect.ALL; OrganizationFilter.Id = AppUser_OrganizationFilterDTO.Id; OrganizationFilter.Code = AppUser_OrganizationFilterDTO.Code; OrganizationFilter.Name = AppUser_OrganizationFilterDTO.Name; OrganizationFilter.ParentId = AppUser_OrganizationFilterDTO.ParentId; OrganizationFilter.Path = AppUser_OrganizationFilterDTO.Path; OrganizationFilter.Level = AppUser_OrganizationFilterDTO.Level; OrganizationFilter.StatusId = new IdFilter { Equal = Enums.StatusEnum.ACTIVE.Id }; OrganizationFilter.Phone = AppUser_OrganizationFilterDTO.Phone; OrganizationFilter.Address = AppUser_OrganizationFilterDTO.Address; OrganizationFilter.Email = AppUser_OrganizationFilterDTO.Email; if (OrganizationFilter.Id == null) { OrganizationFilter.Id = new IdFilter(); } OrganizationFilter.Id.In = await FilterOrganization(OrganizationService, CurrentContext); List <Organization> Organizations = await OrganizationService.List(OrganizationFilter); List <AppUser_OrganizationDTO> AppUser_OrganizationDTOs = Organizations .Select(x => new AppUser_OrganizationDTO(x)).ToList(); return(AppUser_OrganizationDTOs); }
public void Get_Organizations(OrganizationFilter filter, int expectedCount) { // Arrange var helper = new TestHelper(); var user = PrincipalHelper.CreateForPermission(Permissions.SystemAdmin); using var init = helper.InitializeDatabase(user); var organization1 = init.CreateOrganization(100, "TST"); organization1.PrntOrganizationId = 0; organization1.IsDisabled = false; var organization2 = init.CreateOrganization(101, "TST2"); organization2.PrntOrganizationId = 0; var organization3 = init.CreateOrganization(102, "TST3"); organization3.IsDisabled = true; var organization4 = init.CreateOrganization(200, "TST4"); init.AddAndSaveChanges(organization1, organization2, organization3, organization4); var service = helper.CreateRepository <UserOrganizationService>(user); var context = helper.GetService <PimsContext>(); // Act var result = service.Get(filter); // Assert Assert.NotNull(result); Assert.IsAssignableFrom <Paged <Entity.PimsOrganization> >(result); Assert.Equal(expectedCount, result.Items.Count); }
private async Task <bool> ValidateOrganization(KpiItem KpiItem) { if (KpiItem.OrganizationId == 0) { KpiItem.AddError(nameof(KpiItemValidator), nameof(KpiItem.Organization), ErrorCode.OrganizationEmpty); } else { OrganizationFilter OrganizationFilter = new OrganizationFilter { Id = new IdFilter { Equal = KpiItem.OrganizationId } }; var count = await UOW.OrganizationRepository.Count(OrganizationFilter); if (count == 0) { KpiItem.AddError(nameof(KpiItemValidator), nameof(KpiItem.Organization), ErrorCode.OrganizationIdNotExisted); } } return(KpiItem.IsValidated); }
private List <KeyValuePair <string, object> > GetFilterParam(OrganizationFilter filter) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); if (filter == null) { return(parameters); } if (filter.Id.HasValue) { parameters.Add(new KeyValuePair <string, object>("@Id", filter.Id)); } if (filter.Name != null && filter.Name != "") { parameters.Add(new KeyValuePair <string, object>("@Name", filter.Name)); } if (filter.INN != null && filter.INN != "") { parameters.Add(new KeyValuePair <string, object>("@INN", filter.INN)); } if (filter.TeacherId.HasValue) { parameters.Add(new KeyValuePair <string, object>("@TeacherId", filter.TeacherId)); } return(parameters); }
public async Task <int> Count(OrganizationFilter filter) { IQueryable <OrganizationDAO> Organizations = DataContext.Organization; Organizations = DynamicFilter(Organizations, filter); return(await Organizations.CountAsync()); }
public OrganizationFilter ToFilter(OrganizationFilter filter) { if (filter.OrFilter == null) { filter.OrFilter = new List <OrganizationFilter>(); } if (CurrentContext.Filters == null || CurrentContext.Filters.Count == 0) { return(filter); } foreach (var currentFilter in CurrentContext.Filters) { OrganizationFilter subFilter = new OrganizationFilter(); filter.OrFilter.Add(subFilter); List <FilterPermissionDefinition> FilterPermissionDefinitions = currentFilter.Value; foreach (FilterPermissionDefinition FilterPermissionDefinition in FilterPermissionDefinitions) { if (FilterPermissionDefinition.Name == nameof(subFilter.Id)) { subFilter.Id = FilterPermissionDefinition.IdFilter; } if (FilterPermissionDefinition.Name == nameof(subFilter.Code)) { subFilter.Code = FilterPermissionDefinition.StringFilter; } if (FilterPermissionDefinition.Name == nameof(subFilter.Name)) { subFilter.Name = FilterPermissionDefinition.StringFilter; } } } return(filter); }
public async Task <ActionResult <List <Organization_OrganizationDTO> > > FilterListOrganization([FromBody] Organization_OrganizationFilterDTO Organization_OrganizationFilterDTO) { if (UnAuthorization) { return(Forbid()); } OrganizationFilter OrganizationFilter = new OrganizationFilter(); OrganizationFilter.Skip = 0; OrganizationFilter.Take = 99999; OrganizationFilter.OrderBy = OrganizationOrder.Id; OrganizationFilter.OrderType = OrderType.ASC; OrganizationFilter.Selects = OrganizationSelect.ALL; OrganizationFilter.Id = Organization_OrganizationFilterDTO.Id; OrganizationFilter.Code = Organization_OrganizationFilterDTO.Code; OrganizationFilter.Name = Organization_OrganizationFilterDTO.Name; OrganizationFilter.ParentId = Organization_OrganizationFilterDTO.ParentId; OrganizationFilter.Path = Organization_OrganizationFilterDTO.Path; OrganizationFilter.Level = Organization_OrganizationFilterDTO.Level; OrganizationFilter.StatusId = null; if (OrganizationFilter.Id == null) { OrganizationFilter.Id = new IdFilter(); } OrganizationFilter.Id.In = await FilterOrganization(OrganizationService, CurrentContext); List <Organization> Organizations = await OrganizationService.List(OrganizationFilter); List <Organization_OrganizationDTO> Organization_OrganizationDTOs = Organizations .Select(x => new Organization_OrganizationDTO(x)).ToList(); return(Organization_OrganizationDTOs); }
/// <summary> /// 获取组织列表 /// </summary> /// <param name="filter"></param> /// <returns></returns> public List <OrganizationDTO> GetOrganizations(OrganizationFilter filter) { List <OrganizationDAO> organizationDaoList = _dal.GetOrganizations(filter); List <OrganizationDTO> result = new OrganizationDTO().ConvertList(organizationDaoList); return(result); }
/// <summary> /// Adds a filter to the collection. /// </summary> /// <param name="filter">The filter value.</param> public void Filter(OrganizationFilter filter) { if (_additionalParameters == null) { _additionalParameters = new Dictionary <string, object>(); } _additionalParameters["filter"] = filter.GetDescription(); }
internal void SetFilter(OrganizationFilter cardStatus) { if (_additionalParameters == null) { _additionalParameters = new Dictionary <string, object>(); } _additionalParameters["filter"] = cardStatus.GetDescription(); }
public async Task <PagedResult <OrganizationDto> > GetOrganizationsAsync(OrganizationFilter organizationFilter) { var organizationsPagedResult = await organizationRepository.GetOrganizationsAsync(organizationFilter); var organizationsDtoPagedResult = new PagedResult <OrganizationDto>(); Mapper.Map(organizationsPagedResult, organizationsDtoPagedResult); return(organizationsDtoPagedResult); }
public async Task <IActionResult> Get([FromQuery] OrganizationFilter filter) { if (!ModelState.IsValid) { return(BadRequest()); } return(Ok(await _organizationRepository.SearchAsync(filter))); }
/// <summary> /// 获取组织列表 /// </summary> /// <param name="filter"></param> /// <returns></returns> public List <OrganizationDAO> GetOrganizations(OrganizationFilter filter) { var queryable = _sugarClient.Queryable <OrganizationDAO>(); var organizations = queryable.WhereIF(!string.IsNullOrWhiteSpace(filter.Id), x => x.MItemID == filter.Id) .WhereIF(!string.IsNullOrWhiteSpace(filter.Name), x => x.MName == filter.Name) .WhereIF(filter.IsActive != null, x => x.MIsActive == filter.IsActive.Value).ToList(); return(organizations); }
private Expression <Func <Organization, bool> > GetUserExpression(OrganizationFilter filter) { Expression <Func <Organization, bool> > expression = null; if (filter.Id > 0) { expression = x => x.Id == filter.Id; } return(expression); }
public ReponseResult Get([FromQuery] OrganizationFilter filter) { ReponseResult result = new ReponseResult(); var organizations = _business.GetOrganizations(filter); result.Data = organizations; result.Success = true; return(result); }
public async Task <List <Organization> > List(OrganizationFilter filter) { if (filter == null) { return(new List <Organization>()); } IQueryable <OrganizationDAO> OrganizationDAOs = DataContext.Organization.AsNoTracking(); OrganizationDAOs = DynamicFilter(OrganizationDAOs, filter); OrganizationDAOs = DynamicOrder(OrganizationDAOs, filter); List <Organization> Organizations = await DynamicSelect(OrganizationDAOs, filter); return(Organizations); }
public void OrganizationFilter_Default_Constructor() { // Arrange // Act var filter = new OrganizationFilter(); // Assert filter.Page.Should().Be(1); filter.Quantity.Should().Be(10); filter.Id.Should().BeNull(); filter.ParentId.Should().Be(0); filter.IsDisabled.Should().BeNull(); filter.Name.Should().BeNull(); filter.Sort.Should().BeNull(); }
/// <summary> /// Get a page of organizations from the datasource. /// The filter will allow queries to search for the following property values; Name, Description, ParentId. /// </summary> /// <param name="filter"></param> /// <returns></returns> public Paged <PimsOrganization> Get(OrganizationFilter filter = null) { this.User.ThrowIfNotAuthorized(Permissions.SystemAdmin); var query = this.Context.PimsOrganizations.AsNoTracking(); if (filter != null) { if (filter.Page < 1) { filter.Page = 1; } if (filter.Quantity < 1) { filter.Quantity = 1; } if (filter.Quantity > 50) { filter.Quantity = 50; } if (filter.Sort == null) { filter.Sort = System.Array.Empty <string>(); } if (!string.IsNullOrWhiteSpace(filter.Name)) { query = query.Where(a => EF.Functions.Like(a.OrganizationName, $"%{filter.Name}%")); } if (filter.IsDisabled != null) { query = query.Where(a => a.IsDisabled == filter.IsDisabled); } if (filter.Id > 0) { query = query.Where(a => a.OrganizationId == filter.Id); } if (filter.Sort.Any()) { query = query.OrderByProperty(filter.Sort); } } var organizations = query.Skip((filter.Page - 1) * filter.Quantity).Take(filter.Quantity); return(new Paged <PimsOrganization>(organizations.ToArray(), filter.Page, filter.Quantity, query.Count())); }
public async Task <ActionResult> Export([FromBody] Organization_OrganizationFilterDTO Organization_OrganizationFilterDTO) { if (UnAuthorization) { return(Forbid()); } if (!ModelState.IsValid) { throw new BindException(ModelState); } OrganizationFilter OrganizationFilter = ConvertFilterDTOToFilterEntity(Organization_OrganizationFilterDTO); OrganizationFilter = OrganizationService.ToFilter(OrganizationFilter); OrganizationFilter.Skip = 0; OrganizationFilter.Take = int.MaxValue; OrganizationFilter = OrganizationService.ToFilter(OrganizationFilter); List <Organization> Organizations = await OrganizationService.List(OrganizationFilter); MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { var OrganizationHeaders = new List <string[]>() { new string[] { "Mã tổ chức", "Tên tổ chức", "Mã tổ chức" } }; List <object[]> data = new List <object[]>(); for (int i = 0; i < Organizations.Count; i++) { var Organization = Organizations[i]; data.Add(new Object[] { Organization.Name, Organization.Code, Organization.Parent?.Code ?? "", }); } excel.GenerateWorksheet("Organization", OrganizationHeaders, data); excel.Save(); } return(File(memoryStream.ToArray(), "application/octet-stream", "Organization.xlsx")); }
public void OrganizationFilter_Constructor_03() { // Arrange var query = Microsoft.AspNetCore.WebUtilities.QueryHelpers.ParseQuery("?page=2&quantity=3&id=3&parentId=6&name=test&isDisabled=true&sort=one,two"); // Act var filter = new OrganizationFilter(query); // Assert filter.Page.Should().Be(2); filter.Quantity.Should().Be(3); filter.Id.Should().Be(3); filter.ParentId.Should().Be(6); filter.IsDisabled.Should().Be(true); filter.Name.Should().Be("test"); filter.Sort.Should().BeEquivalentTo(new[] { "one", "two" }); }
public void OrganizationFilter_Constructor_01() { // Arrange var page = 2; var quantity = 5; // Act var filter = new OrganizationFilter(page, quantity); // Assert filter.Page.Should().Be(page); filter.Quantity.Should().Be(quantity); filter.Id.Should().BeNull(); filter.ParentId.Should().Be(0); filter.IsDisabled.Should().BeNull(); filter.Name.Should().BeNull(); filter.Sort.Should().BeNull(); }
public async Task <IEnumerable <Organization> > SearchAsync(OrganizationFilter filter) { var query = entities.AsQueryable(); if (!string.IsNullOrWhiteSpace(filter.Name)) { query = query.Where(o => o.Name.StartsWith(filter.Name)); } if (!string.IsNullOrWhiteSpace(filter.Email)) { query = query.Where(o => o.Email.StartsWith(filter.Email)); } query = base.SearchAsync(query, filter); return(await query.ToListAsync()); }
public async Task <ActionResult <int> > Count([FromBody] Organization_OrganizationFilterDTO Organization_OrganizationFilterDTO) { if (UnAuthorization) { return(Forbid()); } if (!ModelState.IsValid) { throw new BindException(ModelState); } OrganizationFilter OrganizationFilter = ConvertFilterDTOToFilterEntity(Organization_OrganizationFilterDTO); OrganizationFilter = OrganizationService.ToFilter(OrganizationFilter); int count = await OrganizationService.Count(OrganizationFilter); return(count); }
public async Task <PagedResult <Organization> > GetOrganizationsAsync(OrganizationFilter filter) { filter = filter ?? new OrganizationFilter(); var result = unitOfWork.Query(GetUserExpression(filter), filter.PropertiesToInclude); List <Organization> list = await result.OrderBy(filter.OrderBy) .Skip((filter.Page - 1) * filter.Skip).Take(filter.Take) .ToListAsync(); var pagedResult = new PagedResult <Organization> { Data = list, PageInfo = await GetPageInfo(x => x.Id, filter, GetUserExpression(filter)) }; return(pagedResult); }
public async Task <ActionResult <List <Notification_OrganizationDTO> > > SingleListOrganization([FromBody] Notification_OrganizationFilterDTO Notification_OrganizationFilterDTO) { if (UnAuthorization) { return(Forbid()); } if (!ModelState.IsValid) { throw new BindException(ModelState); } OrganizationFilter OrganizationFilter = new OrganizationFilter(); OrganizationFilter.Skip = 0; OrganizationFilter.Take = int.MaxValue; OrganizationFilter.OrderBy = OrganizationOrder.Id; OrganizationFilter.OrderType = OrderType.ASC; OrganizationFilter.Selects = OrganizationSelect.ALL; OrganizationFilter.Id = Notification_OrganizationFilterDTO.Id; OrganizationFilter.Code = Notification_OrganizationFilterDTO.Code; OrganizationFilter.Name = Notification_OrganizationFilterDTO.Name; OrganizationFilter.ParentId = Notification_OrganizationFilterDTO.ParentId; OrganizationFilter.Path = Notification_OrganizationFilterDTO.Path; OrganizationFilter.Level = Notification_OrganizationFilterDTO.Level; OrganizationFilter.StatusId = new IdFilter { Equal = Enums.StatusEnum.ACTIVE.Id }; OrganizationFilter.Phone = Notification_OrganizationFilterDTO.Phone; OrganizationFilter.Email = Notification_OrganizationFilterDTO.Email; OrganizationFilter.Address = Notification_OrganizationFilterDTO.Address; if (OrganizationFilter.Id == null) { OrganizationFilter.Id = new IdFilter(); } OrganizationFilter.Id.In = await FilterOrganization(OrganizationService, CurrentContext); List <Organization> Organizations = await OrganizationService.List(OrganizationFilter); List <Notification_OrganizationDTO> Notification_OrganizationDTOs = Organizations .Select(x => new Notification_OrganizationDTO(x)).ToList(); return(Notification_OrganizationDTOs); }
public async Task <bool> ValidateOrganization(Notification Notification) { if (Notification.OrganizationId != null && Notification.OrganizationId != 0) { OrganizationFilter OrganizationFilter = new OrganizationFilter { Id = new IdFilter { Equal = Notification.OrganizationId } }; int count = await UOW.OrganizationRepository.Count(OrganizationFilter); if (count == 0) { Notification.AddError(nameof(NotificationValidator), nameof(Notification.Organization), ErrorCode.OrganizationIdNotExisted); } } return(Notification.IsValidated); }
public MemberOrganizationsRequest(IMemberId member, OrganizationFilter filter) : base(member, "organizations") { this.AddFilter(filter); }
public Task<IEnumerable<Organization>> ForMember(IMemberId member, OrganizationFilter filter = OrganizationFilter.All) { return _restClient.RequestListAsync<Organization>(new OrganizationsForMemberRequest(member, filter)); }
public Task<IEnumerable<Organization>> ForMe(OrganizationFilter filter = OrganizationFilter.All) { return ForMember(new Me(), filter); }
public IEnumerable<Organization> ForMember(IMemberId member, OrganizationFilter filter = OrganizationFilter.Default) { return _restClient.Request<List<Organization>>(new OrganizationsForMemberRequest(member, filter)); }
public IEnumerable<Organization> ForMe(OrganizationFilter filter = OrganizationFilter.Default) { return ForMember(new Me(), filter); }
public IEnumerable<Organization> GetByMember(IMemberId member, OrganizationFilter filter = OrganizationFilter.Default) { Guard.NotNull(member, "member"); return _restClient.Request<List<Organization>>(new MemberOrganizationsRequest(member, filter)); }