Example #1
0
        public async Task <JsonResult> GetAsync([FromQuery] MemberQueryDto condition, int?pageIndex, int?pageSize)
        {
            if (pageIndex == null || pageSize == null)
            {
                if (condition.BirthdayFrom != null ||
                    condition.BirthdayTo != null ||
                    condition.DepartmentCode != null ||
                    condition.Education != null ||
                    condition.EntryTimeFrom != null ||
                    condition.EntryTimeTo != null ||
                    condition.Gender != null ||
                    condition.HomeAddress != null ||
                    condition.LengthOfService != null ||
                    condition.MaritalStatus != null ||
                    condition.MemberCode != null ||
                    condition.Nationality != null ||
                    condition.PersonnelNature != null ||
                    condition.PoliticalStatus != null ||
                    condition.Position != null ||
                    condition.Status != null
                    )
                {
                    var list = _service.Search(condition);
                    return(new JsonResult(new
                    {
                        code = 20000,
                        list
                    }));
                }
                var items = await _service.GetAll();

                return(new JsonResult(new
                {
                    code = 20000,
                    items
                }));
            }
            else
            {
                var items = await _service.GetPaginationAsync(pageIndex.Value, pageSize.Value);

                return(new JsonResult(new
                {
                    code = 20000,
                    items
                }));
            }
        }
Example #2
0
 public List <Member> Search(MemberQueryDto condition)
 {
     return(_domain.Get(condition));
 }
Example #3
0
        public List <Member> Get(MemberQueryDto condition)
        {
            IQueryable <Member> query = _repository.Query();

            if (condition.MemberName != null && condition.MemberName.Trim() != "")
            {
                query = query.Where(Member => Member.MemberName.Contains(condition.MemberName));
            }
            if (condition.MemberCode != null && condition.MemberCode.Trim() != "")
            {
                query = query.Where(Member => Member.MemberCode.Contains(condition.MemberCode));
            }
            if (condition.HomeAddress != null && condition.HomeAddress.Trim() != "")
            {
                query = query.Where(Member => Member.HomeAddress.Contains(condition.HomeAddress));
            }
            if (condition.IdCardNumber != null && condition.IdCardNumber.Trim() != "")
            {
                query = query.Where(Member => Member.IdCardNumber.Contains(condition.IdCardNumber));
            }
            if (condition.MaritalStatus != null && condition.MaritalStatus.Trim() != "")
            {
                query = query.Where(Member => Member.MaritalStatus.Contains(condition.MaritalStatus));
            }
            if (condition.Nationality != null && condition.Nationality.Trim() != "")
            {
                query = query.Where(Member => Member.Nationality.Contains(condition.Nationality));
            }
            if (condition.PoliticalStatus != null && condition.PoliticalStatus.Trim() != "")
            {
                query = query.Where(Member => Member.PoliticalStatus.Contains(condition.PoliticalStatus));
            }
            if (condition.Position != null && condition.Position.Trim() != "")
            {
                query = query.Where(Member => Member.Position.Contains(condition.Position));
            }
            if (condition.Status != null && condition.Status.Trim() != "")
            {
                query = query.Where(Member => Member.Status.Contains(condition.Status));
            }

            if (condition.PersonnelNature != null && condition.PersonnelNature.Trim() != "")
            {
                query = query.Where(Member => Member.PersonnelNature.Contains(condition.PersonnelNature));
            }
            if (condition.Gender != null && condition.Gender.Trim() != "")
            {
                query = query.Where(Member => Member.Gender.Contains(condition.Gender));
            }
            if (condition.LengthOfService != null && condition.LengthOfService.Trim() != "")
            {
                query = query.Where(Member => Member.LengthOfService.Contains(condition.LengthOfService));
            }
            if (condition.BirthdayFrom != null)
            {
                query = query.Where(Member => Member.Birthday >= condition.BirthdayFrom);
            }
            if (condition.BirthdayTo != null)
            {
                query = query.Where(Member => Member.Birthday <= condition.BirthdayTo);
            }
            if (condition.LeaveTimeFrom != null)
            {
                query = query.Where(Member => Member.LeaveTime >= condition.LeaveTimeFrom);
            }
            if (condition.LeaveTimeTo != null)
            {
                query = query.Where(Member => Member.LeaveTime <= condition.LeaveTimeFrom);
            }
            if (condition.EntryTimeFrom != null)
            {
                query = query.Where(Member => Member.EntryTime >= condition.EntryTimeFrom);
            }
            if (condition.EntryTimeTo != null)
            {
                query = query.Where(Member => Member.EntryTime <= condition.EntryTimeTo);
            }

            return(query.ToList());
        }